> On Nov. 17, 2015, 12:08 a.m., Ashutosh Chauhan wrote:
> > ql/src/test/results/clientpositive/rand_partitionpruner3.q.out, lines 
> > 280-282
> > <https://reviews.apache.org/r/40359/diff/1/?file=1127111#file1127111line280>
> >
> >     Incorrect result.

The test case is testing if Partition pruning logic takes out non-deterministic 
functions from experessions.
If you disable CBO & disable PPD you will get a different result that with 
CBO=false, PPD=true.

This is because random(1)<0.1 is non deterministic.
With this patch, CBO first performs partition pruning and then applies col 
pruning.
Col Pruning introduces a select on top of TS below filter. Hence the difference 
in result.

This is not a real issue


- John


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


On Nov. 16, 2015, 6:54 p.m., John Pullokkaran wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/40359/
> -----------------------------------------------------------
> 
> (Updated Nov. 16, 2015, 6:54 p.m.)
> 
> 
> Review request for hive, Ashutosh Chauhan, Hari Sankar Sivarama Subramaniyan, 
> and Jesús Camacho Rodríguez.
> 
> 
> Bugs: HIVE-11110
>     https://issues.apache.org/jira/browse/HIVE-11110
> 
> 
> Repository: hive-git
> 
> 
> Description
> -------
> 
> HIVE-11110 Introduces not null filters, improves filter selectivity 
> estimation, Streamlines pre-join order optimizations
> 
> 
> Diffs
> -----
> 
>   hbase-handler/src/test/results/positive/hbase_queries.q.out d044c7e 
>   
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveCalciteUtil.java 
> e1b60b0 
>   
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/RelOptHiveTable.java 
> cce3588 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/TraitsUtil.java 
> be28828 
>   
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveProject.java
>  4b7887a 
>   
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HivePreFilteringRule.java
>  82d9600 
>   
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/stats/FilterSelectivityEstimator.java
>  b52779c 
>   
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/translator/SqlFunctionConverter.java
>  a17fb94 
>   
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/stats/annotation/StatsRulesProcFactory.java
>  a8ff158 
>   ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java de67b54 
>   ql/src/java/org/apache/hadoop/hive/ql/plan/ExprNodeDescUtils.java e291a48 
>   ql/src/test/queries/clientpositive/special_character_in_tabnames_1.q 
> 7867ae1 
>   ql/src/test/results/clientnegative/bucket_mapjoin_mismatch1.q.out 623c2e8 
>   ql/src/test/results/clientnegative/sortmerge_mapjoin_mismatch_1.q.out 
> b2a7d89 
>   ql/src/test/results/clientpositive/allcolref_in_udf.q.out 216b037 
>   ql/src/test/results/clientpositive/ambiguous_col.q.out 7f04e89 
>   ql/src/test/results/clientpositive/annotate_stats_deep_filters.q.out 
> 20ccda5 
>   ql/src/test/results/clientpositive/annotate_stats_join.q.out ee05e6e 
>   ql/src/test/results/clientpositive/annotate_stats_join_pkfk.q.out aa380b2 
>   ql/src/test/results/clientpositive/auto_join1.q.out 48ad641 
>   ql/src/test/results/clientpositive/auto_join10.q.out fa6f62d 
>   ql/src/test/results/clientpositive/auto_join12.q.out 7d8db0a 
>   ql/src/test/results/clientpositive/auto_join13.q.out 952dbf8 
>   ql/src/test/results/clientpositive/auto_join15.q.out 8e4b24c 
>   ql/src/test/results/clientpositive/auto_join16.q.out 1bad0f9 
>   ql/src/test/results/clientpositive/auto_join17.q.out e85cae8 
>   ql/src/test/results/clientpositive/auto_join19.q.out 8a57cb0 
>   ql/src/test/results/clientpositive/auto_join2.q.out abfc611 
>   ql/src/test/results/clientpositive/auto_join22.q.out bdee886 
>   ql/src/test/results/clientpositive/auto_join24.q.out 5b57303 
>   ql/src/test/results/clientpositive/auto_join26.q.out 94ab76f 
>   ql/src/test/results/clientpositive/auto_join3.q.out d015449 
>   ql/src/test/results/clientpositive/auto_join30.q.out 5437b7f 
>   ql/src/test/results/clientpositive/auto_join33.q.out 0dcd91d 
>   ql/src/test/results/clientpositive/auto_join4.q.out dbbee56 
>   ql/src/test/results/clientpositive/auto_join5.q.out 3209d07 
>   ql/src/test/results/clientpositive/auto_join8.q.out 2ca26aa 
>   ql/src/test/results/clientpositive/auto_join9.q.out 13dd5de 
>   ql/src/test/results/clientpositive/auto_join_reordering_values.q.out 
> f42b45e 
>   ql/src/test/results/clientpositive/auto_join_stats.q.out d75d6c4 
>   ql/src/test/results/clientpositive/auto_join_stats2.q.out a0aefa3 
>   ql/src/test/results/clientpositive/auto_join_without_localtask.q.out 
> 3d0067b 
>   ql/src/test/results/clientpositive/auto_smb_mapjoin_14.q.out 1dc9cd0 
>   ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out f1aadef 
>   ql/src/test/results/clientpositive/auto_sortmerge_join_11.q.out 5dad0fb 
>   ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out b1ba148 
>   ql/src/test/results/clientpositive/auto_sortmerge_join_13.q.out c26e40c 
>   ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out a7a5faa 
>   ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out dfb1a16 
>   ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out 013bc07 
>   ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out d751e70 
>   ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out 853f641 
>   ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out e2d797b 
>   ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out e3bb51d 
>   ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out bbfa756 
>   ql/src/test/results/clientpositive/bucket_map_join_spark1.q.out 870ecdd 
>   ql/src/test/results/clientpositive/bucket_map_join_spark2.q.out 33f5c46 
>   ql/src/test/results/clientpositive/bucket_map_join_spark3.q.out 067d1ff 
>   ql/src/test/results/clientpositive/bucket_map_join_spark4.q.out 41a2ea9 
>   ql/src/test/results/clientpositive/bucketcontext_1.q.out f06303c 
>   ql/src/test/results/clientpositive/bucketcontext_2.q.out 6426515 
>   ql/src/test/results/clientpositive/bucketcontext_3.q.out b13538d 
>   ql/src/test/results/clientpositive/bucketcontext_4.q.out b1fa288 
>   ql/src/test/results/clientpositive/bucketcontext_5.q.out 3e1c49f 
>   ql/src/test/results/clientpositive/bucketcontext_6.q.out 8d7392a 
>   ql/src/test/results/clientpositive/bucketcontext_7.q.out 0159995 
>   ql/src/test/results/clientpositive/bucketcontext_8.q.out b42088a 
>   ql/src/test/results/clientpositive/bucketmapjoin1.q.out 438b991 
>   ql/src/test/results/clientpositive/bucketmapjoin10.q.out 38de15b 
>   ql/src/test/results/clientpositive/bucketmapjoin11.q.out cf79f7b 
>   ql/src/test/results/clientpositive/bucketmapjoin12.q.out 575a9d1 
>   ql/src/test/results/clientpositive/bucketmapjoin13.q.out f06f5a4 
>   ql/src/test/results/clientpositive/bucketmapjoin2.q.out aa33415 
>   ql/src/test/results/clientpositive/bucketmapjoin3.q.out f49b3cd 
>   ql/src/test/results/clientpositive/bucketmapjoin4.q.out 348725c 
>   ql/src/test/results/clientpositive/bucketmapjoin5.q.out 6c4ebb3 
>   ql/src/test/results/clientpositive/bucketmapjoin7.q.out 56b156e 
>   ql/src/test/results/clientpositive/bucketmapjoin8.q.out 426a3e8 
>   ql/src/test/results/clientpositive/bucketmapjoin9.q.out 50ce9c9 
>   ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out dcee44f 
>   ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out 25e70ea 
>   ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out 318c0dd 
>   ql/src/test/results/clientpositive/bucketpruning1.q.out d11239f 
>   ql/src/test/results/clientpositive/bucketsortoptimize_insert_2.q.out 
> 0e44631 
>   ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out 
> 594dc55 
>   ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out 
> 5626efd 
>   ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out 
> a937fb4 
>   ql/src/test/results/clientpositive/bucketsortoptimize_insert_7.q.out 
> 9f530e8 
>   ql/src/test/results/clientpositive/bucketsortoptimize_insert_8.q.out 
> 2b2e7bf 
>   ql/src/test/results/clientpositive/cbo_rp_annotate_stats_groupby.q.out 
> b47a3b3 
>   ql/src/test/results/clientpositive/cbo_rp_auto_join1.q.out 6537a8a 
>   ql/src/test/results/clientpositive/cbo_rp_auto_join17.q.out 351699d 
>   ql/src/test/results/clientpositive/cbo_rp_cross_product_check_2.q.out 
> d31c896 
>   ql/src/test/results/clientpositive/column_access_stats.q.out e904347 
>   ql/src/test/results/clientpositive/constprog_partitioner.q.out e22a4a9 
>   ql/src/test/results/clientpositive/correlationoptimizer1.q.out c5c9d9c 
>   ql/src/test/results/clientpositive/correlationoptimizer10.q.out 90fb6f4 
>   ql/src/test/results/clientpositive/correlationoptimizer11.q.out 4e65fa5 
>   ql/src/test/results/clientpositive/correlationoptimizer12.q.out a541950 
>   ql/src/test/results/clientpositive/correlationoptimizer13.q.out d652d87 
>   ql/src/test/results/clientpositive/correlationoptimizer14.q.out bce3100 
>   ql/src/test/results/clientpositive/correlationoptimizer15.q.out 43ba27d 
>   ql/src/test/results/clientpositive/correlationoptimizer2.q.out 96c7660 
>   ql/src/test/results/clientpositive/correlationoptimizer3.q.out 8510b50 
>   ql/src/test/results/clientpositive/correlationoptimizer4.q.out 95ed861 
>   ql/src/test/results/clientpositive/correlationoptimizer5.q.out 7f2e19f 
>   ql/src/test/results/clientpositive/correlationoptimizer6.q.out 2d72250 
>   ql/src/test/results/clientpositive/correlationoptimizer7.q.out 6514c4a 
>   ql/src/test/results/clientpositive/correlationoptimizer8.q.out 97b79e2 
>   ql/src/test/results/clientpositive/correlationoptimizer9.q.out e00860d 
>   ql/src/test/results/clientpositive/cross_join.q.out c543007 
>   ql/src/test/results/clientpositive/cross_product_check_1.q.out 3ab418a 
>   ql/src/test/results/clientpositive/cross_product_check_2.q.out 6910b40 
>   ql/src/test/results/clientpositive/decimal_join2.q.out a3ca231 
>   ql/src/test/results/clientpositive/decimal_udf.q.out abbfc50 
>   
> ql/src/test/results/clientpositive/encrypted/encryption_join_unencrypted_tbl.q.out
>  5dd927d 
>   ql/src/test/results/clientpositive/explain_logical.q.out 8fa0a4c 
>   ql/src/test/results/clientpositive/filter_cond_pushdown.q.out 99eb3f7 
>   ql/src/test/results/clientpositive/filter_join_breaktask.q.out dee3794 
>   ql/src/test/results/clientpositive/flatten_and_or.q.out 9c51ff3 
>   ql/src/test/results/clientpositive/groupby_join_pushdown.q.out 17df98f 
>   ql/src/test/results/clientpositive/groupby_multi_single_reducer3.q.out 
> ca66c67 
>   ql/src/test/results/clientpositive/groupby_position.q.out 3472134 
>   ql/src/test/results/clientpositive/groupby_sort_1_23.q.out d0644f8 
>   ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out a0c7cc0 
>   ql/src/test/results/clientpositive/having2.q.out 699d8ee 
>   ql/src/test/results/clientpositive/identity_project_remove_skip.q.out 
> 168f9d0 
>   ql/src/test/results/clientpositive/index_auto_mult_tables.q.out 2639edf 
>   ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out 
> 1aa82ba 
>   ql/src/test/results/clientpositive/index_auto_self_join.q.out e8c23dc 
>   ql/src/test/results/clientpositive/index_bitmap3.q.out 7d7f955 
>   ql/src/test/results/clientpositive/index_bitmap_auto.q.out d4a9777 
>   ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out 
> 3df629e 
>   ql/src/test/results/clientpositive/index_bitmap_compression.q.out 37a2944 
>   ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out 
> df30554 
>   ql/src/test/results/clientpositive/innerjoin.q.out 91bb7b3 
>   ql/src/test/results/clientpositive/input39.q.out 66d8573 
>   ql/src/test/results/clientpositive/input42.q.out 2974159 
>   ql/src/test/results/clientpositive/input_part9.q.out d95fee4 
>   ql/src/test/results/clientpositive/input_testxpath2.q.out 67e270f 
>   ql/src/test/results/clientpositive/input_testxpath4.q.out 4aea350 
>   ql/src/test/results/clientpositive/join1.q.out 9ce2646 
>   ql/src/test/results/clientpositive/join10.q.out 6309059 
>   ql/src/test/results/clientpositive/join12.q.out bdb5496 
>   ql/src/test/results/clientpositive/join13.q.out 3b921b9 
>   ql/src/test/results/clientpositive/join15.q.out 474e85f 
>   ql/src/test/results/clientpositive/join16.q.out a5e9f76 
>   ql/src/test/results/clientpositive/join17.q.out 26aabcf 
>   ql/src/test/results/clientpositive/join2.q.out d59aed2 
>   ql/src/test/results/clientpositive/join22.q.out d7fc7ae 
>   ql/src/test/results/clientpositive/join25.q.out 1824863 
>   ql/src/test/results/clientpositive/join26.q.out 866d8cc 
>   ql/src/test/results/clientpositive/join27.q.out 2495de0 
>   ql/src/test/results/clientpositive/join28.q.out d748495 
>   ql/src/test/results/clientpositive/join29.q.out 15d0cbe 
>   ql/src/test/results/clientpositive/join3.q.out 7bb713f 
>   ql/src/test/results/clientpositive/join30.q.out c7b7918 
>   ql/src/test/results/clientpositive/join31.q.out 70ca814 
>   ql/src/test/results/clientpositive/join32.q.out afb373d 
>   ql/src/test/results/clientpositive/join32_lessSize.q.out 5ea4024 
>   ql/src/test/results/clientpositive/join33.q.out afb373d 
>   ql/src/test/results/clientpositive/join34.q.out ffdf5a5 
>   ql/src/test/results/clientpositive/join35.q.out 228524c 
>   ql/src/test/results/clientpositive/join36.q.out 15ce9f1 
>   ql/src/test/results/clientpositive/join37.q.out 60b8747 
>   ql/src/test/results/clientpositive/join40.q.out 3b0d24f 
>   ql/src/test/results/clientpositive/join42.q.out 9fdf673 
>   ql/src/test/results/clientpositive/join43.q.out f22a9b8 
>   ql/src/test/results/clientpositive/join8.q.out 6ff3e33 
>   ql/src/test/results/clientpositive/join9.q.out 8421036 
>   ql/src/test/results/clientpositive/join_alt_syntax.q.out d119ab5 
>   ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out d565c7f 
>   ql/src/test/results/clientpositive/join_cond_pushdown_2.q.out 55c37e4 
>   ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out 9077fc0 
>   ql/src/test/results/clientpositive/join_cond_pushdown_4.q.out 55e7678 
>   ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out c1c2105 
>   ql/src/test/results/clientpositive/join_cond_pushdown_unqual2.q.out 8c22a2c 
>   ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out b0258b8 
>   ql/src/test/results/clientpositive/join_cond_pushdown_unqual4.q.out 26db67e 
>   ql/src/test/results/clientpositive/join_map_ppr.q.out 024afc0 
>   ql/src/test/results/clientpositive/join_merge_multi_expressions.q.out 
> b73643e 
>   ql/src/test/results/clientpositive/join_nullsafe.q.out b6557a2 
>   ql/src/test/results/clientpositive/join_on_varchar.q.out 7d0f551 
>   ql/src/test/results/clientpositive/join_parse.q.out e1a23a0 
>   ql/src/test/results/clientpositive/join_rc.q.out 0c932b4 
>   ql/src/test/results/clientpositive/join_reorder.q.out a9723fa 
>   ql/src/test/results/clientpositive/join_star.q.out a75b48d 
>   ql/src/test/results/clientpositive/join_thrift.q.out b70d44f 
>   ql/src/test/results/clientpositive/join_vc.q.out c0f11e7 
>   ql/src/test/results/clientpositive/lateral_view_cp.q.out 412595e 
>   ql/src/test/results/clientpositive/limit_pushdown.q.out 40f6a48 
>   ql/src/test/results/clientpositive/limit_pushdown_negative.q.out 2b6fb89 
>   ql/src/test/results/clientpositive/lineage3.q.out fb5e9df 
>   ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out 
> 7f32108 
>   ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out 
> d46b0ae 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_tez1.q.out 1f1bf3d 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out 68d1253 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out 
> 7b428bc 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_pruning_2.q.out 
> cec4219 
>   ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_1.q.out 
> 36a032a 
>   ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_2.q.out 
> 423a76a 
>   ql/src/test/results/clientpositive/llap/lvj_mapjoin.q.out 03c2ebd 
>   ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out 4c8b295 
>   ql/src/test/results/clientpositive/llap/mrr.q.out 7026cd4 
>   ql/src/test/results/clientpositive/llap/tez_bmj_schema_evolution.q.out 
> 4d3b13d 
>   ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_1.q.out 
> 15cd967 
>   ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_2.q.out 
> 04e5e75 
>   ql/src/test/results/clientpositive/llap/tez_join_hash.q.out 921397a 
>   ql/src/test/results/clientpositive/llap/tez_join_result_complex.q.out 
> 0ad18ed 
>   ql/src/test/results/clientpositive/llap/tez_self_join.q.out f7922c9 
>   ql/src/test/results/clientpositive/llap/tez_smb_1.q.out 8e7078f 
>   ql/src/test/results/clientpositive/llap/tez_smb_main.q.out b9aad00 
>   ql/src/test/results/clientpositive/llap/tez_union.q.out b60779a 
>   ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out 
> 7a57435 
>   ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_2.q.out 
> 50fcff7 
>   
> ql/src/test/results/clientpositive/llap/vectorized_dynamic_partition_pruning.q.out
>  e9192a3 
>   ql/src/test/results/clientpositive/llap_uncompressed.q.out 73e6729 
>   ql/src/test/results/clientpositive/louter_join_ppr.q.out 65fe291 
>   ql/src/test/results/clientpositive/mapjoin_distinct.q.out 4df25ca 
>   ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out 427e8b2 
>   ql/src/test/results/clientpositive/mapjoin_memcheck.q.out 4b134f2 
>   ql/src/test/results/clientpositive/mapjoin_subquery.q.out 1f7a5f4 
>   ql/src/test/results/clientpositive/mergejoin.q.out cb96ab3 
>   ql/src/test/results/clientpositive/mergejoins.q.out 37761b7 
>   ql/src/test/results/clientpositive/metadataonly1.q.out bb8bdfa 
>   ql/src/test/results/clientpositive/multiMapJoin1.q.out 8548fc7 
>   ql/src/test/results/clientpositive/multiMapJoin2.q.out 46b717f 
>   ql/src/test/results/clientpositive/multi_join_union.q.out 466f34b 
>   ql/src/test/results/clientpositive/nonmr_fetch.q.out d8c6da6 
>   ql/src/test/results/clientpositive/orc_llap.q.out 79c6281 
>   ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out 6a528dd 
>   ql/src/test/results/clientpositive/parallel_join1.q.out 9ce2646 
>   ql/src/test/results/clientpositive/parquet_join.q.out f880d1d 
>   ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out 980b65b 
>   ql/src/test/results/clientpositive/pcr.q.out 7ba9f87 
>   ql/src/test/results/clientpositive/pcs.q.out 5cf0dff 
>   ql/src/test/results/clientpositive/pointlookup.q.out a99b388 
>   ql/src/test/results/clientpositive/pointlookup2.q.out d677327 
>   ql/src/test/results/clientpositive/pointlookup3.q.out 4cb3cba 
>   ql/src/test/results/clientpositive/pointlookup4.q.out 157aea6 
>   ql/src/test/results/clientpositive/ppd_gby.q.out 6f8ee53 
>   ql/src/test/results/clientpositive/ppd_gby2.q.out 5fbe70f 
>   ql/src/test/results/clientpositive/ppd_gby_join.q.out e3f71e7 
>   ql/src/test/results/clientpositive/ppd_join.q.out 58c4e43 
>   ql/src/test/results/clientpositive/ppd_join2.q.out e99839e 
>   ql/src/test/results/clientpositive/ppd_join3.q.out f2b0b60 
>   ql/src/test/results/clientpositive/ppd_join_filter.q.out b50d936 
>   ql/src/test/results/clientpositive/ppd_multi_insert.q.out 83a7820 
>   ql/src/test/results/clientpositive/ppd_outer_join2.q.out d965d5b 
>   ql/src/test/results/clientpositive/ppd_outer_join3.q.out f1fbbd6 
>   ql/src/test/results/clientpositive/ppd_outer_join4.q.out 9997166 
>   ql/src/test/results/clientpositive/ppd_random.q.out ff9a812 
>   ql/src/test/results/clientpositive/ppd_udf_case.q.out ddf1abd 
>   ql/src/test/results/clientpositive/ppd_udf_col.q.out 7c963fb 
>   ql/src/test/results/clientpositive/ppd_union.q.out 166eff1 
>   ql/src/test/results/clientpositive/ppd_vc.q.out 5f36399 
>   ql/src/test/results/clientpositive/ptf.q.out 9d34e4e 
>   ql/src/test/results/clientpositive/ptf_streaming.q.out b4101ea 
>   ql/src/test/results/clientpositive/quotedid_basic.q.out 50c83a8 
>   ql/src/test/results/clientpositive/quotedid_partition.q.out bc52c82 
>   ql/src/test/results/clientpositive/rand_partitionpruner1.q.out 3d8e9b8 
>   ql/src/test/results/clientpositive/rand_partitionpruner2.q.out 88edd07 
>   ql/src/test/results/clientpositive/rand_partitionpruner3.q.out 634e171 
>   ql/src/test/results/clientpositive/reduce_deduplicate_exclude_join.q.out 
> bc1eeb3 
>   ql/src/test/results/clientpositive/reduce_deduplicate_extended.q.out 
> e3ebee7 
>   ql/src/test/results/clientpositive/regex_col.q.out 16f8f88 
>   ql/src/test/results/clientpositive/router_join_ppr.q.out 4d3f81d 
>   ql/src/test/results/clientpositive/runtime_skewjoin_mapjoin_spark.q.out 
> cdd5fd9 
>   ql/src/test/results/clientpositive/sample8.q.out 7801edf 
>   ql/src/test/results/clientpositive/select_transform_hint.q.out 43b1ada 
>   ql/src/test/results/clientpositive/semijoin.q.out 0df96c0 
>   ql/src/test/results/clientpositive/skewjoin.q.out 22a9421 
>   ql/src/test/results/clientpositive/skewjoin_mapjoin10.q.out ca966c2 
>   ql/src/test/results/clientpositive/skewjoin_mapjoin6.q.out ec9fae1 
>   ql/src/test/results/clientpositive/skewjoin_noskew.q.out 24e07c2 
>   ql/src/test/results/clientpositive/skewjoin_onesideskew.q.out 95a2260 
>   ql/src/test/results/clientpositive/skewjoinopt10.q.out 7655cf3 
>   ql/src/test/results/clientpositive/skewjoinopt15.q.out dbf68f1 
>   ql/src/test/results/clientpositive/skewjoinopt18.q.out 7c1a2da 
>   ql/src/test/results/clientpositive/smb_mapjoin9.q.out 14f913b 
>   ql/src/test/results/clientpositive/smb_mapjoin_1.q.out 9ab334b 
>   ql/src/test/results/clientpositive/smb_mapjoin_10.q.out ea2fa51 
>   ql/src/test/results/clientpositive/smb_mapjoin_11.q.out 7b54dbe 
>   ql/src/test/results/clientpositive/smb_mapjoin_12.q.out 777ff8a 
>   ql/src/test/results/clientpositive/smb_mapjoin_13.q.out 1eaea87 
>   ql/src/test/results/clientpositive/smb_mapjoin_14.q.out 28e62d2 
>   ql/src/test/results/clientpositive/smb_mapjoin_15.q.out 64a3ea2 
>   ql/src/test/results/clientpositive/smb_mapjoin_16.q.out 6c78ee5 
>   ql/src/test/results/clientpositive/smb_mapjoin_17.q.out 740f2df 
>   ql/src/test/results/clientpositive/smb_mapjoin_2.q.out 379dc0d 
>   ql/src/test/results/clientpositive/smb_mapjoin_3.q.out 26fa5d4 
>   ql/src/test/results/clientpositive/smb_mapjoin_4.q.out 9fc7f93 
>   ql/src/test/results/clientpositive/smb_mapjoin_6.q.out 5e128a3 
>   ql/src/test/results/clientpositive/sort_merge_join_desc_2.q.out 398e711 
>   ql/src/test/results/clientpositive/sort_merge_join_desc_3.q.out dc449fd 
>   ql/src/test/results/clientpositive/sort_merge_join_desc_4.q.out 09b9622 
>   ql/src/test/results/clientpositive/sort_merge_join_desc_5.q.out 259d0b3 
>   ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out aa4e1bf 
>   ql/src/test/results/clientpositive/sort_merge_join_desc_7.q.out 863a4d1 
>   ql/src/test/results/clientpositive/sort_merge_join_desc_8.q.out d9c8cdc 
>   ql/src/test/results/clientpositive/spark/annotate_stats_join.q.out 9cbc411 
>   ql/src/test/results/clientpositive/spark/auto_join1.q.out d26a33e 
>   ql/src/test/results/clientpositive/spark/auto_join10.q.out b43e55c 
>   ql/src/test/results/clientpositive/spark/auto_join12.q.out 1f480bb 
>   ql/src/test/results/clientpositive/spark/auto_join13.q.out 0ffe9e3 
>   ql/src/test/results/clientpositive/spark/auto_join15.q.out 5b1234f 
>   ql/src/test/results/clientpositive/spark/auto_join16.q.out 5c4bbb3 
>   ql/src/test/results/clientpositive/spark/auto_join17.q.out bc492c9 
>   ql/src/test/results/clientpositive/spark/auto_join18.q.out 349e76d 
>   ql/src/test/results/clientpositive/spark/auto_join19.q.out 9e4fb8f 
>   ql/src/test/results/clientpositive/spark/auto_join2.q.out 2424cca 
>   ql/src/test/results/clientpositive/spark/auto_join22.q.out 29a9093 
>   ql/src/test/results/clientpositive/spark/auto_join24.q.out c714e19 
>   ql/src/test/results/clientpositive/spark/auto_join26.q.out 3c437a1 
>   ql/src/test/results/clientpositive/spark/auto_join3.q.out 54e24f3 
>   ql/src/test/results/clientpositive/spark/auto_join30.q.out 4b67445 
>   ql/src/test/results/clientpositive/spark/auto_join32.q.out 679dd79 
>   ql/src/test/results/clientpositive/spark/auto_join8.q.out 21374ff 
>   ql/src/test/results/clientpositive/spark/auto_join9.q.out 568891b 
>   ql/src/test/results/clientpositive/spark/auto_join_reordering_values.q.out 
> 9df55b9 
>   ql/src/test/results/clientpositive/spark/auto_join_stats.q.out d72b4f3 
>   ql/src/test/results/clientpositive/spark/auto_join_stats2.q.out 480f784 
>   ql/src/test/results/clientpositive/spark/auto_join_without_localtask.q.out 
> a234ff5 
>   ql/src/test/results/clientpositive/spark/auto_smb_mapjoin_14.q.out 714d098 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_1.q.out 
> 6bf47d9 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_12.q.out 
> 197b132 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_13.q.out 
> 7eadcd0 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_2.q.out 
> 4643533 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_3.q.out 
> 23530bd 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_4.q.out 
> b6f6f84 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_5.q.out 
> a3e9e26 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_6.q.out 
> 9d072c7 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_7.q.out 
> e0aa444 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_8.q.out 
> 8171558 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_9.q.out 
> 81b4ce2 
>   ql/src/test/results/clientpositive/spark/bucket_map_join_spark1.q.out 
> 6230bef 
>   ql/src/test/results/clientpositive/spark/bucket_map_join_spark2.q.out 
> 1a33625 
>   ql/src/test/results/clientpositive/spark/bucket_map_join_spark3.q.out 
> fed923c 
>   ql/src/test/results/clientpositive/spark/bucket_map_join_spark4.q.out 
> be46c92 
>   ql/src/test/results/clientpositive/spark/bucket_map_join_tez1.q.out 2c14065 
>   ql/src/test/results/clientpositive/spark/bucket_map_join_tez2.q.out 33e6d63 
>   ql/src/test/results/clientpositive/spark/bucketmapjoin1.q.out b2b93fb 
>   ql/src/test/results/clientpositive/spark/bucketmapjoin10.q.out d7d7d40 
>   ql/src/test/results/clientpositive/spark/bucketmapjoin11.q.out dfdff5c 
>   ql/src/test/results/clientpositive/spark/bucketmapjoin12.q.out 07f3c15 
>   ql/src/test/results/clientpositive/spark/bucketmapjoin13.q.out 1d6e64c 
>   ql/src/test/results/clientpositive/spark/bucketmapjoin2.q.out d82480e 
>   ql/src/test/results/clientpositive/spark/bucketmapjoin3.q.out 39552c1 
>   ql/src/test/results/clientpositive/spark/bucketmapjoin4.q.out ad2762d 
>   ql/src/test/results/clientpositive/spark/bucketmapjoin5.q.out f7c3d4d 
>   ql/src/test/results/clientpositive/spark/bucketmapjoin7.q.out a99cb74 
>   ql/src/test/results/clientpositive/spark/bucketmapjoin8.q.out d6c42b5 
>   ql/src/test/results/clientpositive/spark/bucketmapjoin9.q.out e65e689 
>   ql/src/test/results/clientpositive/spark/bucketmapjoin_negative.q.out 
> 031c46c 
>   ql/src/test/results/clientpositive/spark/bucketmapjoin_negative2.q.out 
> 4a8f46d 
>   ql/src/test/results/clientpositive/spark/bucketmapjoin_negative3.q.out 
> 3671564 
>   ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_2.q.out 
> bcef03c 
>   ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_4.q.out 
> f3c8f04 
>   ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_6.q.out 
> 25f61b8 
>   ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_7.q.out 
> 2b919a0 
>   ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_8.q.out 
> dade75c 
>   ql/src/test/results/clientpositive/spark/column_access_stats.q.out 869d6cb 
>   ql/src/test/results/clientpositive/spark/constprog_partitioner.q.out 
> 3a3a751 
>   ql/src/test/results/clientpositive/spark/cross_join.q.out af49a79 
>   ql/src/test/results/clientpositive/spark/cross_product_check_1.q.out 
> c228f0b 
>   ql/src/test/results/clientpositive/spark/cross_product_check_2.q.out 
> ab062ad 
>   ql/src/test/results/clientpositive/spark/filter_join_breaktask.q.out 
> 216e43b 
>   
> ql/src/test/results/clientpositive/spark/groupby_multi_single_reducer3.q.out 
> f87308f 
>   ql/src/test/results/clientpositive/spark/groupby_position.q.out 99223b9 
>   ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out 8d3f0d8 
>   ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out 
> 1e01b37 
>   ql/src/test/results/clientpositive/spark/identity_project_remove_skip.q.out 
> 654cb1b 
>   ql/src/test/results/clientpositive/spark/index_auto_self_join.q.out c965455 
>   ql/src/test/results/clientpositive/spark/index_bitmap3.q.out 60202f0 
>   ql/src/test/results/clientpositive/spark/index_bitmap_auto.q.out 5f7513f 
>   
> ql/src/test/results/clientpositive/spark/infer_bucket_sort_map_operators.q.out
>  9b284e7 
>   
> ql/src/test/results/clientpositive/spark/infer_bucket_sort_reducers_power_two.q.out
>  15b7992 
>   ql/src/test/results/clientpositive/spark/innerjoin.q.out 762ddad 
>   ql/src/test/results/clientpositive/spark/join1.q.out 4714f11 
>   ql/src/test/results/clientpositive/spark/join10.q.out 8d18683 
>   ql/src/test/results/clientpositive/spark/join12.q.out 38b450e 
>   ql/src/test/results/clientpositive/spark/join13.q.out 4a045f7 
>   ql/src/test/results/clientpositive/spark/join15.q.out d93ef60 
>   ql/src/test/results/clientpositive/spark/join16.q.out aecd953 
>   ql/src/test/results/clientpositive/spark/join17.q.out 4aefeb3 
>   ql/src/test/results/clientpositive/spark/join18.q.out e11ecec 
>   ql/src/test/results/clientpositive/spark/join2.q.out aca15cf 
>   ql/src/test/results/clientpositive/spark/join22.q.out dfbb714 
>   ql/src/test/results/clientpositive/spark/join25.q.out ddc7172 
>   ql/src/test/results/clientpositive/spark/join26.q.out e4d26b2 
>   ql/src/test/results/clientpositive/spark/join27.q.out b525e2c 
>   ql/src/test/results/clientpositive/spark/join28.q.out a8177f3 
>   ql/src/test/results/clientpositive/spark/join29.q.out 9479dd1 
>   ql/src/test/results/clientpositive/spark/join3.q.out 9c7119e 
>   ql/src/test/results/clientpositive/spark/join30.q.out 098b73f 
>   ql/src/test/results/clientpositive/spark/join31.q.out 469a19f 
>   ql/src/test/results/clientpositive/spark/join32.q.out 1c1c103 
>   ql/src/test/results/clientpositive/spark/join32_lessSize.q.out 937e8fc 
>   ql/src/test/results/clientpositive/spark/join33.q.out 1c1c103 
>   ql/src/test/results/clientpositive/spark/join34.q.out 01b9242 
>   ql/src/test/results/clientpositive/spark/join35.q.out 8ccffc8 
>   ql/src/test/results/clientpositive/spark/join36.q.out 0bca73a 
>   ql/src/test/results/clientpositive/spark/join37.q.out 115592f 
>   ql/src/test/results/clientpositive/spark/join40.q.out 02c11cd 
>   ql/src/test/results/clientpositive/spark/join8.q.out 1e9dd28 
>   ql/src/test/results/clientpositive/spark/join9.q.out c7440da 
>   ql/src/test/results/clientpositive/spark/join_alt_syntax.q.out a68321f 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_1.q.out fe2da0e 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_2.q.out 5f572b0 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_3.q.out c0bdd80 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_4.q.out ddc6812 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual1.q.out 
> 5a77830 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual2.q.out 
> 12bac14 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual3.q.out 
> 180787b 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual4.q.out 
> e16884c 
>   ql/src/test/results/clientpositive/spark/join_map_ppr.q.out 086a05a 
>   ql/src/test/results/clientpositive/spark/join_merge_multi_expressions.q.out 
> a18d82e 
>   ql/src/test/results/clientpositive/spark/join_nullsafe.q.out c9e7a5c 
>   ql/src/test/results/clientpositive/spark/join_rc.q.out 98c5c02 
>   ql/src/test/results/clientpositive/spark/join_reorder.q.out 8b1a835 
>   ql/src/test/results/clientpositive/spark/join_star.q.out 69c2fd7 
>   ql/src/test/results/clientpositive/spark/join_thrift.q.out 1402673 
>   ql/src/test/results/clientpositive/spark/join_vc.q.out 27265a6 
>   ql/src/test/results/clientpositive/spark/limit_pushdown.q.out b0e6c6a 
>   ql/src/test/results/clientpositive/spark/louter_join_ppr.q.out 4639b28 
>   ql/src/test/results/clientpositive/spark/mapjoin_decimal.q.out bc785f9 
>   ql/src/test/results/clientpositive/spark/mapjoin_distinct.q.out 662fdaf 
>   ql/src/test/results/clientpositive/spark/mapjoin_mapjoin.q.out 27d2509 
>   ql/src/test/results/clientpositive/spark/mapjoin_memcheck.q.out 14f316c 
>   ql/src/test/results/clientpositive/spark/mapjoin_subquery.q.out d74b7d0 
>   ql/src/test/results/clientpositive/spark/mergejoins.q.out d203376 
>   ql/src/test/results/clientpositive/spark/multi_join_union.q.out ee9f9ca 
>   ql/src/test/results/clientpositive/spark/parallel_join1.q.out 47555b2 
>   ql/src/test/results/clientpositive/spark/parquet_join.q.out 390aeb1 
>   ql/src/test/results/clientpositive/spark/pcr.q.out 3ee6e22 
>   ql/src/test/results/clientpositive/spark/ppd_gby_join.q.out 306292a 
>   ql/src/test/results/clientpositive/spark/ppd_join.q.out aee7630 
>   ql/src/test/results/clientpositive/spark/ppd_join2.q.out b4c7f23 
>   ql/src/test/results/clientpositive/spark/ppd_join3.q.out c9f6762 
>   ql/src/test/results/clientpositive/spark/ppd_join_filter.q.out f9a107b 
>   ql/src/test/results/clientpositive/spark/ppd_multi_insert.q.out 5c8cc5d 
>   ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out eaafd7e 
>   ql/src/test/results/clientpositive/spark/ppd_outer_join3.q.out 2cb969f 
>   ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out 16acc67 
>   ql/src/test/results/clientpositive/spark/ptf.q.out 6beeaf4 
>   ql/src/test/results/clientpositive/spark/ptf_streaming.q.out ddf5555 
>   
> ql/src/test/results/clientpositive/spark/reduce_deduplicate_exclude_join.q.out
>  be70e98 
>   ql/src/test/results/clientpositive/spark/router_join_ppr.q.out 6e34865 
>   
> ql/src/test/results/clientpositive/spark/runtime_skewjoin_mapjoin_spark.q.out 
> c21f53b 
>   ql/src/test/results/clientpositive/spark/sample8.q.out bc1b934 
>   ql/src/test/results/clientpositive/spark/semijoin.q.out 1f6aac2 
>   ql/src/test/results/clientpositive/spark/skewjoin.q.out 828a64f 
>   ql/src/test/results/clientpositive/spark/skewjoin_noskew.q.out 4025885 
>   ql/src/test/results/clientpositive/spark/skewjoinopt10.q.out ad558db 
>   ql/src/test/results/clientpositive/spark/skewjoinopt15.q.out f7fbf25 
>   ql/src/test/results/clientpositive/spark/skewjoinopt18.q.out fb218ec 
>   ql/src/test/results/clientpositive/spark/smb_mapjoin_1.q.out 1ff1262 
>   ql/src/test/results/clientpositive/spark/smb_mapjoin_10.q.out cadf08e 
>   ql/src/test/results/clientpositive/spark/smb_mapjoin_11.q.out 4d912ca 
>   ql/src/test/results/clientpositive/spark/smb_mapjoin_12.q.out eeb18b0 
>   ql/src/test/results/clientpositive/spark/smb_mapjoin_13.q.out 73856eb 
>   ql/src/test/results/clientpositive/spark/smb_mapjoin_14.q.out b39d0b6 
>   ql/src/test/results/clientpositive/spark/smb_mapjoin_15.q.out afb1b22 
>   ql/src/test/results/clientpositive/spark/smb_mapjoin_16.q.out 9ce40bd 
>   ql/src/test/results/clientpositive/spark/smb_mapjoin_17.q.out 1486ca9 
>   ql/src/test/results/clientpositive/spark/smb_mapjoin_2.q.out a0d51f3 
>   ql/src/test/results/clientpositive/spark/smb_mapjoin_3.q.out f46b833 
>   ql/src/test/results/clientpositive/spark/smb_mapjoin_4.q.out a421a42 
>   ql/src/test/results/clientpositive/spark/smb_mapjoin_5.q.out af65010 
>   ql/src/test/results/clientpositive/spark/smb_mapjoin_6.q.out daeb233 
>   ql/src/test/results/clientpositive/spark/subquery_exists.q.out 44f467b 
>   ql/src/test/results/clientpositive/spark/subquery_in.q.out b2a1681 
>   ql/src/test/results/clientpositive/spark/subquery_multiinsert.q.java1.7.out 
> 3aac389 
>   ql/src/test/results/clientpositive/spark/temp_table_join1.q.out 1a1340e 
>   ql/src/test/results/clientpositive/spark/union26.q.out 42d4260 
>   ql/src/test/results/clientpositive/spark/union32.q.out 443796c 
>   ql/src/test/results/clientpositive/spark/union34.q.out 0d35488 
>   ql/src/test/results/clientpositive/spark/union_top_level.q.out e114a7e 
>   ql/src/test/results/clientpositive/spark/vector_count_distinct.q.out 
> f80000e 
>   ql/src/test/results/clientpositive/spark/vector_decimal_mapjoin.q.out 
> d138102 
>   ql/src/test/results/clientpositive/spark/vector_mapjoin_reduce.q.out 
> 6308cee 
>   ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out 
> e970f9a 
>   ql/src/test/results/clientpositive/spark/vectorized_mapjoin.q.out 6d62dd2 
>   ql/src/test/results/clientpositive/spark/vectorized_nested_mapjoin.q.out 
> 6aabab6 
>   ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out 28240e6 
>   ql/src/test/results/clientpositive/spark/vectorized_shufflejoin.q.out 
> 72e39a8 
>   ql/src/test/results/clientpositive/stats11.q.out 17af076 
>   ql/src/test/results/clientpositive/subq_where_serialization.q.out 2a60036 
>   ql/src/test/results/clientpositive/subquery_exists.q.out ace5efe 
>   ql/src/test/results/clientpositive/subquery_exists_having.q.out 13877fc 
>   ql/src/test/results/clientpositive/subquery_in.q.out f12af57 
>   ql/src/test/results/clientpositive/subquery_in_having.q.out deab017 
>   ql/src/test/results/clientpositive/subquery_multiinsert.q.java1.7.out 
> b668694 
>   ql/src/test/results/clientpositive/subquery_notexists.q.out 215d855 
>   ql/src/test/results/clientpositive/subquery_notexists_having.q.out 637fc62 
>   ql/src/test/results/clientpositive/subquery_notin.q.out 5563794 
>   ql/src/test/results/clientpositive/subquery_notin_having.q.java1.7.out 
> 9689ae3 
>   ql/src/test/results/clientpositive/subquery_unqual_corr_expr.q.out 0234c17 
>   ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out 908ad39 
>   ql/src/test/results/clientpositive/subquery_views.q.out 470fa83 
>   ql/src/test/results/clientpositive/temp_table_join1.q.out afb1c10 
>   ql/src/test/results/clientpositive/tez/auto_join1.q.out 41cbcc7 
>   ql/src/test/results/clientpositive/tez/auto_join30.q.out 8c20985 
>   ql/src/test/results/clientpositive/tez/auto_sortmerge_join_1.q.out af0ee00 
>   ql/src/test/results/clientpositive/tez/auto_sortmerge_join_11.q.out 4ac305f 
>   ql/src/test/results/clientpositive/tez/auto_sortmerge_join_12.q.out c1c406f 
>   ql/src/test/results/clientpositive/tez/auto_sortmerge_join_13.q.out c0f99cc 
>   ql/src/test/results/clientpositive/tez/auto_sortmerge_join_2.q.out 96063ef 
>   ql/src/test/results/clientpositive/tez/auto_sortmerge_join_3.q.out 956d11d 
>   ql/src/test/results/clientpositive/tez/auto_sortmerge_join_4.q.out bbb0cbb 
>   ql/src/test/results/clientpositive/tez/auto_sortmerge_join_5.q.out 8f31e94 
>   ql/src/test/results/clientpositive/tez/auto_sortmerge_join_6.q.out 9fc559d 
>   ql/src/test/results/clientpositive/tez/auto_sortmerge_join_7.q.out 4f06198 
>   ql/src/test/results/clientpositive/tez/auto_sortmerge_join_8.q.out 2608c27 
>   ql/src/test/results/clientpositive/tez/auto_sortmerge_join_9.q.out 9f3e698 
>   ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out 3ccc52f 
>   ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out 959d7d0 
>   ql/src/test/results/clientpositive/tez/correlationoptimizer1.q.out 444f931 
>   ql/src/test/results/clientpositive/tez/cross_join.q.out 431aa63 
>   ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out 35c4ea8 
>   ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out 5e8015d 
>   ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out 
> 792ccaf 
>   ql/src/test/results/clientpositive/tez/dynamic_partition_pruning_2.q.out 
> 430d5ad 
>   ql/src/test/results/clientpositive/tez/explainuser_1.q.out fa29dfe 
>   ql/src/test/results/clientpositive/tez/explainuser_2.q.out ff055ea 
>   ql/src/test/results/clientpositive/tez/explainuser_3.q.out 880d2ad 
>   ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out c683ca2 
>   ql/src/test/results/clientpositive/tez/hybridgrace_hashjoin_1.q.out 69fab90 
>   ql/src/test/results/clientpositive/tez/hybridgrace_hashjoin_2.q.out 737bd1d 
>   ql/src/test/results/clientpositive/tez/join1.q.out c5bd100 
>   ql/src/test/results/clientpositive/tez/join_nullsafe.q.out 79ee3f0 
>   ql/src/test/results/clientpositive/tez/limit_pushdown.q.out 14d57e3 
>   ql/src/test/results/clientpositive/tez/lvj_mapjoin.q.out 0a6be5f 
>   ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out 4b15062 
>   ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out f6e652d 
>   ql/src/test/results/clientpositive/tez/mergejoin.q.out de38ac3 
>   ql/src/test/results/clientpositive/tez/mrr.q.out 4d68a2f 
>   ql/src/test/results/clientpositive/tez/ptf.q.out b134440 
>   ql/src/test/results/clientpositive/tez/ptf_streaming.q.out 2b37c1b 
>   ql/src/test/results/clientpositive/tez/skewjoin.q.out 7d0a8e5 
>   ql/src/test/results/clientpositive/tez/subquery_exists.q.out 41aa048 
>   ql/src/test/results/clientpositive/tez/subquery_in.q.out add2c52 
>   ql/src/test/results/clientpositive/tez/tez_bmj_schema_evolution.q.out 
> b31a403 
>   ql/src/test/results/clientpositive/tez/tez_dynpart_hashjoin_1.q.out 429f759 
>   ql/src/test/results/clientpositive/tez/tez_dynpart_hashjoin_2.q.out 8f43b26 
>   ql/src/test/results/clientpositive/tez/tez_join_hash.q.out 7e54e29 
>   ql/src/test/results/clientpositive/tez/tez_join_result_complex.q.out 
> 401506b 
>   ql/src/test/results/clientpositive/tez/tez_self_join.q.out be538ac 
>   ql/src/test/results/clientpositive/tez/tez_smb_1.q.out e60d5af 
>   ql/src/test/results/clientpositive/tez/tez_smb_empty.q.out 82ec31d 
>   ql/src/test/results/clientpositive/tez/tez_smb_main.q.out 52e1750 
>   ql/src/test/results/clientpositive/tez/tez_union.q.out 5a7d0d6 
>   ql/src/test/results/clientpositive/tez/tez_vector_dynpart_hashjoin_1.q.out 
> 39eb1a4 
>   ql/src/test/results/clientpositive/tez/tez_vector_dynpart_hashjoin_2.q.out 
> d8bc128 
>   ql/src/test/results/clientpositive/tez/unionDistinct_1.q.out 9537807 
>   ql/src/test/results/clientpositive/tez/vector_auto_smb_mapjoin_14.q.out 
> cb6de24 
>   ql/src/test/results/clientpositive/tez/vector_binary_join_groupby.q.out 
> c3febc1 
>   ql/src/test/results/clientpositive/tez/vector_char_mapjoin1.q.out 0825fc9 
>   ql/src/test/results/clientpositive/tez/vector_decimal_expressions.q.out 
> 08c3ae9 
>   ql/src/test/results/clientpositive/tez/vector_decimal_mapjoin.q.out 3712549 
>   ql/src/test/results/clientpositive/tez/vector_decimal_udf.q.out 6df956d 
>   ql/src/test/results/clientpositive/tez/vector_if_expr.q.out 3373fc2 
>   ql/src/test/results/clientpositive/tez/vector_interval_mapjoin.q.out 
> b4d3477 
>   ql/src/test/results/clientpositive/tez/vector_join30.q.out a55ba85 
>   ql/src/test/results/clientpositive/tez/vector_leftsemi_mapjoin.q.out 
> 7c5f083 
>   ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out d2937a5 
>   ql/src/test/results/clientpositive/tez/vector_nullsafe_join.q.out db170a9 
>   ql/src/test/results/clientpositive/tez/vector_reduce_groupby_decimal.q.out 
> 337d83f 
>   ql/src/test/results/clientpositive/tez/vector_varchar_mapjoin1.q.out 
> 3c681c3 
>   ql/src/test/results/clientpositive/tez/vectorization_8.q.out 0ab8181 
>   ql/src/test/results/clientpositive/tez/vectorization_limit.q.out 0a943df 
>   ql/src/test/results/clientpositive/tez/vectorization_short_regress.q.out 
> 5c2ece6 
>   ql/src/test/results/clientpositive/tez/vectorized_bucketmapjoin1.q.out 
> 56ef3e2 
>   ql/src/test/results/clientpositive/tez/vectorized_context.q.out b2b71cd 
>   
> ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out
>  da2033b 
>   ql/src/test/results/clientpositive/tez/vectorized_mapjoin.q.out 4430908 
>   ql/src/test/results/clientpositive/tez/vectorized_nested_mapjoin.q.out 
> 3f7dd12 
>   ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out 687085d 
>   ql/src/test/results/clientpositive/tez/vectorized_shufflejoin.q.out 1735cb2 
>   ql/src/test/results/clientpositive/udf_case_column_pruning.q.out a9bfd24 
>   ql/src/test/results/clientpositive/udf_isnull_isnotnull.q.out b59a5b9 
>   ql/src/test/results/clientpositive/udf_size.q.out 13594d2 
>   ql/src/test/results/clientpositive/udtf_json_tuple.q.out 6e60553 
>   ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out eb7a153 
>   ql/src/test/results/clientpositive/union26.q.out 287a9e1 
>   ql/src/test/results/clientpositive/union32.q.out 22b7bbc 
>   ql/src/test/results/clientpositive/union34.q.out 9ee382b 
>   ql/src/test/results/clientpositive/unionDistinct_1.q.out 591df42 
>   ql/src/test/results/clientpositive/union_top_level.q.out 2773ad8 
>   ql/src/test/results/clientpositive/unionall_unbalancedppd.q.out 1562087 
>   ql/src/test/results/clientpositive/vector_auto_smb_mapjoin_14.q.out 827e6b5 
>   ql/src/test/results/clientpositive/vector_binary_join_groupby.q.out 7da8ae0 
>   ql/src/test/results/clientpositive/vector_char_mapjoin1.q.out 02e3681 
>   ql/src/test/results/clientpositive/vector_decimal_cast.q.out 2d81305 
>   ql/src/test/results/clientpositive/vector_decimal_expressions.q.out e57d6c1 
>   ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out d3356ed 
>   ql/src/test/results/clientpositive/vector_decimal_udf.q.out 6837b76 
>   ql/src/test/results/clientpositive/vector_if_expr.q.out 76f155b 
>   ql/src/test/results/clientpositive/vector_interval_mapjoin.q.out 7d47bcb 
>   ql/src/test/results/clientpositive/vector_join30.q.out cfe047d 
>   ql/src/test/results/clientpositive/vector_leftsemi_mapjoin.q.out dcaabd2 
>   ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out ee74fbe 
>   ql/src/test/results/clientpositive/vector_nullsafe_join.q.out 1575aef 
>   ql/src/test/results/clientpositive/vector_reduce_groupby_decimal.q.out 
> 5352885 
>   ql/src/test/results/clientpositive/vector_varchar_mapjoin1.q.out e960ead 
>   ql/src/test/results/clientpositive/vectorization_8.q.out c38fad1 
>   ql/src/test/results/clientpositive/vectorization_decimal_date.q.out ebbb24f 
>   ql/src/test/results/clientpositive/vectorization_limit.q.out 2400baa 
>   ql/src/test/results/clientpositive/vectorization_short_regress.q.out 
> 570e649 
>   ql/src/test/results/clientpositive/vectorized_bucketmapjoin1.q.out 1658bd6 
>   ql/src/test/results/clientpositive/vectorized_context.q.out 16d864f 
>   ql/src/test/results/clientpositive/vectorized_mapjoin.q.out fe02980 
>   ql/src/test/results/clientpositive/vectorized_nested_mapjoin.q.out 75acec9 
>   ql/src/test/results/clientpositive/vectorized_ptf.q.out 04dd4f8 
>   ql/src/test/results/clientpositive/vectorized_shufflejoin.q.out f32cc38 
> 
> Diff: https://reviews.apache.org/r/40359/diff/
> 
> 
> Testing
> -------
> 
> HIVE QA
> 
> 
> Thanks,
> 
> John Pullokkaran
> 
>

Reply via email to