You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by se...@apache.org on 2018/06/26 04:17:10 UTC

[51/58] [abbrv] [partial] hive git commit: HIVE-12342 : Set default value of hive.optimize.index.filter to true (Igor Kryvenko via Ashutosh Chauhan)

HIVE-12342 : Set default value of hive.optimize.index.filter to true (Igor Kryvenko via Ashutosh Chauhan)

Signed-off-by: Ashutosh Chauhan <ha...@apache.org>


Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/f2c4f319
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/f2c4f319
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/f2c4f319

Branch: refs/heads/master-txnstats
Commit: f2c4f3193637b6268edfd60cea054fa9723dcfd0
Parents: 33088de
Author: Igor Kryvenko <kr...@gmail.com>
Authored: Mon Jun 25 09:03:01 2018 -0700
Committer: Ashutosh Chauhan <ha...@apache.org>
Committed: Mon Jun 25 09:03:01 2018 -0700

----------------------------------------------------------------------
 .../positive/accumulo_predicate_pushdown.q.out  |    2 +
 .../org/apache/hadoop/hive/conf/HiveConf.java   |    2 +-
 .../test/results/clientpositive/dboutput.q.out  |    1 +
 .../clientpositive/serde_typedbytes4.q.out      |    1 +
 .../results/positive/hbase_custom_key3.q.out    |    1 +
 .../src/test/results/positive/hbase_ddl.q.out   |    1 +
 .../test/results/positive/hbase_queries.q.out   |    3 +
 .../hadoop/hive/ql/parse/ParseContext.java      |    3 +-
 .../hive/ql/plan/mapping/TestOperatorCmp.java   |    3 +-
 .../bucket_mapjoin_mismatch1.q.out              |    4 +
 .../sortmerge_mapjoin_mismatch_1.q.out          |    2 +
 .../results/clientpositive/acid_mapjoin.q.out   |    2 +
 .../clientpositive/acid_table_stats.q.out       |    4 +
 .../clientpositive/allcolref_in_udf.q.out       |    3 +
 .../clientpositive/alterColumnStatsPart.q.out   |    4 +
 .../alter_partition_coltype.q.out               |    3 +
 .../results/clientpositive/ambiguous_col.q.out  |    6 +
 .../clientpositive/analyze_tbl_date.q.out       |    1 +
 .../annotate_stats_deep_filters.q.out           |    2 +
 .../clientpositive/annotate_stats_filter.q.out  |   19 +
 .../clientpositive/annotate_stats_join.q.out    |   19 +
 .../annotate_stats_join_pkfk.q.out              |   27 +
 .../clientpositive/annotate_stats_part.q.out    |    9 +
 .../clientpositive/annotate_stats_select.q.out  |    1 +
 .../clientpositive/autoColumnStats_1.q.out      |    1 +
 .../clientpositive/autoColumnStats_2.q.out      |    2 +
 .../clientpositive/autoColumnStats_4.q.out      |    1 +
 .../clientpositive/autoColumnStats_9.q.out      |    2 +
 .../results/clientpositive/auto_join0.q.out     |    2 +
 .../results/clientpositive/auto_join1.q.out     |    2 +
 .../results/clientpositive/auto_join10.q.out    |    2 +
 .../results/clientpositive/auto_join11.q.out    |    2 +
 .../results/clientpositive/auto_join12.q.out    |    3 +
 .../results/clientpositive/auto_join13.q.out    |    3 +
 .../results/clientpositive/auto_join14.q.out    |    2 +
 .../results/clientpositive/auto_join15.q.out    |    2 +
 .../results/clientpositive/auto_join16.q.out    |    2 +
 .../results/clientpositive/auto_join17.q.out    |    2 +
 .../results/clientpositive/auto_join19.q.out    |    2 +
 .../clientpositive/auto_join19_inclause.q.out   |    2 +
 .../results/clientpositive/auto_join2.q.out     |    3 +
 .../results/clientpositive/auto_join20.q.out    |    4 +
 .../results/clientpositive/auto_join21.q.out    |    1 +
 .../results/clientpositive/auto_join22.q.out    |    3 +
 .../results/clientpositive/auto_join23.q.out    |    2 +
 .../results/clientpositive/auto_join24.q.out    |    2 +
 .../results/clientpositive/auto_join26.q.out    |    2 +
 .../results/clientpositive/auto_join27.q.out    |    3 +
 .../results/clientpositive/auto_join28.q.out    |    6 +
 .../results/clientpositive/auto_join29.q.out    |   19 +
 .../results/clientpositive/auto_join3.q.out     |    3 +
 .../results/clientpositive/auto_join32.q.out    |    5 +
 .../results/clientpositive/auto_join33.q.out    |    2 +
 .../results/clientpositive/auto_join4.q.out     |    2 +
 .../results/clientpositive/auto_join5.q.out     |    2 +
 .../results/clientpositive/auto_join6.q.out     |    2 +
 .../results/clientpositive/auto_join7.q.out     |    3 +
 .../results/clientpositive/auto_join8.q.out     |    2 +
 .../results/clientpositive/auto_join9.q.out     |    2 +
 .../auto_join_reordering_values.q.out           |    5 +
 .../clientpositive/auto_join_stats.q.out        |   15 +
 .../clientpositive/auto_join_stats2.q.out       |    7 +
 .../auto_join_without_localtask.q.out           |   24 +
 .../avro_schema_evolution_native.q.out          |    2 +
 .../beeline/explain_outputs.q.out               |    6 +
 .../materialized_view_create_rewrite.q.out      |    5 +
 .../clientpositive/beeline/smb_mapjoin_1.q.out  |    2 +
 .../clientpositive/beeline/smb_mapjoin_10.q.out |    1 +
 .../clientpositive/beeline/smb_mapjoin_11.q.out |    1 +
 .../clientpositive/beeline/smb_mapjoin_12.q.out |    2 +
 .../clientpositive/beeline/smb_mapjoin_13.q.out |    3 +
 .../clientpositive/beeline/smb_mapjoin_16.q.out |    1 +
 .../clientpositive/beeline/smb_mapjoin_2.q.out  |    2 +
 .../clientpositive/beeline/smb_mapjoin_3.q.out  |    2 +
 .../test/results/clientpositive/bucket3.q.out   |    1 +
 .../clientpositive/bucket_map_join_1.q.out      |    2 +
 .../clientpositive/bucket_map_join_2.q.out      |    2 +
 .../clientpositive/bucket_map_join_spark1.q.out |    4 +
 .../clientpositive/bucket_map_join_spark2.q.out |    4 +
 .../clientpositive/bucket_map_join_spark3.q.out |    4 +
 .../clientpositive/bucket_map_join_spark4.q.out |    6 +
 .../clientpositive/bucketcontext_1.q.out        |    3 +
 .../clientpositive/bucketcontext_2.q.out        |    3 +
 .../clientpositive/bucketcontext_3.q.out        |    3 +
 .../clientpositive/bucketcontext_4.q.out        |    3 +
 .../clientpositive/bucketcontext_5.q.out        |    3 +
 .../clientpositive/bucketcontext_6.q.out        |    3 +
 .../clientpositive/bucketcontext_7.q.out        |    3 +
 .../clientpositive/bucketcontext_8.q.out        |    3 +
 .../clientpositive/bucketmapjoin10.q.out        |    2 +
 .../clientpositive/bucketmapjoin11.q.out        |    4 +
 .../clientpositive/bucketmapjoin12.q.out        |    4 +
 .../clientpositive/bucketmapjoin13.q.out        |    8 +
 .../results/clientpositive/bucketmapjoin5.q.out |    4 +
 .../results/clientpositive/bucketmapjoin8.q.out |    4 +
 .../results/clientpositive/bucketmapjoin9.q.out |    4 +
 .../clientpositive/bucketmapjoin_negative.q.out |    2 +
 .../bucketmapjoin_negative2.q.out               |    2 +
 .../bucketmapjoin_negative3.q.out               |   18 +
 .../bucketsortoptimize_insert_1.q.out           |    5 +
 .../bucketsortoptimize_insert_3.q.out           |    2 +
 .../bucketsortoptimize_insert_4.q.out           |    2 +
 .../bucketsortoptimize_insert_5.q.out           |    2 +
 .../bucketsortoptimize_insert_8.q.out           |    2 +
 .../clientpositive/case_sensitivity.q.out       |    1 +
 ql/src/test/results/clientpositive/cast1.q.out  |    1 +
 .../clientpositive/cast_on_constant.q.out       |    5 +
 .../test/results/clientpositive/cbo_const.q.out |    4 +
 .../results/clientpositive/cbo_input26.q.out    |    8 +
 .../cbo_ppd_non_deterministic.q.out             |    2 +
 .../clientpositive/cbo_rp_auto_join0.q.out      |    4 +
 .../clientpositive/cbo_rp_auto_join1.q.out      |   19 +
 .../clientpositive/cbo_rp_auto_join17.q.out     |    2 +
 .../cbo_rp_cross_product_check_2.q.out          |    6 +
 .../results/clientpositive/cbo_rp_join0.q.out   |    4 +
 .../clientpositive/cbo_rp_outer_join_ppr.q.out  |    4 +
 .../clientpositive/cbo_rp_simple_select.q.out   |    6 +
 .../clientpositive/cbo_simple_select.q.out      |    6 +
 .../results/clientpositive/cbo_union_view.q.out |    6 +
 .../clientpositive/columnstats_partlvl.q.out    |    5 +
 .../clientpositive/columnstats_partlvl_dp.q.out |    2 +
 .../test/results/clientpositive/combine2.q.out  |    2 +
 .../test/results/clientpositive/comments.q.out  |    2 +
 .../results/clientpositive/complex_alias.q.out  |    2 +
 .../constantPropagateForSubQuery.q.out          |    1 +
 .../clientpositive/constant_prop_1.q.out        |    7 +
 .../clientpositive/constant_prop_2.q.out        |    1 +
 .../clientpositive/constant_prop_3.q.out        |    4 +
 .../results/clientpositive/constprog2.q.out     |    4 +
 .../results/clientpositive/constprog_dp.q.out   |    1 +
 .../clientpositive/constprog_partitioner.q.out  |    4 +
 .../clientpositive/correlated_join_keys.q.out   |    4 +
 .../clientpositive/correlationoptimizer10.q.out |   18 +
 .../clientpositive/correlationoptimizer11.q.out |    8 +
 .../clientpositive/correlationoptimizer12.q.out |    2 +
 .../clientpositive/correlationoptimizer13.q.out |    2 +
 .../clientpositive/correlationoptimizer14.q.out |   20 +
 .../clientpositive/correlationoptimizer15.q.out |    6 +
 .../clientpositive/correlationoptimizer5.q.out  |   12 +
 .../clientpositive/correlationoptimizer7.q.out  |   12 +
 .../clientpositive/correlationoptimizer8.q.out  |   15 +
 .../clientpositive/correlationoptimizer9.q.out  |    8 +
 ql/src/test/results/clientpositive/cp_sel.q.out |    2 +
 .../results/clientpositive/create_view.q.out    |    1 +
 .../results/clientpositive/cross_join.q.out     |    4 +
 .../clientpositive/cross_join_merge.q.out       |   12 +
 .../clientpositive/cross_product_check_1.q.out  |    6 +
 .../clientpositive/cross_product_check_2.q.out  |    6 +
 .../results/clientpositive/ctas_colname.q.out   |    2 +
 ql/src/test/results/clientpositive/cte_1.q.out  |    3 +
 ql/src/test/results/clientpositive/cte_3.q.out  |    4 +
 ql/src/test/results/clientpositive/cte_5.q.out  |    2 +
 ql/src/test/results/clientpositive/cte_6.q.out  |    2 +
 .../test/results/clientpositive/cte_mat_1.q.out |    2 +
 .../test/results/clientpositive/cte_mat_2.q.out |    2 +
 .../test/results/clientpositive/cte_mat_3.q.out |    3 +
 .../test/results/clientpositive/cte_mat_4.q.out |    6 +
 .../test/results/clientpositive/cte_mat_5.q.out |    3 +
 .../results/clientpositive/decimal_join2.q.out  |    4 +
 .../results/clientpositive/decimal_udf.q.out    |    4 +
 .../results/clientpositive/decimal_udf2.q.out   |    2 +
 .../results/clientpositive/deleteAnalyze.q.out  |    2 +
 .../druid/druidkafkamini_basic.q.out            |    1 +
 .../druid/druidmini_dynamic_partition.q.out     |    3 +
 .../clientpositive/druid/druidmini_mv.q.out     |    7 +
 .../dynamic_partition_skip_default.q.out        |    3 +
 .../results/clientpositive/empty_join.q.out     |    3 +
 .../encryption_join_unencrypted_tbl.q.out       |    2 +
 ...on_join_with_different_encryption_keys.q.out |    2 +
 .../clientpositive/explain_logical.q.out        |   13 +
 .../clientpositive/explain_outputs.q.out        |    6 +
 .../clientpositive/explain_rearrange.q.out      |    8 +
 .../extrapolate_part_stats_date.q.out           |    1 +
 .../clientpositive/filter_cond_pushdown.q.out   |   11 +
 .../filter_cond_pushdown_HIVE_15647.q.out       |    8 +
 .../clientpositive/filter_in_or_dup.q.out       |    3 +
 .../clientpositive/filter_join_breaktask.q.out  |    3 +
 .../results/clientpositive/filter_numeric.q.out |    5 +
 .../results/clientpositive/flatten_and_or.q.out |    1 +
 .../test/results/clientpositive/fold_case.q.out |    6 +
 .../clientpositive/fold_eq_with_case_when.q.out |    5 +
 .../test/results/clientpositive/fold_when.q.out |    5 +
 .../clientpositive/folder_predicate.q.out       |    7 +
 .../clientpositive/fp_literal_arithmetic.q.out  |    4 +
 .../test/results/clientpositive/gby_star.q.out  |    4 +
 .../clientpositive/groupby_grouping_sets4.q.out |    6 +
 .../clientpositive/groupby_join_pushdown.q.out  |   24 +
 .../clientpositive/groupby_map_ppr.q.out        |    1 +
 .../groupby_map_ppr_multi_distinct.q.out        |    1 +
 .../groupby_multi_single_reducer2.q.out         |    1 +
 .../groupby_multi_single_reducer3.q.out         |    2 +
 .../clientpositive/groupby_position.q.out       |    3 +
 .../results/clientpositive/groupby_ppd.q.out    |    2 +
 .../results/clientpositive/groupby_ppr.q.out    |    1 +
 .../groupby_ppr_multi_distinct.q.out            |    2 +
 .../clientpositive/groupby_rollup_empty.q.out   |    1 +
 .../clientpositive/groupby_sort_1_23.q.out      |    5 +
 .../results/clientpositive/groupby_sort_6.q.out |    3 +
 .../results/clientpositive/groupby_sort_7.q.out |    1 +
 .../clientpositive/groupby_sort_skew_1_23.q.out |    5 +
 ql/src/test/results/clientpositive/having.q.out |    2 +
 .../test/results/clientpositive/having2.q.out   |    6 +
 .../identity_project_remove_skip.q.out          |    2 +
 .../results/clientpositive/implicit_cast1.q.out |    1 +
 .../implicit_cast_during_insert.q.out           |    1 +
 .../clientpositive/implicit_decimal.q.out       |    1 +
 .../infer_bucket_sort_dyn_part.q.out            |    1 +
 .../infer_bucket_sort_map_operators.q.out       |    3 +
 .../infer_bucket_sort_num_buckets.q.out         |    1 +
 .../clientpositive/infer_const_type.q.out       |    4 +
 .../clientpositive/infer_join_preds.q.out       |    7 +
 .../test/results/clientpositive/innerjoin.q.out |    2 +
 .../results/clientpositive/innerjoin1.q.out     |    4 +
 .../test/results/clientpositive/input11.q.out   |    1 +
 .../results/clientpositive/input11_limit.q.out  |    1 +
 .../test/results/clientpositive/input23.q.out   |    2 +
 .../test/results/clientpositive/input25.q.out   |    2 +
 .../test/results/clientpositive/input26.q.out   |    2 +
 .../results/clientpositive/input2_limit.q.out   |    1 +
 .../test/results/clientpositive/input42.q.out   |    2 +
 ql/src/test/results/clientpositive/input6.q.out |    1 +
 .../results/clientpositive/input_part0.q.out    |    1 +
 .../results/clientpositive/input_part1.q.out    |    1 +
 .../results/clientpositive/input_part3.q.out    |    1 +
 .../results/clientpositive/input_part4.q.out    |    1 +
 .../results/clientpositive/input_part5.q.out    |    1 +
 .../results/clientpositive/input_part6.q.out    |    1 +
 .../results/clientpositive/input_part7.q.out    |    2 +
 .../results/clientpositive/input_part8.q.out    |    1 +
 .../results/clientpositive/input_part9.q.out    |    1 +
 .../clientpositive/input_testxpath2.q.out       |    1 +
 .../clientpositive/input_testxpath4.q.out       |    1 +
 .../test/results/clientpositive/insert1.q.out   |    4 +
 .../insert2_overwrite_partitions.q.out          |    2 +
 .../results/clientpositive/insert_into2.q.out   |    1 +
 ql/src/test/results/clientpositive/join0.q.out  |    4 +-
 ql/src/test/results/clientpositive/join10.q.out |    2 +
 ql/src/test/results/clientpositive/join11.q.out |    2 +
 ql/src/test/results/clientpositive/join12.q.out |    3 +
 ql/src/test/results/clientpositive/join13.q.out |    3 +
 ql/src/test/results/clientpositive/join14.q.out |    2 +
 ql/src/test/results/clientpositive/join15.q.out |    2 +
 ql/src/test/results/clientpositive/join16.q.out |    2 +
 ql/src/test/results/clientpositive/join17.q.out |    2 +
 ql/src/test/results/clientpositive/join19.q.out |    6 +
 ql/src/test/results/clientpositive/join2.q.out  |    3 +
 ql/src/test/results/clientpositive/join20.q.out |    4 +
 ql/src/test/results/clientpositive/join21.q.out |    1 +
 ql/src/test/results/clientpositive/join22.q.out |    3 +
 ql/src/test/results/clientpositive/join23.q.out |    2 +
 ql/src/test/results/clientpositive/join25.q.out |    2 +
 ql/src/test/results/clientpositive/join26.q.out |    3 +
 ql/src/test/results/clientpositive/join27.q.out |    2 +
 ql/src/test/results/clientpositive/join28.q.out |    3 +
 ql/src/test/results/clientpositive/join29.q.out |    2 +
 ql/src/test/results/clientpositive/join3.q.out  |    3 +
 ql/src/test/results/clientpositive/join30.q.out |    2 +
 ql/src/test/results/clientpositive/join31.q.out |    2 +
 ql/src/test/results/clientpositive/join32.q.out |    3 +
 ql/src/test/results/clientpositive/join33.q.out |    3 +
 ql/src/test/results/clientpositive/join34.q.out |    3 +
 ql/src/test/results/clientpositive/join35.q.out |    3 +
 ql/src/test/results/clientpositive/join36.q.out |    2 +
 ql/src/test/results/clientpositive/join37.q.out |    2 +
 ql/src/test/results/clientpositive/join38.q.out |    2 +
 ql/src/test/results/clientpositive/join39.q.out |    1 +
 ql/src/test/results/clientpositive/join4.q.out  |    2 +
 ql/src/test/results/clientpositive/join40.q.out |   10 +
 ql/src/test/results/clientpositive/join41.q.out |    2 +
 ql/src/test/results/clientpositive/join42.q.out |    6 +
 ql/src/test/results/clientpositive/join43.q.out |    6 +
 ql/src/test/results/clientpositive/join44.q.out |    2 +
 ql/src/test/results/clientpositive/join45.q.out |    6 +
 ql/src/test/results/clientpositive/join46.q.out |    2 +
 ql/src/test/results/clientpositive/join47.q.out |    6 +
 ql/src/test/results/clientpositive/join5.q.out  |    2 +
 ql/src/test/results/clientpositive/join6.q.out  |    2 +
 ql/src/test/results/clientpositive/join7.q.out  |    3 +
 ql/src/test/results/clientpositive/join8.q.out  |    2 +
 ql/src/test/results/clientpositive/join9.q.out  |    2 +
 .../clientpositive/join_alt_syntax.q.out        |   16 +
 .../clientpositive/join_cond_pushdown_1.q.out   |   10 +
 .../clientpositive/join_cond_pushdown_2.q.out   |    8 +
 .../clientpositive/join_cond_pushdown_3.q.out   |   10 +
 .../clientpositive/join_cond_pushdown_4.q.out   |    8 +
 .../join_cond_pushdown_unqual1.q.out            |   10 +
 .../join_cond_pushdown_unqual2.q.out            |    8 +
 .../join_cond_pushdown_unqual3.q.out            |   10 +
 .../join_cond_pushdown_unqual4.q.out            |    8 +
 .../clientpositive/join_filters_overlap.q.out   |   11 +
 .../clientpositive/join_grp_diff_keys.q.out     |    4 +
 .../results/clientpositive/join_hive_626.q.out  |    3 +
 .../results/clientpositive/join_map_ppr.q.out   |    6 +
 .../join_merge_multi_expressions.q.out          |    3 +
 .../results/clientpositive/join_merging.q.out   |    3 +
 .../clientpositive/join_on_varchar.q.out        |    2 +
 .../results/clientpositive/join_parse.q.out     |   13 +
 .../test/results/clientpositive/join_rc.q.out   |    2 +
 .../results/clientpositive/join_reorder.q.out   |    4 +
 .../results/clientpositive/join_reorder2.q.out  |    8 +
 .../results/clientpositive/join_reorder3.q.out  |    8 +
 .../results/clientpositive/join_reorder4.q.out  |    9 +
 .../test/results/clientpositive/join_star.q.out |    8 +
 .../results/clientpositive/join_thrift.q.out    |    2 +
 .../test/results/clientpositive/join_vc.q.out   |    5 +
 .../test/results/clientpositive/join_view.q.out |    2 +
 .../clientpositive/lateral_view_cp.q.out        |    2 +
 .../clientpositive/lateral_view_onview.q.out    |    2 +
 .../clientpositive/lateral_view_ppd.q.out       |    5 +
 .../results/clientpositive/leftsemijoin.q.out   |    2 +
 .../limit_pushdown_negative.q.out               |    2 +
 .../clientpositive/list_bucket_dml_1.q.out      |    2 +
 .../clientpositive/list_bucket_dml_11.q.out     |    1 +
 .../clientpositive/list_bucket_dml_12.q.out     |    2 +
 .../clientpositive/list_bucket_dml_13.q.out     |    1 +
 .../clientpositive/list_bucket_dml_14.q.out     |    1 +
 .../clientpositive/list_bucket_dml_2.q.out      |    2 +
 .../clientpositive/list_bucket_dml_3.q.out      |    2 +
 .../clientpositive/list_bucket_dml_4.q.out      |    3 +
 .../clientpositive/list_bucket_dml_5.q.out      |    2 +
 .../clientpositive/list_bucket_dml_6.q.out      |    3 +
 .../clientpositive/list_bucket_dml_7.q.out      |    3 +
 .../clientpositive/list_bucket_dml_8.q.out      |    2 +
 .../clientpositive/list_bucket_dml_9.q.out      |    3 +
 .../list_bucket_query_multiskew_1.q.out         |    4 +
 .../list_bucket_query_multiskew_2.q.out         |    3 +
 .../list_bucket_query_multiskew_3.q.out         |    3 +
 .../list_bucket_query_oneskew_1.q.out           |    3 +
 .../list_bucket_query_oneskew_2.q.out           |    4 +
 .../list_bucket_query_oneskew_3.q.out           |    1 +
 .../clientpositive/llap/acid_no_buckets.q.out   |    4 +
 .../clientpositive/llap/autoColumnStats_1.q.out |    1 +
 .../clientpositive/llap/autoColumnStats_2.q.out |    2 +
 .../clientpositive/llap/auto_join0.q.out        |    1 +
 .../clientpositive/llap/auto_join1.q.out        |    2 +
 .../clientpositive/llap/auto_join21.q.out       |    1 +
 .../clientpositive/llap/auto_join29.q.out       |   19 +
 .../clientpositive/llap/auto_join30.q.out       |    5 +
 .../llap/auto_smb_mapjoin_14.q.out              |   29 +
 .../llap/auto_sortmerge_join_1.q.out            |    6 +
 .../llap/auto_sortmerge_join_10.q.out           |    5 +
 .../llap/auto_sortmerge_join_11.q.out           |    9 +
 .../llap/auto_sortmerge_join_12.q.out           |    7 +-
 .../llap/auto_sortmerge_join_13.q.out           |    6 +
 .../llap/auto_sortmerge_join_16.q.out           |    6 +
 .../llap/auto_sortmerge_join_2.q.out            |    4 +
 .../llap/auto_sortmerge_join_3.q.out            |    6 +
 .../llap/auto_sortmerge_join_4.q.out            |    6 +
 .../llap/auto_sortmerge_join_5.q.out            |    6 +
 .../llap/auto_sortmerge_join_6.q.out            |   30 +
 .../llap/auto_sortmerge_join_7.q.out            |    6 +
 .../llap/auto_sortmerge_join_8.q.out            |    6 +
 .../llap/auto_sortmerge_join_9.q.out            |   56 +
 .../results/clientpositive/llap/bucket3.q.out   |    1 +
 .../clientpositive/llap/bucket_groupby.q.out    |   11 +
 .../llap/bucket_map_join_tez2.q.out             |   41 +
 .../llap/bucket_map_join_tez_empty.q.out        |    2 +
 .../clientpositive/llap/bucketmapjoin1.q.out    |    8 +
 .../clientpositive/llap/bucketmapjoin2.q.out    |    6 +
 .../clientpositive/llap/bucketmapjoin3.q.out    |    4 +
 .../clientpositive/llap/bucketmapjoin4.q.out    |    4 +
 .../clientpositive/llap/bucketmapjoin7.q.out    |    2 +
 .../llap/bucketsortoptimize_insert_2.q.out      |   12 +
 .../llap/bucketsortoptimize_insert_6.q.out      |   14 +
 .../llap/bucketsortoptimize_insert_7.q.out      |    6 +
 .../clientpositive/llap/cbo_simple_select.q.out |    6 +
 .../clientpositive/llap/check_constraint.q.out  |    3 +
 .../results/clientpositive/llap/cluster.q.out   |   18 +
 .../columnStatsUpdateForStatsOptimizer_1.q.out  |    2 +
 .../llap/column_access_stats.q.out              |    9 +
 .../llap/column_table_stats.q.out               |    1 +
 .../llap/column_table_stats_orc.q.out           |    1 +
 .../llap/constprog_semijoin.q.out               |   74 +-
 .../llap/correlationoptimizer1.q.out            |   18 +
 .../llap/correlationoptimizer2.q.out            |    8 +
 .../llap/correlationoptimizer3.q.out            |   20 +
 .../llap/correlationoptimizer4.q.out            |    9 +
 .../llap/correlationoptimizer6.q.out            |   58 +
 .../clientpositive/llap/cross_join.q.out        |    4 +
 .../clientpositive/llap/cross_prod_1.q.out      |    2 +
 .../clientpositive/llap/cross_prod_3.q.out      |    3 +
 .../llap/cross_product_check_1.q.out            |   12 +-
 .../llap/cross_product_check_2.q.out            |   12 +-
 .../results/clientpositive/llap/cte_1.q.out     |    3 +
 .../results/clientpositive/llap/cte_mat_3.q.out |   16 +-
 .../results/clientpositive/llap/cte_mat_4.q.out |   32 +-
 .../results/clientpositive/llap/cte_mat_5.q.out |   16 +-
 .../clientpositive/llap/deleteAnalyze.q.out     |   16 +-
 .../llap/dynpart_sort_opt_vectorization.q.out   |   14 +
 .../llap/dynpart_sort_optimization.q.out        |   21 +
 .../llap/dynpart_sort_optimization2.q.out       |    6 +
 .../llap/dynpart_sort_optimization_acid.q.out   |   12 +
 .../clientpositive/llap/empty_join.q.out        |   22 +-
 .../llap/enforce_constraint_notnull.q.out       |    7 +
 .../clientpositive/llap/explainanalyze_2.q.out  |  508 ++---
 .../clientpositive/llap/explainuser_1.q.out     |  122 +-
 .../clientpositive/llap/explainuser_2.q.out     | 1900 +++++++++---------
 .../clientpositive/llap/explainuser_4.q.out     |  138 +-
 .../llap/filter_join_breaktask.q.out            |    3 +
 .../llap/groupby_resolution.q.out               |    1 +
 .../llap/groupby_rollup_empty.q.out             |    1 +
 .../results/clientpositive/llap/having.q.out    |    2 +
 .../llap/hybridgrace_hashjoin_1.q.out           |   20 +
 .../llap/hybridgrace_hashjoin_2.q.out           |   36 +
 .../llap/identity_project_remove_skip.q.out     |    2 +
 .../results/clientpositive/llap/insert1.q.out   |    4 +
 .../llap/insert1_overwrite_partitions.q.out     |    3 +
 .../clientpositive/llap/insert_into2.q.out      |    1 +
 .../llap/insert_into_default_keyword.q.out      |    4 +
 .../insert_values_orig_table_use_metadata.q.out |    1 +
 .../clientpositive/llap/is_distinct_from.q.out  |    4 +
 .../clientpositive/llap/jdbc_handler.q.out      |    1 +
 .../results/clientpositive/llap/join0.q.out     |    2 +
 .../results/clientpositive/llap/join1.q.out     |    2 +
 .../clientpositive/llap/join32_lessSize.q.out   |   20 +-
 .../results/clientpositive/llap/join46.q.out    |   14 +-
 .../llap/join_is_not_distinct_from.q.out        |    8 +
 .../llap/join_max_hashtable.q.out               |   16 +
 .../clientpositive/llap/join_nullsafe.q.out     |    8 +
 .../llap/join_reordering_no_stats.q.out         |   12 +
 .../test/results/clientpositive/llap/kryo.q.out |    1 +
 .../clientpositive/llap/leftsemijoin.q.out      |    6 +-
 .../llap/limit_join_transpose.q.out             |   48 +
 .../llap/llap_vector_nohybridgrace.q.out        |    4 +
 .../clientpositive/llap/llapdecider.q.out       |   20 +
 .../clientpositive/llap/load_dyn_part2.q.out    |    1 +
 .../clientpositive/llap/load_dyn_part3.q.out    |    1 +
 .../clientpositive/llap/lvj_mapjoin.q.out       |    2 +
 .../results/clientpositive/llap/mapjoin46.q.out |   10 +-
 .../clientpositive/llap/mapjoin_decimal.q.out   |    2 +
 .../clientpositive/llap/mapjoin_mapjoin.q.out   |    9 +
 .../llap/materialized_view_create_rewrite.q.out |    5 +
 .../materialized_view_create_rewrite_2.q.out    |    5 +
 .../materialized_view_create_rewrite_3.q.out    |   14 +
 .../materialized_view_create_rewrite_4.q.out    |   20 +
 .../materialized_view_create_rewrite_5.q.out    |   14 +
 ...materialized_view_create_rewrite_dummy.q.out |    5 +
 ...ized_view_create_rewrite_rebuild_dummy.q.out |   14 +
 ...alized_view_create_rewrite_time_window.q.out |    8 +
 .../llap/materialized_view_rewrite_1.q.out      |    5 +
 .../llap/materialized_view_rewrite_2.q.out      |    6 +
 .../llap/materialized_view_rewrite_3.q.out      |    5 +
 .../llap/materialized_view_rewrite_4.q.out      |    4 +
 .../llap/materialized_view_rewrite_5.q.out      |   11 +-
 .../llap/materialized_view_rewrite_6.q.out      |    8 +
 .../llap/materialized_view_rewrite_7.q.out      |   11 +
 .../llap/materialized_view_rewrite_8.q.out      |    5 +
 .../llap/materialized_view_rewrite_empty.q.out  |    1 +
 .../llap/materialized_view_rewrite_ssb.q.out    |   13 +
 .../llap/materialized_view_rewrite_ssb_2.q.out  |   13 +
 .../clientpositive/llap/metadataonly1.q.out     |    1 +
 .../test/results/clientpositive/llap/mrr.q.out  |    9 +
 .../clientpositive/llap/multiMapJoin1.q.out     |   29 +
 .../clientpositive/llap/multiMapJoin2.q.out     |   27 +
 .../clientpositive/llap/multi_column_in.q.out   |    3 +
 .../llap/multi_column_in_single.q.out           |    3 +
 .../clientpositive/llap/multi_insert.q.out      |    4 +
 .../clientpositive/llap/optimize_join_ptp.q.out |    2 +
 .../llap/orc_merge_incompat1.q.out              |    1 +
 .../llap/orc_struct_type_vectorization.q.out    |    1 +
 .../parquet_complex_types_vectorization.q.out   |    3 +
 .../llap/parquet_map_type_vectorization.q.out   |    1 +
 .../parquet_struct_type_vectorization.q.out     |    1 +
 .../clientpositive/llap/partialdhj.q.out        |    6 +
 .../llap/partition_multilevels.q.out            |    2 +
 .../clientpositive/llap/partition_pruning.q.out |    3 +
 .../llap/partition_shared_scan.q.out            |    5 +
 .../clientpositive/llap/ppd_union_view.q.out    |    6 +
 .../test/results/clientpositive/llap/ptf.q.out  |    5 +
 .../clientpositive/llap/ptf_matchpath.q.out     |    1 +
 .../clientpositive/llap/ptf_streaming.q.out     |    4 +
 .../clientpositive/llap/quotedid_smb.q.out      |    2 +
 .../llap/reduce_deduplicate.q.out               |    1 +
 .../llap/reduce_deduplicate_extended.q.out      |    8 +
 .../clientpositive/llap/results_cache_1.q.out   |    6 +
 .../clientpositive/llap/results_cache_2.q.out   |    4 +
 .../llap/results_cache_capacity.q.out           |    2 +
 .../llap/results_cache_empty_result.q.out       |    1 +
 .../llap/results_cache_invalidation.q.out       |    8 +
 .../llap/results_cache_invalidation2.q.out      |    3 +
 .../llap/results_cache_lifetime.q.out           |    2 +
 .../llap/results_cache_temptable.q.out          |    3 +
 .../llap/results_cache_transactional.q.out      |    6 +
 .../llap/retry_failure_stat_changes.q.out       |    8 +-
 .../clientpositive/llap/runtime_stats_hs2.q.out |   40 +-
 .../results/clientpositive/llap/sample1.q.out   |    1 +
 .../results/clientpositive/llap/sample10.q.out  |    1 +
 .../llap/selectDistinctStar.q.out               |    2 +
 .../results/clientpositive/llap/semijoin.q.out  |   38 +-
 .../results/clientpositive/llap/semijoin6.q.out |    8 +
 .../results/clientpositive/llap/semijoin7.q.out |    8 +
 .../clientpositive/llap/sharedworkext.q.out     |    4 +
 .../results/clientpositive/llap/skewjoin.q.out  |   19 +
 .../clientpositive/llap/skewjoinopt15.q.out     |    4 +
 .../results/clientpositive/llap/smb_cache.q.out |    4 +
 .../clientpositive/llap/smb_mapjoin_14.q.out    |   25 +
 .../clientpositive/llap/smb_mapjoin_15.q.out    |    8 +
 .../clientpositive/llap/smb_mapjoin_17.q.out    |    7 +
 .../clientpositive/llap/smb_mapjoin_18.q.out    |    3 +
 .../clientpositive/llap/smb_mapjoin_19.q.out    |    1 +
 .../clientpositive/llap/smb_mapjoin_4.q.out     |   12 +
 .../clientpositive/llap/smb_mapjoin_5.q.out     |   12 +
 .../clientpositive/llap/smb_mapjoin_6.q.out     |   11 +
 .../results/clientpositive/llap/stats11.q.out   |    4 +
 .../llap/stats_based_fetch_decision.q.out       |    4 +
 .../llap/stats_only_external.q.out              |    1 +
 .../clientpositive/llap/subquery_corr.q.out     |    6 +
 .../clientpositive/llap/subquery_exists.q.out   |    9 +
 .../clientpositive/llap/subquery_in.q.out       |   90 +-
 .../llap/subquery_in_having.q.out               |   33 +-
 .../clientpositive/llap/subquery_multi.q.out    |   98 +-
 .../clientpositive/llap/subquery_notin.q.out    |   57 +-
 .../clientpositive/llap/subquery_scalar.q.out   |   96 +-
 .../clientpositive/llap/subquery_select.q.out   |   54 +-
 .../clientpositive/llap/subquery_views.q.out    |    2 +
 .../llap/table_access_keys_stats.q.out          |    2 +-
 .../clientpositive/llap/temp_table.q.out        |    2 +
 .../llap/tez_bmj_schema_evolution.q.out         |    2 +
 .../llap/tez_dynpart_hashjoin_1.q.out           |   12 +
 .../llap/tez_dynpart_hashjoin_2.q.out           |    9 +
 .../llap/tez_input_counters.q.out               |    2 +
 .../results/clientpositive/llap/tez_join.q.out  |    2 +
 .../clientpositive/llap/tez_join_hash.q.out     |    6 +
 .../llap/tez_join_result_complex.q.out          |    4 +
 .../clientpositive/llap/tez_join_tests.q.out    |    4 +
 .../clientpositive/llap/tez_joins_explain.q.out |    4 +
 .../clientpositive/llap/tez_nway_join.q.out     |    6 +
 .../clientpositive/llap/tez_self_join.q.out     |    7 +-
 .../clientpositive/llap/tez_smb_empty.q.out     |   12 +
 .../clientpositive/llap/tez_smb_main.q.out      |   38 +
 .../results/clientpositive/llap/tez_union.q.out |   21 +
 .../llap/tez_union_group_by.q.out               |    5 +
 .../llap/tez_vector_dynpart_hashjoin_1.q.out    |   12 +
 .../llap/tez_vector_dynpart_hashjoin_2.q.out    |    9 +
 .../clientpositive/llap/unionDistinct_1.q.out   |   38 +
 .../clientpositive/llap/unionDistinct_3.q.out   |    2 +
 .../clientpositive/llap/union_top_level.q.out   |   14 +
 .../llap/vector_adaptor_usage_mode.q.out        |    2 +
 .../llap/vector_aggregate_without_gby.q.out     |    1 +
 .../llap/vector_annotate_stats_select.q.out     |    1 +
 .../llap/vector_auto_smb_mapjoin_14.q.out       |   29 +
 .../clientpositive/llap/vector_between_in.q.out |    8 +
 .../llap/vector_binary_join_groupby.q.out       |    4 +
 .../llap/vector_char_mapjoin1.q.out             |    6 +
 .../llap/vector_complex_join.q.out              |    6 +
 .../clientpositive/llap/vector_date_1.q.out     |    3 +
 .../llap/vector_decimal_cast.q.out              |    2 +
 .../llap/vector_decimal_expressions.q.out       |    2 +
 .../llap/vector_decimal_mapjoin.q.out           |   12 +
 .../llap/vector_decimal_math_funcs.q.out        |    2 +
 .../llap/vector_decimal_udf.q.out               |    8 +
 .../llap/vector_decimal_udf2.q.out              |    4 +
 .../clientpositive/llap/vector_elt.q.out        |    1 +
 .../llap/vector_groupby_grouping_sets4.q.out    |    3 +
 .../llap/vector_groupby_mapjoin.q.out           |    8 +-
 .../llap/vector_groupby_reduce.q.out            |    1 +
 .../clientpositive/llap/vector_if_expr.q.out    |    1 +
 .../clientpositive/llap/vector_inner_join.q.out |   18 +
 .../clientpositive/llap/vector_interval_2.q.out |    6 +
 .../llap/vector_interval_mapjoin.q.out          |    2 +
 .../clientpositive/llap/vector_join30.q.out     |    5 +
 .../llap/vector_leftsemi_mapjoin.q.out          |  128 ++
 .../llap/vector_llap_text_1.q.out               |    2 +
 .../llap/vector_mapjoin_reduce.q.out            |    6 +
 .../llap/vector_mr_diff_schema_alias.q.out      |    3 +
 .../llap/vector_nullsafe_join.q.out             |   12 +
 .../clientpositive/llap/vector_nvl.q.out        |    1 +
 .../llap/vector_orc_nested_column_pruning.q.out |   11 +
 .../llap/vector_outer_reference_windowed.q.out  |   12 +
 .../llap/vector_reduce_groupby_decimal.q.out    |    1 +
 .../vector_reduce_groupby_duplicate_cols.q.out  |    1 +
 .../llap/vector_reuse_scratchcols.q.out         |    2 +
 .../llap/vector_string_decimal.q.out            |    1 +
 .../clientpositive/llap/vector_struct_in.q.out  |    4 +
 .../clientpositive/llap/vector_udf2.q.out       |    2 +
 .../llap/vector_varchar_mapjoin1.q.out          |    6 +
 .../clientpositive/llap/vector_windowing.q.out  |    7 +
 .../llap/vector_windowing_gby.q.out             |    2 +
 .../llap/vector_windowing_gby2.q.out            |    2 +
 .../vector_windowing_multipartitioning.q.out    |    5 +
 .../llap/vector_windowing_navfn.q.out           |    2 +
 .../llap/vector_windowing_rank.q.out            |    6 +
 .../llap/vector_windowing_streaming.q.out       |    1 +
 .../clientpositive/llap/vectorization_0.q.out   |    6 +
 .../clientpositive/llap/vectorization_1.q.out   |    1 +
 .../clientpositive/llap/vectorization_10.q.out  |    1 +
 .../clientpositive/llap/vectorization_11.q.out  |    1 +
 .../clientpositive/llap/vectorization_12.q.out  |    1 +
 .../clientpositive/llap/vectorization_13.q.out  |    2 +
 .../clientpositive/llap/vectorization_14.q.out  |    1 +
 .../clientpositive/llap/vectorization_15.q.out  |    1 +
 .../clientpositive/llap/vectorization_16.q.out  |    1 +
 .../clientpositive/llap/vectorization_17.q.out  |    1 +
 .../clientpositive/llap/vectorization_2.q.out   |    1 +
 .../clientpositive/llap/vectorization_3.q.out   |    1 +
 .../clientpositive/llap/vectorization_4.q.out   |    1 +
 .../clientpositive/llap/vectorization_5.q.out   |    1 +
 .../clientpositive/llap/vectorization_6.q.out   |    1 +
 .../clientpositive/llap/vectorization_7.q.out   |    2 +
 .../clientpositive/llap/vectorization_8.q.out   |    2 +
 .../clientpositive/llap/vectorization_9.q.out   |    1 +
 .../llap/vectorization_decimal_date.q.out       |    1 +
 .../llap/vectorization_div0.q.out               |    3 +
 .../vectorization_input_format_excludes.q.out   |    6 +
 .../llap/vectorization_limit.q.out              |    3 +
 .../llap/vectorization_short_regress.q.out      |   12 +
 .../llap/vectorized_bucketmapjoin1.q.out        |    6 +
 .../clientpositive/llap/vectorized_case.q.out   |    4 +-
 .../clientpositive/llap/vectorized_casts.q.out  |    1 +
 .../llap/vectorized_context.q.out               |    3 +
 .../clientpositive/llap/vectorized_join46.q.out |    2 +
 .../llap/vectorized_mapjoin.q.out               |    2 +
 .../llap/vectorized_mapjoin3.q.out              |    3 +
 .../llap/vectorized_math_funcs.q.out            |    1 +
 .../llap/vectorized_multi_output_select.q.out   |    7 +-
 .../llap/vectorized_nested_mapjoin.q.out        |    3 +
 .../llap/vectorized_parquet.q.out               |    1 +
 .../clientpositive/llap/vectorized_ptf.q.out    |    5 +
 .../llap/vectorized_shufflejoin.q.out           |    2 +
 .../llap/vectorized_string_funcs.q.out          |    1 +
 .../llap/vectorized_timestamp.q.out             |    1 +
 .../llap/vectorized_timestamp_ints_casts.q.out  |    2 +
 .../clientpositive/llap/windowing_gby.q.out     |   30 +-
 .../clientpositive/load_dyn_part10.q.out        |    1 +
 .../clientpositive/load_dyn_part13.q.out        |    2 +
 .../results/clientpositive/load_dyn_part2.q.out |    1 +
 .../results/clientpositive/load_dyn_part3.q.out |    1 +
 .../results/clientpositive/load_dyn_part4.q.out |    1 +
 .../results/clientpositive/load_dyn_part9.q.out |    1 +
 .../clientpositive/louter_join_ppr.q.out        |    8 +
 .../test/results/clientpositive/mapjoin46.q.out |    2 +
 .../test/results/clientpositive/mapjoin47.q.out |    6 +
 .../clientpositive/mapjoin_distinct.q.out       |    8 +
 .../mapjoin_filter_on_outerjoin.q.out           |    6 +
 .../clientpositive/mapjoin_mapjoin.q.out        |    9 +
 .../clientpositive/mapjoin_memcheck.q.out       |    2 +
 .../clientpositive/mapjoin_subquery.q.out       |    6 +
 .../clientpositive/mapjoin_subquery2.q.out      |    3 +
 .../test/results/clientpositive/masking_1.q.out |    8 +
 .../results/clientpositive/masking_10.q.out     |    3 +
 .../results/clientpositive/masking_12.q.out     |    3 +
 .../clientpositive/masking_1_newdb.q.out        |    1 +
 .../test/results/clientpositive/masking_2.q.out |    6 +
 .../test/results/clientpositive/masking_3.q.out |    8 +
 .../test/results/clientpositive/masking_4.q.out |    3 +
 .../test/results/clientpositive/masking_6.q.out |    2 +
 .../test/results/clientpositive/masking_7.q.out |    2 +
 .../test/results/clientpositive/masking_9.q.out |    1 +
 .../clientpositive/masking_disablecbo_1.q.out   |    8 +
 .../clientpositive/masking_disablecbo_2.q.out   |    3 +
 .../clientpositive/masking_disablecbo_3.q.out   |   16 +
 .../clientpositive/masking_disablecbo_4.q.out   |    3 +
 ql/src/test/results/clientpositive/merge3.q.out |    2 +
 ql/src/test/results/clientpositive/merge4.q.out |    3 +
 .../merge_dynamic_partition.q.out               |    3 +
 .../merge_dynamic_partition2.q.out              |    1 +
 .../merge_dynamic_partition3.q.out              |    1 +
 .../merge_dynamic_partition4.q.out              |    1 +
 .../merge_dynamic_partition5.q.out              |    1 +
 .../results/clientpositive/merge_join_1.q.out   |    3 +
 .../results/clientpositive/mergejoins.q.out     |    8 +
 .../clientpositive/mergejoins_mixed.q.out       |   28 +
 .../clientpositive/multi_insert_gby.q.out       |    1 +
 ...i_insert_move_tasks_share_dependencies.q.out |    8 +
 .../clientpositive/multi_insert_union_src.q.out |    2 +
 .../multi_insert_with_join2.q.out               |   12 +
 .../clientpositive/multi_join_union.q.out       |    4 +
 .../clientpositive/named_column_join.q.out      |    2 +
 .../clientpositive/nested_column_pruning.q.out  |   11 +
 .../test/results/clientpositive/no_hooks.q.out  |    2 +
 .../results/clientpositive/noalias_subq1.q.out  |    1 +
 .../results/clientpositive/nonmr_fetch.q.out    |   11 +
 .../clientpositive/nonmr_fetch_threshold.q.out  |    3 +
 .../results/clientpositive/notable_alias1.q.out |    1 +
 .../results/clientpositive/notable_alias2.q.out |    1 +
 .../nullability_transitive_inference.q.out      |    2 +
 .../test/results/clientpositive/nullgroup.q.out |    4 +
 .../results/clientpositive/nullgroup2.q.out     |    4 +
 .../results/clientpositive/nullgroup4.q.out     |    4 +
 .../nullgroup4_multi_distinct.q.out             |    2 +
 .../results/clientpositive/nullgroup5.q.out     |    2 +
 .../clientpositive/orc_merge_incompat1.q.out    |    1 +
 .../orc_nested_column_pruning.q.out             |   11 +
 .../clientpositive/orc_ppd_str_conversion.q.out |    1 +
 .../orc_struct_type_vectorization.q.out         |    1 +
 .../results/clientpositive/outer_join_ppr.q.out |    4 +
 .../outer_reference_windowed.q.out              |    6 +
 .../results/clientpositive/parallel_join0.q.out |    4 +-
 .../results/clientpositive/parallel_join1.q.out |    2 +
 .../parquet_complex_types_vectorization.q.out   |    3 +
 .../results/clientpositive/parquet_join.q.out   |    5 +
 .../parquet_map_type_vectorization.q.out        |    1 +
 .../parquet_struct_type_vectorization.q.out     |    1 +
 .../parquet_vectorization_0.q.out               |    6 +
 .../parquet_vectorization_1.q.out               |    1 +
 .../parquet_vectorization_10.q.out              |    1 +
 .../parquet_vectorization_11.q.out              |    1 +
 .../parquet_vectorization_12.q.out              |    1 +
 .../parquet_vectorization_13.q.out              |    2 +
 .../parquet_vectorization_14.q.out              |    1 +
 .../parquet_vectorization_15.q.out              |    1 +
 .../parquet_vectorization_16.q.out              |    1 +
 .../parquet_vectorization_17.q.out              |    1 +
 .../parquet_vectorization_2.q.out               |    1 +
 .../parquet_vectorization_3.q.out               |    1 +
 .../parquet_vectorization_4.q.out               |    1 +
 .../parquet_vectorization_5.q.out               |    1 +
 .../parquet_vectorization_6.q.out               |    1 +
 .../parquet_vectorization_7.q.out               |    2 +
 .../parquet_vectorization_8.q.out               |    2 +
 .../parquet_vectorization_9.q.out               |    1 +
 .../parquet_vectorization_decimal_date.q.out    |    1 +
 .../parquet_vectorization_div0.q.out            |    2 +
 .../parquet_vectorization_limit.q.out           |    3 +
 .../parquet_vectorization_offset_limit.q.out    |    2 +
 .../clientpositive/partition_boolexpr.q.out     |    1 +
 .../partition_condition_remover.q.out           |    1 +
 .../partition_wise_fileformat2.q.out            |    2 +
 ql/src/test/results/clientpositive/pcr.q.out    |   22 +
 ql/src/test/results/clientpositive/pcs.q.out    |   12 +
 .../clientpositive/perf/spark/query1.q.out      |    6 +
 .../clientpositive/perf/spark/query10.q.out     |    9 +
 .../clientpositive/perf/spark/query11.q.out     |   12 +
 .../clientpositive/perf/spark/query12.q.out     |    3 +
 .../clientpositive/perf/spark/query13.q.out     |    6 +
 .../clientpositive/perf/spark/query15.q.out     |    4 +
 .../clientpositive/perf/spark/query16.q.out     |    6 +
 .../clientpositive/perf/spark/query17.q.out     |    8 +
 .../clientpositive/perf/spark/query18.q.out     |    7 +
 .../clientpositive/perf/spark/query19.q.out     |    6 +
 .../clientpositive/perf/spark/query2.q.out      |    8 +
 .../clientpositive/perf/spark/query20.q.out     |    3 +
 .../clientpositive/perf/spark/query21.q.out     |    4 +
 .../clientpositive/perf/spark/query22.q.out     |    4 +
 .../clientpositive/perf/spark/query23.q.out     |   20 +
 .../clientpositive/perf/spark/query24.q.out     |   12 +
 .../clientpositive/perf/spark/query25.q.out     |    8 +
 .../clientpositive/perf/spark/query26.q.out     |    5 +
 .../clientpositive/perf/spark/query27.q.out     |    5 +
 .../clientpositive/perf/spark/query28.q.out     |    6 +
 .../clientpositive/perf/spark/query29.q.out     |    8 +
 .../clientpositive/perf/spark/query3.q.out      |    3 +
 .../clientpositive/perf/spark/query30.q.out     |    8 +
 .../clientpositive/perf/spark/query31.q.out     |   18 +
 .../clientpositive/perf/spark/query32.q.out     |    5 +
 .../clientpositive/perf/spark/query33.q.out     |   10 +
 .../clientpositive/perf/spark/query34.q.out     |    5 +
 .../clientpositive/perf/spark/query35.q.out     |    9 +
 .../clientpositive/perf/spark/query36.q.out     |    4 +
 .../clientpositive/perf/spark/query37.q.out     |    4 +
 .../clientpositive/perf/spark/query38.q.out     |    8 +
 .../clientpositive/perf/spark/query39.q.out     |    8 +
 .../clientpositive/perf/spark/query4.q.out      |   18 +
 .../clientpositive/perf/spark/query40.q.out     |    5 +
 .../clientpositive/perf/spark/query42.q.out     |    3 +
 .../clientpositive/perf/spark/query43.q.out     |    3 +
 .../clientpositive/perf/spark/query44.q.out     |    5 +
 .../clientpositive/perf/spark/query45.q.out     |    7 +
 .../clientpositive/perf/spark/query46.q.out     |    7 +
 .../clientpositive/perf/spark/query47.q.out     |   12 +
 .../clientpositive/perf/spark/query48.q.out     |    5 +
 .../clientpositive/perf/spark/query49.q.out     |    7 +
 .../clientpositive/perf/spark/query5.q.out      |   12 +
 .../clientpositive/perf/spark/query50.q.out     |    5 +
 .../clientpositive/perf/spark/query51.q.out     |    4 +
 .../clientpositive/perf/spark/query52.q.out     |    3 +
 .../clientpositive/perf/spark/query53.q.out     |    4 +
 .../clientpositive/perf/spark/query54.q.out     |   12 +
 .../clientpositive/perf/spark/query55.q.out     |    3 +
 .../clientpositive/perf/spark/query56.q.out     |   10 +
 .../clientpositive/perf/spark/query57.q.out     |   12 +
 .../clientpositive/perf/spark/query58.q.out     |   18 +
 .../clientpositive/perf/spark/query59.q.out     |    8 +
 .../clientpositive/perf/spark/query6.q.out      |    8 +
 .../clientpositive/perf/spark/query60.q.out     |   10 +
 .../clientpositive/perf/spark/query61.q.out     |   13 +
 .../clientpositive/perf/spark/query63.q.out     |    4 +
 .../clientpositive/perf/spark/query65.q.out     |    6 +
 .../clientpositive/perf/spark/query66.q.out     |   10 +
 .../clientpositive/perf/spark/query67.q.out     |    4 +
 .../clientpositive/perf/spark/query68.q.out     |    7 +
 .../clientpositive/perf/spark/query69.q.out     |    9 +
 .../clientpositive/perf/spark/query7.q.out      |    5 +
 .../clientpositive/perf/spark/query70.q.out     |    6 +
 .../clientpositive/perf/spark/query71.q.out     |    7 +
 .../clientpositive/perf/spark/query72.q.out     |   10 +
 .../clientpositive/perf/spark/query73.q.out     |    5 +
 .../clientpositive/perf/spark/query74.q.out     |   12 +
 .../clientpositive/perf/spark/query75.q.out     |   16 +
 .../clientpositive/perf/spark/query76.q.out     |    9 +
 .../clientpositive/perf/spark/query77.q.out     |   15 +
 .../clientpositive/perf/spark/query78.q.out     |    5 +
 .../clientpositive/perf/spark/query79.q.out     |    5 +
 .../clientpositive/perf/spark/query8.q.out      |    6 +
 .../clientpositive/perf/spark/query80.q.out     |   17 +
 .../clientpositive/perf/spark/query81.q.out     |    8 +
 .../clientpositive/perf/spark/query82.q.out     |    4 +
 .../clientpositive/perf/spark/query83.q.out     |   15 +
 .../clientpositive/perf/spark/query84.q.out     |    6 +
 .../clientpositive/perf/spark/query85.q.out     |    8 +
 .../clientpositive/perf/spark/query86.q.out     |    3 +
 .../clientpositive/perf/spark/query87.q.out     |    7 +
 .../clientpositive/perf/spark/query88.q.out     |   32 +
 .../clientpositive/perf/spark/query89.q.out     |    4 +
 .../clientpositive/perf/spark/query9.q.out      |   16 +
 .../clientpositive/perf/spark/query90.q.out     |    8 +
 .../clientpositive/perf/spark/query91.q.out     |    7 +
 .../clientpositive/perf/spark/query92.q.out     |    5 +
 .../clientpositive/perf/spark/query93.q.out     |    3 +
 .../clientpositive/perf/spark/query94.q.out     |    6 +
 .../clientpositive/perf/spark/query95.q.out     |    9 +
 .../clientpositive/perf/spark/query96.q.out     |    4 +
 .../clientpositive/perf/spark/query97.q.out     |    4 +
 .../clientpositive/perf/spark/query98.q.out     |    3 +
 .../clientpositive/perf/spark/query99.q.out     |    5 +
 .../clientpositive/perf/tez/query1.q.out        |   76 +-
 .../clientpositive/perf/tez/query10.q.out       |  239 ++-
 .../clientpositive/perf/tez/query11.q.out       |  346 ++--
 .../clientpositive/perf/tez/query12.q.out       |   85 +-
 .../clientpositive/perf/tez/query13.q.out       |  145 +-
 .../clientpositive/perf/tez/query14.q.out       | 1466 ++++++++------
 .../clientpositive/perf/tez/query15.q.out       |   69 +-
 .../clientpositive/perf/tez/query16.q.out       |  151 +-
 .../clientpositive/perf/tez/query17.q.out       |  190 +-
 .../clientpositive/perf/tez/query18.q.out       |  201 +-
 .../clientpositive/perf/tez/query19.q.out       |  169 +-
 .../clientpositive/perf/tez/query2.q.out        |  181 +-
 .../clientpositive/perf/tez/query20.q.out       |   85 +-
 .../clientpositive/perf/tez/query21.q.out       |   42 +-
 .../clientpositive/perf/tez/query22.q.out       |   48 +-
 .../clientpositive/perf/tez/query23.q.out       |  554 +++--
 .../clientpositive/perf/tez/query24.q.out       |  311 ++-
 .../clientpositive/perf/tez/query25.q.out       |  191 +-
 .../clientpositive/perf/tez/query26.q.out       |  131 +-
 .../clientpositive/perf/tez/query27.q.out       |  131 +-
 .../clientpositive/perf/tez/query29.q.out       |  218 +-
 .../clientpositive/perf/tez/query3.q.out        |   77 +-
 .../clientpositive/perf/tez/query30.q.out       |   94 +-
 .../clientpositive/perf/tez/query31.q.out       |  486 +++--
 .../clientpositive/perf/tez/query32.q.out       |  125 +-
 .../clientpositive/perf/tez/query33.q.out       |  381 ++--
 .../clientpositive/perf/tez/query34.q.out       |  135 +-
 .../clientpositive/perf/tez/query35.q.out       |  239 ++-
 .../clientpositive/perf/tez/query36.q.out       |  113 +-
 .../clientpositive/perf/tez/query37.q.out       |  101 +-
 .../clientpositive/perf/tez/query38.q.out       |  223 +-
 .../clientpositive/perf/tez/query39.q.out       |   94 +-
 .../clientpositive/perf/tez/query4.q.out        |  499 +++--
 .../clientpositive/perf/tez/query40.q.out       |  103 +-
 .../clientpositive/perf/tez/query42.q.out       |   79 +-
 .../clientpositive/perf/tez/query43.q.out       |   77 +-
 .../clientpositive/perf/tez/query44.q.out       |  102 +-
 .../clientpositive/perf/tez/query45.q.out       |  159 +-
 .../clientpositive/perf/tez/query46.q.out       |  177 +-
 .../clientpositive/perf/tez/query47.q.out       |  121 +-
 .../clientpositive/perf/tez/query48.q.out       |  117 +-
 .../clientpositive/perf/tez/query49.q.out       |  261 ++-
 .../clientpositive/perf/tez/query5.q.out        |  326 +--
 .../clientpositive/perf/tez/query50.q.out       |  145 +-
 .../clientpositive/perf/tez/query51.q.out       |  118 +-
 .../clientpositive/perf/tez/query52.q.out       |   79 +-
 .../clientpositive/perf/tez/query53.q.out       |   99 +-
 .../clientpositive/perf/tez/query54.q.out       |  349 ++--
 .../clientpositive/perf/tez/query55.q.out       |   79 +-
 .../clientpositive/perf/tez/query56.q.out       |  381 ++--
 .../clientpositive/perf/tez/query57.q.out       |  121 +-
 .../clientpositive/perf/tez/query58.q.out       |  271 ++-
 .../clientpositive/perf/tez/query59.q.out       |  183 +-
 .../clientpositive/perf/tez/query6.q.out        |  213 +-
 .../clientpositive/perf/tez/query60.q.out       |  381 ++--
 .../clientpositive/perf/tez/query61.q.out       |  292 ++-
 .../clientpositive/perf/tez/query63.q.out       |   99 +-
 .../clientpositive/perf/tez/query64.q.out       |  675 +++++--
 .../clientpositive/perf/tez/query65.q.out       |  188 +-
 .../clientpositive/perf/tez/query66.q.out       |  254 ++-
 .../clientpositive/perf/tez/query67.q.out       |  115 +-
 .../clientpositive/perf/tez/query68.q.out       |  177 +-
 .../clientpositive/perf/tez/query69.q.out       |  245 ++-
 .../clientpositive/perf/tez/query7.q.out        |  131 +-
 .../clientpositive/perf/tez/query70.q.out       |  195 +-
 .../clientpositive/perf/tez/query71.q.out       |  213 +-
 .../clientpositive/perf/tez/query72.q.out       |  267 ++-
 .../clientpositive/perf/tez/query73.q.out       |  135 +-
 .../clientpositive/perf/tez/query74.q.out       |  354 ++--
 .../clientpositive/perf/tez/query75.q.out       |  565 ++++--
 .../clientpositive/perf/tez/query76.q.out       |  215 +-
 .../clientpositive/perf/tez/query77.q.out       |  339 ++--
 .../clientpositive/perf/tez/query78.q.out       |  187 +-
 .../clientpositive/perf/tez/query79.q.out       |  143 +-
 .../clientpositive/perf/tez/query8.q.out        |  165 +-
 .../clientpositive/perf/tez/query80.q.out       |  425 ++--
 .../clientpositive/perf/tez/query81.q.out       |   94 +-
 .../clientpositive/perf/tez/query82.q.out       |  101 +-
 .../clientpositive/perf/tez/query83.q.out       |  108 +-
 .../clientpositive/perf/tez/query84.q.out       |   56 +-
 .../clientpositive/perf/tez/query85.q.out       |  129 +-
 .../clientpositive/perf/tez/query86.q.out       |   87 +-
 .../clientpositive/perf/tez/query87.q.out       |  249 ++-
 .../clientpositive/perf/tez/query88.q.out       |  819 +++++---
 .../clientpositive/perf/tez/query89.q.out       |  103 +-
 .../clientpositive/perf/tez/query90.q.out       |  207 +-
 .../clientpositive/perf/tez/query91.q.out       |   74 +-
 .../clientpositive/perf/tez/query92.q.out       |  147 +-
 .../clientpositive/perf/tez/query93.q.out       |   81 +-
 .../clientpositive/perf/tez/query94.q.out       |  151 +-
 .../clientpositive/perf/tez/query95.q.out       |  246 ++-
 .../clientpositive/perf/tez/query96.q.out       |  105 +-
 .../clientpositive/perf/tez/query97.q.out       |   90 +-
 .../clientpositive/perf/tez/query98.q.out       |   83 +-
 .../clientpositive/perf/tez/query99.q.out       |  131 +-
 .../results/clientpositive/pointlookup.q.out    |    3 +
 .../results/clientpositive/pointlookup2.q.out   |   18 +
 .../results/clientpositive/pointlookup3.q.out   |   16 +
 .../results/clientpositive/pointlookup4.q.out   |    2 +
 ql/src/test/results/clientpositive/ppd1.q.out   |    2 +
 ql/src/test/results/clientpositive/ppd2.q.out   |    5 +
 .../results/clientpositive/ppd_clusterby.q.out  |    6 +
 .../test/results/clientpositive/ppd_gby.q.out   |    2 +
 .../test/results/clientpositive/ppd_gby2.q.out  |    2 +
 .../results/clientpositive/ppd_gby_join.q.out   |    4 +
 .../test/results/clientpositive/ppd_join.q.out  |    4 +
 .../test/results/clientpositive/ppd_join2.q.out |    6 +
 .../test/results/clientpositive/ppd_join3.q.out |    6 +
 .../test/results/clientpositive/ppd_join4.q.out |    2 +
 .../test/results/clientpositive/ppd_join5.q.out |    3 +
 .../clientpositive/ppd_join_filter.q.out        |    6 +
 .../clientpositive/ppd_multi_insert.q.out       |    4 +
 .../clientpositive/ppd_outer_join1.q.out        |    4 +
 .../clientpositive/ppd_outer_join2.q.out        |    4 +
 .../clientpositive/ppd_outer_join3.q.out        |    4 +
 .../clientpositive/ppd_outer_join4.q.out        |    6 +
 .../clientpositive/ppd_outer_join5.q.out        |    9 +
 .../results/clientpositive/ppd_random.q.out     |    4 +
 .../clientpositive/ppd_repeated_alias.q.out     |    9 +
 .../results/clientpositive/ppd_udf_case.q.out   |    4 +
 .../results/clientpositive/ppd_udf_col.q.out    |    4 +
 .../test/results/clientpositive/ppd_udtf.q.out  |    1 +
 .../test/results/clientpositive/ppd_union.q.out |    2 +
 ql/src/test/results/clientpositive/ppd_vc.q.out |    3 +
 .../results/clientpositive/ppd_windowing1.q.out |   18 +
 .../clientpositive/ppr_allchildsarenull.q.out   |    1 +
 .../results/clientpositive/ppr_pushdown3.q.out  |    1 +
 .../results/clientpositive/ptf_matchpath.q.out  |    1 +
 .../results/clientpositive/ptfgroupbyjoin.q.out |    4 +
 .../test/results/clientpositive/push_or.q.out   |    1 +
 .../query_result_fileformat.q.out               |    2 +
 ql/src/test/results/clientpositive/quote1.q.out |    2 +
 .../results/clientpositive/quotedid_basic.q.out |    4 +
 .../clientpositive/quotedid_partition.q.out     |    1 +
 .../results/clientpositive/quotedid_skew.q.out  |    2 +
 .../clientpositive/rand_partitionpruner3.q.out  |    1 +
 .../clientpositive/rcfile_null_value.q.out      |    2 +
 .../reduce_deduplicate_exclude_join.q.out       |    2 +
 .../reduce_deduplicate_extended2.q.out          |   12 +
 .../test/results/clientpositive/regex_col.q.out |    4 +
 .../clientpositive/remove_exprs_stats.q.out     |    9 +
 .../clientpositive/router_join_ppr.q.out        |    8 +
 .../test/results/clientpositive/row__id.q.out   |    1 +
 .../runtime_skewjoin_mapjoin_spark.q.out        |    8 +
 .../test/results/clientpositive/sample1.q.out   |    1 +
 .../test/results/clientpositive/sample7.q.out   |    1 +
 .../test/results/clientpositive/sample8.q.out   |    5 +
 .../clientpositive/select_column_pruning.q.out  |    1 +
 .../clientpositive/select_transform_hint.q.out  |    4 +
 .../clientpositive/select_unquote_and.q.out     |    1 +
 .../clientpositive/select_unquote_not.q.out     |    1 +
 .../clientpositive/select_unquote_or.q.out      |    1 +
 .../test/results/clientpositive/semijoin2.q.out |    4 +
 .../test/results/clientpositive/semijoin3.q.out |    2 +
 .../test/results/clientpositive/semijoin4.q.out |    4 +
 .../test/results/clientpositive/semijoin5.q.out |    4 +
 .../set_processor_namespaces.q.out              |    1 +
 .../clientpositive/set_variable_sub.q.out       |    3 +
 .../results/clientpositive/setop_subq.q.out     |    2 +
 .../test/results/clientpositive/skewjoin.q.out  |   19 +
 .../clientpositive/skewjoin_mapjoin1.q.out      |    4 +
 .../clientpositive/skewjoin_mapjoin10.q.out     |    4 +
 .../clientpositive/skewjoin_mapjoin11.q.out     |    2 +
 .../clientpositive/skewjoin_mapjoin2.q.out      |    2 +
 .../clientpositive/skewjoin_mapjoin3.q.out      |    2 +
 .../clientpositive/skewjoin_mapjoin4.q.out      |    3 +
 .../clientpositive/skewjoin_mapjoin5.q.out      |    5 +
 .../clientpositive/skewjoin_mapjoin6.q.out      |    2 +
 .../clientpositive/skewjoin_mapjoin7.q.out      |    4 +
 .../clientpositive/skewjoin_mapjoin8.q.out      |    3 +
 .../clientpositive/skewjoin_mapjoin9.q.out      |    3 +
 .../clientpositive/skewjoin_noskew.q.out        |    2 +
 .../clientpositive/skewjoin_onesideskew.q.out   |    2 +
 .../skewjoin_union_remove_1.q.out               |    4 +
 .../skewjoin_union_remove_2.q.out               |    3 +
 .../results/clientpositive/skewjoinopt1.q.out   |    4 +
 .../results/clientpositive/skewjoinopt10.q.out  |    2 +
 .../results/clientpositive/skewjoinopt11.q.out  |    4 +
 .../results/clientpositive/skewjoinopt12.q.out  |    2 +
 .../results/clientpositive/skewjoinopt13.q.out  |    3 +
 .../results/clientpositive/skewjoinopt14.q.out  |    3 +
 .../results/clientpositive/skewjoinopt16.q.out  |    2 +
 .../results/clientpositive/skewjoinopt17.q.out  |    4 +
 .../results/clientpositive/skewjoinopt18.q.out  |    2 +
 .../results/clientpositive/skewjoinopt19.q.out  |    2 +
 .../results/clientpositive/skewjoinopt2.q.out   |    4 +
 .../results/clientpositive/skewjoinopt20.q.out  |    2 +
 .../results/clientpositive/skewjoinopt21.q.out  |    2 +
 .../results/clientpositive/skewjoinopt3.q.out   |    2 +
 .../results/clientpositive/skewjoinopt4.q.out   |    4 +
 .../results/clientpositive/skewjoinopt5.q.out   |    2 +
 .../results/clientpositive/skewjoinopt6.q.out   |    2 +
 .../results/clientpositive/skewjoinopt7.q.out   |    3 +
 .../results/clientpositive/skewjoinopt8.q.out   |    3 +
 .../results/clientpositive/skewjoinopt9.q.out   |    5 +
 .../results/clientpositive/smb_mapjoin9.q.out   |    3 +
 .../results/clientpositive/smb_mapjoin_1.q.out  |    2 +
 .../results/clientpositive/smb_mapjoin_10.q.out |    1 +
 .../results/clientpositive/smb_mapjoin_11.q.out |    1 +
 .../results/clientpositive/smb_mapjoin_12.q.out |    2 +
 .../results/clientpositive/smb_mapjoin_13.q.out |    3 +
 .../results/clientpositive/smb_mapjoin_16.q.out |    1 +
 .../results/clientpositive/smb_mapjoin_2.q.out  |    2 +
 .../results/clientpositive/smb_mapjoin_20.q.out |    3 +
 .../results/clientpositive/smb_mapjoin_21.q.out |    6 +
 .../results/clientpositive/smb_mapjoin_25.q.out |    8 +
 .../results/clientpositive/smb_mapjoin_3.q.out  |    2 +
 .../results/clientpositive/smb_mapjoin_46.q.out |    1 +
 .../results/clientpositive/smb_mapjoin_47.q.out |    4 +
 .../clientpositive/sort_merge_join_desc_1.q.out |    1 +
 .../clientpositive/sort_merge_join_desc_2.q.out |    1 +
 .../clientpositive/sort_merge_join_desc_3.q.out |    1 +
 .../clientpositive/sort_merge_join_desc_4.q.out |    2 +
 .../clientpositive/sort_merge_join_desc_5.q.out |    1 +
 .../clientpositive/sort_merge_join_desc_6.q.out |    2 +
 .../clientpositive/sort_merge_join_desc_7.q.out |    2 +
 .../clientpositive/sort_merge_join_desc_8.q.out |    3 +
 .../spark/annotate_stats_join.q.out             |   19 +
 .../clientpositive/spark/auto_join0.q.out       |    2 +
 .../clientpositive/spark/auto_join1.q.out       |    2 +
 .../clientpositive/spark/auto_join10.q.out      |    2 +
 .../clientpositive/spark/auto_join11.q.out      |    2 +
 .../clientpositive/spark/auto_join12.q.out      |    3 +
 .../clientpositive/spark/auto_join13.q.out      |    3 +
 .../clientpositive/spark/auto_join14.q.out      |    2 +
 .../clientpositive/spark/auto_join15.q.out      |    2 +
 .../clientpositive/spark/auto_join16.q.out      |    2 +
 .../clientpositive/spark/auto_join17.q.out      |    2 +
 .../clientpositive/spark/auto_join19.q.out      |    2 +
 .../clientpositive/spark/auto_join2.q.out       |    3 +
 .../clientpositive/spark/auto_join20.q.out      |    4 +
 .../clientpositive/spark/auto_join21.q.out      |    1 +
 .../clientpositive/spark/auto_join22.q.out      |    3 +
 .../clientpositive/spark/auto_join23.q.out      |    2 +
 .../clientpositive/spark/auto_join24.q.out      |    2 +
 .../clientpositive/spark/auto_join26.q.out      |    2 +
 .../clientpositive/spark/auto_join27.q.out      |    3 +
 .../clientpositive/spark/auto_join28.q.out      |    6 +
 .../clientpositive/spark/auto_join29.q.out      |   19 +
 .../clientpositive/spark/auto_join3.q.out       |    3 +
 .../clientpositive/spark/auto_join30.q.out      |    5 +
 .../clientpositive/spark/auto_join32.q.out      |    5 +
 .../clientpositive/spark/auto_join4.q.out       |    2 +
 .../clientpositive/spark/auto_join5.q.out       |    2 +
 .../clientpositive/spark/auto_join6.q.out       |    2 +
 .../clientpositive/spark/auto_join7.q.out       |    3 +
 .../clientpositive/spark/auto_join8.q.out       |    2 +
 .../clientpositive/spark/auto_join9.q.out       |    2 +
 .../spark/auto_join_reordering_values.q.out     |    5 +
 .../clientpositive/spark/auto_join_stats.q.out  |    7 +
 .../clientpositive/spark/auto_join_stats2.q.out |    7 +
 .../spark/auto_join_without_localtask.q.out     |    8 +
 .../spark/auto_smb_mapjoin_14.q.out             |   14 +
 .../spark/auto_sortmerge_join_1.q.out           |    3 +
 .../spark/auto_sortmerge_join_12.q.out          |    3 +
 .../spark/auto_sortmerge_join_13.q.out          |    4 +
 .../spark/auto_sortmerge_join_16.q.out          |    4 +
 .../spark/auto_sortmerge_join_16.q.out_spark    |    4 +
 .../spark/auto_sortmerge_join_2.q.out           |    2 +
 .../spark/auto_sortmerge_join_3.q.out           |    3 +
 .../spark/auto_sortmerge_join_4.q.out           |    3 +
 .../spark/auto_sortmerge_join_5.q.out           |    3 +
 .../spark/auto_sortmerge_join_6.q.out           |   24 +
 .../spark/auto_sortmerge_join_7.q.out           |    3 +
 .../spark/auto_sortmerge_join_8.q.out           |    3 +
 .../spark/auto_sortmerge_join_9.q.out           |   26 +
 .../results/clientpositive/spark/bucket3.q.out  |    1 +
 .../spark/bucket_map_join_1.q.out               |    2 +
 .../spark/bucket_map_join_2.q.out               |    2 +
 .../spark/bucket_map_join_spark1.q.out          |    4 +
 .../spark/bucket_map_join_spark2.q.out          |    4 +
 .../spark/bucket_map_join_spark3.q.out          |    4 +
 .../spark/bucket_map_join_spark4.q.out          |    6 +
 .../spark/bucket_map_join_tez1.q.out            |   82 +
 .../spark/bucket_map_join_tez2.q.out            |   42 +
 .../clientpositive/spark/bucketmapjoin1.q.out   |    6 +
 .../clientpositive/spark/bucketmapjoin10.q.out  |    2 +
 .../clientpositive/spark/bucketmapjoin11.q.out  |    4 +
 .../clientpositive/spark/bucketmapjoin12.q.out  |    4 +
 .../clientpositive/spark/bucketmapjoin13.q.out  |    8 +
 .../clientpositive/spark/bucketmapjoin2.q.out   |    6 +
 .../clientpositive/spark/bucketmapjoin3.q.out   |    4 +
 .../clientpositive/spark/bucketmapjoin4.q.out   |    4 +
 .../clientpositive/spark/bucketmapjoin5.q.out   |    4 +
 .../clientpositive/spark/bucketmapjoin7.q.out   |    2 +
 .../spark/bucketmapjoin7.q.out_spark            |    2 +
 .../clientpositive/spark/bucketmapjoin8.q.out   |    4 +
 .../clientpositive/spark/bucketmapjoin9.q.out   |    4 +
 .../spark/bucketmapjoin_negative.q.out          |    2 +
 .../spark/bucketmapjoin_negative2.q.out         |    2 +
 .../spark/bucketmapjoin_negative3.q.out         |   18 +
 .../spark/bucketsortoptimize_insert_2.q.out     |    6 +
 .../spark/bucketsortoptimize_insert_4.q.out     |    4 +
 .../spark/bucketsortoptimize_insert_6.q.out     |   14 +
 .../spark/bucketsortoptimize_insert_7.q.out     |    3 +
 .../spark/bucketsortoptimize_insert_8.q.out     |    4 +
 .../spark/cbo_simple_select.q.out               |    6 +
 .../spark/column_access_stats.q.out             |    9 +
 .../spark/constprog_partitioner.q.out           |    4 +
 .../spark/constprog_semijoin.q.out              |   16 +
 .../clientpositive/spark/cross_join.q.out       |    4 +
 .../spark/cross_product_check_1.q.out           |    6 +
 .../spark/cross_product_check_2.q.out           |    6 +
 .../spark/dynamic_rdd_cache.q.out               |   10 +
 .../spark/filter_join_breaktask.q.out           |    3 +
 .../clientpositive/spark/groupby_map_ppr.q.out  |    1 +
 .../spark/groupby_map_ppr_multi_distinct.q.out  |    1 +
 .../spark/groupby_multi_single_reducer2.q.out   |    1 +
 .../spark/groupby_multi_single_reducer3.q.out   |    2 +
 .../clientpositive/spark/groupby_position.q.out |    3 +
 .../clientpositive/spark/groupby_ppr.q.out      |    1 +
 .../spark/groupby_ppr_multi_distinct.q.out      |    2 +
 .../spark/groupby_resolution.q.out              |    1 +
 .../spark/groupby_sort_1_23.q.out               |    5 +
 .../spark/groupby_sort_skew_1_23.q.out          |    5 +
 .../results/clientpositive/spark/having.q.out   |    2 +
 .../spark/identity_project_remove_skip.q.out    |    2 +
 .../spark/infer_bucket_sort_map_operators.q.out |    3 +
 .../spark/infer_bucket_sort_num_buckets.q.out   |    1 +
 .../clientpositive/spark/innerjoin.q.out        |    2 +
 .../results/clientpositive/spark/insert1.q.out  |    4 +
 .../clientpositive/spark/insert_into2.q.out     |    1 +
 .../results/clientpositive/spark/join0.q.out    |    2 +
 .../results/clientpositive/spark/join1.q.out    |    2 +
 .../results/clientpositive/spark/join10.q.out   |    2 +
 .../results/clientpositive/spark/join11.q.out   |    2 +
 .../results/clientpositive/spark/join12.q.out   |    3 +
 .../results/clientpositive/spark/join13.q.out   |    3 +
 .../results/clientpositive/spark/join14.q.out   |    2 +
 .../results/clientpositive/spark/join15.q.out   |    2 +
 .../results/clientpositive/spark/join16.q.out   |    2 +
 .../results/clientpositive/spark/join17.q.out   |    2 +
 .../results/clientpositive/spark/join19.q.out   |    6 +
 .../results/clientpositive/spark/join2.q.out    |    3 +
 .../results/clientpositive/spark/join20.q.out   |    4 +
 .../results/clientpositive/spark/join21.q.out   |    1 +
 .../results/clientpositive/spark/join22.q.out   |   23 +-
 .../results/clientpositive/spark/join23.q.out   |    2 +
 .../results/clientpositive/spark/join25.q.out   |    2 +
 .../results/clientpositive/spark/join26.q.out   |    3 +
 .../results/clientpositive/spark/join27.q.out   |    2 +
 .../results/clientpositive/spark/join28.q.out   |    3 +
 .../results/clientpositive/spark/join29.q.out   |    2 +
 .../results/clientpositive/spark/join3.q.out    |    3 +
 .../results/clientpositive/spark/join30.q.out   |    2 +
 .../results/clientpositive/spark/join31.q.out   |    2 +
 .../results/clientpositive/spark/join32.q.out   |    3 +
 .../clientpositive/spark/join32_lessSize.q.out  |   18 +
 .../results/clientpositive/spark/join33.q.out   |    3 +
 .../results/clientpositive/spark/join34.q.out   |    3 +
 .../results/clientpositive/spark/join35.q.out   |    3 +
 .../results/clientpositive/spark/join36.q.out   |    2 +
 .../results/clientpositive/spark/join37.q.out   |    2 +
 .../results/clientpositive/spark/join38.q.out   |    2 +
 .../results/clientpositive/spark/join39.q.out   |    1 +
 .../results/clientpositive/spark/join4.q.out    |    2 +
 .../results/clientpositive/spark/join40.q.out   |   10 +
 .../results/clientpositive/spark/join41.q.out   |    2 +
 .../results/clientpositive/spark/join5.q.out    |    2 +
 .../results/clientpositive/spark/join6.q.out    |    2 +
 .../results/clientpositive/spark/join7.q.out    |    3 +
 .../results/clientpositive/spark/join8.q.out    |    2 +
 .../results/clientpositive/spark/join9.q.out    |    2 +
 .../clientpositive/spark/join_alt_syntax.q.out  |   16 +
 .../spark/join_cond_pushdown_1.q.out            |   10 +
 .../spark/join_cond_pushdown_2.q.out            |    8 +
 .../spark/join_cond_pushdown_3.q.out            |   10 +
 .../spark/join_cond_pushdown_4.q.out            |    8 +
 .../spark/join_cond_pushdown_unqual1.q.out      |   10 +
 .../spark/join_cond_pushdown_unqual2.q.out      |    8 +
 .../spark/join_cond_pushdown_unqual3.q.out      |   10 +
 .../spark/join_cond_pushdown_unqual4.q.out      |    8 +
 .../spark/join_filters_overlap.q.out            |   11 +
 .../clientpositive/spark/join_hive_626.q.out    |    3 +
 .../clientpositive/spark/join_map_ppr.q.out     |    6 +
 .../spark/join_merge_multi_expressions.q.out    |    3 +
 .../clientpositive/spark/join_merging.q.out     |    3 +
 .../clientpositive/spark/join_nullsafe.q.out    |    8 +
 .../results/clientpositive/spark/join_rc.q.out  |    2 +
 .../clientpositive/spark/join_reorder.q.out     |    4 +
 .../clientpositive/spark/join_reorder2.q.out    |    8 +
 .../clientpositive/spark/join_reorder3.q.out    |    8 +
 .../clientpositive/spark/join_reorder4.q.out    |    9 +
 .../clientpositive/spark/join_star.q.out        |    8 +
 .../clientpositive/spark/join_thrift.q.out      |    2 +
 .../results/clientpositive/spark/join_vc.q.out  |    5 +
 .../clientpositive/spark/join_view.q.out        |    2 +
 .../clientpositive/spark/leftsemijoin.q.out     |    2 +
 .../spark/list_bucket_dml_2.q.out               |    2 +
 .../clientpositive/spark/load_dyn_part10.q.out  |    1 +
 .../clientpositive/spark/load_dyn_part13.q.out  |    2 +
 .../clientpositive/spark/load_dyn_part2.q.out   |    1 +
 .../clientpositive/spark/load_dyn_part3.q.out   |    1 +
 .../clientpositive/spark/load_dyn_part4.q.out   |    1 +
 .../clientpositive/spark/load_dyn_part9.q.out   |    1 +
 .../clientpositive/spark/louter_join_ppr.q.out  |    8 +
 .../clientpositive/spark/mapjoin_decimal.q.out  |    2 +
 .../clientpositive/spark/mapjoin_distinct.q.out |    8 +
 .../spark/mapjoin_filter_on_outerjoin.q.out     |    6 +
 .../clientpositive/spark/mapjoin_mapjoin.q.out  |    9 +
 .../clientpositive/spark/mapjoin_memcheck.q.out |    2 +
 .../clientpositive/spark/mapjoin_subquery.q.out |    6 +
 .../spark/mapjoin_subquery2.q.out               |    3 +
 .../clientpositive/spark/mergejoins.q.out       |    8 +
 .../clientpositive/spark/mergejoins_mixed.q.out |   28 +
 .../clientpositive/spark/multi_insert.q.out     |    4 +
 .../clientpositive/spark/multi_insert_gby.q.out |    1 +
 ...i_insert_move_tasks_share_dependencies.q.out |    8 +
 .../clientpositive/spark/multi_join_union.q.out |    4 +
 .../clientpositive/spark/nullgroup.q.out        |    4 +
 .../clientpositive/spark/nullgroup2.q.out       |    4 +
 .../clientpositive/spark/nullgroup4.q.out       |    4 +
 .../spark/nullgroup4_multi_distinct.q.out       |    2 +
 .../spark/orc_merge_incompat1.q.out             |    1 +
 .../clientpositive/spark/outer_join_ppr.q.out   |    4 +
 .../clientpositive/spark/parallel_join0.q.out   |    2 +
 .../clientpositive/spark/parallel_join1.q.out   |    2 +
 .../clientpositive/spark/parquet_join.q.out     |    5 +
 .../spark/parquet_vectorization_0.q.out         |    6 +
 .../spark/parquet_vectorization_1.q.out         |    1 +
 .../spark/parquet_vectorization_10.q.out        |    1 +
 .../spark/parquet_vectorization_11.q.out        |    1 +
 .../spark/parquet_vectorization_12.q.out        |    1 +
 .../spark/parquet_vectorization_13.q.out        |    2 +
 .../spark/parquet_vectorization_14.q.out        |    1 +
 .../spark/parquet_vectorization_15.q.out        |    1 +
 .../spark/parquet_vectorization_16.q.out        |    1 +
 .../spark/parquet_vectorization_17.q.out        |    1 +
 .../spark/parquet_vectorization_2.q.out         |    1 +
 .../spark/parquet_vectorization_3.q.out         |    1 +
 .../spark/parquet_vectorization_4.q.out         |    1 +
 .../spark/parquet_vectorization_5.q.out         |    1 +
 .../spark/parquet_vectorization_6.q.out         |    1 +
 .../spark/parquet_vectorization_7.q.out         |    2 +
 .../spark/parquet_vectorization_8.q.out         |    2 +
 .../spark/parquet_vectorization_9.q.out         |    1 +
 .../parquet_vectorization_decimal_date.q.out    |    1 +
 .../spark/parquet_vectorization_div0.q.out      |    2 +
 .../spark/parquet_vectorization_limit.q.out     |    3 +
 .../parquet_vectorization_offset_limit.q.out    |    2 +
 .../test/results/clientpositive/spark/pcr.q.out |   22 +
 .../clientpositive/spark/ppd_gby_join.q.out     |    4 +
 .../results/clientpositive/spark/ppd_join.q.out |    4 +
 .../clientpositive/spark/ppd_join2.q.out        |    6 +
 .../clientpositive/spark/ppd_join3.q.out        |    6 +
 .../clientpositive/spark/ppd_join4.q.out        |    2 +
 .../clientpositive/spark/ppd_join5.q.out        |    3 +
 .../clientpositive/spark/ppd_join_filter.q.out  |    6 +
 .../clientpositive/spark/ppd_multi_insert.q.out |    4 +
 .../clientpositive/spark/ppd_outer_join1.q.out  |    4 +
 .../clientpositive/spark/ppd_outer_join2.q.out  |    4 +
 .../clientpositive/spark/ppd_outer_join3.q.out  |    4 +
 .../clientpositive/spark/ppd_outer_join4.q.out  |    6 +
 .../clientpositive/spark/ppd_outer_join5.q.out  |    9 +
 .../test/results/clientpositive/spark/ptf.q.out |    5 +
 .../clientpositive/spark/ptf_matchpath.q.out    |    1 +
 .../clientpositive/spark/ptf_streaming.q.out    |    4 +
 .../clientpositive/spark/quotedid_smb.q.out     |    1 +
 .../spark/reduce_deduplicate.q.out              |    1 +
 .../spark/reduce_deduplicate_exclude_join.q.out |    2 +
 .../clientpositive/spark/router_join_ppr.q.out  |    8 +
 .../spark/runtime_skewjoin_mapjoin_spark.q.out  |    4 +
 .../results/clientpositive/spark/sample1.q.out  |    1 +
 .../results/clientpositive/spark/sample10.q.out |    1 +
 .../results/clientpositive/spark/sample7.q.out  |    1 +
 .../results/clientpositive/spark/sample8.q.out  |    5 +
 .../results/clientpositive/spark/semijoin.q.out |   35 +
 .../results/clientpositive/spark/skewjoin.q.out |   19 +
 .../clientpositive/spark/skewjoin_noskew.q.out  |    2 +
 .../spark/skewjoin_union_remove_1.q.out         |    4 +
 .../spark/skewjoin_union_remove_2.q.out         |    3 +
 .../clientpositive/spark/skewjoinopt1.q.out     |    4 +
 .../clientpositive/spark/skewjoinopt10.q.out    |    2 +
 .../clientpositive/spark/skewjoinopt11.q.out    |    2 +
 .../clientpositive/spark/skewjoinopt12.q.out    |    2 +
 .../clientpositive/spark/skewjoinopt13.q.out    |    3 +
 .../clientpositive/spark/skewjoinopt14.q.out    |    3 +
 .../clientpositive/spark/skewjoinopt15.q.out    |    4 +
 .../clientpositive/spark/skewjoinopt16.q.out    |    2 +
 .../clientpositive/spark/skewjoinopt17.q.out    |    4 +
 .../clientpositive/spark/skewjoinopt18.q.out    |    2 +
 .../clientpositive/spark/skewjoinopt19.q.out    |    2 +
 .../clientpositive/spark/skewjoinopt2.q.out     |    4 +
 .../clientpositive/spark/skewjoinopt20.q.out    |    2 +
 .../clientpositive/spark/skewjoinopt3.q.out     |    2 +
 .../clientpositive/spark/skewjoinopt4.q.out     |    4 +
 .../clientpositive/spark/skewjoinopt5.q.out     |    2 +
 .../clientpositive/spark/skewjoinopt6.q.out     |    2 +
 .../clientpositive/spark/skewjoinopt7.q.out     |    3 +
 .../clientpositive/spark/skewjoinopt8.q.out     |    3 +
 .../clientpositive/spark/skewjoinopt9.q.out     |    4 +
 .../clientpositive/spark/smb_mapjoin_1.q.out    |    2 +
 .../clientpositive/spark/smb_mapjoin_10.q.out   |    1 +
 .../clientpositive/spark/smb_mapjoin_11.q.out   |    1 +
 .../clientpositive/spark/smb_mapjoin_12.q.out   |    2 +
 .../clientpositive/spark/smb_mapjoin_13.q.out   |    3 +
 .../clientpositive/spark/smb_mapjoin_14.q.out   |   13 +
 .../clientpositive/spark/smb_mapjoin_15.q.out   |    5 +
 .../clientpositive/spark/smb_mapjoin_16.q.out   |    1 +
 .../clientpositive/spark/smb_mapjoin_17.q.out   |    7 +
 .../clientpositive/spark/smb_mapjoin_18.q.out   |    3 +
 .../clientpositive/spark/smb_mapjoin_19.q.out   |    1 +
 .../clientpositive/spark/smb_mapjoin_2.q.out    |    2 +
 .../clientpositive/spark/smb_mapjoin_20.q.out   |    3 +
 .../clientpositive/spark/smb_mapjoin_21.q.out   |    6 +
 .../clientpositive/spark/smb_mapjoin_25.q.out   |    8 +
 .../clientpositive/spark/smb_mapjoin_3.q.out    |    2 +
 .../clientpositive/spark/smb_mapjoin_4.q.out    |    4 +
 .../clientpositive/spark/smb_mapjoin_5.q.out    |    4 +
 .../clientpositive/spark/smb_mapjoin_6.q.out    |    5 +
 .../spark_dynamic_partition_pruning_3.q.out     |   17 +
 .../spark_dynamic_partition_pruning_4.q.out     |   27 +
 .../spark_dynamic_partition_pruning_5.q.out     |    7 +
 .../spark_dynamic_partition_pruning_6.q.out     |    4 +
 .../spark_dynamic_partition_pruning_7.q.out     |   10 +
 ...ic_partition_pruning_recursive_mapjoin.q.out |    4 +
 .../spark/spark_union_merge.q.out               |    4 +
 .../spark/spark_use_op_stats.q.out              |    6 +
 .../spark/spark_use_ts_stats_for_mapjoin.q.out  |   10 +
 .../results/clientpositive/spark/stats2.q.out   |    1 +
 .../clientpositive/spark/stats_noscan_2.q.out   |    1 +
 .../clientpositive/spark/subquery_exists.q.out  |    9 +
 .../clientpositive/spark/subquery_in.q.out      |   81 +
 .../clientpositive/spark/subquery_multi.q.out   |   55 +
 .../spark/subquery_multiinsert.q.out            |    6 +
 .../clientpositive/spark/subquery_notin.q.out   |   45 +
 .../clientpositive/spark/subquery_scalar.q.out  |   54 +
 .../clientpositive/spark/subquery_select.q.out  |   54 +-
 .../clientpositive/spark/subquery_views.q.out   |    5 +
 .../clientpositive/spark/temp_table.q.out       |    2 +
 .../clientpositive/spark/temp_table_join1.q.out |    6 +
 .../clientpositive/spark/transform_ppr2.q.out   |    1 +
 .../results/clientpositive/spark/union.q.out    |    2 +
 .../results/clientpositive/spark/union20.q.out  |    2 +
 .../results/clientpositive/spark/union22.q.out  |    3 +
 .../results/clientpositive/spark/union24.q.out  |   12 +
 .../results/clientpositive/spark/union25.q.out  |   25 +-
 .../results/clientpositive/spark/union26.q.out  |    3 +
 .../results/clientpositive/spark/union27.q.out  |    3 +
 .../results/clientpositive/spark/union32.q.out  |    8 +
 .../results/clientpositive/spark/union33.q.out  |    2 +
 .../results/clientpositive/spark/union34.q.out  |    4 +
 .../spark/union_lateralview.q.out               |    1 +
 .../clientpositive/spark/union_ppr.q.out        |  134 +-
 .../clientpositive/spark/union_remove_12.q.out  |    2 +
 .../clientpositive/spark/union_remove_13.q.out  |    2 +
 .../clientpositive/spark/union_remove_14.q.out  |    2 +
 .../clientpositive/spark/union_remove_19.q.out  |    2 +
 .../clientpositive/spark/union_remove_23.q.out  |    2 +
 .../clientpositive/spark/union_remove_25.q.out  |    2 +
 .../clientpositive/spark/union_top_level.q.out  |   14 +
 .../spark/vector_between_in.q.out               |    8 +
 .../spark/vector_decimal_mapjoin.q.out          |   12 +
 .../clientpositive/spark/vector_elt.q.out       |    1 +
 .../spark/vector_inner_join.q.out               |   18 +
 .../spark/vector_mapjoin_reduce.q.out           |    6 +
 .../clientpositive/spark/vectorization_0.q.out  |    6 +
 .../clientpositive/spark/vectorization_1.q.out  |    1 +
 .../clientpositive/spark/vectorization_10.q.out |    1 +
 .../clientpositive/spark/vectorization_11.q.out |    1 +
 .../clientpositive/spark/vectorization_12.q.out |    1 +
 .../clientpositive/spark/vectorization_13.q.out |    2 +
 .../clientpositive/spark/vectorization_14.q.out |    1 +
 .../clientpositive/spark/vectorization_15.q.out |    1 +
 .../clientpositive/spark/vectorization_16.q.out |    1 +
 .../clientpositive/spark/vectorization_17.q.out |    1 +
 .../clientpositive/spark/vectorization_2.q.out  |    1 +
 .../clientpositive/spark/vectorization_3.q.out  |    1 +
 .../clientpositive/spark/vectorization_4.q.out  |    1 +
 .../clientpositive/spark/vectorization_5.q.out  |    1 +
 .../clientpositive/spark/vectorization_6.q.out  |    1 +
 .../clientpositive/spark/vectorization_9.q.out  |    1 +
 .../spark/vectorization_decimal_date.q.out      |    1 +
 .../spark/vectorization_div0.q.out              |    3 +
 .../vectorization_input_format_excludes.q.out   |    6 +
 .../vectorization_parquet_projection.q.out      |    2 +
 .../spark/vectorization_short_regress.q.out     |   12 +
 .../clientpositive/spark/vectorized_case.q.out  |    4 +-
 .../spark/vectorized_mapjoin.q.out              |    2 +
 .../spark/vectorized_math_funcs.q.out           |    1 +
 .../spark/vectorized_nested_mapjoin.q.out       |    3 +
 .../clientpositive/spark/vectorized_ptf.q.out   |    5 +
 .../spark/vectorized_shufflejoin.q.out          |    2 +
 .../spark/vectorized_string_funcs.q.out         |    1 +
 .../special_character_in_tabnames_2.q.out       |    1 +
 .../stat_estimate_related_col.q.out             |   11 +
 ql/src/test/results/clientpositive/stats2.q.out |    1 +
 .../clientpositive/stats_empty_dyn_part.q.out   |    1 +
 .../clientpositive/stats_empty_partition2.q.out |    2 +
 .../results/clientpositive/stats_noscan_2.q.out |    1 +
 .../clientpositive/stats_partial_size.q.out     |    2 +
 .../results/clientpositive/stats_ppr_all.q.out  |    5 +
 .../test/results/clientpositive/structin.q.out  |    2 +
 ql/src/test/results/clientpositive/subq.q.out   |    1 +
 ql/src/test/results/clientpositive/subq2.q.out  |    1 +
 .../subq_where_serialization.q.out              |    2 +
 .../results/clientpositive/subquery_alias.q.out |    1 +
 .../clientpositive/subquery_exists.q.out        |    9 +
 .../clientpositive/subquery_exists_having.q.out |    4 +
 .../clientpositive/subquery_multiinsert.q.out   |    6 +
 .../clientpositive/subquery_notexists.q.out     |    5 +
 .../subquery_notexists_having.q.out             |    2 +
 .../clientpositive/subquery_notin_having.q.out  |    6 +
 .../subquery_unqual_corr_expr.q.out             |    3 +
 .../subquery_unqualcolumnrefs.q.out             |    8 +
 .../clientpositive/temp_table_join1.q.out       |    6 +
 .../clientpositive/tez/explainanalyze_1.q.out   |    8 +-
 .../clientpositive/tez/explainanalyze_4.q.out   |   12 +-
 .../clientpositive/tez/explainanalyze_5.q.out   |   18 +-
 .../tez/hybridgrace_hashjoin_1.q.out            |   20 +
 .../tez/hybridgrace_hashjoin_2.q.out            |   36 +
 .../tez/vector_non_string_partition.q.out       |    2 +
 .../clientpositive/timestamp_ints_casts.q.out   |    2 +
 .../results/clientpositive/transform_ppr2.q.out |    1 +
 .../truncate_column_list_bucket.q.out           |    2 +
 .../results/clientpositive/type_widening.q.out  |    4 +
 ql/src/test/results/clientpositive/udf1.q.out   |    1 +
 ql/src/test/results/clientpositive/udf9.q.out   |    1 +
 .../results/clientpositive/udf_10_trims.q.out   |    1 +
 .../results/clientpositive/udf_between.q.out    |    2 +
 .../udf_case_column_pruning.q.out               |    2 +
 .../clientpositive/udf_folder_constants.q.out   |    2 +
 .../test/results/clientpositive/udf_hour.q.out  |    1 +
 .../clientpositive/udf_isnull_isnotnull.q.out   |    1 +
 .../test/results/clientpositive/udf_like.q.out  |    1 +
 .../test/results/clientpositive/udf_lower.q.out |    1 +
 .../results/clientpositive/udf_minute.q.out     |    1 +
 .../results/clientpositive/udf_notequal.q.out   |    2 +
 .../results/clientpositive/udf_parse_url.q.out  |    1 +
 .../results/clientpositive/udf_second.q.out     |    1 +
 .../test/results/clientpositive/udf_size.q.out  |    1 +
 .../clientpositive/udf_to_unix_timestamp.q.out  |    2 +
 ql/src/test/results/clientpositive/union.q.out  |    2 +
 .../test/results/clientpositive/union20.q.out   |    2 +
 .../test/results/clientpositive/union22.q.out   |    5 +
 .../test/results/clientpositive/union24.q.out   |   12 +
 .../test/results/clientpositive/union25.q.out   |    3 +
 .../test/results/clientpositive/union26.q.out   |    3 +
 .../test/results/clientpositive/union27.q.out   |    3 +
 .../test/results/clientpositive/union32.q.out   |    8 +
 .../test/results/clientpositive/union33.q.out   |    2 +
 .../test/results/clientpositive/union34.q.out   |    4 +
 .../clientpositive/union_lateralview.q.out      |    1 +
 .../results/clientpositive/union_offcbo.q.out   |   12 +
 .../clientpositive/union_pos_alias.q.out        |    2 +
 .../test/results/clientpositive/union_ppr.q.out |    2 +
 .../clientpositive/union_remove_12.q.out        |    2 +
 .../clientpositive/union_remove_13.q.out        |    2 +
 .../clientpositive/union_remove_14.q.out        |    2 +
 .../clientpositive/union_remove_19.q.out        |    4 +
 .../clientpositive/union_remove_23.q.out        |    2 +
 .../clientpositive/union_remove_25.q.out        |    4 +
 .../clientpositive/unionall_unbalancedppd.q.out |    3 +
 .../clientpositive/updateBasicStats.q.out       |    8 +
 .../vector_aggregate_without_gby.q.out          |    1 +
 .../vector_binary_join_groupby.q.out            |    4 +
 .../clientpositive/vector_char_mapjoin1.q.out   |    6 +
 .../results/clientpositive/vector_date_1.q.out  |    3 +
 .../clientpositive/vector_decimal_cast.q.out    |    2 +
 .../vector_decimal_expressions.q.out            |    2 +
 .../clientpositive/vector_decimal_mapjoin.q.out |   12 +
 .../vector_decimal_math_funcs.q.out             |    2 +
 .../clientpositive/vector_decimal_udf2.q.out    |    4 +
 .../results/clientpositive/vector_elt.q.out     |    1 +
 .../clientpositive/vector_groupby_reduce.q.out  |    1 +
 .../results/clientpositive/vector_if_expr.q.out |    1 +
 .../vector_interval_mapjoin.q.out               |    2 +
 .../vector_join_part_col_char.q.out             |    2 +
 .../vector_mr_diff_schema_alias.q.out           |    3 +
 .../vector_non_constant_in_expr.q.out           |    1 +
 .../vector_non_string_partition.q.out           |    2 +
 .../results/clientpositive/vector_nvl.q.out     |    1 +
 .../vector_reduce_groupby_decimal.q.out         |    1 +
 .../vector_reduce_groupby_duplicate_cols.q.out  |    1 +
 .../clientpositive/vector_struct_in.q.out       |    4 +
 .../vector_varchar_mapjoin1.q.out               |    6 +
 .../clientpositive/vectorization_1.q.out        |    1 +
 .../clientpositive/vectorization_10.q.out       |    1 +
 .../clientpositive/vectorization_11.q.out       |    1 +
 .../clientpositive/vectorization_12.q.out       |    1 +
 .../clientpositive/vectorization_13.q.out       |    2 +
 .../clientpositive/vectorization_14.q.out       |    1 +
 .../clientpositive/vectorization_15.q.out       |    1 +
 .../clientpositive/vectorization_16.q.out       |    1 +
 .../clientpositive/vectorization_17.q.out       |    1 +
 .../clientpositive/vectorization_2.q.out        |    1 +
 .../clientpositive/vectorization_3.q.out        |    1 +
 .../clientpositive/vectorization_4.q.out        |    1 +
 .../clientpositive/vectorization_5.q.out        |    1 +
 .../clientpositive/vectorization_6.q.out        |    1 +
 .../clientpositive/vectorization_7.q.out        |    2 +
 .../clientpositive/vectorization_8.q.out        |    2 +
 .../clientpositive/vectorization_9.q.out        |    1 +
 .../vectorization_decimal_date.q.out            |    1 +
 .../clientpositive/vectorization_limit.q.out    |    3 +
 .../vectorization_numeric_overflows.q.out       |   10 +
 .../vectorization_offset_limit.q.out            |    2 +
 .../vectorization_parquet_projection.q.out      |    2 +
 .../vectorized_bucketmapjoin1.q.out             |    3 +
 .../clientpositive/vectorized_case.q.out        |    2 +
 .../clientpositive/vectorized_casts.q.out       |    1 +
 .../clientpositive/vectorized_context.q.out     |    3 +
 .../clientpositive/vectorized_mapjoin.q.out     |    2 +
 .../clientpositive/vectorized_mapjoin2.q.out    |    2 +
 .../clientpositive/vectorized_mapjoin3.q.out    |    3 +
 .../clientpositive/vectorized_math_funcs.q.out  |    1 +
 .../clientpositive/vectorized_shufflejoin.q.out |    2 +
 .../vectorized_string_funcs.q.out               |    1 +
 .../clientpositive/vectorized_timestamp.q.out   |    1 +
 .../vectorized_timestamp_ints_casts.q.out       |    2 +
 .../results/clientpositive/windowing_gby2.q.out |    2 +
 .../clientpositive/windowing_navfn.q.out        |    1 +
 1527 files changed, 22016 insertions(+), 8750 deletions(-)
----------------------------------------------------------------------