You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by Zoltan Haindrich <ki...@rxd.hu> on 2019/03/27 15:41:22 UTC

Re: Review Request 69918: HIVE-21001 Update to Calcite 1.19

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

(Updated March 27, 2019, 4:40 p.m.)


Review request for hive, Ashutosh Chauhan and Jesús Camacho Rodríguez.


Changes
-------

update diff


Summary (updated)
-----------------

HIVE-21001 Update to Calcite 1.19


Bugs: HIVE-21001
    https://issues.apache.org/jira/browse/HIVE-21001


Repository: hive-git


Description (updated)
-------

patch#1 here is #23 on jira
patch#2 here is #48 on jira


Diffs (updated)
-----

  accumulo-handler/src/test/results/positive/accumulo_predicate_pushdown.q.out fb8fca9324 
  accumulo-handler/src/test/results/positive/accumulo_queries.q.out 80a7dc9717 
  hbase-handler/src/test/results/positive/hbase_ppd_key_range.q.out b80738b263 
  hbase-handler/src/test/results/positive/hbase_pushdown.q.out f37460c6d3 
  hbase-handler/src/test/results/positive/hbase_queries.q.out cfcfaf3274 
  pom.xml 7b45d84de8 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveRelBuilder.java e85a99e846 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveRelDecorrelator.java 238ae4ef4e 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveSubQueryRemoveRule.java 50ed8eda89 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/translator/ASTBuilder.java 74f8c33ab7 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/translator/ASTConverter.java e783d1c833 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/ppr/PartitionPruner.java 7645564f3d 
  ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java 98e94e27e9 
  ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java a2dd554b6e 
  ql/src/test/queries/clientpositive/druidmini_expressions.q e491986250 
  ql/src/test/queries/clientpositive/subquery_multi.q 81a9187c19 
  ql/src/test/results/clientpositive/allcolref_in_udf.q.out b635f67b7a 
  ql/src/test/results/clientpositive/alter_partition_coltype.q.out 1fbc2131d5 
  ql/src/test/results/clientpositive/annotate_stats_filter.q.out 44f77b8f50 
  ql/src/test/results/clientpositive/annotate_stats_join_pkfk.q.out 2cf5b0c456 
  ql/src/test/results/clientpositive/auto_join2.q.out f154680c62 
  ql/src/test/results/clientpositive/auto_join33.q.out 27fe10a0aa 
  ql/src/test/results/clientpositive/auto_join_stats.q.out dc1338a5a7 
  ql/src/test/results/clientpositive/auto_join_stats2.q.out 69623472fc 
  ql/src/test/results/clientpositive/cbo_rp_simple_select.q.out cb22b61f26 
  ql/src/test/results/clientpositive/cbo_simple_select.q.out 32e69204f6 
  ql/src/test/results/clientpositive/char_udf1.q.out 09fb69782f 
  ql/src/test/results/clientpositive/complex_alias.q.out a808513d73 
  ql/src/test/results/clientpositive/constantPropWhen.q.out 1684cb6010 
  ql/src/test/results/clientpositive/constant_prop_3.q.out db73902af1 
  ql/src/test/results/clientpositive/constprog_when_case.q.out 958e05e959 
  ql/src/test/results/clientpositive/cte_mat_5.q.out 5beaada3f9 
  ql/src/test/results/clientpositive/decimal_udf.q.out b2a5837aef 
  ql/src/test/results/clientpositive/druid/druidmini_expressions.q.out 071a0f7739 
  ql/src/test/results/clientpositive/druid/druidmini_extractTime.q.out 4ea95f6930 
  ql/src/test/results/clientpositive/druid/druidmini_floorTime.q.out 8d9382443e 
  ql/src/test/results/clientpositive/druid/druidmini_test_ts.q.out 358e98b674 
  ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out 0c2ad97bdd 
  ql/src/test/results/clientpositive/encrypted/encryption_join_unencrypted_tbl.q.out e5e6fd1f48 
  ql/src/test/results/clientpositive/except_all.q.out 24a7dfbcf8 
  ql/src/test/results/clientpositive/filter_cond_pushdown.q.out 8627583c37 
  ql/src/test/results/clientpositive/fold_case.q.out f4ef28dae5 
  ql/src/test/results/clientpositive/fold_eq_with_case_when.q.out 7bd756a863 
  ql/src/test/results/clientpositive/fold_to_null.q.out 84c379e42e 
  ql/src/test/results/clientpositive/fold_when.q.out 2cf30b5b4d 
  ql/src/test/results/clientpositive/groupby_grouping_sets_grouping.q.out 33e68882ff 
  ql/src/test/results/clientpositive/groupby_rollup_empty.q.out ecfd766526 
  ql/src/test/results/clientpositive/groupby_sort_1_23.q.out e4ca83b0f4 
  ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out 7f1a231152 
  ql/src/test/results/clientpositive/in_typecheck_char.q.out 464aad5924 
  ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out cd9fb275c4 
  ql/src/test/results/clientpositive/infer_join_preds.q.out 0afdd029be 
  ql/src/test/results/clientpositive/innerjoin1.q.out cfc2c06bbc 
  ql/src/test/results/clientpositive/input8.q.out 32daa0598f 
  ql/src/test/results/clientpositive/join2.q.out ec9e436013 
  ql/src/test/results/clientpositive/join_filters_overlap.q.out 6cd17d1ddb 
  ql/src/test/results/clientpositive/list_bucket_dml_6.q.out da36c459fe 
  ql/src/test/results/clientpositive/list_bucket_dml_7.q.out 68664a7060 
  ql/src/test/results/clientpositive/list_bucket_dml_8.q.out 6521e0f497 
  ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out c6a3c1fb8f 
  ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out 30f8f0570b 
  ql/src/test/results/clientpositive/llap/auto_sortmerge_join_16.q.out 2c6d7cafa7 
  ql/src/test/results/clientpositive/llap/auto_sortmerge_join_6.q.out f61a6ed462 
  ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out 2d48b9fa84 
  ql/src/test/results/clientpositive/llap/bucketpruning1.q.out 934b383af5 
  ql/src/test/results/clientpositive/llap/cbo_simple_select.q.out acf91bf178 
  ql/src/test/results/clientpositive/llap/constraints_optimization.q.out fbdc702daf 
  ql/src/test/results/clientpositive/llap/cte_mat_5.q.out 7acc8eefc6 
  ql/src/test/results/clientpositive/llap/current_date_timestamp.q.out 54244672e4 
  ql/src/test/results/clientpositive/llap/default_constraint.q.out 5d716ebb56 
  ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out 1679d577e6 
  ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_2.q.out 9813b8fcc3 
  ql/src/test/results/clientpositive/llap/except_distinct.q.out d54dda9714 
  ql/src/test/results/clientpositive/llap/explainuser_1.q.out 1ea8fdcbb2 
  ql/src/test/results/clientpositive/llap/groupby_rollup_empty.q.out e7c0ab975b 
  ql/src/test/results/clientpositive/llap/join_constraints_optimization.q.out 1098bb41f3 
  ql/src/test/results/clientpositive/llap/kryo.q.out 7e10d64403 
  ql/src/test/results/clientpositive/llap/lineage3.q.out 11e6904a12 
  ql/src/test/results/clientpositive/llap/mapjoin_hint.q.out 9350fcb982 
  ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_3.q.out e0efe3cc1e 
  ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out 6c3ba6cd96 
  ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out d3e494dc4b 
  ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out b55287deb0 
  ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out cf6a6bace1 
  ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out d8aab03a22 
  ql/src/test/results/clientpositive/llap/materialized_view_rewrite_10.q.out de13beaf75 
  ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out 8566402bff 
  ql/src/test/results/clientpositive/llap/materialized_view_rewrite_7.q.out 4d7b983226 
  ql/src/test/results/clientpositive/llap/materialized_view_rewrite_no_join_opt.q.out 9197bb6394 
  ql/src/test/results/clientpositive/llap/mergejoin.q.out f1153e76dd 
  ql/src/test/results/clientpositive/llap/optimize_join_ptp.q.out abd7dbdf7a 
  ql/src/test/results/clientpositive/llap/orc_ppd_varchar.q.out 12d6f67092 
  ql/src/test/results/clientpositive/llap/sharedwork.q.out 9bd73f98b6 
  ql/src/test/results/clientpositive/llap/subquery_in.q.out afcbddcef2 
  ql/src/test/results/clientpositive/llap/subquery_in_having.q.out ddb7b421d9 
  ql/src/test/results/clientpositive/llap/subquery_multi.q.out e04b2a6f94 
  ql/src/test/results/clientpositive/llap/subquery_notin.q.out 37d9253f4e 
  ql/src/test/results/clientpositive/llap/subquery_null_agg.q.out 2c306da6d9 
  ql/src/test/results/clientpositive/llap/subquery_scalar.q.out 1016a64525 
  ql/src/test/results/clientpositive/llap/subquery_select.q.out ab56f905e0 
  ql/src/test/results/clientpositive/llap/subquery_views.q.out fbc9f5b82d 
  ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_2.q.out c1156759d2 
  ql/src/test/results/clientpositive/llap/tez_smb_reduce_side.q.out 93a1716064 
  ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_2.q.out c1156759d2 
  ql/src/test/results/clientpositive/llap/unionDistinct_1.q.out 3d6fe204be 
  ql/src/test/results/clientpositive/llap/vector_adaptor_usage_mode.q.out 93c7e5aa61 
  ql/src/test/results/clientpositive/llap/vector_case_when_1.q.out 6529758a3a 
  ql/src/test/results/clientpositive/llap/vector_case_when_2.q.out 218a5cff17 
  ql/src/test/results/clientpositive/llap/vector_char_mapjoin1.q.out d6f01ae582 
  ql/src/test/results/clientpositive/llap/vector_coalesce_3.q.out 493cfca23a 
  ql/src/test/results/clientpositive/llap/vector_date_1.q.out e79a7b7e9e 
  ql/src/test/results/clientpositive/llap/vector_decimal_math_funcs.q.out b26fb62e17 
  ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets_grouping.q.out 16fe26fb6b 
  ql/src/test/results/clientpositive/llap/vector_groupby_mapjoin.q.out 229814f46d 
  ql/src/test/results/clientpositive/llap/vector_interval_2.q.out 28da5049af 
  ql/src/test/results/clientpositive/llap/vector_interval_mapjoin.q.out abf998eb90 
  ql/src/test/results/clientpositive/llap/vector_orc_nested_column_pruning.q.out 944a36329c 
  ql/src/test/results/clientpositive/llap/vector_varchar_mapjoin1.q.out f8b3223fdc 
  ql/src/test/results/clientpositive/llap/vector_windowing_navfn.q.out 2af57ed583 
  ql/src/test/results/clientpositive/llap/vectorization_0.q.out 1ee9aa97eb 
  ql/src/test/results/clientpositive/llap/vectorization_5.q.out 6467a2fd81 
  ql/src/test/results/clientpositive/llap/vectorization_6.q.out 2990bd4b82 
  ql/src/test/results/clientpositive/llap/vectorization_8.q.out 3959239dbe 
  ql/src/test/results/clientpositive/llap/vectorization_div0.q.out 9a260ef118 
  ql/src/test/results/clientpositive/llap/vectorization_short_regress.q.out 051dc2f8a8 
  ql/src/test/results/clientpositive/llap/vectorized_casts.q.out d1a9620186 
  ql/src/test/results/clientpositive/llap/vectorized_dynamic_partition_pruning.q.out 7f096716ff 
  ql/src/test/results/clientpositive/llap/vectorized_math_funcs.q.out 63b42fde3a 
  ql/src/test/results/clientpositive/llap/vectorized_string_funcs.q.out 7a5073577e 
  ql/src/test/results/clientpositive/llap/vectorized_timestamp_ints_casts.q.out c52e3b9e94 
  ql/src/test/results/clientpositive/masking_1.q.out d915a47757 
  ql/src/test/results/clientpositive/masking_12.q.out 178a141da3 
  ql/src/test/results/clientpositive/masking_2.q.out 6d8420270b 
  ql/src/test/results/clientpositive/masking_3.q.out 1c7cd158f4 
  ql/src/test/results/clientpositive/masking_4.q.out fc0acb7e27 
  ql/src/test/results/clientpositive/mergejoin.q.out 1c6d62c8a0 
  ql/src/test/results/clientpositive/nested_column_pruning.q.out 80fb68b2ba 
  ql/src/test/results/clientpositive/optimize_filter_literal.q.out 6eb573a400 
  ql/src/test/results/clientpositive/orc_nested_column_pruning.q.out 0fccc9ee7f 
  ql/src/test/results/clientpositive/orc_ppd_char.q.out 846de53ff4 
  ql/src/test/results/clientpositive/parquet_vectorization_0.q.out ebbe004dfa 
  ql/src/test/results/clientpositive/parquet_vectorization_5.q.out fd348a04c2 
  ql/src/test/results/clientpositive/parquet_vectorization_6.q.out 3ad9ad7e17 
  ql/src/test/results/clientpositive/parquet_vectorization_8.q.out 112f63392a 
  ql/src/test/results/clientpositive/parquet_vectorization_div0.q.out a4791ef2c9 
  ql/src/test/results/clientpositive/pcr.q.out 3840eae596 
  ql/src/test/results/clientpositive/pcs.q.out b6c22125f3 
  ql/src/test/results/clientpositive/perf/spark/query11.q.out 45f02fdb49 
  ql/src/test/results/clientpositive/perf/spark/query13.q.out 04be3cf39a 
  ql/src/test/results/clientpositive/perf/spark/query21.q.out db03678080 
  ql/src/test/results/clientpositive/perf/spark/query27.q.out 98a0ea8015 
  ql/src/test/results/clientpositive/perf/spark/query31.q.out 12c99b1431 
  ql/src/test/results/clientpositive/perf/spark/query34.q.out 1a6c034cef 
  ql/src/test/results/clientpositive/perf/spark/query36.q.out 2920c2f0b5 
  ql/src/test/results/clientpositive/perf/spark/query4.q.out 14a5ea2b21 
  ql/src/test/results/clientpositive/perf/spark/query45.q.out 7ee7c0ee2b 
  ql/src/test/results/clientpositive/perf/spark/query47.q.out 7ee1efa54e 
  ql/src/test/results/clientpositive/perf/spark/query48.q.out 80d9752853 
  ql/src/test/results/clientpositive/perf/spark/query53.q.out 939e2a54db 
  ql/src/test/results/clientpositive/perf/spark/query57.q.out b975a8abfc 
  ql/src/test/results/clientpositive/perf/spark/query63.q.out 9cd9c9897d 
  ql/src/test/results/clientpositive/perf/spark/query67.q.out f1954b1c85 
  ql/src/test/results/clientpositive/perf/spark/query70.q.out 11e8f0d18a 
  ql/src/test/results/clientpositive/perf/spark/query73.q.out f77acfda3d 
  ql/src/test/results/clientpositive/perf/spark/query74.q.out e7a4784479 
  ql/src/test/results/clientpositive/perf/spark/query78.q.out 125f0a9904 
  ql/src/test/results/clientpositive/perf/spark/query85.q.out 04a4e18c30 
  ql/src/test/results/clientpositive/perf/spark/query86.q.out 301679a2cd 
  ql/src/test/results/clientpositive/perf/spark/query87.q.out 9008fc2d99 
  ql/src/test/results/clientpositive/perf/spark/query88.q.out f06f831298 
  ql/src/test/results/clientpositive/perf/spark/query89.q.out c781201379 
  ql/src/test/results/clientpositive/perf/spark/query93.q.out f69920d27b 
  ql/src/test/results/clientpositive/perf/spark/query97.q.out 2372928d52 
  ql/src/test/results/clientpositive/perf/tez/cbo_ext_query1.q.out bcd1f8dd20 
  ql/src/test/results/clientpositive/perf/tez/cbo_query1.q.out 9d0fa3a109 
  ql/src/test/results/clientpositive/perf/tez/cbo_query11.q.out de0783be16 
  ql/src/test/results/clientpositive/perf/tez/cbo_query12.q.out cda7aa302e 
  ql/src/test/results/clientpositive/perf/tez/cbo_query13.q.out 412cc67334 
  ql/src/test/results/clientpositive/perf/tez/cbo_query14.q.out c85f42c4fd 
  ql/src/test/results/clientpositive/perf/tez/cbo_query15.q.out c00a7418f3 
  ql/src/test/results/clientpositive/perf/tez/cbo_query16.q.out ef8712ce1f 
  ql/src/test/results/clientpositive/perf/tez/cbo_query17.q.out 84832a4b4d 
  ql/src/test/results/clientpositive/perf/tez/cbo_query2.q.out 7b14ad3358 
  ql/src/test/results/clientpositive/perf/tez/cbo_query20.q.out ba354b6738 
  ql/src/test/results/clientpositive/perf/tez/cbo_query21.q.out 0365697005 
  ql/src/test/results/clientpositive/perf/tez/cbo_query23.q.out 377b587654 
  ql/src/test/results/clientpositive/perf/tez/cbo_query24.q.out 3add88ad25 
  ql/src/test/results/clientpositive/perf/tez/cbo_query25.q.out db13a5d30a 
  ql/src/test/results/clientpositive/perf/tez/cbo_query27.q.out e072692b33 
  ql/src/test/results/clientpositive/perf/tez/cbo_query28.q.out e0e61534c5 
  ql/src/test/results/clientpositive/perf/tez/cbo_query29.q.out 82a914b616 
  ql/src/test/results/clientpositive/perf/tez/cbo_query30.q.out 02e26a7c10 
  ql/src/test/results/clientpositive/perf/tez/cbo_query31.q.out 8907b8d6cd 
  ql/src/test/results/clientpositive/perf/tez/cbo_query32.q.out fc353fb02b 
  ql/src/test/results/clientpositive/perf/tez/cbo_query33.q.out 8534997488 
  ql/src/test/results/clientpositive/perf/tez/cbo_query34.q.out b2a6320acb 
  ql/src/test/results/clientpositive/perf/tez/cbo_query36.q.out 9a74bed470 
  ql/src/test/results/clientpositive/perf/tez/cbo_query37.q.out 07b9901520 
  ql/src/test/results/clientpositive/perf/tez/cbo_query39.q.out 51bb90101d 
  ql/src/test/results/clientpositive/perf/tez/cbo_query4.q.out 4b388653ae 
  ql/src/test/results/clientpositive/perf/tez/cbo_query40.q.out 1f834b5647 
  ql/src/test/results/clientpositive/perf/tez/cbo_query43.q.out 1d86c8bd07 
  ql/src/test/results/clientpositive/perf/tez/cbo_query47.q.out 8dff4677ba 
  ql/src/test/results/clientpositive/perf/tez/cbo_query48.q.out 22b051d06a 
  ql/src/test/results/clientpositive/perf/tez/cbo_query49.q.out 1300dd92af 
  ql/src/test/results/clientpositive/perf/tez/cbo_query5.q.out e78c3e5917 
  ql/src/test/results/clientpositive/perf/tez/cbo_query50.q.out becffde820 
  ql/src/test/results/clientpositive/perf/tez/cbo_query53.q.out 9b42428097 
  ql/src/test/results/clientpositive/perf/tez/cbo_query54.q.out 39b6a6be15 
  ql/src/test/results/clientpositive/perf/tez/cbo_query56.q.out d01dbcd154 
  ql/src/test/results/clientpositive/perf/tez/cbo_query57.q.out 6c8ef17bc6 
  ql/src/test/results/clientpositive/perf/tez/cbo_query58.q.out b4410ff07a 
  ql/src/test/results/clientpositive/perf/tez/cbo_query59.q.out 8674a8a6c6 
  ql/src/test/results/clientpositive/perf/tez/cbo_query6.q.out f502c004cf 
  ql/src/test/results/clientpositive/perf/tez/cbo_query60.q.out acda930197 
  ql/src/test/results/clientpositive/perf/tez/cbo_query61.q.out 3c03347810 
  ql/src/test/results/clientpositive/perf/tez/cbo_query63.q.out 78c9b13111 
  ql/src/test/results/clientpositive/perf/tez/cbo_query64.q.out 356778b4a7 
  ql/src/test/results/clientpositive/perf/tez/cbo_query65.q.out 25cb9ccc6b 
  ql/src/test/results/clientpositive/perf/tez/cbo_query66.q.out e2409a9d82 
  ql/src/test/results/clientpositive/perf/tez/cbo_query73.q.out 2639cf22b4 
  ql/src/test/results/clientpositive/perf/tez/cbo_query74.q.out 4a9a1127b3 
  ql/src/test/results/clientpositive/perf/tez/cbo_query75.q.out 8c445d9de5 
  ql/src/test/results/clientpositive/perf/tez/cbo_query76.q.out 740d03818e 
  ql/src/test/results/clientpositive/perf/tez/cbo_query77.q.out 91ad054e66 
  ql/src/test/results/clientpositive/perf/tez/cbo_query78.q.out 02635826f0 
  ql/src/test/results/clientpositive/perf/tez/cbo_query80.q.out 334f09cc33 
  ql/src/test/results/clientpositive/perf/tez/cbo_query81.q.out 0adb5551da 
  ql/src/test/results/clientpositive/perf/tez/cbo_query82.q.out a60312f11b 
  ql/src/test/results/clientpositive/perf/tez/cbo_query83.q.out 8211db1c95 
  ql/src/test/results/clientpositive/perf/tez/cbo_query85.q.out 0963936768 
  ql/src/test/results/clientpositive/perf/tez/cbo_query87.q.out e030b3eb2c 
  ql/src/test/results/clientpositive/perf/tez/cbo_query88.q.out 1f4471e8ae 
  ql/src/test/results/clientpositive/perf/tez/cbo_query89.q.out 7cfb3ecdec 
  ql/src/test/results/clientpositive/perf/tez/cbo_query91.q.out e6fe23fb5b 
  ql/src/test/results/clientpositive/perf/tez/cbo_query92.q.out be7f364ee9 
  ql/src/test/results/clientpositive/perf/tez/cbo_query93.q.out 6a8ed39e29 
  ql/src/test/results/clientpositive/perf/tez/cbo_query94.q.out e80788209e 
  ql/src/test/results/clientpositive/perf/tez/cbo_query95.q.out 68f318934c 
  ql/src/test/results/clientpositive/perf/tez/cbo_query97.q.out a6f39397ea 
  ql/src/test/results/clientpositive/perf/tez/cbo_query98.q.out 374a6a06d6 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_ext_query1.q.out 255261bdaa 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query1.q.out 13801ffc6c 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query11.q.out f315e3c455 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query12.q.out ab4a8377e6 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query13.q.out a08c5a4be1 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query14.q.out 118d23b577 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query15.q.out 32404b6209 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query16.q.out 1de59b24d9 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query17.q.out 120c8d28d1 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query2.q.out 07ab7a16e0 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query20.q.out 29382b389b 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query21.q.out 5e165e8e70 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query23.q.out 3146b776ce 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query24.q.out 41d96ea303 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query25.q.out 958033e41b 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query27.q.out 7fae258207 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query28.q.out e0e61534c5 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query29.q.out 3e7c6805b2 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query30.q.out bd68baa23b 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query31.q.out f8e31a23aa 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query32.q.out b5cf714198 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query33.q.out e8824ddf54 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query34.q.out 987f8d3eea 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query36.q.out d4031261c7 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query37.q.out f054717d70 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query39.q.out 272bedcbce 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query4.q.out 9668e0f4a1 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query40.q.out 5cce22af4e 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query43.q.out 6b21ee45c0 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query46.q.out 9d21449b65 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query47.q.out 8aa0871cb0 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query48.q.out 3188d82f28 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query49.q.out bc108dba6e 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query5.q.out 54f3dd6a10 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query50.q.out 49c87eedb5 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query53.q.out bac3f77538 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query54.q.out e33203d93c 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query56.q.out a13e599b34 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query57.q.out cb8f67b5c1 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query58.q.out 3e89c2da75 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query59.q.out 34376d1262 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query6.q.out 5e3deb3eb9 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query60.q.out ea098f7567 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query61.q.out 2bc02f51f7 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query63.q.out e22d812f78 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query64.q.out 8223efcdb6 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query65.q.out 3e906b73b0 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query66.q.out 77256a3adc 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query68.q.out 1b25235c8a 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query72.q.out 206b0f1972 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query73.q.out 38af7c0d35 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query74.q.out 4a8f0b88f0 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query75.q.out a95e756dab 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query76.q.out a51a05ac00 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query77.q.out 0ac295bf8f 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query78.q.out de1b133006 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query80.q.out a4fac0cca1 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query81.q.out 98066643bf 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query82.q.out 54c4a99b68 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query83.q.out 58ed6dabe7 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query85.q.out 91aad930ba 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query87.q.out 97c9eddc34 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query88.q.out 1ac8fe2dcd 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query89.q.out d9c7d42b9f 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query91.q.out 0017776216 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query92.q.out 503c78185c 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query94.q.out 25e0c8bd9e 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query95.q.out 606e162b30 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query97.q.out c8fff90413 
  ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query98.q.out 2a6b66f2bf 
  ql/src/test/results/clientpositive/perf/tez/constraints/mv_query44.q.out db9acc93cb 
  ql/src/test/results/clientpositive/perf/tez/constraints/query1.q.out 69f93290d9 
  ql/src/test/results/clientpositive/perf/tez/constraints/query11.q.out 7e0582e164 
  ql/src/test/results/clientpositive/perf/tez/constraints/query13.q.out 616ed6bcde 
  ql/src/test/results/clientpositive/perf/tez/constraints/query21.q.out 7c68a294ea 
  ql/src/test/results/clientpositive/perf/tez/constraints/query31.q.out 8e0de0ffe2 
  ql/src/test/results/clientpositive/perf/tez/constraints/query34.q.out e2c3631141 
  ql/src/test/results/clientpositive/perf/tez/constraints/query36.q.out 8158608354 
  ql/src/test/results/clientpositive/perf/tez/constraints/query4.q.out e6558e99a9 
  ql/src/test/results/clientpositive/perf/tez/constraints/query44.q.out 3fd361a9f9 
  ql/src/test/results/clientpositive/perf/tez/constraints/query45.q.out 64d9c98395 
  ql/src/test/results/clientpositive/perf/tez/constraints/query46.q.out dde72e07b8 
  ql/src/test/results/clientpositive/perf/tez/constraints/query47.q.out efb3edda71 
  ql/src/test/results/clientpositive/perf/tez/constraints/query48.q.out 93bafabefd 
  ql/src/test/results/clientpositive/perf/tez/constraints/query53.q.out a13d0f9c09 
  ql/src/test/results/clientpositive/perf/tez/constraints/query57.q.out 69aeaae7e9 
  ql/src/test/results/clientpositive/perf/tez/constraints/query6.q.out 7aea119ac3 
  ql/src/test/results/clientpositive/perf/tez/constraints/query63.q.out 5620b819fb 
  ql/src/test/results/clientpositive/perf/tez/constraints/query68.q.out dd4ce4eb84 
  ql/src/test/results/clientpositive/perf/tez/constraints/query70.q.out a49314c858 
  ql/src/test/results/clientpositive/perf/tez/constraints/query72.q.out 1a9c2cf203 
  ql/src/test/results/clientpositive/perf/tez/constraints/query73.q.out 52b0c26588 
  ql/src/test/results/clientpositive/perf/tez/constraints/query74.q.out 525217b526 
  ql/src/test/results/clientpositive/perf/tez/constraints/query78.q.out ef4d6dbc21 
  ql/src/test/results/clientpositive/perf/tez/constraints/query85.q.out aeb33836cd 
  ql/src/test/results/clientpositive/perf/tez/constraints/query86.q.out 638cce1b46 
  ql/src/test/results/clientpositive/perf/tez/constraints/query87.q.out b6d3904c1c 
  ql/src/test/results/clientpositive/perf/tez/constraints/query88.q.out 64919cafe7 
  ql/src/test/results/clientpositive/perf/tez/constraints/query89.q.out 3049fec95c 
  ql/src/test/results/clientpositive/perf/tez/query11.q.out da1c349ff0 
  ql/src/test/results/clientpositive/perf/tez/query13.q.out 60a73d7250 
  ql/src/test/results/clientpositive/perf/tez/query21.q.out 0d10843009 
  ql/src/test/results/clientpositive/perf/tez/query31.q.out c0762b7bd4 
  ql/src/test/results/clientpositive/perf/tez/query34.q.out d401e4cdc0 
  ql/src/test/results/clientpositive/perf/tez/query36.q.out 064837a3cf 
  ql/src/test/results/clientpositive/perf/tez/query4.q.out bb0d7ba3f5 
  ql/src/test/results/clientpositive/perf/tez/query45.q.out c2f9374c4b 
  ql/src/test/results/clientpositive/perf/tez/query47.q.out 04c64b405f 
  ql/src/test/results/clientpositive/perf/tez/query48.q.out d64eec1c74 
  ql/src/test/results/clientpositive/perf/tez/query53.q.out e9153f3a06 
  ql/src/test/results/clientpositive/perf/tez/query57.q.out 4a18880260 
  ql/src/test/results/clientpositive/perf/tez/query63.q.out 0bdd48b728 
  ql/src/test/results/clientpositive/perf/tez/query70.q.out 8d9d06dd48 
  ql/src/test/results/clientpositive/perf/tez/query73.q.out 352c7245ea 
  ql/src/test/results/clientpositive/perf/tez/query74.q.out 20aade2974 
  ql/src/test/results/clientpositive/perf/tez/query78.q.out 3d938e1c8e 
  ql/src/test/results/clientpositive/perf/tez/query85.q.out 5b8ad0ba57 
  ql/src/test/results/clientpositive/perf/tez/query86.q.out 2d6d545a5b 
  ql/src/test/results/clientpositive/perf/tez/query87.q.out 5b59116741 
  ql/src/test/results/clientpositive/perf/tez/query88.q.out e02ff3715b 
  ql/src/test/results/clientpositive/perf/tez/query89.q.out 8501822cd2 
  ql/src/test/results/clientpositive/perf/tez/query93.q.out b5e6ba9c48 
  ql/src/test/results/clientpositive/pointlookup.q.out c77536efe5 
  ql/src/test/results/clientpositive/pointlookup2.q.out 5a1f92758a 
  ql/src/test/results/clientpositive/pointlookup3.q.out 469a460773 
  ql/src/test/results/clientpositive/pointlookup4.q.out f105f8a569 
  ql/src/test/results/clientpositive/ppd_constant_expr.q.out 39dd2d7de3 
  ql/src/test/results/clientpositive/ppd_join_filter.q.out 68a8cd01f7 
  ql/src/test/results/clientpositive/row__id.q.out fc4c3123b0 
  ql/src/test/results/clientpositive/semijoin4.q.out 4cfdd55503 
  ql/src/test/results/clientpositive/semijoin5.q.out 6fd4174110 
  ql/src/test/results/clientpositive/skewjoinopt18.q.out 26526a37b2 
  ql/src/test/results/clientpositive/spark/auto_join2.q.out 6aeadb52dd 
  ql/src/test/results/clientpositive/spark/auto_join_stats.q.out a6d09228c1 
  ql/src/test/results/clientpositive/spark/auto_join_stats2.q.out fbcc489b14 
  ql/src/test/results/clientpositive/spark/auto_sortmerge_join_12.q.out 7138a6fb30 
  ql/src/test/results/clientpositive/spark/auto_sortmerge_join_16.q.out 24cf07b9a3 
  ql/src/test/results/clientpositive/spark/auto_sortmerge_join_16.q.out_spark 8c22440488 
  ql/src/test/results/clientpositive/spark/auto_sortmerge_join_6.q.out 329cdf66b2 
  ql/src/test/results/clientpositive/spark/bucket_map_join_tez2.q.out be43889af1 
  ql/src/test/results/clientpositive/spark/cbo_simple_select.q.out acf91bf178 
  ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out 866a86d7b4 
  ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out 06da1248f3 
  ql/src/test/results/clientpositive/spark/infer_bucket_sort_map_operators.q.out 59e25f890e 
  ql/src/test/results/clientpositive/spark/join2.q.out 3f64bc9a40 
  ql/src/test/results/clientpositive/spark/join_filters_overlap.q.out 49226b2622 
  ql/src/test/results/clientpositive/spark/parquet_vectorization_0.q.out adb9f4a33b 
  ql/src/test/results/clientpositive/spark/parquet_vectorization_5.q.out fc3952117a 
  ql/src/test/results/clientpositive/spark/parquet_vectorization_6.q.out 6eabffb84d 
  ql/src/test/results/clientpositive/spark/parquet_vectorization_8.q.out 357a321c27 
  ql/src/test/results/clientpositive/spark/parquet_vectorization_div0.q.out 8f40278318 
  ql/src/test/results/clientpositive/spark/pcr.q.out 2c5b15aa3a 
  ql/src/test/results/clientpositive/spark/ppd_join_filter.q.out b8a8760955 
  ql/src/test/results/clientpositive/spark/skewjoinopt18.q.out 0e43a882ed 
  ql/src/test/results/clientpositive/spark/spark_dynamic_partition_pruning.q.out 89da63134c 
  ql/src/test/results/clientpositive/spark/spark_explainuser_1.q.out b8403f4e39 
  ql/src/test/results/clientpositive/spark/spark_use_ts_stats_for_mapjoin.q.out eecacca8ad 
  ql/src/test/results/clientpositive/spark/spark_vectorized_dynamic_partition_pruning.q.out e90f9d17ac 
  ql/src/test/results/clientpositive/spark/subquery_in.q.out 3fc9aa1b1b 
  ql/src/test/results/clientpositive/spark/subquery_multi.q.out 17240f9dc5 
  ql/src/test/results/clientpositive/spark/subquery_notin.q.out 2d93874450 
  ql/src/test/results/clientpositive/spark/subquery_null_agg.q.out 302c2609cb 
  ql/src/test/results/clientpositive/spark/subquery_scalar.q.out 4e31c3fd20 
  ql/src/test/results/clientpositive/spark/subquery_select.q.out 3c6f6af020 
  ql/src/test/results/clientpositive/spark/subquery_views.q.out d048716c0a 
  ql/src/test/results/clientpositive/spark/union22.q.out 3798d87f7b 
  ql/src/test/results/clientpositive/spark/vectorization_0.q.out c6e0c33dc5 
  ql/src/test/results/clientpositive/spark/vectorization_5.q.out 00f8260aac 
  ql/src/test/results/clientpositive/spark/vectorization_6.q.out d1cc6e39ed 
  ql/src/test/results/clientpositive/spark/vectorization_div0.q.out 18159aa9bf 
  ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out 2d8d8b1ec9 
  ql/src/test/results/clientpositive/spark/vectorized_math_funcs.q.out 977725ca4c 
  ql/src/test/results/clientpositive/spark/vectorized_string_funcs.q.out 79546c5a73 
  ql/src/test/results/clientpositive/subquery_notexists.q.out 2b6c08bde4 
  ql/src/test/results/clientpositive/subquery_notin_having.q.out 68a65df3a9 
  ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out 7217ac55b3 
  ql/src/test/results/clientpositive/timestamp_ints_casts.q.out 83d4557c8a 
  ql/src/test/results/clientpositive/udf_isops_simplify.q.out e9fcd05939 
  ql/src/test/results/clientpositive/udf_to_unix_timestamp.q.out 1f446eb454 
  ql/src/test/results/clientpositive/union22.q.out a3aa5e2c77 
  ql/src/test/results/clientpositive/union_offcbo.q.out 2e5675fe8e 
  ql/src/test/results/clientpositive/vector_case_when_1.q.out 61062e1f8e 
  ql/src/test/results/clientpositive/vector_case_when_2.q.out 29b0823961 
  ql/src/test/results/clientpositive/vector_char_mapjoin1.q.out 19cb5b4b71 
  ql/src/test/results/clientpositive/vector_coalesce_3.q.out 39fd5e898a 
  ql/src/test/results/clientpositive/vector_date_1.q.out 4e82ed84b6 
  ql/src/test/results/clientpositive/vector_decimal_math_funcs.q.out 31751503b5 
  ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out 613a30701a 
  ql/src/test/results/clientpositive/vector_interval_mapjoin.q.out 49843e939e 
  ql/src/test/results/clientpositive/vector_varchar_mapjoin1.q.out 0d4107991c 
  ql/src/test/results/clientpositive/vectorization_5.q.out 36eb6d53a8 
  ql/src/test/results/clientpositive/vectorization_6.q.out fbb6f5e3ca 
  ql/src/test/results/clientpositive/vectorization_8.q.out 6a52519eae 
  ql/src/test/results/clientpositive/vectorized_casts.q.out fd6277c4bb 
  ql/src/test/results/clientpositive/vectorized_math_funcs.q.out 0b0aba6829 
  ql/src/test/results/clientpositive/vectorized_string_funcs.q.out 64064c0e85 
  ql/src/test/results/clientpositive/vectorized_timestamp_ints_casts.q.out bf66c03a5e 
  ql/src/test/results/clientpositive/view_cbo.q.out c7d9c8a0ec 


Diff: https://reviews.apache.org/r/69918/diff/2/

Changes: https://reviews.apache.org/r/69918/diff/1-2/


Testing
-------


Thanks,

Zoltan Haindrich


Re: Review Request 69918: HIVE-21001 Update to Calcite 1.19

Posted by Zoltan Haindrich <ki...@rxd.hu>.

> On March 27, 2019, 9:06 p.m., Jesús Camacho Rodríguez wrote:
> > accumulo-handler/src/test/results/positive/accumulo_queries.q.out
> > Line 150 (original), 150 (patched)
> > <https://reviews.apache.org/r/69918/diff/2/?file=2134691#file2134691line150>
> >
> >     Is this a known issue?

removing the cast might have suppressed problematic cases;

In Hive: `select cast('xxx' as double) is null` should be true; however `select 'xxx' is null` is false

see: CALCITE-2929


> On March 27, 2019, 9:06 p.m., Jesús Camacho Rodríguez wrote:
> > ql/src/test/results/clientpositive/allcolref_in_udf.q.out
> > Line 107 (original), 107 (patched)
> > <https://reviews.apache.org/r/69918/diff/2/?file=2134706#file2134706line107>
> >
> >     Known issue?

CALCITE-2929


> On March 27, 2019, 9:06 p.m., Jesús Camacho Rodríguez wrote:
> > ql/src/test/results/clientpositive/auto_join2.q.out
> > Line 42 (original), 42 (patched)
> > <https://reviews.apache.org/r/69918/diff/2/?file=2134710#file2134710line42>
> >
> >     I guess same as previous one, but this time it is preventing folding in more complex expression from happening.

CALCITE-2929 was a late comer to 1.19 release;

this change was happening in many q.out-s; not sure how much impact this has - but from `UDFToDouble(key) is not null` we could deduce that `key is not null`...
however; I think keeping `key is not null` is also good; because I don't think that readers could be able to do the `cast` as well.


> On March 27, 2019, 9:06 p.m., Jesús Camacho Rodríguez wrote:
> > ql/src/test/results/clientpositive/filter_cond_pushdown.q.out
> > Line 344 (original), 344 (patched)
> > <https://reviews.apache.org/r/69918/diff/2/?file=2134730#file2134730line344>
> >
> >     Is the literal transformation here expected (int -> double?)?

query expressions is: `(int1 + int2) > 2`; so integer comparision would be fine....
I've checked that even earlier if the literal was 2.1 or something it worked correctly and the comparision happened in decimal


> On March 27, 2019, 9:06 p.m., Jesús Camacho Rodríguez wrote:
> > ql/src/test/results/clientpositive/llap/explainuser_1.q.out
> > Line 588 (original), 588 (patched)
> > <https://reviews.apache.org/r/69918/diff/2/?file=2134763#file2134763line588>
> >
> >     Constant literal transformation. Is it expected?

`((UDFToFloat(c_int) + c_float) >= 0.0)`

I think in this case it is ok to change to floating point; as left hand side is all float as well


> On March 27, 2019, 9:06 p.m., Jesús Camacho Rodríguez wrote:
> > ql/src/test/results/clientpositive/llap/orc_ppd_varchar.q.out
> > Line 29 (original), 29 (patched)
> > <https://reviews.apache.org/r/69918/diff/2/?file=2134781#file2134781line29>
> >
> >     Expected?

this issue has its own ticket: issues is that a literal varchar value have changed type to string
https://issues.apache.org/jira/browse/HIVE-21316


> On March 27, 2019, 9:06 p.m., Jesús Camacho Rodríguez wrote:
> > ql/src/test/results/clientpositive/orc_ppd_char.q.out
> > Line 29 (original), 29 (patched)
> > <https://reviews.apache.org/r/69918/diff/2/?file=2134829#file2134829line29>
> >
> >     Expected?

this issue has its own ticket: issues is that a literal varchar value have changed type to string
https://issues.apache.org/jira/browse/HIVE-21316


- Zoltan


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


On March 27, 2019, 4:40 p.m., Zoltan Haindrich wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/69918/
> -----------------------------------------------------------
> 
> (Updated March 27, 2019, 4:40 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
> patch#2 here is #48 on jira
> 
> 
> Diffs
> -----
> 
>   accumulo-handler/src/test/results/positive/accumulo_predicate_pushdown.q.out fb8fca9324 
>   accumulo-handler/src/test/results/positive/accumulo_queries.q.out 80a7dc9717 
>   hbase-handler/src/test/results/positive/hbase_ppd_key_range.q.out b80738b263 
>   hbase-handler/src/test/results/positive/hbase_pushdown.q.out f37460c6d3 
>   hbase-handler/src/test/results/positive/hbase_queries.q.out cfcfaf3274 
>   pom.xml 7b45d84de8 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveRelBuilder.java e85a99e846 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveRelDecorrelator.java 238ae4ef4e 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveSubQueryRemoveRule.java 50ed8eda89 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/translator/ASTBuilder.java 74f8c33ab7 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/translator/ASTConverter.java e783d1c833 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/ppr/PartitionPruner.java 7645564f3d 
>   ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java 98e94e27e9 
>   ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java a2dd554b6e 
>   ql/src/test/queries/clientpositive/druidmini_expressions.q e491986250 
>   ql/src/test/queries/clientpositive/subquery_multi.q 81a9187c19 
>   ql/src/test/results/clientpositive/allcolref_in_udf.q.out b635f67b7a 
>   ql/src/test/results/clientpositive/alter_partition_coltype.q.out 1fbc2131d5 
>   ql/src/test/results/clientpositive/annotate_stats_filter.q.out 44f77b8f50 
>   ql/src/test/results/clientpositive/annotate_stats_join_pkfk.q.out 2cf5b0c456 
>   ql/src/test/results/clientpositive/auto_join2.q.out f154680c62 
>   ql/src/test/results/clientpositive/auto_join33.q.out 27fe10a0aa 
>   ql/src/test/results/clientpositive/auto_join_stats.q.out dc1338a5a7 
>   ql/src/test/results/clientpositive/auto_join_stats2.q.out 69623472fc 
>   ql/src/test/results/clientpositive/cbo_rp_simple_select.q.out cb22b61f26 
>   ql/src/test/results/clientpositive/cbo_simple_select.q.out 32e69204f6 
>   ql/src/test/results/clientpositive/char_udf1.q.out 09fb69782f 
>   ql/src/test/results/clientpositive/complex_alias.q.out a808513d73 
>   ql/src/test/results/clientpositive/constantPropWhen.q.out 1684cb6010 
>   ql/src/test/results/clientpositive/constant_prop_3.q.out db73902af1 
>   ql/src/test/results/clientpositive/constprog_when_case.q.out 958e05e959 
>   ql/src/test/results/clientpositive/cte_mat_5.q.out 5beaada3f9 
>   ql/src/test/results/clientpositive/decimal_udf.q.out b2a5837aef 
>   ql/src/test/results/clientpositive/druid/druidmini_expressions.q.out 071a0f7739 
>   ql/src/test/results/clientpositive/druid/druidmini_extractTime.q.out 4ea95f6930 
>   ql/src/test/results/clientpositive/druid/druidmini_floorTime.q.out 8d9382443e 
>   ql/src/test/results/clientpositive/druid/druidmini_test_ts.q.out 358e98b674 
>   ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out 0c2ad97bdd 
>   ql/src/test/results/clientpositive/encrypted/encryption_join_unencrypted_tbl.q.out e5e6fd1f48 
>   ql/src/test/results/clientpositive/except_all.q.out 24a7dfbcf8 
>   ql/src/test/results/clientpositive/filter_cond_pushdown.q.out 8627583c37 
>   ql/src/test/results/clientpositive/fold_case.q.out f4ef28dae5 
>   ql/src/test/results/clientpositive/fold_eq_with_case_when.q.out 7bd756a863 
>   ql/src/test/results/clientpositive/fold_to_null.q.out 84c379e42e 
>   ql/src/test/results/clientpositive/fold_when.q.out 2cf30b5b4d 
>   ql/src/test/results/clientpositive/groupby_grouping_sets_grouping.q.out 33e68882ff 
>   ql/src/test/results/clientpositive/groupby_rollup_empty.q.out ecfd766526 
>   ql/src/test/results/clientpositive/groupby_sort_1_23.q.out e4ca83b0f4 
>   ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out 7f1a231152 
>   ql/src/test/results/clientpositive/in_typecheck_char.q.out 464aad5924 
>   ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out cd9fb275c4 
>   ql/src/test/results/clientpositive/infer_join_preds.q.out 0afdd029be 
>   ql/src/test/results/clientpositive/innerjoin1.q.out cfc2c06bbc 
>   ql/src/test/results/clientpositive/input8.q.out 32daa0598f 
>   ql/src/test/results/clientpositive/join2.q.out ec9e436013 
>   ql/src/test/results/clientpositive/join_filters_overlap.q.out 6cd17d1ddb 
>   ql/src/test/results/clientpositive/list_bucket_dml_6.q.out da36c459fe 
>   ql/src/test/results/clientpositive/list_bucket_dml_7.q.out 68664a7060 
>   ql/src/test/results/clientpositive/list_bucket_dml_8.q.out 6521e0f497 
>   ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out c6a3c1fb8f 
>   ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out 30f8f0570b 
>   ql/src/test/results/clientpositive/llap/auto_sortmerge_join_16.q.out 2c6d7cafa7 
>   ql/src/test/results/clientpositive/llap/auto_sortmerge_join_6.q.out f61a6ed462 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out 2d48b9fa84 
>   ql/src/test/results/clientpositive/llap/bucketpruning1.q.out 934b383af5 
>   ql/src/test/results/clientpositive/llap/cbo_simple_select.q.out acf91bf178 
>   ql/src/test/results/clientpositive/llap/constraints_optimization.q.out fbdc702daf 
>   ql/src/test/results/clientpositive/llap/cte_mat_5.q.out 7acc8eefc6 
>   ql/src/test/results/clientpositive/llap/current_date_timestamp.q.out 54244672e4 
>   ql/src/test/results/clientpositive/llap/default_constraint.q.out 5d716ebb56 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out 1679d577e6 
>   ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_2.q.out 9813b8fcc3 
>   ql/src/test/results/clientpositive/llap/except_distinct.q.out d54dda9714 
>   ql/src/test/results/clientpositive/llap/explainuser_1.q.out 1ea8fdcbb2 
>   ql/src/test/results/clientpositive/llap/groupby_rollup_empty.q.out e7c0ab975b 
>   ql/src/test/results/clientpositive/llap/join_constraints_optimization.q.out 1098bb41f3 
>   ql/src/test/results/clientpositive/llap/kryo.q.out 7e10d64403 
>   ql/src/test/results/clientpositive/llap/lineage3.q.out 11e6904a12 
>   ql/src/test/results/clientpositive/llap/mapjoin_hint.q.out 9350fcb982 
>   ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_3.q.out e0efe3cc1e 
>   ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out 6c3ba6cd96 
>   ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out d3e494dc4b 
>   ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out b55287deb0 
>   ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out cf6a6bace1 
>   ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out d8aab03a22 
>   ql/src/test/results/clientpositive/llap/materialized_view_rewrite_10.q.out de13beaf75 
>   ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out 8566402bff 
>   ql/src/test/results/clientpositive/llap/materialized_view_rewrite_7.q.out 4d7b983226 
>   ql/src/test/results/clientpositive/llap/materialized_view_rewrite_no_join_opt.q.out 9197bb6394 
>   ql/src/test/results/clientpositive/llap/mergejoin.q.out f1153e76dd 
>   ql/src/test/results/clientpositive/llap/optimize_join_ptp.q.out abd7dbdf7a 
>   ql/src/test/results/clientpositive/llap/orc_ppd_varchar.q.out 12d6f67092 
>   ql/src/test/results/clientpositive/llap/sharedwork.q.out 9bd73f98b6 
>   ql/src/test/results/clientpositive/llap/subquery_in.q.out afcbddcef2 
>   ql/src/test/results/clientpositive/llap/subquery_in_having.q.out ddb7b421d9 
>   ql/src/test/results/clientpositive/llap/subquery_multi.q.out e04b2a6f94 
>   ql/src/test/results/clientpositive/llap/subquery_notin.q.out 37d9253f4e 
>   ql/src/test/results/clientpositive/llap/subquery_null_agg.q.out 2c306da6d9 
>   ql/src/test/results/clientpositive/llap/subquery_scalar.q.out 1016a64525 
>   ql/src/test/results/clientpositive/llap/subquery_select.q.out ab56f905e0 
>   ql/src/test/results/clientpositive/llap/subquery_views.q.out fbc9f5b82d 
>   ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_2.q.out c1156759d2 
>   ql/src/test/results/clientpositive/llap/tez_smb_reduce_side.q.out 93a1716064 
>   ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_2.q.out c1156759d2 
>   ql/src/test/results/clientpositive/llap/unionDistinct_1.q.out 3d6fe204be 
>   ql/src/test/results/clientpositive/llap/vector_adaptor_usage_mode.q.out 93c7e5aa61 
>   ql/src/test/results/clientpositive/llap/vector_case_when_1.q.out 6529758a3a 
>   ql/src/test/results/clientpositive/llap/vector_case_when_2.q.out 218a5cff17 
>   ql/src/test/results/clientpositive/llap/vector_char_mapjoin1.q.out d6f01ae582 
>   ql/src/test/results/clientpositive/llap/vector_coalesce_3.q.out 493cfca23a 
>   ql/src/test/results/clientpositive/llap/vector_date_1.q.out e79a7b7e9e 
>   ql/src/test/results/clientpositive/llap/vector_decimal_math_funcs.q.out b26fb62e17 
>   ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets_grouping.q.out 16fe26fb6b 
>   ql/src/test/results/clientpositive/llap/vector_groupby_mapjoin.q.out 229814f46d 
>   ql/src/test/results/clientpositive/llap/vector_interval_2.q.out 28da5049af 
>   ql/src/test/results/clientpositive/llap/vector_interval_mapjoin.q.out abf998eb90 
>   ql/src/test/results/clientpositive/llap/vector_orc_nested_column_pruning.q.out 944a36329c 
>   ql/src/test/results/clientpositive/llap/vector_varchar_mapjoin1.q.out f8b3223fdc 
>   ql/src/test/results/clientpositive/llap/vector_windowing_navfn.q.out 2af57ed583 
>   ql/src/test/results/clientpositive/llap/vectorization_0.q.out 1ee9aa97eb 
>   ql/src/test/results/clientpositive/llap/vectorization_5.q.out 6467a2fd81 
>   ql/src/test/results/clientpositive/llap/vectorization_6.q.out 2990bd4b82 
>   ql/src/test/results/clientpositive/llap/vectorization_8.q.out 3959239dbe 
>   ql/src/test/results/clientpositive/llap/vectorization_div0.q.out 9a260ef118 
>   ql/src/test/results/clientpositive/llap/vectorization_short_regress.q.out 051dc2f8a8 
>   ql/src/test/results/clientpositive/llap/vectorized_casts.q.out d1a9620186 
>   ql/src/test/results/clientpositive/llap/vectorized_dynamic_partition_pruning.q.out 7f096716ff 
>   ql/src/test/results/clientpositive/llap/vectorized_math_funcs.q.out 63b42fde3a 
>   ql/src/test/results/clientpositive/llap/vectorized_string_funcs.q.out 7a5073577e 
>   ql/src/test/results/clientpositive/llap/vectorized_timestamp_ints_casts.q.out c52e3b9e94 
>   ql/src/test/results/clientpositive/masking_1.q.out d915a47757 
>   ql/src/test/results/clientpositive/masking_12.q.out 178a141da3 
>   ql/src/test/results/clientpositive/masking_2.q.out 6d8420270b 
>   ql/src/test/results/clientpositive/masking_3.q.out 1c7cd158f4 
>   ql/src/test/results/clientpositive/masking_4.q.out fc0acb7e27 
>   ql/src/test/results/clientpositive/mergejoin.q.out 1c6d62c8a0 
>   ql/src/test/results/clientpositive/nested_column_pruning.q.out 80fb68b2ba 
>   ql/src/test/results/clientpositive/optimize_filter_literal.q.out 6eb573a400 
>   ql/src/test/results/clientpositive/orc_nested_column_pruning.q.out 0fccc9ee7f 
>   ql/src/test/results/clientpositive/orc_ppd_char.q.out 846de53ff4 
>   ql/src/test/results/clientpositive/parquet_vectorization_0.q.out ebbe004dfa 
>   ql/src/test/results/clientpositive/parquet_vectorization_5.q.out fd348a04c2 
>   ql/src/test/results/clientpositive/parquet_vectorization_6.q.out 3ad9ad7e17 
>   ql/src/test/results/clientpositive/parquet_vectorization_8.q.out 112f63392a 
>   ql/src/test/results/clientpositive/parquet_vectorization_div0.q.out a4791ef2c9 
>   ql/src/test/results/clientpositive/pcr.q.out 3840eae596 
>   ql/src/test/results/clientpositive/pcs.q.out b6c22125f3 
>   ql/src/test/results/clientpositive/perf/spark/query11.q.out 45f02fdb49 
>   ql/src/test/results/clientpositive/perf/spark/query13.q.out 04be3cf39a 
>   ql/src/test/results/clientpositive/perf/spark/query21.q.out db03678080 
>   ql/src/test/results/clientpositive/perf/spark/query27.q.out 98a0ea8015 
>   ql/src/test/results/clientpositive/perf/spark/query31.q.out 12c99b1431 
>   ql/src/test/results/clientpositive/perf/spark/query34.q.out 1a6c034cef 
>   ql/src/test/results/clientpositive/perf/spark/query36.q.out 2920c2f0b5 
>   ql/src/test/results/clientpositive/perf/spark/query4.q.out 14a5ea2b21 
>   ql/src/test/results/clientpositive/perf/spark/query45.q.out 7ee7c0ee2b 
>   ql/src/test/results/clientpositive/perf/spark/query47.q.out 7ee1efa54e 
>   ql/src/test/results/clientpositive/perf/spark/query48.q.out 80d9752853 
>   ql/src/test/results/clientpositive/perf/spark/query53.q.out 939e2a54db 
>   ql/src/test/results/clientpositive/perf/spark/query57.q.out b975a8abfc 
>   ql/src/test/results/clientpositive/perf/spark/query63.q.out 9cd9c9897d 
>   ql/src/test/results/clientpositive/perf/spark/query67.q.out f1954b1c85 
>   ql/src/test/results/clientpositive/perf/spark/query70.q.out 11e8f0d18a 
>   ql/src/test/results/clientpositive/perf/spark/query73.q.out f77acfda3d 
>   ql/src/test/results/clientpositive/perf/spark/query74.q.out e7a4784479 
>   ql/src/test/results/clientpositive/perf/spark/query78.q.out 125f0a9904 
>   ql/src/test/results/clientpositive/perf/spark/query85.q.out 04a4e18c30 
>   ql/src/test/results/clientpositive/perf/spark/query86.q.out 301679a2cd 
>   ql/src/test/results/clientpositive/perf/spark/query87.q.out 9008fc2d99 
>   ql/src/test/results/clientpositive/perf/spark/query88.q.out f06f831298 
>   ql/src/test/results/clientpositive/perf/spark/query89.q.out c781201379 
>   ql/src/test/results/clientpositive/perf/spark/query93.q.out f69920d27b 
>   ql/src/test/results/clientpositive/perf/spark/query97.q.out 2372928d52 
>   ql/src/test/results/clientpositive/perf/tez/cbo_ext_query1.q.out bcd1f8dd20 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query1.q.out 9d0fa3a109 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query11.q.out de0783be16 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query12.q.out cda7aa302e 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query13.q.out 412cc67334 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query14.q.out c85f42c4fd 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query15.q.out c00a7418f3 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query16.q.out ef8712ce1f 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query17.q.out 84832a4b4d 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query2.q.out 7b14ad3358 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query20.q.out ba354b6738 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query21.q.out 0365697005 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query23.q.out 377b587654 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query24.q.out 3add88ad25 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query25.q.out db13a5d30a 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query27.q.out e072692b33 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query28.q.out e0e61534c5 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query29.q.out 82a914b616 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query30.q.out 02e26a7c10 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query31.q.out 8907b8d6cd 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query32.q.out fc353fb02b 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query33.q.out 8534997488 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query34.q.out b2a6320acb 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query36.q.out 9a74bed470 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query37.q.out 07b9901520 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query39.q.out 51bb90101d 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query4.q.out 4b388653ae 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query40.q.out 1f834b5647 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query43.q.out 1d86c8bd07 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query47.q.out 8dff4677ba 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query48.q.out 22b051d06a 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query49.q.out 1300dd92af 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query5.q.out e78c3e5917 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query50.q.out becffde820 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query53.q.out 9b42428097 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query54.q.out 39b6a6be15 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query56.q.out d01dbcd154 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query57.q.out 6c8ef17bc6 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query58.q.out b4410ff07a 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query59.q.out 8674a8a6c6 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query6.q.out f502c004cf 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query60.q.out acda930197 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query61.q.out 3c03347810 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query63.q.out 78c9b13111 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query64.q.out 356778b4a7 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query65.q.out 25cb9ccc6b 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query66.q.out e2409a9d82 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query73.q.out 2639cf22b4 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query74.q.out 4a9a1127b3 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query75.q.out 8c445d9de5 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query76.q.out 740d03818e 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query77.q.out 91ad054e66 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query78.q.out 02635826f0 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query80.q.out 334f09cc33 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query81.q.out 0adb5551da 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query82.q.out a60312f11b 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query83.q.out 8211db1c95 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query85.q.out 0963936768 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query87.q.out e030b3eb2c 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query88.q.out 1f4471e8ae 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query89.q.out 7cfb3ecdec 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query91.q.out e6fe23fb5b 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query92.q.out be7f364ee9 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query93.q.out 6a8ed39e29 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query94.q.out e80788209e 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query95.q.out 68f318934c 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query97.q.out a6f39397ea 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query98.q.out 374a6a06d6 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_ext_query1.q.out 255261bdaa 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query1.q.out 13801ffc6c 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query11.q.out f315e3c455 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query12.q.out ab4a8377e6 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query13.q.out a08c5a4be1 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query14.q.out 118d23b577 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query15.q.out 32404b6209 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query16.q.out 1de59b24d9 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query17.q.out 120c8d28d1 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query2.q.out 07ab7a16e0 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query20.q.out 29382b389b 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query21.q.out 5e165e8e70 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query23.q.out 3146b776ce 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query24.q.out 41d96ea303 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query25.q.out 958033e41b 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query27.q.out 7fae258207 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query28.q.out e0e61534c5 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query29.q.out 3e7c6805b2 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query30.q.out bd68baa23b 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query31.q.out f8e31a23aa 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query32.q.out b5cf714198 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query33.q.out e8824ddf54 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query34.q.out 987f8d3eea 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query36.q.out d4031261c7 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query37.q.out f054717d70 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query39.q.out 272bedcbce 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query4.q.out 9668e0f4a1 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query40.q.out 5cce22af4e 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query43.q.out 6b21ee45c0 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query46.q.out 9d21449b65 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query47.q.out 8aa0871cb0 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query48.q.out 3188d82f28 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query49.q.out bc108dba6e 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query5.q.out 54f3dd6a10 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query50.q.out 49c87eedb5 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query53.q.out bac3f77538 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query54.q.out e33203d93c 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query56.q.out a13e599b34 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query57.q.out cb8f67b5c1 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query58.q.out 3e89c2da75 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query59.q.out 34376d1262 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query6.q.out 5e3deb3eb9 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query60.q.out ea098f7567 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query61.q.out 2bc02f51f7 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query63.q.out e22d812f78 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query64.q.out 8223efcdb6 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query65.q.out 3e906b73b0 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query66.q.out 77256a3adc 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query68.q.out 1b25235c8a 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query72.q.out 206b0f1972 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query73.q.out 38af7c0d35 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query74.q.out 4a8f0b88f0 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query75.q.out a95e756dab 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query76.q.out a51a05ac00 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query77.q.out 0ac295bf8f 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query78.q.out de1b133006 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query80.q.out a4fac0cca1 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query81.q.out 98066643bf 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query82.q.out 54c4a99b68 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query83.q.out 58ed6dabe7 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query85.q.out 91aad930ba 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query87.q.out 97c9eddc34 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query88.q.out 1ac8fe2dcd 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query89.q.out d9c7d42b9f 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query91.q.out 0017776216 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query92.q.out 503c78185c 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query94.q.out 25e0c8bd9e 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query95.q.out 606e162b30 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query97.q.out c8fff90413 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query98.q.out 2a6b66f2bf 
>   ql/src/test/results/clientpositive/perf/tez/constraints/mv_query44.q.out db9acc93cb 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query1.q.out 69f93290d9 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query11.q.out 7e0582e164 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query13.q.out 616ed6bcde 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query21.q.out 7c68a294ea 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query31.q.out 8e0de0ffe2 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query34.q.out e2c3631141 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query36.q.out 8158608354 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query4.q.out e6558e99a9 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query44.q.out 3fd361a9f9 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query45.q.out 64d9c98395 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query46.q.out dde72e07b8 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query47.q.out efb3edda71 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query48.q.out 93bafabefd 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query53.q.out a13d0f9c09 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query57.q.out 69aeaae7e9 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query6.q.out 7aea119ac3 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query63.q.out 5620b819fb 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query68.q.out dd4ce4eb84 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query70.q.out a49314c858 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query72.q.out 1a9c2cf203 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query73.q.out 52b0c26588 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query74.q.out 525217b526 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query78.q.out ef4d6dbc21 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query85.q.out aeb33836cd 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query86.q.out 638cce1b46 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query87.q.out b6d3904c1c 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query88.q.out 64919cafe7 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query89.q.out 3049fec95c 
>   ql/src/test/results/clientpositive/perf/tez/query11.q.out da1c349ff0 
>   ql/src/test/results/clientpositive/perf/tez/query13.q.out 60a73d7250 
>   ql/src/test/results/clientpositive/perf/tez/query21.q.out 0d10843009 
>   ql/src/test/results/clientpositive/perf/tez/query31.q.out c0762b7bd4 
>   ql/src/test/results/clientpositive/perf/tez/query34.q.out d401e4cdc0 
>   ql/src/test/results/clientpositive/perf/tez/query36.q.out 064837a3cf 
>   ql/src/test/results/clientpositive/perf/tez/query4.q.out bb0d7ba3f5 
>   ql/src/test/results/clientpositive/perf/tez/query45.q.out c2f9374c4b 
>   ql/src/test/results/clientpositive/perf/tez/query47.q.out 04c64b405f 
>   ql/src/test/results/clientpositive/perf/tez/query48.q.out d64eec1c74 
>   ql/src/test/results/clientpositive/perf/tez/query53.q.out e9153f3a06 
>   ql/src/test/results/clientpositive/perf/tez/query57.q.out 4a18880260 
>   ql/src/test/results/clientpositive/perf/tez/query63.q.out 0bdd48b728 
>   ql/src/test/results/clientpositive/perf/tez/query70.q.out 8d9d06dd48 
>   ql/src/test/results/clientpositive/perf/tez/query73.q.out 352c7245ea 
>   ql/src/test/results/clientpositive/perf/tez/query74.q.out 20aade2974 
>   ql/src/test/results/clientpositive/perf/tez/query78.q.out 3d938e1c8e 
>   ql/src/test/results/clientpositive/perf/tez/query85.q.out 5b8ad0ba57 
>   ql/src/test/results/clientpositive/perf/tez/query86.q.out 2d6d545a5b 
>   ql/src/test/results/clientpositive/perf/tez/query87.q.out 5b59116741 
>   ql/src/test/results/clientpositive/perf/tez/query88.q.out e02ff3715b 
>   ql/src/test/results/clientpositive/perf/tez/query89.q.out 8501822cd2 
>   ql/src/test/results/clientpositive/perf/tez/query93.q.out b5e6ba9c48 
>   ql/src/test/results/clientpositive/pointlookup.q.out c77536efe5 
>   ql/src/test/results/clientpositive/pointlookup2.q.out 5a1f92758a 
>   ql/src/test/results/clientpositive/pointlookup3.q.out 469a460773 
>   ql/src/test/results/clientpositive/pointlookup4.q.out f105f8a569 
>   ql/src/test/results/clientpositive/ppd_constant_expr.q.out 39dd2d7de3 
>   ql/src/test/results/clientpositive/ppd_join_filter.q.out 68a8cd01f7 
>   ql/src/test/results/clientpositive/row__id.q.out fc4c3123b0 
>   ql/src/test/results/clientpositive/semijoin4.q.out 4cfdd55503 
>   ql/src/test/results/clientpositive/semijoin5.q.out 6fd4174110 
>   ql/src/test/results/clientpositive/skewjoinopt18.q.out 26526a37b2 
>   ql/src/test/results/clientpositive/spark/auto_join2.q.out 6aeadb52dd 
>   ql/src/test/results/clientpositive/spark/auto_join_stats.q.out a6d09228c1 
>   ql/src/test/results/clientpositive/spark/auto_join_stats2.q.out fbcc489b14 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_12.q.out 7138a6fb30 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_16.q.out 24cf07b9a3 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_16.q.out_spark 8c22440488 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_6.q.out 329cdf66b2 
>   ql/src/test/results/clientpositive/spark/bucket_map_join_tez2.q.out be43889af1 
>   ql/src/test/results/clientpositive/spark/cbo_simple_select.q.out acf91bf178 
>   ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out 866a86d7b4 
>   ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out 06da1248f3 
>   ql/src/test/results/clientpositive/spark/infer_bucket_sort_map_operators.q.out 59e25f890e 
>   ql/src/test/results/clientpositive/spark/join2.q.out 3f64bc9a40 
>   ql/src/test/results/clientpositive/spark/join_filters_overlap.q.out 49226b2622 
>   ql/src/test/results/clientpositive/spark/parquet_vectorization_0.q.out adb9f4a33b 
>   ql/src/test/results/clientpositive/spark/parquet_vectorization_5.q.out fc3952117a 
>   ql/src/test/results/clientpositive/spark/parquet_vectorization_6.q.out 6eabffb84d 
>   ql/src/test/results/clientpositive/spark/parquet_vectorization_8.q.out 357a321c27 
>   ql/src/test/results/clientpositive/spark/parquet_vectorization_div0.q.out 8f40278318 
>   ql/src/test/results/clientpositive/spark/pcr.q.out 2c5b15aa3a 
>   ql/src/test/results/clientpositive/spark/ppd_join_filter.q.out b8a8760955 
>   ql/src/test/results/clientpositive/spark/skewjoinopt18.q.out 0e43a882ed 
>   ql/src/test/results/clientpositive/spark/spark_dynamic_partition_pruning.q.out 89da63134c 
>   ql/src/test/results/clientpositive/spark/spark_explainuser_1.q.out b8403f4e39 
>   ql/src/test/results/clientpositive/spark/spark_use_ts_stats_for_mapjoin.q.out eecacca8ad 
>   ql/src/test/results/clientpositive/spark/spark_vectorized_dynamic_partition_pruning.q.out e90f9d17ac 
>   ql/src/test/results/clientpositive/spark/subquery_in.q.out 3fc9aa1b1b 
>   ql/src/test/results/clientpositive/spark/subquery_multi.q.out 17240f9dc5 
>   ql/src/test/results/clientpositive/spark/subquery_notin.q.out 2d93874450 
>   ql/src/test/results/clientpositive/spark/subquery_null_agg.q.out 302c2609cb 
>   ql/src/test/results/clientpositive/spark/subquery_scalar.q.out 4e31c3fd20 
>   ql/src/test/results/clientpositive/spark/subquery_select.q.out 3c6f6af020 
>   ql/src/test/results/clientpositive/spark/subquery_views.q.out d048716c0a 
>   ql/src/test/results/clientpositive/spark/union22.q.out 3798d87f7b 
>   ql/src/test/results/clientpositive/spark/vectorization_0.q.out c6e0c33dc5 
>   ql/src/test/results/clientpositive/spark/vectorization_5.q.out 00f8260aac 
>   ql/src/test/results/clientpositive/spark/vectorization_6.q.out d1cc6e39ed 
>   ql/src/test/results/clientpositive/spark/vectorization_div0.q.out 18159aa9bf 
>   ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out 2d8d8b1ec9 
>   ql/src/test/results/clientpositive/spark/vectorized_math_funcs.q.out 977725ca4c 
>   ql/src/test/results/clientpositive/spark/vectorized_string_funcs.q.out 79546c5a73 
>   ql/src/test/results/clientpositive/subquery_notexists.q.out 2b6c08bde4 
>   ql/src/test/results/clientpositive/subquery_notin_having.q.out 68a65df3a9 
>   ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out 7217ac55b3 
>   ql/src/test/results/clientpositive/timestamp_ints_casts.q.out 83d4557c8a 
>   ql/src/test/results/clientpositive/udf_isops_simplify.q.out e9fcd05939 
>   ql/src/test/results/clientpositive/udf_to_unix_timestamp.q.out 1f446eb454 
>   ql/src/test/results/clientpositive/union22.q.out a3aa5e2c77 
>   ql/src/test/results/clientpositive/union_offcbo.q.out 2e5675fe8e 
>   ql/src/test/results/clientpositive/vector_case_when_1.q.out 61062e1f8e 
>   ql/src/test/results/clientpositive/vector_case_when_2.q.out 29b0823961 
>   ql/src/test/results/clientpositive/vector_char_mapjoin1.q.out 19cb5b4b71 
>   ql/src/test/results/clientpositive/vector_coalesce_3.q.out 39fd5e898a 
>   ql/src/test/results/clientpositive/vector_date_1.q.out 4e82ed84b6 
>   ql/src/test/results/clientpositive/vector_decimal_math_funcs.q.out 31751503b5 
>   ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out 613a30701a 
>   ql/src/test/results/clientpositive/vector_interval_mapjoin.q.out 49843e939e 
>   ql/src/test/results/clientpositive/vector_varchar_mapjoin1.q.out 0d4107991c 
>   ql/src/test/results/clientpositive/vectorization_5.q.out 36eb6d53a8 
>   ql/src/test/results/clientpositive/vectorization_6.q.out fbb6f5e3ca 
>   ql/src/test/results/clientpositive/vectorization_8.q.out 6a52519eae 
>   ql/src/test/results/clientpositive/vectorized_casts.q.out fd6277c4bb 
>   ql/src/test/results/clientpositive/vectorized_math_funcs.q.out 0b0aba6829 
>   ql/src/test/results/clientpositive/vectorized_string_funcs.q.out 64064c0e85 
>   ql/src/test/results/clientpositive/vectorized_timestamp_ints_casts.q.out bf66c03a5e 
>   ql/src/test/results/clientpositive/view_cbo.q.out c7d9c8a0ec 
> 
> 
> Diff: https://reviews.apache.org/r/69918/diff/2/
> 
> 
> Testing
> -------
> 
> 
> Thanks,
> 
> Zoltan Haindrich
> 
>


Re: Review Request 69918: HIVE-21001 Update to Calcite 1.19

Posted by Jesús Camacho Rodríguez <jc...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/69918/#review214127
-----------------------------------------------------------




accumulo-handler/src/test/results/positive/accumulo_queries.q.out
Line 150 (original), 150 (patched)
<https://reviews.apache.org/r/69918/#comment300297>

    Is this a known issue?



ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java
Lines 1494 (patched)
<https://reviews.apache.org/r/69918/#comment300298>

    Cool!



ql/src/test/results/clientpositive/allcolref_in_udf.q.out
Line 107 (original), 107 (patched)
<https://reviews.apache.org/r/69918/#comment300299>

    Known issue?



ql/src/test/results/clientpositive/auto_join2.q.out
Line 42 (original), 42 (patched)
<https://reviews.apache.org/r/69918/#comment300302>

    I guess same as previous one, but this time it is preventing folding in more complex expression from happening.



ql/src/test/results/clientpositive/filter_cond_pushdown.q.out
Line 344 (original), 344 (patched)
<https://reviews.apache.org/r/69918/#comment300304>

    Is the literal transformation here expected (int -> double?)?



ql/src/test/results/clientpositive/llap/explainuser_1.q.out
Line 588 (original), 588 (patched)
<https://reviews.apache.org/r/69918/#comment300312>

    Constant literal transformation. Is it expected?



ql/src/test/results/clientpositive/llap/join_constraints_optimization.q.out
Line 734 (original)
<https://reviews.apache.org/r/69918/#comment300313>

    Nice! Would you mind to update the comment in L125 in join_constraints_optimization accordingly?



ql/src/test/results/clientpositive/llap/orc_ppd_varchar.q.out
Line 29 (original), 29 (patched)
<https://reviews.apache.org/r/69918/#comment300314>

    Expected?



ql/src/test/results/clientpositive/orc_ppd_char.q.out
Line 29 (original), 29 (patched)
<https://reviews.apache.org/r/69918/#comment300305>

    Expected?


- Jesús Camacho Rodríguez


On March 27, 2019, 3:40 p.m., Zoltan Haindrich wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/69918/
> -----------------------------------------------------------
> 
> (Updated March 27, 2019, 3:40 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
> patch#2 here is #48 on jira
> 
> 
> Diffs
> -----
> 
>   accumulo-handler/src/test/results/positive/accumulo_predicate_pushdown.q.out fb8fca9324 
>   accumulo-handler/src/test/results/positive/accumulo_queries.q.out 80a7dc9717 
>   hbase-handler/src/test/results/positive/hbase_ppd_key_range.q.out b80738b263 
>   hbase-handler/src/test/results/positive/hbase_pushdown.q.out f37460c6d3 
>   hbase-handler/src/test/results/positive/hbase_queries.q.out cfcfaf3274 
>   pom.xml 7b45d84de8 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveRelBuilder.java e85a99e846 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveRelDecorrelator.java 238ae4ef4e 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveSubQueryRemoveRule.java 50ed8eda89 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/translator/ASTBuilder.java 74f8c33ab7 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/translator/ASTConverter.java e783d1c833 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/ppr/PartitionPruner.java 7645564f3d 
>   ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java 98e94e27e9 
>   ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java a2dd554b6e 
>   ql/src/test/queries/clientpositive/druidmini_expressions.q e491986250 
>   ql/src/test/queries/clientpositive/subquery_multi.q 81a9187c19 
>   ql/src/test/results/clientpositive/allcolref_in_udf.q.out b635f67b7a 
>   ql/src/test/results/clientpositive/alter_partition_coltype.q.out 1fbc2131d5 
>   ql/src/test/results/clientpositive/annotate_stats_filter.q.out 44f77b8f50 
>   ql/src/test/results/clientpositive/annotate_stats_join_pkfk.q.out 2cf5b0c456 
>   ql/src/test/results/clientpositive/auto_join2.q.out f154680c62 
>   ql/src/test/results/clientpositive/auto_join33.q.out 27fe10a0aa 
>   ql/src/test/results/clientpositive/auto_join_stats.q.out dc1338a5a7 
>   ql/src/test/results/clientpositive/auto_join_stats2.q.out 69623472fc 
>   ql/src/test/results/clientpositive/cbo_rp_simple_select.q.out cb22b61f26 
>   ql/src/test/results/clientpositive/cbo_simple_select.q.out 32e69204f6 
>   ql/src/test/results/clientpositive/char_udf1.q.out 09fb69782f 
>   ql/src/test/results/clientpositive/complex_alias.q.out a808513d73 
>   ql/src/test/results/clientpositive/constantPropWhen.q.out 1684cb6010 
>   ql/src/test/results/clientpositive/constant_prop_3.q.out db73902af1 
>   ql/src/test/results/clientpositive/constprog_when_case.q.out 958e05e959 
>   ql/src/test/results/clientpositive/cte_mat_5.q.out 5beaada3f9 
>   ql/src/test/results/clientpositive/decimal_udf.q.out b2a5837aef 
>   ql/src/test/results/clientpositive/druid/druidmini_expressions.q.out 071a0f7739 
>   ql/src/test/results/clientpositive/druid/druidmini_extractTime.q.out 4ea95f6930 
>   ql/src/test/results/clientpositive/druid/druidmini_floorTime.q.out 8d9382443e 
>   ql/src/test/results/clientpositive/druid/druidmini_test_ts.q.out 358e98b674 
>   ql/src/test/results/clientpositive/dynamic_partition_skip_default.q.out 0c2ad97bdd 
>   ql/src/test/results/clientpositive/encrypted/encryption_join_unencrypted_tbl.q.out e5e6fd1f48 
>   ql/src/test/results/clientpositive/except_all.q.out 24a7dfbcf8 
>   ql/src/test/results/clientpositive/filter_cond_pushdown.q.out 8627583c37 
>   ql/src/test/results/clientpositive/fold_case.q.out f4ef28dae5 
>   ql/src/test/results/clientpositive/fold_eq_with_case_when.q.out 7bd756a863 
>   ql/src/test/results/clientpositive/fold_to_null.q.out 84c379e42e 
>   ql/src/test/results/clientpositive/fold_when.q.out 2cf30b5b4d 
>   ql/src/test/results/clientpositive/groupby_grouping_sets_grouping.q.out 33e68882ff 
>   ql/src/test/results/clientpositive/groupby_rollup_empty.q.out ecfd766526 
>   ql/src/test/results/clientpositive/groupby_sort_1_23.q.out e4ca83b0f4 
>   ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out 7f1a231152 
>   ql/src/test/results/clientpositive/in_typecheck_char.q.out 464aad5924 
>   ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out cd9fb275c4 
>   ql/src/test/results/clientpositive/infer_join_preds.q.out 0afdd029be 
>   ql/src/test/results/clientpositive/innerjoin1.q.out cfc2c06bbc 
>   ql/src/test/results/clientpositive/input8.q.out 32daa0598f 
>   ql/src/test/results/clientpositive/join2.q.out ec9e436013 
>   ql/src/test/results/clientpositive/join_filters_overlap.q.out 6cd17d1ddb 
>   ql/src/test/results/clientpositive/list_bucket_dml_6.q.out da36c459fe 
>   ql/src/test/results/clientpositive/list_bucket_dml_7.q.out 68664a7060 
>   ql/src/test/results/clientpositive/list_bucket_dml_8.q.out 6521e0f497 
>   ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out c6a3c1fb8f 
>   ql/src/test/results/clientpositive/llap/auto_sortmerge_join_12.q.out 30f8f0570b 
>   ql/src/test/results/clientpositive/llap/auto_sortmerge_join_16.q.out 2c6d7cafa7 
>   ql/src/test/results/clientpositive/llap/auto_sortmerge_join_6.q.out f61a6ed462 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out 2d48b9fa84 
>   ql/src/test/results/clientpositive/llap/bucketpruning1.q.out 934b383af5 
>   ql/src/test/results/clientpositive/llap/cbo_simple_select.q.out acf91bf178 
>   ql/src/test/results/clientpositive/llap/constraints_optimization.q.out fbdc702daf 
>   ql/src/test/results/clientpositive/llap/cte_mat_5.q.out 7acc8eefc6 
>   ql/src/test/results/clientpositive/llap/current_date_timestamp.q.out 54244672e4 
>   ql/src/test/results/clientpositive/llap/default_constraint.q.out 5d716ebb56 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out 1679d577e6 
>   ql/src/test/results/clientpositive/llap/dynamic_semijoin_reduction_2.q.out 9813b8fcc3 
>   ql/src/test/results/clientpositive/llap/except_distinct.q.out d54dda9714 
>   ql/src/test/results/clientpositive/llap/explainuser_1.q.out 1ea8fdcbb2 
>   ql/src/test/results/clientpositive/llap/groupby_rollup_empty.q.out e7c0ab975b 
>   ql/src/test/results/clientpositive/llap/join_constraints_optimization.q.out 1098bb41f3 
>   ql/src/test/results/clientpositive/llap/kryo.q.out 7e10d64403 
>   ql/src/test/results/clientpositive/llap/lineage3.q.out 11e6904a12 
>   ql/src/test/results/clientpositive/llap/mapjoin_hint.q.out 9350fcb982 
>   ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_3.q.out e0efe3cc1e 
>   ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_4.q.out 6c3ba6cd96 
>   ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_5.q.out d3e494dc4b 
>   ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_rebuild_dummy.q.out b55287deb0 
>   ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite_time_window.q.out cf6a6bace1 
>   ql/src/test/results/clientpositive/llap/materialized_view_rewrite_1.q.out d8aab03a22 
>   ql/src/test/results/clientpositive/llap/materialized_view_rewrite_10.q.out de13beaf75 
>   ql/src/test/results/clientpositive/llap/materialized_view_rewrite_4.q.out 8566402bff 
>   ql/src/test/results/clientpositive/llap/materialized_view_rewrite_7.q.out 4d7b983226 
>   ql/src/test/results/clientpositive/llap/materialized_view_rewrite_no_join_opt.q.out 9197bb6394 
>   ql/src/test/results/clientpositive/llap/mergejoin.q.out f1153e76dd 
>   ql/src/test/results/clientpositive/llap/optimize_join_ptp.q.out abd7dbdf7a 
>   ql/src/test/results/clientpositive/llap/orc_ppd_varchar.q.out 12d6f67092 
>   ql/src/test/results/clientpositive/llap/sharedwork.q.out 9bd73f98b6 
>   ql/src/test/results/clientpositive/llap/subquery_in.q.out afcbddcef2 
>   ql/src/test/results/clientpositive/llap/subquery_in_having.q.out ddb7b421d9 
>   ql/src/test/results/clientpositive/llap/subquery_multi.q.out e04b2a6f94 
>   ql/src/test/results/clientpositive/llap/subquery_notin.q.out 37d9253f4e 
>   ql/src/test/results/clientpositive/llap/subquery_null_agg.q.out 2c306da6d9 
>   ql/src/test/results/clientpositive/llap/subquery_scalar.q.out 1016a64525 
>   ql/src/test/results/clientpositive/llap/subquery_select.q.out ab56f905e0 
>   ql/src/test/results/clientpositive/llap/subquery_views.q.out fbc9f5b82d 
>   ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_2.q.out c1156759d2 
>   ql/src/test/results/clientpositive/llap/tez_smb_reduce_side.q.out 93a1716064 
>   ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_2.q.out c1156759d2 
>   ql/src/test/results/clientpositive/llap/unionDistinct_1.q.out 3d6fe204be 
>   ql/src/test/results/clientpositive/llap/vector_adaptor_usage_mode.q.out 93c7e5aa61 
>   ql/src/test/results/clientpositive/llap/vector_case_when_1.q.out 6529758a3a 
>   ql/src/test/results/clientpositive/llap/vector_case_when_2.q.out 218a5cff17 
>   ql/src/test/results/clientpositive/llap/vector_char_mapjoin1.q.out d6f01ae582 
>   ql/src/test/results/clientpositive/llap/vector_coalesce_3.q.out 493cfca23a 
>   ql/src/test/results/clientpositive/llap/vector_date_1.q.out e79a7b7e9e 
>   ql/src/test/results/clientpositive/llap/vector_decimal_math_funcs.q.out b26fb62e17 
>   ql/src/test/results/clientpositive/llap/vector_groupby_grouping_sets_grouping.q.out 16fe26fb6b 
>   ql/src/test/results/clientpositive/llap/vector_groupby_mapjoin.q.out 229814f46d 
>   ql/src/test/results/clientpositive/llap/vector_interval_2.q.out 28da5049af 
>   ql/src/test/results/clientpositive/llap/vector_interval_mapjoin.q.out abf998eb90 
>   ql/src/test/results/clientpositive/llap/vector_orc_nested_column_pruning.q.out 944a36329c 
>   ql/src/test/results/clientpositive/llap/vector_varchar_mapjoin1.q.out f8b3223fdc 
>   ql/src/test/results/clientpositive/llap/vector_windowing_navfn.q.out 2af57ed583 
>   ql/src/test/results/clientpositive/llap/vectorization_0.q.out 1ee9aa97eb 
>   ql/src/test/results/clientpositive/llap/vectorization_5.q.out 6467a2fd81 
>   ql/src/test/results/clientpositive/llap/vectorization_6.q.out 2990bd4b82 
>   ql/src/test/results/clientpositive/llap/vectorization_8.q.out 3959239dbe 
>   ql/src/test/results/clientpositive/llap/vectorization_div0.q.out 9a260ef118 
>   ql/src/test/results/clientpositive/llap/vectorization_short_regress.q.out 051dc2f8a8 
>   ql/src/test/results/clientpositive/llap/vectorized_casts.q.out d1a9620186 
>   ql/src/test/results/clientpositive/llap/vectorized_dynamic_partition_pruning.q.out 7f096716ff 
>   ql/src/test/results/clientpositive/llap/vectorized_math_funcs.q.out 63b42fde3a 
>   ql/src/test/results/clientpositive/llap/vectorized_string_funcs.q.out 7a5073577e 
>   ql/src/test/results/clientpositive/llap/vectorized_timestamp_ints_casts.q.out c52e3b9e94 
>   ql/src/test/results/clientpositive/masking_1.q.out d915a47757 
>   ql/src/test/results/clientpositive/masking_12.q.out 178a141da3 
>   ql/src/test/results/clientpositive/masking_2.q.out 6d8420270b 
>   ql/src/test/results/clientpositive/masking_3.q.out 1c7cd158f4 
>   ql/src/test/results/clientpositive/masking_4.q.out fc0acb7e27 
>   ql/src/test/results/clientpositive/mergejoin.q.out 1c6d62c8a0 
>   ql/src/test/results/clientpositive/nested_column_pruning.q.out 80fb68b2ba 
>   ql/src/test/results/clientpositive/optimize_filter_literal.q.out 6eb573a400 
>   ql/src/test/results/clientpositive/orc_nested_column_pruning.q.out 0fccc9ee7f 
>   ql/src/test/results/clientpositive/orc_ppd_char.q.out 846de53ff4 
>   ql/src/test/results/clientpositive/parquet_vectorization_0.q.out ebbe004dfa 
>   ql/src/test/results/clientpositive/parquet_vectorization_5.q.out fd348a04c2 
>   ql/src/test/results/clientpositive/parquet_vectorization_6.q.out 3ad9ad7e17 
>   ql/src/test/results/clientpositive/parquet_vectorization_8.q.out 112f63392a 
>   ql/src/test/results/clientpositive/parquet_vectorization_div0.q.out a4791ef2c9 
>   ql/src/test/results/clientpositive/pcr.q.out 3840eae596 
>   ql/src/test/results/clientpositive/pcs.q.out b6c22125f3 
>   ql/src/test/results/clientpositive/perf/spark/query11.q.out 45f02fdb49 
>   ql/src/test/results/clientpositive/perf/spark/query13.q.out 04be3cf39a 
>   ql/src/test/results/clientpositive/perf/spark/query21.q.out db03678080 
>   ql/src/test/results/clientpositive/perf/spark/query27.q.out 98a0ea8015 
>   ql/src/test/results/clientpositive/perf/spark/query31.q.out 12c99b1431 
>   ql/src/test/results/clientpositive/perf/spark/query34.q.out 1a6c034cef 
>   ql/src/test/results/clientpositive/perf/spark/query36.q.out 2920c2f0b5 
>   ql/src/test/results/clientpositive/perf/spark/query4.q.out 14a5ea2b21 
>   ql/src/test/results/clientpositive/perf/spark/query45.q.out 7ee7c0ee2b 
>   ql/src/test/results/clientpositive/perf/spark/query47.q.out 7ee1efa54e 
>   ql/src/test/results/clientpositive/perf/spark/query48.q.out 80d9752853 
>   ql/src/test/results/clientpositive/perf/spark/query53.q.out 939e2a54db 
>   ql/src/test/results/clientpositive/perf/spark/query57.q.out b975a8abfc 
>   ql/src/test/results/clientpositive/perf/spark/query63.q.out 9cd9c9897d 
>   ql/src/test/results/clientpositive/perf/spark/query67.q.out f1954b1c85 
>   ql/src/test/results/clientpositive/perf/spark/query70.q.out 11e8f0d18a 
>   ql/src/test/results/clientpositive/perf/spark/query73.q.out f77acfda3d 
>   ql/src/test/results/clientpositive/perf/spark/query74.q.out e7a4784479 
>   ql/src/test/results/clientpositive/perf/spark/query78.q.out 125f0a9904 
>   ql/src/test/results/clientpositive/perf/spark/query85.q.out 04a4e18c30 
>   ql/src/test/results/clientpositive/perf/spark/query86.q.out 301679a2cd 
>   ql/src/test/results/clientpositive/perf/spark/query87.q.out 9008fc2d99 
>   ql/src/test/results/clientpositive/perf/spark/query88.q.out f06f831298 
>   ql/src/test/results/clientpositive/perf/spark/query89.q.out c781201379 
>   ql/src/test/results/clientpositive/perf/spark/query93.q.out f69920d27b 
>   ql/src/test/results/clientpositive/perf/spark/query97.q.out 2372928d52 
>   ql/src/test/results/clientpositive/perf/tez/cbo_ext_query1.q.out bcd1f8dd20 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query1.q.out 9d0fa3a109 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query11.q.out de0783be16 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query12.q.out cda7aa302e 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query13.q.out 412cc67334 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query14.q.out c85f42c4fd 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query15.q.out c00a7418f3 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query16.q.out ef8712ce1f 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query17.q.out 84832a4b4d 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query2.q.out 7b14ad3358 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query20.q.out ba354b6738 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query21.q.out 0365697005 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query23.q.out 377b587654 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query24.q.out 3add88ad25 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query25.q.out db13a5d30a 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query27.q.out e072692b33 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query28.q.out e0e61534c5 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query29.q.out 82a914b616 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query30.q.out 02e26a7c10 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query31.q.out 8907b8d6cd 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query32.q.out fc353fb02b 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query33.q.out 8534997488 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query34.q.out b2a6320acb 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query36.q.out 9a74bed470 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query37.q.out 07b9901520 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query39.q.out 51bb90101d 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query4.q.out 4b388653ae 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query40.q.out 1f834b5647 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query43.q.out 1d86c8bd07 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query47.q.out 8dff4677ba 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query48.q.out 22b051d06a 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query49.q.out 1300dd92af 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query5.q.out e78c3e5917 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query50.q.out becffde820 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query53.q.out 9b42428097 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query54.q.out 39b6a6be15 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query56.q.out d01dbcd154 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query57.q.out 6c8ef17bc6 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query58.q.out b4410ff07a 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query59.q.out 8674a8a6c6 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query6.q.out f502c004cf 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query60.q.out acda930197 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query61.q.out 3c03347810 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query63.q.out 78c9b13111 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query64.q.out 356778b4a7 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query65.q.out 25cb9ccc6b 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query66.q.out e2409a9d82 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query73.q.out 2639cf22b4 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query74.q.out 4a9a1127b3 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query75.q.out 8c445d9de5 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query76.q.out 740d03818e 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query77.q.out 91ad054e66 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query78.q.out 02635826f0 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query80.q.out 334f09cc33 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query81.q.out 0adb5551da 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query82.q.out a60312f11b 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query83.q.out 8211db1c95 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query85.q.out 0963936768 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query87.q.out e030b3eb2c 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query88.q.out 1f4471e8ae 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query89.q.out 7cfb3ecdec 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query91.q.out e6fe23fb5b 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query92.q.out be7f364ee9 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query93.q.out 6a8ed39e29 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query94.q.out e80788209e 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query95.q.out 68f318934c 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query97.q.out a6f39397ea 
>   ql/src/test/results/clientpositive/perf/tez/cbo_query98.q.out 374a6a06d6 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_ext_query1.q.out 255261bdaa 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query1.q.out 13801ffc6c 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query11.q.out f315e3c455 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query12.q.out ab4a8377e6 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query13.q.out a08c5a4be1 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query14.q.out 118d23b577 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query15.q.out 32404b6209 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query16.q.out 1de59b24d9 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query17.q.out 120c8d28d1 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query2.q.out 07ab7a16e0 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query20.q.out 29382b389b 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query21.q.out 5e165e8e70 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query23.q.out 3146b776ce 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query24.q.out 41d96ea303 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query25.q.out 958033e41b 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query27.q.out 7fae258207 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query28.q.out e0e61534c5 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query29.q.out 3e7c6805b2 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query30.q.out bd68baa23b 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query31.q.out f8e31a23aa 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query32.q.out b5cf714198 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query33.q.out e8824ddf54 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query34.q.out 987f8d3eea 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query36.q.out d4031261c7 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query37.q.out f054717d70 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query39.q.out 272bedcbce 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query4.q.out 9668e0f4a1 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query40.q.out 5cce22af4e 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query43.q.out 6b21ee45c0 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query46.q.out 9d21449b65 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query47.q.out 8aa0871cb0 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query48.q.out 3188d82f28 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query49.q.out bc108dba6e 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query5.q.out 54f3dd6a10 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query50.q.out 49c87eedb5 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query53.q.out bac3f77538 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query54.q.out e33203d93c 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query56.q.out a13e599b34 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query57.q.out cb8f67b5c1 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query58.q.out 3e89c2da75 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query59.q.out 34376d1262 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query6.q.out 5e3deb3eb9 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query60.q.out ea098f7567 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query61.q.out 2bc02f51f7 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query63.q.out e22d812f78 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query64.q.out 8223efcdb6 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query65.q.out 3e906b73b0 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query66.q.out 77256a3adc 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query68.q.out 1b25235c8a 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query72.q.out 206b0f1972 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query73.q.out 38af7c0d35 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query74.q.out 4a8f0b88f0 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query75.q.out a95e756dab 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query76.q.out a51a05ac00 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query77.q.out 0ac295bf8f 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query78.q.out de1b133006 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query80.q.out a4fac0cca1 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query81.q.out 98066643bf 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query82.q.out 54c4a99b68 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query83.q.out 58ed6dabe7 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query85.q.out 91aad930ba 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query87.q.out 97c9eddc34 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query88.q.out 1ac8fe2dcd 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query89.q.out d9c7d42b9f 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query91.q.out 0017776216 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query92.q.out 503c78185c 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query94.q.out 25e0c8bd9e 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query95.q.out 606e162b30 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query97.q.out c8fff90413 
>   ql/src/test/results/clientpositive/perf/tez/constraints/cbo_query98.q.out 2a6b66f2bf 
>   ql/src/test/results/clientpositive/perf/tez/constraints/mv_query44.q.out db9acc93cb 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query1.q.out 69f93290d9 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query11.q.out 7e0582e164 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query13.q.out 616ed6bcde 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query21.q.out 7c68a294ea 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query31.q.out 8e0de0ffe2 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query34.q.out e2c3631141 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query36.q.out 8158608354 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query4.q.out e6558e99a9 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query44.q.out 3fd361a9f9 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query45.q.out 64d9c98395 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query46.q.out dde72e07b8 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query47.q.out efb3edda71 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query48.q.out 93bafabefd 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query53.q.out a13d0f9c09 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query57.q.out 69aeaae7e9 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query6.q.out 7aea119ac3 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query63.q.out 5620b819fb 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query68.q.out dd4ce4eb84 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query70.q.out a49314c858 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query72.q.out 1a9c2cf203 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query73.q.out 52b0c26588 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query74.q.out 525217b526 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query78.q.out ef4d6dbc21 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query85.q.out aeb33836cd 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query86.q.out 638cce1b46 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query87.q.out b6d3904c1c 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query88.q.out 64919cafe7 
>   ql/src/test/results/clientpositive/perf/tez/constraints/query89.q.out 3049fec95c 
>   ql/src/test/results/clientpositive/perf/tez/query11.q.out da1c349ff0 
>   ql/src/test/results/clientpositive/perf/tez/query13.q.out 60a73d7250 
>   ql/src/test/results/clientpositive/perf/tez/query21.q.out 0d10843009 
>   ql/src/test/results/clientpositive/perf/tez/query31.q.out c0762b7bd4 
>   ql/src/test/results/clientpositive/perf/tez/query34.q.out d401e4cdc0 
>   ql/src/test/results/clientpositive/perf/tez/query36.q.out 064837a3cf 
>   ql/src/test/results/clientpositive/perf/tez/query4.q.out bb0d7ba3f5 
>   ql/src/test/results/clientpositive/perf/tez/query45.q.out c2f9374c4b 
>   ql/src/test/results/clientpositive/perf/tez/query47.q.out 04c64b405f 
>   ql/src/test/results/clientpositive/perf/tez/query48.q.out d64eec1c74 
>   ql/src/test/results/clientpositive/perf/tez/query53.q.out e9153f3a06 
>   ql/src/test/results/clientpositive/perf/tez/query57.q.out 4a18880260 
>   ql/src/test/results/clientpositive/perf/tez/query63.q.out 0bdd48b728 
>   ql/src/test/results/clientpositive/perf/tez/query70.q.out 8d9d06dd48 
>   ql/src/test/results/clientpositive/perf/tez/query73.q.out 352c7245ea 
>   ql/src/test/results/clientpositive/perf/tez/query74.q.out 20aade2974 
>   ql/src/test/results/clientpositive/perf/tez/query78.q.out 3d938e1c8e 
>   ql/src/test/results/clientpositive/perf/tez/query85.q.out 5b8ad0ba57 
>   ql/src/test/results/clientpositive/perf/tez/query86.q.out 2d6d545a5b 
>   ql/src/test/results/clientpositive/perf/tez/query87.q.out 5b59116741 
>   ql/src/test/results/clientpositive/perf/tez/query88.q.out e02ff3715b 
>   ql/src/test/results/clientpositive/perf/tez/query89.q.out 8501822cd2 
>   ql/src/test/results/clientpositive/perf/tez/query93.q.out b5e6ba9c48 
>   ql/src/test/results/clientpositive/pointlookup.q.out c77536efe5 
>   ql/src/test/results/clientpositive/pointlookup2.q.out 5a1f92758a 
>   ql/src/test/results/clientpositive/pointlookup3.q.out 469a460773 
>   ql/src/test/results/clientpositive/pointlookup4.q.out f105f8a569 
>   ql/src/test/results/clientpositive/ppd_constant_expr.q.out 39dd2d7de3 
>   ql/src/test/results/clientpositive/ppd_join_filter.q.out 68a8cd01f7 
>   ql/src/test/results/clientpositive/row__id.q.out fc4c3123b0 
>   ql/src/test/results/clientpositive/semijoin4.q.out 4cfdd55503 
>   ql/src/test/results/clientpositive/semijoin5.q.out 6fd4174110 
>   ql/src/test/results/clientpositive/skewjoinopt18.q.out 26526a37b2 
>   ql/src/test/results/clientpositive/spark/auto_join2.q.out 6aeadb52dd 
>   ql/src/test/results/clientpositive/spark/auto_join_stats.q.out a6d09228c1 
>   ql/src/test/results/clientpositive/spark/auto_join_stats2.q.out fbcc489b14 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_12.q.out 7138a6fb30 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_16.q.out 24cf07b9a3 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_16.q.out_spark 8c22440488 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_6.q.out 329cdf66b2 
>   ql/src/test/results/clientpositive/spark/bucket_map_join_tez2.q.out be43889af1 
>   ql/src/test/results/clientpositive/spark/cbo_simple_select.q.out acf91bf178 
>   ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out 866a86d7b4 
>   ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out 06da1248f3 
>   ql/src/test/results/clientpositive/spark/infer_bucket_sort_map_operators.q.out 59e25f890e 
>   ql/src/test/results/clientpositive/spark/join2.q.out 3f64bc9a40 
>   ql/src/test/results/clientpositive/spark/join_filters_overlap.q.out 49226b2622 
>   ql/src/test/results/clientpositive/spark/parquet_vectorization_0.q.out adb9f4a33b 
>   ql/src/test/results/clientpositive/spark/parquet_vectorization_5.q.out fc3952117a 
>   ql/src/test/results/clientpositive/spark/parquet_vectorization_6.q.out 6eabffb84d 
>   ql/src/test/results/clientpositive/spark/parquet_vectorization_8.q.out 357a321c27 
>   ql/src/test/results/clientpositive/spark/parquet_vectorization_div0.q.out 8f40278318 
>   ql/src/test/results/clientpositive/spark/pcr.q.out 2c5b15aa3a 
>   ql/src/test/results/clientpositive/spark/ppd_join_filter.q.out b8a8760955 
>   ql/src/test/results/clientpositive/spark/skewjoinopt18.q.out 0e43a882ed 
>   ql/src/test/results/clientpositive/spark/spark_dynamic_partition_pruning.q.out 89da63134c 
>   ql/src/test/results/clientpositive/spark/spark_explainuser_1.q.out b8403f4e39 
>   ql/src/test/results/clientpositive/spark/spark_use_ts_stats_for_mapjoin.q.out eecacca8ad 
>   ql/src/test/results/clientpositive/spark/spark_vectorized_dynamic_partition_pruning.q.out e90f9d17ac 
>   ql/src/test/results/clientpositive/spark/subquery_in.q.out 3fc9aa1b1b 
>   ql/src/test/results/clientpositive/spark/subquery_multi.q.out 17240f9dc5 
>   ql/src/test/results/clientpositive/spark/subquery_notin.q.out 2d93874450 
>   ql/src/test/results/clientpositive/spark/subquery_null_agg.q.out 302c2609cb 
>   ql/src/test/results/clientpositive/spark/subquery_scalar.q.out 4e31c3fd20 
>   ql/src/test/results/clientpositive/spark/subquery_select.q.out 3c6f6af020 
>   ql/src/test/results/clientpositive/spark/subquery_views.q.out d048716c0a 
>   ql/src/test/results/clientpositive/spark/union22.q.out 3798d87f7b 
>   ql/src/test/results/clientpositive/spark/vectorization_0.q.out c6e0c33dc5 
>   ql/src/test/results/clientpositive/spark/vectorization_5.q.out 00f8260aac 
>   ql/src/test/results/clientpositive/spark/vectorization_6.q.out d1cc6e39ed 
>   ql/src/test/results/clientpositive/spark/vectorization_div0.q.out 18159aa9bf 
>   ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out 2d8d8b1ec9 
>   ql/src/test/results/clientpositive/spark/vectorized_math_funcs.q.out 977725ca4c 
>   ql/src/test/results/clientpositive/spark/vectorized_string_funcs.q.out 79546c5a73 
>   ql/src/test/results/clientpositive/subquery_notexists.q.out 2b6c08bde4 
>   ql/src/test/results/clientpositive/subquery_notin_having.q.out 68a65df3a9 
>   ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out 7217ac55b3 
>   ql/src/test/results/clientpositive/timestamp_ints_casts.q.out 83d4557c8a 
>   ql/src/test/results/clientpositive/udf_isops_simplify.q.out e9fcd05939 
>   ql/src/test/results/clientpositive/udf_to_unix_timestamp.q.out 1f446eb454 
>   ql/src/test/results/clientpositive/union22.q.out a3aa5e2c77 
>   ql/src/test/results/clientpositive/union_offcbo.q.out 2e5675fe8e 
>   ql/src/test/results/clientpositive/vector_case_when_1.q.out 61062e1f8e 
>   ql/src/test/results/clientpositive/vector_case_when_2.q.out 29b0823961 
>   ql/src/test/results/clientpositive/vector_char_mapjoin1.q.out 19cb5b4b71 
>   ql/src/test/results/clientpositive/vector_coalesce_3.q.out 39fd5e898a 
>   ql/src/test/results/clientpositive/vector_date_1.q.out 4e82ed84b6 
>   ql/src/test/results/clientpositive/vector_decimal_math_funcs.q.out 31751503b5 
>   ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out 613a30701a 
>   ql/src/test/results/clientpositive/vector_interval_mapjoin.q.out 49843e939e 
>   ql/src/test/results/clientpositive/vector_varchar_mapjoin1.q.out 0d4107991c 
>   ql/src/test/results/clientpositive/vectorization_5.q.out 36eb6d53a8 
>   ql/src/test/results/clientpositive/vectorization_6.q.out fbb6f5e3ca 
>   ql/src/test/results/clientpositive/vectorization_8.q.out 6a52519eae 
>   ql/src/test/results/clientpositive/vectorized_casts.q.out fd6277c4bb 
>   ql/src/test/results/clientpositive/vectorized_math_funcs.q.out 0b0aba6829 
>   ql/src/test/results/clientpositive/vectorized_string_funcs.q.out 64064c0e85 
>   ql/src/test/results/clientpositive/vectorized_timestamp_ints_casts.q.out bf66c03a5e 
>   ql/src/test/results/clientpositive/view_cbo.q.out c7d9c8a0ec 
> 
> 
> Diff: https://reviews.apache.org/r/69918/diff/2/
> 
> 
> Testing
> -------
> 
> 
> Thanks,
> 
> Zoltan Haindrich
> 
>