> On Feb. 7, 2019, 10:16 p.m., Ashutosh Chauhan wrote: > > accumulo-handler/src/test/results/positive/accumulo_predicate_pushdown.q.out > > Line 417 (original), 417 (patched) > > <https://reviews.apache.org/r/69918/diff/1/?file=2124217#file2124217line417> > > > > This should further fold to key >= '90'Can you file a follow-up jira > > for this?
I think this might not be simplified further; because when key is null the expression should be true. ``` (key < '90') is not true (key >= '90') or key is null not COALESCE((key < '90'),false) COALESCE((key >= '90'),true) ``` > On Feb. 7, 2019, 10:16 p.m., Ashutosh Chauhan wrote: > > ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveRelBuilder.java > > Lines 156 (patched) > > <https://reviews.apache.org/r/69918/diff/1/?file=2124221#file2124221line159> > > > > Can you add a comment for this, since this is counter-intuitive. sure. This enables an agressive project merge - which is done by the builder and it merges together multiple windowing expressions ; there are rules to merge projects together - this builder feature looks like something which is somewhat redundant > On Feb. 7, 2019, 10:16 p.m., Ashutosh Chauhan wrote: > > ql/src/test/results/clientpositive/cbo_rp_simple_select.q.out > > Line 902 (original), 900 (patched) > > <https://reviews.apache.org/r/69918/diff/1/?file=2124225#file2124225line903> > > > > We lost filterExpr on TableScan this will prohibit pushing of filters > > to ORC. Can you investigate this and file follow-up jira for this? yes the filter is false; opened HIVE-21251 > On Feb. 7, 2019, 10:16 p.m., Ashutosh Chauhan wrote: > > ql/src/test/results/clientpositive/constant_prop_3.q.out > > Line 286 (original), 286 (patched) > > <https://reviews.apache.org/r/69918/diff/1/?file=2124230#file2124230line286> > > > > New expression tree is longer compared to original. I guess we try to > > apply DeMorgan theorem here, but in this case its a net loss. Perhaps, we > > can add a (simple) logic which says if node count in expression tree grows > > after the application of theorem we throw away that. simplification is too conservative in 1.18; see: CALCITE-2840 > On Feb. 7, 2019, 10:16 p.m., Ashutosh Chauhan wrote: > > ql/src/test/results/clientpositive/constprog_when_case.q.out > > Line 53 (original), 53 (patched) > > <https://reviews.apache.org/r/69918/diff/1/?file=2124231#file2124231line53> > > > > Same comment as previous. this is not simplified right now; because it's inside an "if" - I believe the best would be to rewrite IF to CASE before running calcite (HIVE-21152) there was a problematic simplification invcation which visited every subexpression ; and it was prone to some bugs - the fix is to be more carefull; and as such it not visits "unknown udfs" > On Feb. 7, 2019, 10:16 p.m., Ashutosh Chauhan wrote: > > ql/src/test/results/clientpositive/fold_case.q.out > > Line 21 (original), 21 (patched) > > <https://reviews.apache.org/r/69918/diff/1/?file=2124238#file2124238line21> > > > > {{is true}} is redundant. Can we re-fold it? yes; simplify currently not removes redundant IS X w.r.t. unknownAs mode - I've noted this somewhere... it's interesting that it earlier worked CALCITE-2838 > On Feb. 7, 2019, 10:16 p.m., Ashutosh Chauhan wrote: > > ql/src/test/results/clientpositive/fold_eq_with_case_when.q.out > > Line 50 (original), 50 (patched) > > <https://reviews.apache.org/r/69918/diff/1/?file=2124239#file2124239line50> > > > > New Expression is more complex to evaluate. Can we refold this? yes, this shouldn't happen; "ELSE NULL" should really be "ELSE FALSE" > On Feb. 7, 2019, 10:16 p.m., Ashutosh Chauhan wrote: > > ql/src/test/results/clientpositive/fold_when.q.out > > Line 227 (original), 227 (patched) > > <https://reviews.apache.org/r/69918/diff/1/?file=2124240#file2124240line227> > > > > This {{is true}} also gets in a way of constant propagation. CALCITE-2838 > On Feb. 7, 2019, 10:16 p.m., Ashutosh Chauhan wrote: > > ql/src/test/results/clientpositive/list_bucket_dml_14.q.out > > Line 300 (original), 300 (patched) > > <https://reviews.apache.org/r/69918/diff/1/?file=2124256#file2124256line300> > > > > Although this doesn't affect correctness, but Hive does make a > > difference between string and varchar. It would have been useful to retain > > this cast as string since that is what is executed by Hive. this seem have worked very similarily earlier; only the printout is "fixed" https://github.com/apache/hive/blob/e540cf8238680453fc04e861dbc332e7f56b904a/ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java#L1494 CALCITE-2713 added a check to limit it to 64K I've set hive typesystem...it was the default during optimizedsql generation > On Feb. 7, 2019, 10:16 p.m., Ashutosh Chauhan wrote: > > ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query78.q.out > > Lines 150-154 (original), 147-160 (patched) > > <https://reviews.apache.org/r/69918/diff/1/?file=2124363#file2124363line150> > > > > Is new join order better? actually the join order is the same; but there are some new conditions which were pushed down further > On Feb. 7, 2019, 10:16 p.m., Ashutosh Chauhan wrote: > > ql/src/test/results/clientpositive/perf/tez/query70.q.out > > Line 113 (original), 113 (patched) > > <https://reviews.apache.org/r/69918/diff/1/?file=2124400#file2124400line113> > > > > UDFToLong(0) should be folded. Can you file a follow-up jira for it? yes; cast(null as string) also seems to be odd at the ast level it looks good - calcite doesn't seem to be leaving an explicit cast there > On Feb. 7, 2019, 10:16 p.m., Ashutosh Chauhan wrote: > > ql/src/test/results/clientpositive/ppd_udf_case.q.out > > Line 50 (original), 49 (patched) > > <https://reviews.apache.org/r/69918/diff/1/?file=2124414#file2124414line50> > > > > New expression is more expensive to evaluate. this expression is false ``` (null and (key = '27') is not true and (key = '38') is not true)) is true ``` I'll take a look why it regressed after some calcite fixes I've prepared so far...most probably CALCITE-2840 > On Feb. 7, 2019, 10:16 p.m., Ashutosh Chauhan wrote: > > ql/src/test/results/clientpositive/ppd_udf_case.q.out > > Line 214 (original), 215-217 (patched) > > <https://reviews.apache.org/r/69918/diff/1/?file=2124414#file2124414line218> > > > > Constant propagation is also broken here. will be fixed with my current set of calcite changes - 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 > >
