> On Feb. 7, 2019, 10:16 p.m., Ashutosh Chauhan wrote:
> > ql/src/test/results/clientpositive/llap/subquery_multi.q.out
> > Lines 2312-2313 (patched)
> > <https://reviews.apache.org/r/69918/diff/1/?file=2124283#file2124283line2317>
> >
> >     Worse plan than earlier.

It seems like more accurate equals/hashcode have caused this change; before 
CALCITE-2632 RexCorrelVariables were not properly compared; it seems like that 
have helped/interfered with HiveRelDecorrelator's operations.

https://github.com/apache/calcite/blob/ef9f926061de21ad713a76ec3ec8110e5cbd92bf/core/src/main/java/org/apache/calcite/rex/RexCorrelVariable.java#L59


> On Feb. 7, 2019, 10:16 p.m., Ashutosh Chauhan wrote:
> > ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query6.q.out
> > Lines 68-70 (original), 68-70 (patched)
> > <https://reviews.apache.org/r/69918/diff/1/?file=2124356#file2124356line68>
> >
> >     Is new join order better?

the join order is essentially the same

* one of the higher level inner join have its arguments swapped in the output.
* the new plan has 1 projection happening earlier than in the old
* has 1 new projection


- Zoltan


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/69918/#review212637
-----------------------------------------------------------


On Feb. 7, 2019, 8:08 p.m., Zoltan Haindrich wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/69918/
> -----------------------------------------------------------
> 
> (Updated Feb. 7, 2019, 8:08 p.m.)
> 
> 
> Review request for hive, Ashutosh Chauhan and Jesús Camacho Rodríguez.
> 
> 
> Bugs: HIVE-21001
>     https://issues.apache.org/jira/browse/HIVE-21001
> 
> 
> Repository: hive-git
> 
> 
> Description
> -------
> 
> patch#1 here is #23 on jira
> 
> 
> Diffs
> -----
> 
>   
> accumulo-handler/src/test/results/positive/accumulo_predicate_pushdown.q.out 
> 8a1e0609f9f48434d8147c296984bbc0a6cbae35 
>   hbase-handler/src/test/results/positive/hbase_ppd_key_range.q.out 
> 5e051543133125a57dbf5b83b62f0a13cf7f415a 
>   hbase-handler/src/test/results/positive/hbase_pushdown.q.out 
> 57613c36f9b3376469b1b05e9a9df59bd5365450 
>   pom.xml 240472a30e033a83d1c799e636d8df29cb2c5770 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveRelBuilder.java 
> e85a99e84658a69c4fd93a6c352af4ead768ef67 
>   ql/src/test/queries/clientpositive/druidmini_expressions.q 
> 36aad7937d556e013773f29ecd89bf0629c1937d 
>   ql/src/test/results/clientpositive/alter_partition_coltype.q.out 
> d484f9e2237402fa475cb79a182340d7d83dadb9 
>   ql/src/test/results/clientpositive/annotate_stats_filter.q.out 
> 44f77b8f503e3b1a5c6d68caeb9727b8950fc93c 
>   ql/src/test/results/clientpositive/cbo_rp_simple_select.q.out 
> cb22b61f269db76f5397a4ce0981e92d236d1123 
>   ql/src/test/results/clientpositive/cbo_simple_select.q.out 
> 32e69204f699186c4e591770320802ebb40e2c42 
>   ql/src/test/results/clientpositive/complex_alias.q.out 
> f9315f80457651a1324397c2a129c2bcc6ac0bc4 
>   ql/src/test/results/clientpositive/constantPropWhen.q.out 
> 4e7af0cf181c47c5e19a658764bea3eda959d88f 
>   ql/src/test/results/clientpositive/constantPropagateForSubQuery.q.out 
> 221837b410f6df499c18cbf04bee54a4c7b241f4 
>   ql/src/test/results/clientpositive/constant_prop_3.q.out 
> 2b314d7ebdf1e015a28379cd1795353206268efb 
>   ql/src/test/results/clientpositive/constprog_when_case.q.out 
> d237f135acd1ee199084866e44436e7757cb12e4 
>   ql/src/test/results/clientpositive/decimal_udf.q.out 
> 3ef40023ebf683c224c45eca61af5221d210a8ff 
>   ql/src/test/results/clientpositive/druid/druidmini_expressions.q.out 
> 973cade307bef1a1559a4a27a78078659628ea5a 
>   ql/src/test/results/clientpositive/druid/druidmini_extractTime.q.out 
> 4ea95f69302cdc283047612ef5b0f9847365b820 
>   ql/src/test/results/clientpositive/druid/druidmini_floorTime.q.out 
> 8d9382443ef290dedfa880b7413bf2742fd199ce 
>   ql/src/test/results/clientpositive/druid/druidmini_test_ts.q.out 
> 9c412d97dd4d42e7e45990fa3be380f947103cfd 
>   ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out 
> f76b24e7d9c0cf947cf4fff06fa55af73670e68f 
>   ql/src/test/results/clientpositive/fold_case.q.out 
> 408275dff6b42b6339fde24ae9d948fcca66d90f 
>   ql/src/test/results/clientpositive/fold_eq_with_case_when.q.out 
> 25825b824db57cec60ee199aaccaab06056c3287 
>   ql/src/test/results/clientpositive/fold_when.q.out 
> 6f3a479ba6f5092bcd6ce1e431a88df8a32725fd 
>   ql/src/test/results/clientpositive/groupby_sort_1_23.q.out 
> 7826f2eb7ad94ae0bf77bd129c21caca8808e0a2 
>   ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out 
> 674e8bfe328761bffbaedfb93e3942548ac9b691 
>   ql/src/test/results/clientpositive/in_typecheck_char.q.out 
> 6948719881a7da18def438a2a113a4c48201ad41 
>   ql/src/test/results/clientpositive/infer_join_preds.q.out 
> 2bd92aedb69589f7183b22e50fd6175595cd6a8e 
>   ql/src/test/results/clientpositive/innerjoin1.q.out 
> 0bde0c9fe00282f25d184fa90e30e98639f90ac7 
>   ql/src/test/results/clientpositive/input23.q.out 
> 4140b3c63f5e5d7923ce9f11f56e004d750db12b 
>   ql/src/test/results/clientpositive/input42.q.out 
> b2a3c6a0a4c710c6fd1da9a2e12504727d7dc4db 
>   ql/src/test/results/clientpositive/input8.q.out 
> 3c533a87481638937becffe1cb957ac86ab74daf 
>   ql/src/test/results/clientpositive/input_part1.q.out 
> ae893c47426d5202adfcd9044a850a5f1dcdd003 
>   ql/src/test/results/clientpositive/input_part9.q.out 
> 356c28334c4216549ca0321b5e5c3eda268b96e3 
>   ql/src/test/results/clientpositive/join_filters_overlap.q.out 
> 847b45d60839994fea25a069a410cf89285cf69c 
>   ql/src/test/results/clientpositive/list_bucket_dml_1.q.out 
> 1ca49834c0b4cb40f9ff9a9f2d920c681c319ab6 
>   ql/src/test/results/clientpositive/list_bucket_dml_11.q.out 
> 3508a6ffd17b1cb68bf691392b92a4fe7317573b 
>   ql/src/test/results/clientpositive/list_bucket_dml_12.q.out 
> 406a9c1a75e2ef3802992dc956bb6f68a20207c9 
>   ql/src/test/results/clientpositive/list_bucket_dml_13.q.out 
> a383a3849c024f169a2aeb1bf9f97d5a72d64367 
>   ql/src/test/results/clientpositive/list_bucket_dml_14.q.out 
> 5b89cd7c1115890a07f4ed440a44b63b1b16b3c2 
>   ql/src/test/results/clientpositive/list_bucket_dml_2.q.out 
> 8f39619971d92d7b614e70672cec5eb2fb79dce4 
>   ql/src/test/results/clientpositive/list_bucket_dml_3.q.out 
> fb8ff449a934946cb4eec39565c3d86fdb33be50 
>   ql/src/test/results/clientpositive/list_bucket_dml_4.q.out 
> 9bcc9a5fca3c26e56cb7e80771be1ccdb1c6842b 
>   ql/src/test/results/clientpositive/list_bucket_dml_5.q.out 
> 9b6bf06790b242d4a0b1f92942fe4fd8888125d9 
>   ql/src/test/results/clientpositive/list_bucket_dml_6.q.out 
> 76459d77297c37dd6b2df7329bbef4f91cd9eab1 
>   ql/src/test/results/clientpositive/list_bucket_dml_7.q.out 
> ddfa3240e333c8b3d8c1207e3580f4c79d17d65f 
>   ql/src/test/results/clientpositive/list_bucket_dml_8.q.out 
> 30e75e1d325f9ec2862588cc0de098db3bbf8d77 
>   ql/src/test/results/clientpositive/list_bucket_dml_9.q.out 
> c8876b7ba909bed77065c0040f47b968afe47bd6 
>   ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out 
> 901b2862e66f7474f67b347f6ba82a23ce7d36d3 
>   ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out 
> ba28d5030782e5b4cde64969057ca1230e62e131 
>   ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out 
> 75c4aba78ac173ed7a883d9f5d9b12223b5ac259 
>   ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out 
> 79620126a8963bc0ecbc810cef9ee8d6b57a4b2e 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out 
> 5de5a69f87d70ad0fd65ba5d11cc6f6314e24bd3 
>   ql/src/test/results/clientpositive/llap/bucketpruning1.q.out 
> 934b383af54eb99ee072fb6e212f75f2325367a1 
>   ql/src/test/results/clientpositive/llap/cbo_simple_select.q.out 
> acf91bf1787fb19c1c51264beabaa109d36c59f2 
>   ql/src/test/results/clientpositive/llap/explainuser_1.q.out 
> 688296359940fe9648f852813383b72788a777ca 
>   ql/src/test/results/clientpositive/llap/join_constraints_optimization.q.out 
> 1098bb41f309e95a0a7eeb7e765cfd5a7ac6e5b8 
>   ql/src/test/results/clientpositive/llap/kryo.q.out 
> 5d556f46c083b44f6a47ab8d92c8da4071d64503 
>   ql/src/test/results/clientpositive/llap/lineage3.q.out 
> bfd82cd5137d75add4d73f8534d03c5146a1a3c5 
>   ql/src/test/results/clientpositive/llap/mapjoin_hint.q.out 
> 46e211d26aafef0ec0c09c678ade3527d8338234 
>   ql/src/test/results/clientpositive/llap/mergejoin.q.out 
> 7c1bc565af71da7800d157acf09d108db30f4185 
>   ql/src/test/results/clientpositive/llap/ppd_union_view.q.out 
> cba24342f82bc1216403c01ac24135b7c591b3b8 
>   ql/src/test/results/clientpositive/llap/results_cache_2.q.out 
> 11dbacf3d1a33d41f144981a4bce7bb719684adc 
>   ql/src/test/results/clientpositive/llap/semijoin6.q.out 
> 139471970a818c1384bb8ceea808203412e51553 
>   ql/src/test/results/clientpositive/llap/subquery_in.q.out 
> 07cc4dbabc2cf4f109b6dcce1e909a4f7f469da2 
>   ql/src/test/results/clientpositive/llap/subquery_in_having.q.out 
> 3839696882a357180d74472fe40e14a8b15a6205 
>   ql/src/test/results/clientpositive/llap/subquery_multi.q.out 
> 7b00d6975432d73ba5b7a091efed5fe03fc937e6 
>   ql/src/test/results/clientpositive/llap/subquery_notin.q.out 
> 29d8bbfb48e68522071f2c3987ef719a1ed01f6d 
>   ql/src/test/results/clientpositive/llap/subquery_null_agg.q.out 
> 4591ff846056daecabf9c3cff35d0158c37d699d 
>   ql/src/test/results/clientpositive/llap/subquery_scalar.q.out 
> c43ad9188b3fbacc467131685db7aafdc5c5b9bc 
>   ql/src/test/results/clientpositive/llap/subquery_select.q.out 
> d3cc980ca1059a96864ecb6008022d412a344bd0 
>   ql/src/test/results/clientpositive/llap/subquery_views.q.out 
> aa50b468c3729ace343b25c3754d3c859ed1b39d 
>   ql/src/test/results/clientpositive/llap/tez_smb_reduce_side.q.out 
> 7ceeb417c51cd6cb5dbcc38e4c1151315c5a44d8 
>   ql/src/test/results/clientpositive/llap/unionDistinct_1.q.out 
> 93791ac8e0a0c1b8f0540f7f61ad02b71a9789ec 
>   ql/src/test/results/clientpositive/llap/vector_case_when_1.q.out 
> c5a35ba91cfd81e3c02f2c70ef591f0b90513c56 
>   ql/src/test/results/clientpositive/llap/vector_case_when_2.q.out 
> 0f958e833bd0a6bfdeee5b14b77e4271136bf578 
>   ql/src/test/results/clientpositive/llap/vector_coalesce_3.q.out 
> 493cfca23ad6595a99e6f12ca1ccf8b6188739f4 
>   ql/src/test/results/clientpositive/llap/vector_decimal_math_funcs.q.out 
> 359f9e7ca05e001793d28ceaa09abbb998cbe308 
>   ql/src/test/results/clientpositive/llap/vector_groupby_mapjoin.q.out 
> c20bc7125774bc69c6d427bc3534a364974128ed 
>   ql/src/test/results/clientpositive/llap/vectorization_0.q.out 
> 60c70219fff31b703035704c33ef6f80b7b39ccd 
>   ql/src/test/results/clientpositive/llap/vectorization_5.q.out 
> 5d700255fbd08989048adc1fed788b4419f7e61b 
>   ql/src/test/results/clientpositive/llap/vectorization_8.q.out 
> a0e1a4b21458be47695496a457d406365b8360cd 
>   ql/src/test/results/clientpositive/llap/vectorization_short_regress.q.out 
> f9297067570f1b75a870fc05d585fa4f1e8d5f25 
>   ql/src/test/results/clientpositive/llap/vectorized_casts.q.out 
> cc53f110be0ff91d450b1bd6d8cca1d7d605a1f1 
>   ql/src/test/results/clientpositive/llap/vectorized_math_funcs.q.out 
> 61a915936c090b47fba2c4ecaf87ed837f5813db 
>   ql/src/test/results/clientpositive/llap/vectorized_string_funcs.q.out 
> 7a5073577e250753eafb0103848b74279d4ce8cb 
>   
> ql/src/test/results/clientpositive/llap/vectorized_timestamp_ints_casts.q.out 
> 9073b6a77e129c06f32c9947818630f2b8732e4e 
>   ql/src/test/results/clientpositive/mergejoin.q.out 
> 2108434f27cd707ab822ee652424a7260d528bb1 
>   ql/src/test/results/clientpositive/optimize_filter_literal.q.out 
> 3e8ca3a7f9660597291267e15d23d2d51e04dbed 
>   ql/src/test/results/clientpositive/parquet_vectorization_0.q.out 
> d45655d6981f89b233e13539eabd9b1e55a098de 
>   ql/src/test/results/clientpositive/parquet_vectorization_5.q.out 
> baee2c80a9ca08c012ed5b21da86347bfa20b25f 
>   ql/src/test/results/clientpositive/parquet_vectorization_8.q.out 
> e01cf4a8c0fbe0cde48ab6ba482690c2d3bf315b 
>   ql/src/test/results/clientpositive/pcr.q.out 
> d71ef675d50e861ed7da62f3cea4684a3fc49a66 
>   ql/src/test/results/clientpositive/pcs.q.out 
> 225624eb978164c1f1148745c1d74700aeb8561a 
>   ql/src/test/results/clientpositive/perf/spark/query11.q.out 
> 28ce6d0814c60580e5daa1649d3735f00c54d71b 
>   ql/src/test/results/clientpositive/perf/spark/query13.q.out 
> 2b6c19d6c2724952ca5d2d14a06733ff6a327b0f 
>   ql/src/test/results/clientpositive/perf/spark/query31.q.out 
> 27cfadc94269b8d1e08c3f0fd69b3e88b27c2d57 
>   ql/src/test/results/clientpositive/perf/spark/query36.q.out 
> c6088be8dbcbc2688f34f45099c38173610b7f20 
>   ql/src/test/results/clientpositive/perf/spark/query4.q.out 
> 93e83ef10ed543b085188ba20bb9137969cc57c5 
>   ql/src/test/results/clientpositive/perf/spark/query45.q.out 
> c8242745ee4417adaca79e6f8abd621637db88bd 
>   ql/src/test/results/clientpositive/perf/spark/query48.q.out 
> 024d2052904d7dee4ee7310c70bff996794ec9bc 
>   ql/src/test/results/clientpositive/perf/spark/query53.q.out 
> ea5dde1e511983c45b2afe23277e78e6cc67b408 
>   ql/src/test/results/clientpositive/perf/spark/query6.q.out 
> 2702aefd92ba7af8eed0741bd4595454af0eb298 
>   ql/src/test/results/clientpositive/perf/spark/query63.q.out 
> 2d905d382bc3352e97703be2405d1fa983434a20 
>   ql/src/test/results/clientpositive/perf/spark/query70.q.out 
> 56767af272f2d8bb5443e482b67779aa81a1fcf6 
>   ql/src/test/results/clientpositive/perf/spark/query74.q.out 
> cc9b74eb0c9893746ebca4fb0d648a2a212d9812 
>   ql/src/test/results/clientpositive/perf/spark/query78.q.out 
> c121a341fd47b12003e7b3c698e29c9cdc9137f8 
>   ql/src/test/results/clientpositive/perf/spark/query85.q.out 
> a7bf288044b8a80211c95b34f43b513325c58509 
>   ql/src/test/results/clientpositive/perf/spark/query86.q.out 
> 835ac5c9ada33a6edd2c5f2d2010a272a512c23e 
>   ql/src/test/results/clientpositive/perf/spark/query88.q.out 
> 029da524d04e41ac4aafeebd8686d537d3c19072 
>   ql/src/test/results/clientpositive/perf/spark/query89.q.out 
> 40a698aadfc1554f95a9435440f3cd3956ac2bf4 
>   ql/src/test/results/clientpositive/perf/spark/query97.q.out 
> 1ace8e8ff537d82bbba6cd41ef28e9ef2efb2046 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query11.q.out 
> de0783be16564d0b0a7755652056e7a61d7fea51 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query13.q.out 
> 19f30397814b16a5abdd2901c8efbe2f87fef681 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query31.q.out 
> 8907b8d6cd51f3be884b537a240c2cc97cb3ff87 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query36.q.out 
> 9a74bed47058c34cd397ecb1b4c3e36897573023 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query4.q.out 
> 4b388653aee1caf1ecfd64b2538fec5b98b4542b 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query48.q.out 
> 079556ec993f8fc84f6dac88433ebb32fbd32e16 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query53.q.out 
> 9b424280971646189baa0ed07c8af3fda7fda231 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query6.q.out 
> f502c004cfc7791f5a97ba170a4a3db6bc47cbec 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query63.q.out 
> 78c9b1311147eeda82c2515f786f59a2ffcbf239 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query64.q.out 
> 5a5bb797a1f8c4419ff90eada59b1945dcb6aa8c 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query72.q.out 
> e49b44bf32d0bd49b6d3ae16dfec00388e4edafc 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query74.q.out 
> 4a9a1127b3037fb8aef2f22a34a7092acd15459a 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query78.q.out 
> 02635826f03dbd413e6eaaa1fb6dec2abc75d667 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query85.q.out 
> f5a71b422bdd042d2613378c4ff87280e849b6b8 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query88.q.out 
> 1f4471e8ae67ecb8e4a3a85357e9006520b2c235 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query89.q.out 
> 7cfb3ecdecc2f973a989e7687e6af9a437538ad6 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query97.q.out 
> f79dffbdc8661cb83346ef1899a9d9ff1d91ad53 
>   
> ql/src/test/results/clientpositive/perf/tez/constraints/cbo_ext_query1.q.out 
> PRE-CREATION 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query1.q.out 
> 13801ffc6c242b8e651d630801dd3e46c1c3a8b1 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query11.q.out 
> f315e3c455ae9cebcaaf971efcd78c80edd732fb 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query13.q.out 
> 811a5184aa02cab41cddb1e7356adca0c5ffa28b 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query31.q.out 
> f8e31a23aa065471c7ce842a6a369c0f382e1b7b 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query36.q.out 
> d4031261c7b7ccf65567ed044f4d51c92ac70a86 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query4.q.out 
> 9668e0f4a1bc342caee643f96cb8689281b40df0 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query46.q.out 
> 9d21449b6563b87ca6ab5ab511a84fd9047af13a 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query48.q.out 
> 12d59348f7aebaa6046d38902f57a22edb4b3cf6 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query53.q.out 
> bac3f775380acc914764c1759fb4149a51a413fd 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query6.q.out 
> 5e3deb3eb983c56ede11d012e014a98adc2c2d0b 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query63.q.out 
> e22d812f789bf682cef57cb4034c78078bd6cc4e 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query64.q.out 
> 4261d0655d0fadad9b2bd100f954bcd563248274 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query65.q.out 
> 3e906b73b04a2e0c361af6a0846cc37cbdac5b40 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query68.q.out 
> 1b25235c8a3aa8066349c9e68ca69f6a328eb291 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query72.q.out 
> 206b0f197258f8cb3c9d58c3500088730fefa343 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query74.q.out 
> 4a8f0b88f0f23809ab4e6b9e43a525d4e7a535cd 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query78.q.out 
> de1b13300643ab51bcea45874293fa1add6e2078 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query85.q.out 
> 647134514184337d7fefe1f43d03bdae224234d3 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query88.q.out 
> 1ac8fe2dcdb5a2df6c3c22c6bd0471269e493686 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query89.q.out 
> d9c7d42b9f4718970cce03f539e6fea4b43a29b4 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query97.q.out 
> 6151627c83da5a2d53c2ebfc0b415c945e042aa1 
>   ql/src/test/results/clientpositive/perf/tez/constraints/mv_query44.q.out 
> db9acc93cb250e9d4f259ada32c1365e2063da06 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query1.q.out 
> 69f93290d9ec806cd1e282833b87aeac5197ed6f 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query11.q.out 
> 7e0582e16462385e0051617c301e5efbc1b654c2 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query13.q.out 
> ac81e3794cbb22216bdef026087e8ed59d66567c 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query31.q.out 
> 8e0de0ffe2bff69792156d3273e63452e87fd9db 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query36.q.out 
> 8158608354bce91338bac8423a8113e93d18db65 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query4.q.out 
> e6558e99a975fc214b118eb362a0fd5f5ebbd2bf 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query44.q.out 
> 3fd361a9f99bd4857c9f65193086d4f134df22d6 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query45.q.out 
> 64d9c98395262d0dfb766b3e34fe2dd22466e84f 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query46.q.out 
> dde72e07b829f38c784a838c15d02f21e97fdf01 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query48.q.out 
> af9d44207d5d95999aa964a8e2d6ef3c1f8cb502 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query53.q.out 
> a13d0f9c094094a9de13be2913a55f667d15cca1 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query6.q.out 
> 7aea119ac3d59d59ccde4db128a04a7b3955b937 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query63.q.out 
> 5620b819fbbaf98c37e53c492454c51f484bd0eb 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query68.q.out 
> dd4ce4eb84f964e2ef5833ba6f2d87adbe1146af 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query70.q.out 
> 17e2f99ae92f59418039da930d3e7a962a6db1b9 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query72.q.out 
> 1a9c2cf203d76000dabacf27470426cdbf1dd8bd 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query74.q.out 
> 525217b526c40de6a7d7c67364bfb0e8a20f103c 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query78.q.out 
> ef4d6dbc2143ea707a4b8a85a39b13c77b4606c7 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query85.q.out 
> 2aa27db1ef245234447852fb86cc0dd228863aa2 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query86.q.out 
> 638cce1b46d38203a75733cefbe243154d3d4896 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query88.q.out 
> 64919cafe7c65e24df25f6c8b347cb6ea2c6078f 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query89.q.out 
> 3049fec95c3c38bdac7f35b103721822f2cb2f63 
>   ql/src/test/results/clientpositive/perf/tez/query11.q.out 
> da1c349ff06cdcf0d6a1913262938a5afbbd75cb 
>   ql/src/test/results/clientpositive/perf/tez/query13.q.out 
> 2cf833bbf1acc4db829f363607f00a44535c113c 
>   ql/src/test/results/clientpositive/perf/tez/query31.q.out 
> c0762b7bd476252d1a62b21a41dadebf70055fce 
>   ql/src/test/results/clientpositive/perf/tez/query36.q.out 
> 064837a3cf1c8dcfd4adab6a60b07050f3156342 
>   ql/src/test/results/clientpositive/perf/tez/query4.q.out 
> bb0d7ba3f5f3e575c52d8ea7dd1b1f01b5bb812f 
>   ql/src/test/results/clientpositive/perf/tez/query45.q.out 
> c2f9374c4b04afc12118a34279c7c5bf66be58a5 
>   ql/src/test/results/clientpositive/perf/tez/query48.q.out 
> 885be1371fdd3b073aeebe56b6eacb8918e20bf2 
>   ql/src/test/results/clientpositive/perf/tez/query53.q.out 
> e9153f3a06c75a431e0c6c7496c436c7a6ddd7a5 
>   ql/src/test/results/clientpositive/perf/tez/query63.q.out 
> 0bdd48b728eca8ba372e764ac68aaef8c6050db5 
>   ql/src/test/results/clientpositive/perf/tez/query70.q.out 
> 6d2528e474bea4f70c3cec769466fa136c2070bb 
>   ql/src/test/results/clientpositive/perf/tez/query74.q.out 
> 20aade29748a358f13d6dc84342fbb739a6c08d0 
>   ql/src/test/results/clientpositive/perf/tez/query78.q.out 
> 3d938e1c8e7b443a83c197d1fd861ee3a83a883e 
>   ql/src/test/results/clientpositive/perf/tez/query85.q.out 
> 1ada3945fdd2e37d5b439bf30647d3d944b28013 
>   ql/src/test/results/clientpositive/perf/tez/query86.q.out 
> 2d6d545a5bd12afcc359745ea4da5de32b29c8be 
>   ql/src/test/results/clientpositive/perf/tez/query88.q.out 
> e02ff3715b2eb942ba2eb021f53360d2f15d5834 
>   ql/src/test/results/clientpositive/perf/tez/query89.q.out 
> 8501822cd2200394fc8d084b523f1933c77bed97 
>   ql/src/test/results/clientpositive/pointlookup.q.out 
> 35ece97d90c5ea959f3323a5ef94807cf27ecae2 
>   ql/src/test/results/clientpositive/pointlookup2.q.out 
> 42d2c787a0dcb9706e99dd1c4a40074c40268b74 
>   ql/src/test/results/clientpositive/pointlookup3.q.out 
> a3056a515e3bae3cd193ac629cac0271e1a82a01 
>   ql/src/test/results/clientpositive/pointlookup4.q.out 
> efbc8518d4981b7cad0a5b43782d279a1f76fa15 
>   ql/src/test/results/clientpositive/ppd2.q.out 
> a9af979e4fd089afaf2f25c271ec8c22b95d7401 
>   ql/src/test/results/clientpositive/ppd_constant_expr.q.out 
> 27c13d3df379fda9a3bfc3c020b4d9f14bc61062 
>   ql/src/test/results/clientpositive/ppd_join_filter.q.out 
> 790c4b503b4552e8c5fd44fa527622745b6cb67d 
>   ql/src/test/results/clientpositive/ppd_udf_case.q.out 
> b791a9f51014dfb4ada0914321952c843c0966cd 
>   ql/src/test/results/clientpositive/ppr_allchildsarenull.q.out 
> 26612905f226a306c5eccda06de41b61813ca9a9 
>   ql/src/test/results/clientpositive/rand_partitionpruner2.q.out 
> 692d861dab2e34a7e04b3de32e8706b3164f4961 
>   ql/src/test/results/clientpositive/rand_partitionpruner3.q.out 
> db7441ffc7ffa0cb6e338c53e5746925896f2524 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_12.q.out 
> bae6c2ab8274110ab761046c4aaf5a06f199cefa 
>   ql/src/test/results/clientpositive/spark/bucket_map_join_tez2.q.out 
> aecb230178088e87329b6809da2052b9ef182211 
>   ql/src/test/results/clientpositive/spark/cbo_simple_select.q.out 
> acf91bf1787fb19c1c51264beabaa109d36c59f2 
>   ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out 
> 0bd26cb7cba012388db59f409ccee6864b6b8b85 
>   ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out 
> 62c8f16a12d7f5d1105907e80b709984a4359201 
>   ql/src/test/results/clientpositive/spark/join_filters_overlap.q.out 
> 49226b2622f2b7b84bd3f81201af6c95ebc5d43d 
>   ql/src/test/results/clientpositive/spark/list_bucket_dml_2.q.out 
> 212b16327a5138d26b601b99dbce17e3fee0002e 
>   ql/src/test/results/clientpositive/spark/parquet_vectorization_0.q.out 
> 55998aea7fa061cc933b49e4ff6ec061d229b51c 
>   ql/src/test/results/clientpositive/spark/parquet_vectorization_5.q.out 
> 022f16c39471493ca7463a7eb5a08f08a3c2195c 
>   ql/src/test/results/clientpositive/spark/parquet_vectorization_8.q.out 
> 657e05cb097d2c8827953d1f4d1b63036231f9f8 
>   ql/src/test/results/clientpositive/spark/pcr.q.out 
> 270f55ad9bd66aeb6c8512109b1a7cc97bcad351 
>   ql/src/test/results/clientpositive/spark/ppd_join_filter.q.out 
> c3bc6f4cb0dfd5bb52aeb62dacd0660e92e7043b 
>   
> ql/src/test/results/clientpositive/spark/spark_dynamic_partition_pruning.q.out
>  5f06e4e832d94683476c9ac2b2a02a902ebfe6e0 
>   ql/src/test/results/clientpositive/spark/spark_explainuser_1.q.out 
> 3e395a84ecbd5808462a32573a3a833cf96deeda 
>   
> ql/src/test/results/clientpositive/spark/spark_vectorized_dynamic_partition_pruning.q.out
>  6ab8da9c269160b458be8d39aaa62d4c20c08c80 
>   ql/src/test/results/clientpositive/spark/subquery_in.q.out 
> 09cd9d8550974580f1f4d9f29f6272db9841d524 
>   ql/src/test/results/clientpositive/spark/subquery_multi.q.out 
> 5bf5459b5641ccccafcd40875f7348bf659ab82b 
>   ql/src/test/results/clientpositive/spark/subquery_notin.q.out 
> 89d032f8c36002fb0b522c0af171b2c98c9f8dfe 
>   ql/src/test/results/clientpositive/spark/subquery_null_agg.q.out 
> 4223d6dc99a1bed808c35023b767faeb07d2217e 
>   ql/src/test/results/clientpositive/spark/subquery_scalar.q.out 
> e204a01333538d76e64029f75cae0ba5580967df 
>   ql/src/test/results/clientpositive/spark/subquery_select.q.out 
> 3104c5c6cbaacef42d869543bfcd63f99636a3d6 
>   ql/src/test/results/clientpositive/spark/subquery_views.q.out 
> 30bcf4b43c50a9b5675997669340ffc9516d853f 
>   ql/src/test/results/clientpositive/spark/union22.q.out 
> 3798d87f7bf9b77b055f9cb33d649d4838667fe2 
>   ql/src/test/results/clientpositive/spark/vectorization_0.q.out 
> c4626e4e465b3f2c563868f2cf231dbb8025720d 
>   ql/src/test/results/clientpositive/spark/vectorization_5.q.out 
> 82973c6249b0f3792ad77a5f5037a583b2dca5fd 
>   ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out 
> 6c3ab0d851913d711149ac1a6a8c0d856a1d4689 
>   ql/src/test/results/clientpositive/spark/vectorized_math_funcs.q.out 
> fe97f78be3508bc3e9144eb96e9b04d181d699d8 
>   ql/src/test/results/clientpositive/spark/vectorized_string_funcs.q.out 
> 79546c5a736b67f6f93328099981e26dbe23418d 
>   ql/src/test/results/clientpositive/subquery_notin_having.q.out 
> 30580ab5490c827aa4a0c40d9d810f44acdbf3e2 
>   ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out 
> 7cbbaa7b010c9a59f865944c976784a37e6c8ffd 
>   ql/src/test/results/clientpositive/timestamp_ints_casts.q.out 
> 3997377966425b92c8ab38c71888195209d415d4 
>   ql/src/test/results/clientpositive/truncate_column_list_bucket.q.out 
> 5f019995004c8de061fb7441707f62dfc0494dd0 
>   ql/src/test/results/clientpositive/udf_isops_simplify.q.out 
> 96a07181c126b8bc3344457eeb06f1395abd9ea9 
>   ql/src/test/results/clientpositive/union22.q.out 
> 3862eb8cb2ad3148850df63ca5f7e8d58d475840 
>   ql/src/test/results/clientpositive/union_offcbo.q.out 
> 7d3161302494927ad187096ff40375a6a03d03f8 
>   ql/src/test/results/clientpositive/vector_case_when_1.q.out 
> 9949de73abd975a53d9e40cf8e22dcc63b7c9a9d 
>   ql/src/test/results/clientpositive/vector_case_when_2.q.out 
> 60a80bcbc19259986c17881ef7fb72294590c334 
>   ql/src/test/results/clientpositive/vector_coalesce_3.q.out 
> cf9d9e352162862f39c25c7bf28fbb80d03a6aae 
>   ql/src/test/results/clientpositive/vector_decimal_math_funcs.q.out 
> 56b72db68b49e60f5f0f739952b8ad0fe048b45b 
>   ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out 
> 1f60366c5e3585fe3e1941adfa461559927c8132 
>   ql/src/test/results/clientpositive/vectorization_5.q.out 
> e0bfa727d705519153056789f13240b83400de92 
>   ql/src/test/results/clientpositive/vectorization_8.q.out 
> 498506cbb7fc54daf68ea0185a59054acb6bf434 
>   ql/src/test/results/clientpositive/vectorized_casts.q.out 
> c8fb9ec7c8343ff4a051b140c1f7c8ac552945db 
>   ql/src/test/results/clientpositive/vectorized_math_funcs.q.out 
> 0ce4ea149f66c0858436e3d88d589a1faf4090a0 
>   ql/src/test/results/clientpositive/vectorized_string_funcs.q.out 
> d4db85452aab4d10aa6f6f3ce1fca331b3152fb1 
>   ql/src/test/results/clientpositive/vectorized_timestamp_ints_casts.q.out 
> efb2fc23fc32e65afb7d16917148d8efc52453c4 
> 
> 
> Diff: https://reviews.apache.org/r/69918/diff/1/
> 
> 
> Testing
> -------
> 
> 
> Thanks,
> 
> Zoltan Haindrich
> 
>

Reply via email to