You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by pengcheng xiong <px...@hortonworks.com> on 2015/05/13 02:42:28 UTC
Review Request 34143: Fix stats annotation
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/34143/
-----------------------------------------------------------
Review request for hive, Ashutosh Chauhan and John Pullokkaran.
Repository: hive-git
Description
-------
This is a umbrella patch for a bunch of issues: HIVE-8769 Physical optimizer : Incorrect CE results in a shuffle join instead of a Map join (PK/FK pattern not detected) HIVE-9392 JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column names having duplicated fqColumnName HIVE-10107 Union All : Vertex missing stats resulting in OOM and in-efficient plans
Diffs
-----
hbase-handler/src/test/results/positive/external_table_ppd.q.out 6d48edb
hbase-handler/src/test/results/positive/hbase_custom_key2.q.out c9b5a84
hbase-handler/src/test/results/positive/hbase_custom_key3.q.out 76848e0
hbase-handler/src/test/results/positive/hbase_ppd_key_range.q.out 6174bfb
hbase-handler/src/test/results/positive/hbase_pushdown.q.out 8a979bf
hbase-handler/src/test/results/positive/hbase_queries.q.out 7863f69
hbase-handler/src/test/results/positive/hbase_timestamp.q.out 3aae7d0
hbase-handler/src/test/results/positive/ppd_key_ranges.q.out 5936735
ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/RelOptHiveTable.java 0de7488
ql/src/java/org/apache/hadoop/hive/ql/optimizer/stats/annotation/StatsRulesProcFactory.java 44269f0
ql/src/java/org/apache/hadoop/hive/ql/plan/AbstractOperatorDesc.java 0a83440
ql/src/java/org/apache/hadoop/hive/ql/plan/ColStatistics.java c420190
ql/src/java/org/apache/hadoop/hive/ql/plan/Statistics.java f66279f
ql/src/java/org/apache/hadoop/hive/ql/stats/StatsUtils.java 508d880
ql/src/test/results/clientpositive/annotate_stats_filter.q.out e8cd06d
ql/src/test/results/clientpositive/annotate_stats_limit.q.out 5f8b6f8
ql/src/test/results/clientpositive/annotate_stats_select.q.out 753ab4e
ql/src/test/results/clientpositive/auto_join30.q.out b068493
ql/src/test/results/clientpositive/auto_join31.q.out 1e19dd0
ql/src/test/results/clientpositive/auto_join32.q.out bfc8be8
ql/src/test/results/clientpositive/auto_join_stats.q.out 9100762
ql/src/test/results/clientpositive/auto_join_stats2.q.out ed09875
ql/src/test/results/clientpositive/auto_join_without_localtask.q.out ce4ad8a
ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out 383defd
ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out 43504d8
ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out afd5518
ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out c089419
ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out 6e443fa
ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out feaea04
ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out f64ecf0
ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out f039dda
ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out e89f548
ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out 44c037f
ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out 65aa3ef
ql/src/test/results/clientpositive/binarysortable_1.q.out c4ba7e0
ql/src/test/results/clientpositive/bucket_map_join_1.q.out d778203
ql/src/test/results/clientpositive/bucket_map_join_2.q.out aef77aa
ql/src/test/results/clientpositive/bucketmapjoin1.q.out 72f2a07
ql/src/test/results/clientpositive/bucketsortoptimize_insert_2.q.out eec099c
ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out 1a644a9
ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out e4f90e4
ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out 307c83b
ql/src/test/results/clientpositive/column_access_stats.q.out a779564
ql/src/test/results/clientpositive/complex_alias.q.out 133ce91
ql/src/test/results/clientpositive/correlationoptimizer1.q.out 0eb1596
ql/src/test/results/clientpositive/correlationoptimizer10.q.out 3c3564d
ql/src/test/results/clientpositive/correlationoptimizer11.q.out bd86942
ql/src/test/results/clientpositive/correlationoptimizer15.q.out b57203e
ql/src/test/results/clientpositive/correlationoptimizer2.q.out 43d209f
ql/src/test/results/clientpositive/correlationoptimizer3.q.out 5389647
ql/src/test/results/clientpositive/correlationoptimizer4.q.out b350816
ql/src/test/results/clientpositive/correlationoptimizer5.q.out 6ba3462
ql/src/test/results/clientpositive/correlationoptimizer6.q.out be518dc
ql/src/test/results/clientpositive/cross_product_check_2.q.out 500f912
ql/src/test/results/clientpositive/explain_logical.q.out 9b86ce8
ql/src/test/results/clientpositive/explain_rearrange.q.out c4a015e
ql/src/test/results/clientpositive/filter_numeric.q.out b6b8339
ql/src/test/results/clientpositive/fold_case.q.out de6c43e
ql/src/test/results/clientpositive/fold_when.q.out 37803e0
ql/src/test/results/clientpositive/groupby_cube1.q.out 659ac52
ql/src/test/results/clientpositive/groupby_grouping_sets2.q.out 5acac64
ql/src/test/results/clientpositive/groupby_grouping_sets3.q.out b96521a
ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out a00f94b
ql/src/test/results/clientpositive/groupby_grouping_sets5.q.out b2625fe
ql/src/test/results/clientpositive/groupby_grouping_sets6.q.out 587a8c3
ql/src/test/results/clientpositive/groupby_ppd.q.out dbbab88
ql/src/test/results/clientpositive/groupby_rollup1.q.out faa6583
ql/src/test/results/clientpositive/groupby_sort_6.q.out c5cb8b9
ql/src/test/results/clientpositive/having2.q.out 9539394
ql/src/test/results/clientpositive/identity_project_remove_skip.q.out e7bd0ed
ql/src/test/results/clientpositive/implicit_cast1.q.out d4bcd64
ql/src/test/results/clientpositive/index_auto_empty.q.out f824ce5
ql/src/test/results/clientpositive/index_serde.q.out 182d681
ql/src/test/results/clientpositive/index_skewtable.q.out fac53e5
ql/src/test/results/clientpositive/infer_const_type.q.out 09803b4
ql/src/test/results/clientpositive/input9.q.out d1824e5
ql/src/test/results/clientpositive/input_part4.q.out 1ebf36b
ql/src/test/results/clientpositive/insert1.q.out 5816a2c
ql/src/test/results/clientpositive/join29.q.out 63bd035
ql/src/test/results/clientpositive/join31.q.out ddd4077
ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out c1e1051
ql/src/test/results/clientpositive/join_cond_pushdown_unqual2.q.out 678ddb8
ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out 0adf5d7
ql/src/test/results/clientpositive/join_cond_pushdown_unqual4.q.out 4668eb1
ql/src/test/results/clientpositive/join_hive_626.q.out 4e29d42
ql/src/test/results/clientpositive/join_reorder.q.out c9498bf
ql/src/test/results/clientpositive/join_reorder2.q.out 0d56a42
ql/src/test/results/clientpositive/join_reorder3.q.out eb847c2
ql/src/test/results/clientpositive/join_reorder4.q.out 23f4e4c
ql/src/test/results/clientpositive/join_view.q.out e703e0b
ql/src/test/results/clientpositive/lateral_view_explode2.q.out 737d562
ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out 13e601a
ql/src/test/results/clientpositive/mapjoin_subquery2.q.out 507c7ca
ql/src/test/results/clientpositive/merge_join_1.q.out 99c7efe
ql/src/test/results/clientpositive/mergejoins.q.out 68416a0
ql/src/test/results/clientpositive/mergejoins_mixed.q.out 6bcc3d5
ql/src/test/results/clientpositive/metadataonly1.q.out e55efd5
ql/src/test/results/clientpositive/multiMapJoin1.q.out c00ff29
ql/src/test/results/clientpositive/multiMapJoin2.q.out 5a07fe0
ql/src/test/results/clientpositive/multigroupby_singlemr.q.out 4b80693
ql/src/test/results/clientpositive/nullgroup5.q.out 8a94d62
ql/src/test/results/clientpositive/optimize_nullscan.q.out 888af95
ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out df5ee76
ql/src/test/results/clientpositive/partition_boolexpr.q.out cfd03e2
ql/src/test/results/clientpositive/ppd_gby_join.q.out be275bd
ql/src/test/results/clientpositive/ppd_join.q.out d495a1a
ql/src/test/results/clientpositive/ppd_join4.q.out 22f84ba
ql/src/test/results/clientpositive/ppd_join5.q.out 85e357e
ql/src/test/results/clientpositive/ppd_outer_join2.q.out 681c2ea
ql/src/test/results/clientpositive/ppd_outer_join3.q.out 75f1020
ql/src/test/results/clientpositive/ppd_outer_join4.q.out bb5b5cf
ql/src/test/results/clientpositive/ppd_outer_join5.q.out 43c792f
ql/src/test/results/clientpositive/ppd_repeated_alias.q.out 7d3482b
ql/src/test/results/clientpositive/ppd_udf_col.q.out c3e7d1b
ql/src/test/results/clientpositive/ppd_union_view.q.out a13ef7a
ql/src/test/results/clientpositive/ql_rewrite_gbtoidx.q.out 0a3c427
ql/src/test/results/clientpositive/ql_rewrite_gbtoidx_cbo_1.q.out 5ca966f
ql/src/test/results/clientpositive/ql_rewrite_gbtoidx_cbo_2.q.out 381e58f
ql/src/test/results/clientpositive/query_result_fileformat.q.out 3848bd4
ql/src/test/results/clientpositive/quote1.q.out 20f754f
ql/src/test/results/clientpositive/quotedid_basic.q.out 507369c
ql/src/test/results/clientpositive/quotedid_skew.q.out f604cdd
ql/src/test/results/clientpositive/reduce_deduplicate.q.out fa714b8
ql/src/test/results/clientpositive/runtime_skewjoin_mapjoin_spark.q.out 889a9d0
ql/src/test/results/clientpositive/sample6.q.out 9891cbb
ql/src/test/results/clientpositive/semijoin.q.out 97eb9fb
ql/src/test/results/clientpositive/skewjoin.q.out 27f2ffc
ql/src/test/results/clientpositive/skewjoin_mapjoin1.q.out 9f10861
ql/src/test/results/clientpositive/skewjoin_mapjoin10.q.out 27b1aee
ql/src/test/results/clientpositive/skewjoin_mapjoin11.q.out dd084e8
ql/src/test/results/clientpositive/skewjoin_mapjoin2.q.out 7e3046f
ql/src/test/results/clientpositive/skewjoin_mapjoin3.q.out 40e4de2
ql/src/test/results/clientpositive/skewjoin_mapjoin4.q.out b7c12f9
ql/src/test/results/clientpositive/skewjoin_mapjoin5.q.out 7c04a9d
ql/src/test/results/clientpositive/skewjoin_mapjoin6.q.out d3183f8
ql/src/test/results/clientpositive/skewjoin_mapjoin7.q.out aaf7de3
ql/src/test/results/clientpositive/skewjoin_mapjoin8.q.out 5d1a3e8
ql/src/test/results/clientpositive/skewjoin_mapjoin9.q.out c7271b0
ql/src/test/results/clientpositive/skewjoin_union_remove_1.q.out c67b681
ql/src/test/results/clientpositive/skewjoin_union_remove_2.q.out 2979c42
ql/src/test/results/clientpositive/skewjoinopt1.q.out 61e9a8e
ql/src/test/results/clientpositive/skewjoinopt10.q.out 90925a0
ql/src/test/results/clientpositive/skewjoinopt11.q.out 2504c17
ql/src/test/results/clientpositive/skewjoinopt12.q.out 5ac7677
ql/src/test/results/clientpositive/skewjoinopt13.q.out d6ede51
ql/src/test/results/clientpositive/skewjoinopt14.q.out 8a4802e
ql/src/test/results/clientpositive/skewjoinopt15.q.out 3abf5b7
ql/src/test/results/clientpositive/skewjoinopt16.q.out 894a265
ql/src/test/results/clientpositive/skewjoinopt17.q.out d27929f
ql/src/test/results/clientpositive/skewjoinopt18.q.out 33a0ed9
ql/src/test/results/clientpositive/skewjoinopt19.q.out fd43409
ql/src/test/results/clientpositive/skewjoinopt2.q.out d613f10
ql/src/test/results/clientpositive/skewjoinopt20.q.out a28e433
ql/src/test/results/clientpositive/skewjoinopt3.q.out bd87ccd
ql/src/test/results/clientpositive/skewjoinopt4.q.out 47f5a92
ql/src/test/results/clientpositive/skewjoinopt5.q.out d46214c
ql/src/test/results/clientpositive/skewjoinopt6.q.out c42a3ef
ql/src/test/results/clientpositive/skewjoinopt7.q.out 97482f0
ql/src/test/results/clientpositive/skewjoinopt8.q.out 244c2be
ql/src/test/results/clientpositive/skewjoinopt9.q.out f877e56
ql/src/test/results/clientpositive/spark/auto_join27.q.out 0ae494e
ql/src/test/results/clientpositive/spark/auto_join32.q.out c537b95
ql/src/test/results/clientpositive/spark/auto_join_stats.q.out 1fa1a74
ql/src/test/results/clientpositive/spark/auto_join_stats2.q.out c6473d3
ql/src/test/results/clientpositive/spark/auto_sortmerge_join_10.q.out 2b245fb
ql/src/test/results/clientpositive/spark/bucket_map_join_1.q.out 4e8ce0d
ql/src/test/results/clientpositive/spark/bucket_map_join_2.q.out c0a3c3d
ql/src/test/results/clientpositive/spark/bucketmapjoin1.q.out 44f4d0c
ql/src/test/results/clientpositive/spark/column_access_stats.q.out 3e16f61
ql/src/test/results/clientpositive/spark/groupby_cube1.q.out 8191b64
ql/src/test/results/clientpositive/spark/groupby_rollup1.q.out 25029d0
ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out cfbce61
ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out 9343805
ql/src/test/results/clientpositive/spark/insert1.q.out ba8876f
ql/src/test/results/clientpositive/spark/join34.q.out 54b7ba0
ql/src/test/results/clientpositive/spark/join35.q.out 3d14a79
ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual1.q.out 687f2e9
ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual2.q.out 949fdee
ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual3.q.out 2d70084
ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual4.q.out 3de2aed
ql/src/test/results/clientpositive/spark/join_hive_626.q.out bb65240
ql/src/test/results/clientpositive/spark/join_reorder.q.out 69b90b5
ql/src/test/results/clientpositive/spark/join_reorder2.q.out 9f9104c
ql/src/test/results/clientpositive/spark/join_reorder3.q.out 9813110
ql/src/test/results/clientpositive/spark/join_reorder4.q.out 5cc30f7
ql/src/test/results/clientpositive/spark/join_view.q.out f6e0542
ql/src/test/results/clientpositive/spark/lateral_view_explode2.q.out 41d60f5
ql/src/test/results/clientpositive/spark/load_dyn_part13.q.out 51e57e8
ql/src/test/results/clientpositive/spark/load_dyn_part14.q.out ca36ac6
ql/src/test/results/clientpositive/spark/mapjoin_subquery2.q.out 06b2cbe
ql/src/test/results/clientpositive/spark/mergejoins.q.out 86ee699
ql/src/test/results/clientpositive/spark/mergejoins_mixed.q.out 8dcf5ac
ql/src/test/results/clientpositive/spark/multi_insert.q.out 137082a
ql/src/test/results/clientpositive/spark/multi_insert_move_tasks_share_dependencies.q.out 4645a65
ql/src/test/results/clientpositive/spark/multi_join_union.q.out bda569d
ql/src/test/results/clientpositive/spark/multigroupby_singlemr.q.out c1480e3
ql/src/test/results/clientpositive/spark/optimize_nullscan.q.out b5eff31
ql/src/test/results/clientpositive/spark/ppd_gby_join.q.out e76f9cf
ql/src/test/results/clientpositive/spark/ppd_join.q.out 2925a83
ql/src/test/results/clientpositive/spark/ppd_join4.q.out 193311a
ql/src/test/results/clientpositive/spark/ppd_join5.q.out 5943e7c
ql/src/test/results/clientpositive/spark/ppd_outer_join1.q.out 7c10afe
ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out c70133e
ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out 9bcacb3
ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out 690a9e3
ql/src/test/results/clientpositive/spark/runtime_skewjoin_mapjoin_spark.q.out 2348058
ql/src/test/results/clientpositive/spark/sample6.q.out 4117732
ql/src/test/results/clientpositive/spark/semijoin.q.out 96edf5f
ql/src/test/results/clientpositive/spark/skewjoin.q.out 35d4f6f
ql/src/test/results/clientpositive/spark/skewjoin_union_remove_1.q.out 0ce2bb9
ql/src/test/results/clientpositive/spark/skewjoin_union_remove_2.q.out 3d629be
ql/src/test/results/clientpositive/spark/skewjoinopt1.q.out 93e08eb
ql/src/test/results/clientpositive/spark/skewjoinopt10.q.out a30ccc9
ql/src/test/results/clientpositive/spark/skewjoinopt11.q.out 2dfe692
ql/src/test/results/clientpositive/spark/skewjoinopt12.q.out 667ec5c
ql/src/test/results/clientpositive/spark/skewjoinopt13.q.out 88d84c4
ql/src/test/results/clientpositive/spark/skewjoinopt14.q.out 5bc8a76
ql/src/test/results/clientpositive/spark/skewjoinopt15.q.out 3ac7511
ql/src/test/results/clientpositive/spark/skewjoinopt16.q.out 46a28de
ql/src/test/results/clientpositive/spark/skewjoinopt17.q.out 8c7d620
ql/src/test/results/clientpositive/spark/skewjoinopt18.q.out 60c4677
ql/src/test/results/clientpositive/spark/skewjoinopt19.q.out eb9bb84
ql/src/test/results/clientpositive/spark/skewjoinopt2.q.out 1c5f36d
ql/src/test/results/clientpositive/spark/skewjoinopt20.q.out 22de156
ql/src/test/results/clientpositive/spark/skewjoinopt3.q.out 0707b4c
ql/src/test/results/clientpositive/spark/skewjoinopt4.q.out cff75a6
ql/src/test/results/clientpositive/spark/skewjoinopt5.q.out 3c4cb67
ql/src/test/results/clientpositive/spark/skewjoinopt6.q.out 16a218b
ql/src/test/results/clientpositive/spark/skewjoinopt7.q.out bba46c0
ql/src/test/results/clientpositive/spark/skewjoinopt8.q.out 7c8328f
ql/src/test/results/clientpositive/spark/skewjoinopt9.q.out 4c789cf
ql/src/test/results/clientpositive/spark/stats1.q.out fa8d05f
ql/src/test/results/clientpositive/spark/subquery_multiinsert.q.java1.7.out 92a8595
ql/src/test/results/clientpositive/spark/temp_table.q.out 16d663d
ql/src/test/results/clientpositive/spark/union.q.out f2bd7b0
ql/src/test/results/clientpositive/spark/union10.q.out 3138618
ql/src/test/results/clientpositive/spark/union11.q.out 2689bb6
ql/src/test/results/clientpositive/spark/union12.q.out cd21b73
ql/src/test/results/clientpositive/spark/union13.q.out b995d22
ql/src/test/results/clientpositive/spark/union14.q.out 4027393
ql/src/test/results/clientpositive/spark/union15.q.out fcc1cf7
ql/src/test/results/clientpositive/spark/union16.q.out 51ba287
ql/src/test/results/clientpositive/spark/union17.q.out 4b0b682
ql/src/test/results/clientpositive/spark/union18.q.out 3e25a49
ql/src/test/results/clientpositive/spark/union19.q.out b6b172f
ql/src/test/results/clientpositive/spark/union2.q.out 3ab9069
ql/src/test/results/clientpositive/spark/union20.q.out d1e23f6
ql/src/test/results/clientpositive/spark/union21.q.out 8a26f5e
ql/src/test/results/clientpositive/spark/union22.q.out 4cb7bf0
ql/src/test/results/clientpositive/spark/union23.q.out dda7234
ql/src/test/results/clientpositive/spark/union24.q.out 22ec159
ql/src/test/results/clientpositive/spark/union25.q.out 67416a3
ql/src/test/results/clientpositive/spark/union26.q.out fa996ed
ql/src/test/results/clientpositive/spark/union27.q.out e66db27
ql/src/test/results/clientpositive/spark/union28.q.out 0294bad
ql/src/test/results/clientpositive/spark/union29.q.out daa581f
ql/src/test/results/clientpositive/spark/union3.q.out 25e78e3
ql/src/test/results/clientpositive/spark/union30.q.out b9b59d4
ql/src/test/results/clientpositive/spark/union31.q.out d58d17c
ql/src/test/results/clientpositive/spark/union32.q.out c8909a5
ql/src/test/results/clientpositive/spark/union33.q.out 2de2984
ql/src/test/results/clientpositive/spark/union34.q.out d5e7e4a
ql/src/test/results/clientpositive/spark/union4.q.out a7308ec
ql/src/test/results/clientpositive/spark/union5.q.out f8cd94b
ql/src/test/results/clientpositive/spark/union6.q.out f2c3411
ql/src/test/results/clientpositive/spark/union7.q.out 73042d6
ql/src/test/results/clientpositive/spark/union8.q.out 2766dc2
ql/src/test/results/clientpositive/spark/union9.q.out 73cf3d5
ql/src/test/results/clientpositive/spark/union_lateralview.q.out 126ca0c
ql/src/test/results/clientpositive/spark/union_ppr.q.out 5d77bef
ql/src/test/results/clientpositive/spark/union_remove_1.q.out 027ede7
ql/src/test/results/clientpositive/spark/union_remove_10.q.out 2bc06d3
ql/src/test/results/clientpositive/spark/union_remove_11.q.out 76cd688
ql/src/test/results/clientpositive/spark/union_remove_12.q.out 81f815f
ql/src/test/results/clientpositive/spark/union_remove_13.q.out bf25b54
ql/src/test/results/clientpositive/spark/union_remove_14.q.out 8259c08
ql/src/test/results/clientpositive/spark/union_remove_15.q.out 1f1e3c8
ql/src/test/results/clientpositive/spark/union_remove_16.q.out f17b7a4
ql/src/test/results/clientpositive/spark/union_remove_17.q.out 9704d0f
ql/src/test/results/clientpositive/spark/union_remove_18.q.out 4b71e77
ql/src/test/results/clientpositive/spark/union_remove_19.q.out 290d11a
ql/src/test/results/clientpositive/spark/union_remove_2.q.out 06d4ad8
ql/src/test/results/clientpositive/spark/union_remove_20.q.out bd8f9d7
ql/src/test/results/clientpositive/spark/union_remove_21.q.out 9379e34
ql/src/test/results/clientpositive/spark/union_remove_22.q.out 8fe568a
ql/src/test/results/clientpositive/spark/union_remove_23.q.out 4add1d6
ql/src/test/results/clientpositive/spark/union_remove_24.q.out 881e4ed
ql/src/test/results/clientpositive/spark/union_remove_25.q.out 5853cc0
ql/src/test/results/clientpositive/spark/union_remove_3.q.out df17b35
ql/src/test/results/clientpositive/spark/union_remove_4.q.out 5d6dd88
ql/src/test/results/clientpositive/spark/union_remove_5.q.out 554cffc
ql/src/test/results/clientpositive/spark/union_remove_6.q.out ea0a1a0
ql/src/test/results/clientpositive/spark/union_remove_6_subq.q.out 977d0f5
ql/src/test/results/clientpositive/spark/union_remove_7.q.out d8f4c03
ql/src/test/results/clientpositive/spark/union_remove_8.q.out 994552e
ql/src/test/results/clientpositive/spark/union_remove_9.q.out a16ca19
ql/src/test/results/clientpositive/spark/union_top_level.q.out a64fc95
ql/src/test/results/clientpositive/spark/union_view.q.out 2ca9e13
ql/src/test/results/clientpositive/subq_where_serialization.q.out 94d3685
ql/src/test/results/clientpositive/subquery_in_having.q.out 862c6ad
ql/src/test/results/clientpositive/subquery_multiinsert.q.java1.7.out 4f8ad0a
ql/src/test/results/clientpositive/subquery_notin.q.out 733e8ff
ql/src/test/results/clientpositive/subquery_notin_having.q.java1.7.out 2d5b486
ql/src/test/results/clientpositive/subquery_unqual_corr_expr.q.out e3dd5ed
ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out cf22ca6
ql/src/test/results/clientpositive/subquery_views.q.out e495acc
ql/src/test/results/clientpositive/tez/auto_sortmerge_join_10.q.out 28268fc
ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out 8b3d637
ql/src/test/results/clientpositive/tez/dynamic_partition_pruning_2.q.out 8c8531c
ql/src/test/results/clientpositive/tez/explainuser_1.q.out b684858
ql/src/test/results/clientpositive/tez/explainuser_2.q.out f84524b
ql/src/test/results/clientpositive/tez/hybridgrace_hashjoin_2.q.out 4ad143c
ql/src/test/results/clientpositive/tez/mergejoin.q.out 97df12a
ql/src/test/results/clientpositive/tez/metadataonly1.q.out 2850314
ql/src/test/results/clientpositive/tez/optimize_nullscan.q.out 2c7528e
ql/src/test/results/clientpositive/tez/selectDistinctStar.q.out f387cd0
ql/src/test/results/clientpositive/tez/skewjoin.q.out ab2ce24
ql/src/test/results/clientpositive/tez/temp_table.q.out 1bf4085
ql/src/test/results/clientpositive/tez/tez_join.q.out b87b71c
ql/src/test/results/clientpositive/tez/tez_join_hash.q.out c4bec62
ql/src/test/results/clientpositive/tez/tez_smb_main.q.out 6183390
ql/src/test/results/clientpositive/tez/tez_union.q.out 4c9368e
ql/src/test/results/clientpositive/tez/tez_union2.q.out 4e4ed9f
ql/src/test/results/clientpositive/tez/tez_union_group_by.q.out 654b34b
ql/src/test/results/clientpositive/tez/tez_union_multiinsert.q.out e67bf3e
ql/src/test/results/clientpositive/tez/union2.q.out f3c5723
ql/src/test/results/clientpositive/tez/union3.q.out 79e29a5
ql/src/test/results/clientpositive/tez/union4.q.out e28af5e
ql/src/test/results/clientpositive/tez/union5.q.out c771747
ql/src/test/results/clientpositive/tez/union6.q.out 9d24ea1
ql/src/test/results/clientpositive/tez/union7.q.out 2e07bad
ql/src/test/results/clientpositive/tez/union8.q.out 3ee38b2
ql/src/test/results/clientpositive/tez/union9.q.out e6464a0
ql/src/test/results/clientpositive/tez/unionDistinct_1.q.out 9940e4b
ql/src/test/results/clientpositive/tez/vector_date_1.q.out 8d1192a
ql/src/test/results/clientpositive/tez/vector_interval_2.q.out 0f32cee
ql/src/test/results/clientpositive/tez/vector_leftsemi_mapjoin.q.out 564f59d
ql/src/test/results/clientpositive/tez/vector_mr_diff_schema_alias.q.out fafccdc
ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out fd6c629
ql/src/test/results/clientpositive/type_widening.q.out e6617d4
ql/src/test/results/clientpositive/union10.q.out 53490e6
ql/src/test/results/clientpositive/union11.q.out c77a766
ql/src/test/results/clientpositive/union12.q.out d65086b
ql/src/test/results/clientpositive/union14.q.out 5bd1556
ql/src/test/results/clientpositive/union15.q.out 55d5510
ql/src/test/results/clientpositive/union17.q.out 56b335a
ql/src/test/results/clientpositive/union18.q.out a76d7fd
ql/src/test/results/clientpositive/union19.q.out da94293
ql/src/test/results/clientpositive/union20.q.out b80ec1e
ql/src/test/results/clientpositive/union21.q.out b24c276
ql/src/test/results/clientpositive/union22.q.out 9115287
ql/src/test/results/clientpositive/union4.q.out b7f03ea
ql/src/test/results/clientpositive/union5.q.out 0b0d7c6
ql/src/test/results/clientpositive/union7.q.out 5be3185
ql/src/test/results/clientpositive/unionDistinct_1.q.out c102b46
ql/src/test/results/clientpositive/union_remove_1.q.out f30f39b
ql/src/test/results/clientpositive/union_remove_10.q.out e720c37
ql/src/test/results/clientpositive/union_remove_12.q.out 4d6f4a1
ql/src/test/results/clientpositive/union_remove_13.q.out a558967
ql/src/test/results/clientpositive/union_remove_14.q.out 1502749
ql/src/test/results/clientpositive/union_remove_15.q.out 2b3c109
ql/src/test/results/clientpositive/union_remove_16.q.out ef32e1c
ql/src/test/results/clientpositive/union_remove_18.q.out 80971dd
ql/src/test/results/clientpositive/union_remove_19.q.out 030c5ce
ql/src/test/results/clientpositive/union_remove_2.q.out 1593029
ql/src/test/results/clientpositive/union_remove_20.q.out fc8464d
ql/src/test/results/clientpositive/union_remove_21.q.out 842e67f
ql/src/test/results/clientpositive/union_remove_22.q.out 71054ae
ql/src/test/results/clientpositive/union_remove_23.q.out 96e7d3d
ql/src/test/results/clientpositive/union_remove_24.q.out d9e86bf
ql/src/test/results/clientpositive/union_remove_25.q.out 0435ad5
ql/src/test/results/clientpositive/union_remove_4.q.out b83a0a8
ql/src/test/results/clientpositive/union_remove_5.q.out 81e64b4
ql/src/test/results/clientpositive/union_remove_6.q.out 215e90e
ql/src/test/results/clientpositive/union_remove_6_subq.q.out 2661bcb
ql/src/test/results/clientpositive/union_remove_7.q.out 4feb092
ql/src/test/results/clientpositive/union_remove_8.q.out 5d22aa5
ql/src/test/results/clientpositive/union_remove_9.q.out 7380d12
ql/src/test/results/clientpositive/union_view.q.out 9181e9b
ql/src/test/results/clientpositive/vector_date_1.q.out 5ed7424
ql/src/test/results/clientpositive/vector_interval_2.q.out b70ef7a
ql/src/test/results/clientpositive/vector_leftsemi_mapjoin.q.out 23a8adb
ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out 27af52c
ql/src/test/results/clientpositive/vector_mr_diff_schema_alias.q.out 59985cb
ql/src/test/results/clientpositive/vector_multi_insert.q.out 2fcacad
Diff: https://reviews.apache.org/r/34143/diff/
Testing
-------
Thanks,
pengcheng xiong
Re: Review Request 34143: Fix stats annotation
Posted by pengcheng xiong <px...@hortonworks.com>.
> On May 20, 2015, 4:26 a.m., Ashutosh Chauhan wrote:
> > ql/src/test/results/clientpositive/tez/auto_sortmerge_join_12.q.out, line 397
> > <https://reviews.apache.org/r/34143/diff/2/?file=960021#file960021line397>
> >
> > Seems like cloning bug? Says Map 5, but its really Map 3.
confirmed with Tez plan, it is really "Map 5 => 1"
> On May 20, 2015, 4:26 a.m., Ashutosh Chauhan wrote:
> > ql/src/test/results/clientpositive/tez/hybridgrace_hashjoin_2.q.out, line 735
> > <https://reviews.apache.org/r/34143/diff/2/?file=960026#file960026line735>
> >
> > GBy followed by gby has double the # of rows. Expected it to go lower.
GB33 has two parents, GB13 and GB28, thus the #row is the sum of them.
- pengcheng
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/34143/#review84434
-----------------------------------------------------------
On May 14, 2015, 4:50 p.m., pengcheng xiong wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/34143/
> -----------------------------------------------------------
>
> (Updated May 14, 2015, 4:50 p.m.)
>
>
> Review request for hive, Ashutosh Chauhan and John Pullokkaran.
>
>
> Repository: hive-git
>
>
> Description
> -------
>
> This is a umbrella patch for a bunch of issues: HIVE-8769 Physical optimizer : Incorrect CE results in a shuffle join instead of a Map join (PK/FK pattern not detected) HIVE-9392 JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column names having duplicated fqColumnName HIVE-10107 Union All : Vertex missing stats resulting in OOM and in-efficient plans
>
>
> Diffs
> -----
>
> hbase-handler/src/test/results/positive/external_table_ppd.q.out 6d48edb
> hbase-handler/src/test/results/positive/hbase_custom_key2.q.out c9b5a84
> hbase-handler/src/test/results/positive/hbase_custom_key3.q.out 76848e0
> hbase-handler/src/test/results/positive/hbase_ppd_key_range.q.out 6174bfb
> hbase-handler/src/test/results/positive/hbase_pushdown.q.out 8a979bf
> hbase-handler/src/test/results/positive/hbase_queries.q.out 7863f69
> hbase-handler/src/test/results/positive/hbase_timestamp.q.out 3aae7d0
> hbase-handler/src/test/results/positive/ppd_key_ranges.q.out 5936735
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/RelOptHiveTable.java 0de7488
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/stats/annotation/StatsRulesProcFactory.java 44269f0
> ql/src/java/org/apache/hadoop/hive/ql/plan/AbstractOperatorDesc.java 0a83440
> ql/src/java/org/apache/hadoop/hive/ql/plan/ColStatistics.java c420190
> ql/src/java/org/apache/hadoop/hive/ql/plan/Statistics.java f66279f
> ql/src/java/org/apache/hadoop/hive/ql/stats/StatsUtils.java 508d880
> ql/src/test/results/clientpositive/annotate_stats_filter.q.out e8cd06d
> ql/src/test/results/clientpositive/annotate_stats_limit.q.out 5f8b6f8
> ql/src/test/results/clientpositive/annotate_stats_part.q.out 241192b
> ql/src/test/results/clientpositive/annotate_stats_select.q.out 753ab4e
> ql/src/test/results/clientpositive/annotate_stats_table.q.out 9bf82ac
> ql/src/test/results/clientpositive/auto_join30.q.out b068493
> ql/src/test/results/clientpositive/auto_join31.q.out 1e19dd0
> ql/src/test/results/clientpositive/auto_join32.q.out bfc8be8
> ql/src/test/results/clientpositive/auto_join_stats.q.out 9100762
> ql/src/test/results/clientpositive/auto_join_stats2.q.out ed09875
> ql/src/test/results/clientpositive/auto_join_without_localtask.q.out ce4ad8a
> ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out 383defd
> ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out e9fb705
> ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out 43504d8
> ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out afd5518
> ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out c089419
> ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out 6e443fa
> ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out feaea04
> ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out f64ecf0
> ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out f039dda
> ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out e89f548
> ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out 44c037f
> ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out 65aa3ef
> ql/src/test/results/clientpositive/binarysortable_1.q.out c4ba7e0
> ql/src/test/results/clientpositive/bucket_map_join_1.q.out d778203
> ql/src/test/results/clientpositive/bucket_map_join_2.q.out aef77aa
> ql/src/test/results/clientpositive/bucketmapjoin1.q.out 72f2a07
> ql/src/test/results/clientpositive/bucketsortoptimize_insert_2.q.out eec099c
> ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out 1a644a9
> ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out e4f90e4
> ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out 307c83b
> ql/src/test/results/clientpositive/column_access_stats.q.out a779564
> ql/src/test/results/clientpositive/complex_alias.q.out 133ce91
> ql/src/test/results/clientpositive/correlationoptimizer1.q.out 0eb1596
> ql/src/test/results/clientpositive/correlationoptimizer10.q.out 3c3564d
> ql/src/test/results/clientpositive/correlationoptimizer11.q.out bd86942
> ql/src/test/results/clientpositive/correlationoptimizer15.q.out b57203e
> ql/src/test/results/clientpositive/correlationoptimizer2.q.out 43d209f
> ql/src/test/results/clientpositive/correlationoptimizer3.q.out 5389647
> ql/src/test/results/clientpositive/correlationoptimizer4.q.out b350816
> ql/src/test/results/clientpositive/correlationoptimizer5.q.out 6ba3462
> ql/src/test/results/clientpositive/correlationoptimizer6.q.out be518dc
> ql/src/test/results/clientpositive/cross_product_check_2.q.out 500f912
> ql/src/test/results/clientpositive/decimal_precision2.q.out dafc2c3
> ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_dynamic.q.out 22cbce9
> ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_static.q.out 96f8b6a
> ql/src/test/results/clientpositive/explain_logical.q.out 9b86ce8
> ql/src/test/results/clientpositive/explain_rearrange.q.out c4a015e
> ql/src/test/results/clientpositive/filter_numeric.q.out b6b8339
> ql/src/test/results/clientpositive/fold_case.q.out de6c43e
> ql/src/test/results/clientpositive/fold_when.q.out 37803e0
> ql/src/test/results/clientpositive/groupby_cube1.q.out 659ac52
> ql/src/test/results/clientpositive/groupby_grouping_sets2.q.out 5acac64
> ql/src/test/results/clientpositive/groupby_grouping_sets3.q.out b96521a
> ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out a00f94b
> ql/src/test/results/clientpositive/groupby_grouping_sets5.q.out b2625fe
> ql/src/test/results/clientpositive/groupby_grouping_sets6.q.out 587a8c3
> ql/src/test/results/clientpositive/groupby_ppd.q.out dbbab88
> ql/src/test/results/clientpositive/groupby_rollup1.q.out faa6583
> ql/src/test/results/clientpositive/groupby_sort_6.q.out c5cb8b9
> ql/src/test/results/clientpositive/having2.q.out 9539394
> ql/src/test/results/clientpositive/identity_project_remove_skip.q.out e7bd0ed
> ql/src/test/results/clientpositive/implicit_cast1.q.out d4bcd64
> ql/src/test/results/clientpositive/index_auto_empty.q.out f824ce5
> ql/src/test/results/clientpositive/index_serde.q.out 182d681
> ql/src/test/results/clientpositive/index_skewtable.q.out fac53e5
> ql/src/test/results/clientpositive/infer_const_type.q.out 09803b4
> ql/src/test/results/clientpositive/input21.q.out f6559f3
> ql/src/test/results/clientpositive/input23.q.out 73038c3
> ql/src/test/results/clientpositive/input24.q.out 63f2b64
> ql/src/test/results/clientpositive/input25.q.out bf9948a
> ql/src/test/results/clientpositive/input26.q.out 1b24aa6
> ql/src/test/results/clientpositive/input9.q.out d1824e5
> ql/src/test/results/clientpositive/input_part4.q.out 1ebf36b
> ql/src/test/results/clientpositive/insert1.q.out 5816a2c
> ql/src/test/results/clientpositive/join19.q.out 2570663
> ql/src/test/results/clientpositive/join29.q.out 63bd035
> ql/src/test/results/clientpositive/join31.q.out ddd4077
> ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out c1e1051
> ql/src/test/results/clientpositive/join_cond_pushdown_unqual2.q.out 678ddb8
> ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out 0adf5d7
> ql/src/test/results/clientpositive/join_cond_pushdown_unqual4.q.out 4668eb1
> ql/src/test/results/clientpositive/join_hive_626.q.out 4e29d42
> ql/src/test/results/clientpositive/join_reorder.q.out c9498bf
> ql/src/test/results/clientpositive/join_reorder2.q.out 0d56a42
> ql/src/test/results/clientpositive/join_reorder3.q.out eb847c2
> ql/src/test/results/clientpositive/join_reorder4.q.out 23f4e4c
> ql/src/test/results/clientpositive/join_view.q.out e703e0b
> ql/src/test/results/clientpositive/keyword_1.q.out a37093d
> ql/src/test/results/clientpositive/lateral_view_explode2.q.out 737d562
> ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out 13e601a
> ql/src/test/results/clientpositive/mapjoin_subquery2.q.out 507c7ca
> ql/src/test/results/clientpositive/merge_join_1.q.out 99c7efe
> ql/src/test/results/clientpositive/mergejoins.q.out 68416a0
> ql/src/test/results/clientpositive/mergejoins_mixed.q.out 6bcc3d5
> ql/src/test/results/clientpositive/metadataonly1.q.out e55efd5
> ql/src/test/results/clientpositive/multiMapJoin1.q.out c00ff29
> ql/src/test/results/clientpositive/multiMapJoin2.q.out 5a07fe0
> ql/src/test/results/clientpositive/multigroupby_singlemr.q.out 4b80693
> ql/src/test/results/clientpositive/nullformatCTAS.q.out 892de6e
> ql/src/test/results/clientpositive/nullgroup3.q.out 7712d4d
> ql/src/test/results/clientpositive/nullgroup5.q.out 8a94d62
> ql/src/test/results/clientpositive/optimize_nullscan.q.out 888af95
> ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out df5ee76
> ql/src/test/results/clientpositive/partition_boolexpr.q.out cfd03e2
> ql/src/test/results/clientpositive/ppd_gby_join.q.out be275bd
> ql/src/test/results/clientpositive/ppd_join.q.out d495a1a
> ql/src/test/results/clientpositive/ppd_join4.q.out 22f84ba
> ql/src/test/results/clientpositive/ppd_join5.q.out 85e357e
> ql/src/test/results/clientpositive/ppd_outer_join2.q.out 681c2ea
> ql/src/test/results/clientpositive/ppd_outer_join3.q.out 75f1020
> ql/src/test/results/clientpositive/ppd_outer_join4.q.out bb5b5cf
> ql/src/test/results/clientpositive/ppd_outer_join5.q.out 43c792f
> ql/src/test/results/clientpositive/ppd_repeated_alias.q.out 7d3482b
> ql/src/test/results/clientpositive/ppd_udf_col.q.out c3e7d1b
> ql/src/test/results/clientpositive/ppd_union_view.q.out a13ef7a
> ql/src/test/results/clientpositive/ql_rewrite_gbtoidx.q.out 0a3c427
> ql/src/test/results/clientpositive/ql_rewrite_gbtoidx_cbo_1.q.out 5ca966f
> ql/src/test/results/clientpositive/ql_rewrite_gbtoidx_cbo_2.q.out 381e58f
> ql/src/test/results/clientpositive/query_result_fileformat.q.out 3848bd4
> ql/src/test/results/clientpositive/quote1.q.out 20f754f
> ql/src/test/results/clientpositive/quotedid_basic.q.out 507369c
> ql/src/test/results/clientpositive/quotedid_skew.q.out f604cdd
> ql/src/test/results/clientpositive/reduce_deduplicate.q.out fa714b8
> ql/src/test/results/clientpositive/runtime_skewjoin_mapjoin_spark.q.out 889a9d0
> ql/src/test/results/clientpositive/sample6.q.out 9891cbb
> ql/src/test/results/clientpositive/select_dummy_source.q.out b1f0939
> ql/src/test/results/clientpositive/semijoin.q.out 97eb9fb
> ql/src/test/results/clientpositive/skewjoin.q.out 27f2ffc
> ql/src/test/results/clientpositive/skewjoin_mapjoin1.q.out 9f10861
> ql/src/test/results/clientpositive/skewjoin_mapjoin10.q.out 27b1aee
> ql/src/test/results/clientpositive/skewjoin_mapjoin11.q.out dd084e8
> ql/src/test/results/clientpositive/skewjoin_mapjoin2.q.out 7e3046f
> ql/src/test/results/clientpositive/skewjoin_mapjoin3.q.out 40e4de2
> ql/src/test/results/clientpositive/skewjoin_mapjoin4.q.out b7c12f9
> ql/src/test/results/clientpositive/skewjoin_mapjoin5.q.out 7c04a9d
> ql/src/test/results/clientpositive/skewjoin_mapjoin6.q.out d3183f8
> ql/src/test/results/clientpositive/skewjoin_mapjoin7.q.out aaf7de3
> ql/src/test/results/clientpositive/skewjoin_mapjoin8.q.out 5d1a3e8
> ql/src/test/results/clientpositive/skewjoin_mapjoin9.q.out c7271b0
> ql/src/test/results/clientpositive/skewjoin_union_remove_1.q.out c67b681
> ql/src/test/results/clientpositive/skewjoin_union_remove_2.q.out 2979c42
> ql/src/test/results/clientpositive/skewjoinopt1.q.out 61e9a8e
> ql/src/test/results/clientpositive/skewjoinopt10.q.out 90925a0
> ql/src/test/results/clientpositive/skewjoinopt11.q.out 2504c17
> ql/src/test/results/clientpositive/skewjoinopt12.q.out 5ac7677
> ql/src/test/results/clientpositive/skewjoinopt13.q.out d6ede51
> ql/src/test/results/clientpositive/skewjoinopt14.q.out 8a4802e
> ql/src/test/results/clientpositive/skewjoinopt15.q.out 3abf5b7
> ql/src/test/results/clientpositive/skewjoinopt16.q.out 894a265
> ql/src/test/results/clientpositive/skewjoinopt17.q.out d27929f
> ql/src/test/results/clientpositive/skewjoinopt18.q.out 33a0ed9
> ql/src/test/results/clientpositive/skewjoinopt19.q.out fd43409
> ql/src/test/results/clientpositive/skewjoinopt2.q.out d613f10
> ql/src/test/results/clientpositive/skewjoinopt20.q.out a28e433
> ql/src/test/results/clientpositive/skewjoinopt3.q.out bd87ccd
> ql/src/test/results/clientpositive/skewjoinopt4.q.out 47f5a92
> ql/src/test/results/clientpositive/skewjoinopt5.q.out d46214c
> ql/src/test/results/clientpositive/skewjoinopt6.q.out c42a3ef
> ql/src/test/results/clientpositive/skewjoinopt7.q.out 97482f0
> ql/src/test/results/clientpositive/skewjoinopt8.q.out 244c2be
> ql/src/test/results/clientpositive/skewjoinopt9.q.out f877e56
> ql/src/test/results/clientpositive/smb_mapjoin9.q.out cbaf7e1
> ql/src/test/results/clientpositive/spark/auto_join27.q.out 0ae494e
> ql/src/test/results/clientpositive/spark/auto_join32.q.out c537b95
> ql/src/test/results/clientpositive/spark/auto_join_stats.q.out 1fa1a74
> ql/src/test/results/clientpositive/spark/auto_join_stats2.q.out c6473d3
> ql/src/test/results/clientpositive/spark/auto_sortmerge_join_10.q.out 2b245fb
> ql/src/test/results/clientpositive/spark/auto_sortmerge_join_12.q.out 8102ec1
> ql/src/test/results/clientpositive/spark/bucket_map_join_1.q.out 4e8ce0d
> ql/src/test/results/clientpositive/spark/bucket_map_join_2.q.out c0a3c3d
> ql/src/test/results/clientpositive/spark/bucketmapjoin1.q.out 44f4d0c
> ql/src/test/results/clientpositive/spark/column_access_stats.q.out 3e16f61
> ql/src/test/results/clientpositive/spark/groupby_cube1.q.out 8191b64
> ql/src/test/results/clientpositive/spark/groupby_rollup1.q.out 25029d0
> ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out cfbce61
> ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out 9343805
> ql/src/test/results/clientpositive/spark/insert1.q.out ba8876f
> ql/src/test/results/clientpositive/spark/join19.q.out f84ce2d
> ql/src/test/results/clientpositive/spark/join34.q.out 54b7ba0
> ql/src/test/results/clientpositive/spark/join35.q.out 3d14a79
> ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual1.q.out 687f2e9
> ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual2.q.out 949fdee
> ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual3.q.out 2d70084
> ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual4.q.out 3de2aed
> ql/src/test/results/clientpositive/spark/join_hive_626.q.out bb65240
> ql/src/test/results/clientpositive/spark/join_reorder.q.out 69b90b5
> ql/src/test/results/clientpositive/spark/join_reorder2.q.out 9f9104c
> ql/src/test/results/clientpositive/spark/join_reorder3.q.out 9813110
> ql/src/test/results/clientpositive/spark/join_reorder4.q.out 5cc30f7
> ql/src/test/results/clientpositive/spark/join_view.q.out f6e0542
> ql/src/test/results/clientpositive/spark/lateral_view_explode2.q.out 41d60f5
> ql/src/test/results/clientpositive/spark/load_dyn_part13.q.out 51e57e8
> ql/src/test/results/clientpositive/spark/load_dyn_part14.q.out ca36ac6
> ql/src/test/results/clientpositive/spark/mapjoin_subquery2.q.out 06b2cbe
> ql/src/test/results/clientpositive/spark/mergejoins.q.out 86ee699
> ql/src/test/results/clientpositive/spark/mergejoins_mixed.q.out 8dcf5ac
> ql/src/test/results/clientpositive/spark/multi_insert.q.out 137082a
> ql/src/test/results/clientpositive/spark/multi_insert_move_tasks_share_dependencies.q.out 4645a65
> ql/src/test/results/clientpositive/spark/multi_join_union.q.out bda569d
> ql/src/test/results/clientpositive/spark/multigroupby_singlemr.q.out c1480e3
> ql/src/test/results/clientpositive/spark/optimize_nullscan.q.out b5eff31
> ql/src/test/results/clientpositive/spark/ppd_gby_join.q.out e76f9cf
> ql/src/test/results/clientpositive/spark/ppd_join.q.out 2925a83
> ql/src/test/results/clientpositive/spark/ppd_join4.q.out 193311a
> ql/src/test/results/clientpositive/spark/ppd_join5.q.out 5943e7c
> ql/src/test/results/clientpositive/spark/ppd_outer_join1.q.out 7c10afe
> ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out c70133e
> ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out 9bcacb3
> ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out 690a9e3
> ql/src/test/results/clientpositive/spark/ql_rewrite_gbtoidx.q.out 45712d6
> ql/src/test/results/clientpositive/spark/ql_rewrite_gbtoidx_cbo_1.q.out aec0204
> ql/src/test/results/clientpositive/spark/reduce_deduplicate.q.out 7b92c73
> ql/src/test/results/clientpositive/spark/runtime_skewjoin_mapjoin_spark.q.out 2348058
> ql/src/test/results/clientpositive/spark/sample6.q.out 4117732
> ql/src/test/results/clientpositive/spark/semijoin.q.out 96edf5f
> ql/src/test/results/clientpositive/spark/skewjoin.q.out 35d4f6f
> ql/src/test/results/clientpositive/spark/skewjoin_union_remove_1.q.out 0ce2bb9
> ql/src/test/results/clientpositive/spark/skewjoin_union_remove_2.q.out 3d629be
> ql/src/test/results/clientpositive/spark/skewjoinopt1.q.out 93e08eb
> ql/src/test/results/clientpositive/spark/skewjoinopt10.q.out a30ccc9
> ql/src/test/results/clientpositive/spark/skewjoinopt11.q.out 2dfe692
> ql/src/test/results/clientpositive/spark/skewjoinopt12.q.out 667ec5c
> ql/src/test/results/clientpositive/spark/skewjoinopt13.q.out 88d84c4
> ql/src/test/results/clientpositive/spark/skewjoinopt14.q.out 5bc8a76
> ql/src/test/results/clientpositive/spark/skewjoinopt15.q.out 3ac7511
> ql/src/test/results/clientpositive/spark/skewjoinopt16.q.out 46a28de
> ql/src/test/results/clientpositive/spark/skewjoinopt17.q.out 8c7d620
> ql/src/test/results/clientpositive/spark/skewjoinopt18.q.out 60c4677
> ql/src/test/results/clientpositive/spark/skewjoinopt19.q.out eb9bb84
> ql/src/test/results/clientpositive/spark/skewjoinopt2.q.out 1c5f36d
> ql/src/test/results/clientpositive/spark/skewjoinopt20.q.out 22de156
> ql/src/test/results/clientpositive/spark/skewjoinopt3.q.out 0707b4c
> ql/src/test/results/clientpositive/spark/skewjoinopt4.q.out cff75a6
> ql/src/test/results/clientpositive/spark/skewjoinopt5.q.out 3c4cb67
> ql/src/test/results/clientpositive/spark/skewjoinopt6.q.out 16a218b
> ql/src/test/results/clientpositive/spark/skewjoinopt7.q.out bba46c0
> ql/src/test/results/clientpositive/spark/skewjoinopt8.q.out 7c8328f
> ql/src/test/results/clientpositive/spark/skewjoinopt9.q.out 4c789cf
> ql/src/test/results/clientpositive/spark/stats1.q.out fa8d05f
> ql/src/test/results/clientpositive/spark/stats12.q.out 0e25ac1
> ql/src/test/results/clientpositive/spark/stats13.q.out 4934aec
> ql/src/test/results/clientpositive/spark/stats2.q.out ad7ba0d
> ql/src/test/results/clientpositive/spark/stats7.q.out 32b09a0
> ql/src/test/results/clientpositive/spark/stats8.q.out 54eb2a1
> ql/src/test/results/clientpositive/spark/subquery_multiinsert.q.java1.7.out 92a8595
> ql/src/test/results/clientpositive/spark/temp_table.q.out 16d663d
> ql/src/test/results/clientpositive/spark/transform1.q.out 4a79875
> ql/src/test/results/clientpositive/spark/udf_in_file.q.out c769d1f
> ql/src/test/results/clientpositive/spark/union.q.out f2bd7b0
> ql/src/test/results/clientpositive/spark/union10.q.out 3138618
> ql/src/test/results/clientpositive/spark/union11.q.out 2689bb6
> ql/src/test/results/clientpositive/spark/union12.q.out cd21b73
> ql/src/test/results/clientpositive/spark/union13.q.out b995d22
> ql/src/test/results/clientpositive/spark/union14.q.out 4027393
> ql/src/test/results/clientpositive/spark/union15.q.out fcc1cf7
> ql/src/test/results/clientpositive/spark/union16.q.out 51ba287
> ql/src/test/results/clientpositive/spark/union17.q.out 4b0b682
> ql/src/test/results/clientpositive/spark/union18.q.out 3e25a49
> ql/src/test/results/clientpositive/spark/union19.q.out b6b172f
> ql/src/test/results/clientpositive/spark/union2.q.out 3ab9069
> ql/src/test/results/clientpositive/spark/union20.q.out d1e23f6
> ql/src/test/results/clientpositive/spark/union21.q.out 8a26f5e
> ql/src/test/results/clientpositive/spark/union22.q.out 4cb7bf0
> ql/src/test/results/clientpositive/spark/union23.q.out dda7234
> ql/src/test/results/clientpositive/spark/union24.q.out 22ec159
> ql/src/test/results/clientpositive/spark/union25.q.out 67416a3
> ql/src/test/results/clientpositive/spark/union26.q.out fa996ed
> ql/src/test/results/clientpositive/spark/union27.q.out e66db27
> ql/src/test/results/clientpositive/spark/union28.q.out 0294bad
> ql/src/test/results/clientpositive/spark/union29.q.out daa581f
> ql/src/test/results/clientpositive/spark/union3.q.out 25e78e3
> ql/src/test/results/clientpositive/spark/union30.q.out b9b59d4
> ql/src/test/results/clientpositive/spark/union31.q.out d58d17c
> ql/src/test/results/clientpositive/spark/union32.q.out c8909a5
> ql/src/test/results/clientpositive/spark/union33.q.out 2de2984
> ql/src/test/results/clientpositive/spark/union34.q.out d5e7e4a
> ql/src/test/results/clientpositive/spark/union4.q.out a7308ec
> ql/src/test/results/clientpositive/spark/union5.q.out f8cd94b
> ql/src/test/results/clientpositive/spark/union6.q.out f2c3411
> ql/src/test/results/clientpositive/spark/union7.q.out 73042d6
> ql/src/test/results/clientpositive/spark/union8.q.out 2766dc2
> ql/src/test/results/clientpositive/spark/union9.q.out 73cf3d5
> ql/src/test/results/clientpositive/spark/union_lateralview.q.out 126ca0c
> ql/src/test/results/clientpositive/spark/union_ppr.q.out 5d77bef
> ql/src/test/results/clientpositive/spark/union_remove_1.q.out 027ede7
> ql/src/test/results/clientpositive/spark/union_remove_10.q.out 2bc06d3
> ql/src/test/results/clientpositive/spark/union_remove_11.q.out 76cd688
> ql/src/test/results/clientpositive/spark/union_remove_12.q.out 81f815f
> ql/src/test/results/clientpositive/spark/union_remove_13.q.out bf25b54
> ql/src/test/results/clientpositive/spark/union_remove_14.q.out 8259c08
> ql/src/test/results/clientpositive/spark/union_remove_15.q.out 1f1e3c8
> ql/src/test/results/clientpositive/spark/union_remove_16.q.out f17b7a4
> ql/src/test/results/clientpositive/spark/union_remove_17.q.out 9704d0f
> ql/src/test/results/clientpositive/spark/union_remove_18.q.out 4b71e77
> ql/src/test/results/clientpositive/spark/union_remove_19.q.out 290d11a
> ql/src/test/results/clientpositive/spark/union_remove_2.q.out 06d4ad8
> ql/src/test/results/clientpositive/spark/union_remove_20.q.out bd8f9d7
> ql/src/test/results/clientpositive/spark/union_remove_21.q.out 9379e34
> ql/src/test/results/clientpositive/spark/union_remove_22.q.out 8fe568a
> ql/src/test/results/clientpositive/spark/union_remove_23.q.out 4add1d6
> ql/src/test/results/clientpositive/spark/union_remove_24.q.out 881e4ed
> ql/src/test/results/clientpositive/spark/union_remove_25.q.out 5853cc0
> ql/src/test/results/clientpositive/spark/union_remove_3.q.out df17b35
> ql/src/test/results/clientpositive/spark/union_remove_4.q.out 5d6dd88
> ql/src/test/results/clientpositive/spark/union_remove_5.q.out 554cffc
> ql/src/test/results/clientpositive/spark/union_remove_6.q.out ea0a1a0
> ql/src/test/results/clientpositive/spark/union_remove_6_subq.q.out 977d0f5
> ql/src/test/results/clientpositive/spark/union_remove_7.q.out d8f4c03
> ql/src/test/results/clientpositive/spark/union_remove_8.q.out 994552e
> ql/src/test/results/clientpositive/spark/union_remove_9.q.out a16ca19
> ql/src/test/results/clientpositive/spark/union_top_level.q.out a64fc95
> ql/src/test/results/clientpositive/spark/union_view.q.out 2ca9e13
> ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out a4b8e05
> ql/src/test/results/clientpositive/stats12.q.out f8aa4d0
> ql/src/test/results/clientpositive/stats13.q.out 10ecfd2
> ql/src/test/results/clientpositive/stats2.q.out 694c1a2
> ql/src/test/results/clientpositive/stats7.q.out 1162103
> ql/src/test/results/clientpositive/stats8.q.out 11b2010
> ql/src/test/results/clientpositive/subq_where_serialization.q.out 94d3685
> ql/src/test/results/clientpositive/subquery_in_having.q.out 862c6ad
> ql/src/test/results/clientpositive/subquery_multiinsert.q.java1.7.out 4f8ad0a
> ql/src/test/results/clientpositive/subquery_notin.q.out 733e8ff
> ql/src/test/results/clientpositive/subquery_notin_having.q.java1.7.out 2d5b486
> ql/src/test/results/clientpositive/subquery_unqual_corr_expr.q.out e3dd5ed
> ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out cf22ca6
> ql/src/test/results/clientpositive/subquery_views.q.out e495acc
> ql/src/test/results/clientpositive/symlink_text_input_format.q.out 6e3b31f
> ql/src/test/results/clientpositive/tez/auto_sortmerge_join_10.q.out 28268fc
> ql/src/test/results/clientpositive/tez/auto_sortmerge_join_12.q.out 8c8a3bf
> ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out 8b3d637
> ql/src/test/results/clientpositive/tez/dynamic_partition_pruning_2.q.out 8c8531c
> ql/src/test/results/clientpositive/tez/explainuser_1.q.out b684858
> ql/src/test/results/clientpositive/tez/explainuser_2.q.out f84524b
> ql/src/test/results/clientpositive/tez/hybridgrace_hashjoin_2.q.out 4ad143c
> ql/src/test/results/clientpositive/tez/mergejoin.q.out 97df12a
> ql/src/test/results/clientpositive/tez/metadataonly1.q.out 2850314
> ql/src/test/results/clientpositive/tez/optimize_nullscan.q.out 2c7528e
> ql/src/test/results/clientpositive/tez/selectDistinctStar.q.out f387cd0
> ql/src/test/results/clientpositive/tez/skewjoin.q.out ab2ce24
> ql/src/test/results/clientpositive/tez/temp_table.q.out 1bf4085
> ql/src/test/results/clientpositive/tez/tez_join.q.out b87b71c
> ql/src/test/results/clientpositive/tez/tez_join_hash.q.out c4bec62
> ql/src/test/results/clientpositive/tez/tez_smb_main.q.out 6183390
> ql/src/test/results/clientpositive/tez/tez_union.q.out 4c9368e
> ql/src/test/results/clientpositive/tez/tez_union2.q.out 4e4ed9f
> ql/src/test/results/clientpositive/tez/tez_union_group_by.q.out 654b34b
> ql/src/test/results/clientpositive/tez/tez_union_multiinsert.q.out e67bf3e
> ql/src/test/results/clientpositive/tez/transform1.q.out 718f128
> ql/src/test/results/clientpositive/tez/union2.q.out f3c5723
> ql/src/test/results/clientpositive/tez/union3.q.out 79e29a5
> ql/src/test/results/clientpositive/tez/union4.q.out e28af5e
> ql/src/test/results/clientpositive/tez/union5.q.out c771747
> ql/src/test/results/clientpositive/tez/union6.q.out 9d24ea1
> ql/src/test/results/clientpositive/tez/union7.q.out 2e07bad
> ql/src/test/results/clientpositive/tez/union8.q.out 3ee38b2
> ql/src/test/results/clientpositive/tez/union9.q.out e6464a0
> ql/src/test/results/clientpositive/tez/unionDistinct_1.q.out 9940e4b
> ql/src/test/results/clientpositive/tez/vector_bucket.q.out 410212a
> ql/src/test/results/clientpositive/tez/vector_date_1.q.out 8d1192a
> ql/src/test/results/clientpositive/tez/vector_interval_2.q.out 0f32cee
> ql/src/test/results/clientpositive/tez/vector_leftsemi_mapjoin.q.out 564f59d
> ql/src/test/results/clientpositive/tez/vector_mr_diff_schema_alias.q.out fafccdc
> ql/src/test/results/clientpositive/tez/vectorization_short_regress.q.out a3c723d
> ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out fd6c629
> ql/src/test/results/clientpositive/timestamp_literal.q.out 13ffaf1
> ql/src/test/results/clientpositive/transform1.q.out 9382cf0
> ql/src/test/results/clientpositive/type_widening.q.out e6617d4
> ql/src/test/results/clientpositive/udf_add_months.q.out 8c37fc2
> ql/src/test/results/clientpositive/udf_bitwise_shiftleft.q.out 6703d95
> ql/src/test/results/clientpositive/udf_bitwise_shiftright.q.out dbfe390
> ql/src/test/results/clientpositive/udf_bitwise_shiftrightunsigned.q.out c20029e
> ql/src/test/results/clientpositive/udf_cbrt.q.out 4cdaf15
> ql/src/test/results/clientpositive/udf_current_database.q.out e22165e
> ql/src/test/results/clientpositive/udf_date_format.q.out acca21e
> ql/src/test/results/clientpositive/udf_decode.q.out 107712a
> ql/src/test/results/clientpositive/udf_factorial.q.out b9b7bf9
> ql/src/test/results/clientpositive/udf_from_utc_timestamp.q.out 4df872c
> ql/src/test/results/clientpositive/udf_in_file.q.out 5564890
> ql/src/test/results/clientpositive/udf_last_day.q.out 2d39e38
> ql/src/test/results/clientpositive/udf_length.q.out f4b0b18
> ql/src/test/results/clientpositive/udf_levenshtein.q.out 1a60822
> ql/src/test/results/clientpositive/udf_md5.q.out 01744fe
> ql/src/test/results/clientpositive/udf_months_between.q.out 95f756f
> ql/src/test/results/clientpositive/udf_quarter.q.out b29ba4a
> ql/src/test/results/clientpositive/udf_soundex.q.out 9895a90
> ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out e70b401
> ql/src/test/results/clientpositive/udf_trunc.q.out 6cc18c2
> ql/src/test/results/clientpositive/udtf_stack.q.out 4e9c2fd
> ql/src/test/results/clientpositive/union10.q.out 53490e6
> ql/src/test/results/clientpositive/union11.q.out c77a766
> ql/src/test/results/clientpositive/union12.q.out d65086b
> ql/src/test/results/clientpositive/union14.q.out 5bd1556
> ql/src/test/results/clientpositive/union15.q.out 55d5510
> ql/src/test/results/clientpositive/union17.q.out 56b335a
> ql/src/test/results/clientpositive/union18.q.out a76d7fd
> ql/src/test/results/clientpositive/union19.q.out da94293
> ql/src/test/results/clientpositive/union20.q.out b80ec1e
> ql/src/test/results/clientpositive/union21.q.out b24c276
> ql/src/test/results/clientpositive/union22.q.out 9115287
> ql/src/test/results/clientpositive/union4.q.out b7f03ea
> ql/src/test/results/clientpositive/union5.q.out 0b0d7c6
> ql/src/test/results/clientpositive/union7.q.out 5be3185
> ql/src/test/results/clientpositive/unionDistinct_1.q.out c102b46
> ql/src/test/results/clientpositive/union_remove_1.q.out f30f39b
> ql/src/test/results/clientpositive/union_remove_10.q.out e720c37
> ql/src/test/results/clientpositive/union_remove_11.q.out 571b398
> ql/src/test/results/clientpositive/union_remove_12.q.out 4d6f4a1
> ql/src/test/results/clientpositive/union_remove_13.q.out a558967
> ql/src/test/results/clientpositive/union_remove_14.q.out 1502749
> ql/src/test/results/clientpositive/union_remove_15.q.out 2b3c109
> ql/src/test/results/clientpositive/union_remove_16.q.out ef32e1c
> ql/src/test/results/clientpositive/union_remove_17.q.out 56b22d9
> ql/src/test/results/clientpositive/union_remove_18.q.out 80971dd
> ql/src/test/results/clientpositive/union_remove_19.q.out 030c5ce
> ql/src/test/results/clientpositive/union_remove_2.q.out 1593029
> ql/src/test/results/clientpositive/union_remove_20.q.out fc8464d
> ql/src/test/results/clientpositive/union_remove_21.q.out 842e67f
> ql/src/test/results/clientpositive/union_remove_22.q.out 71054ae
> ql/src/test/results/clientpositive/union_remove_23.q.out 96e7d3d
> ql/src/test/results/clientpositive/union_remove_24.q.out d9e86bf
> ql/src/test/results/clientpositive/union_remove_25.q.out 0435ad5
> ql/src/test/results/clientpositive/union_remove_3.q.out 0de46d0
> ql/src/test/results/clientpositive/union_remove_4.q.out b83a0a8
> ql/src/test/results/clientpositive/union_remove_5.q.out 81e64b4
> ql/src/test/results/clientpositive/union_remove_6.q.out 215e90e
> ql/src/test/results/clientpositive/union_remove_6_subq.q.out 2661bcb
> ql/src/test/results/clientpositive/union_remove_7.q.out 4feb092
> ql/src/test/results/clientpositive/union_remove_8.q.out 5d22aa5
> ql/src/test/results/clientpositive/union_remove_9.q.out 7380d12
> ql/src/test/results/clientpositive/union_view.q.out 9181e9b
> ql/src/test/results/clientpositive/vector_bucket.q.out 1ac37a7
> ql/src/test/results/clientpositive/vector_date_1.q.out 5ed7424
> ql/src/test/results/clientpositive/vector_interval_2.q.out b70ef7a
> ql/src/test/results/clientpositive/vector_leftsemi_mapjoin.q.out 23a8adb
> ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out 27af52c
> ql/src/test/results/clientpositive/vector_mr_diff_schema_alias.q.out 59985cb
> ql/src/test/results/clientpositive/vector_multi_insert.q.out 2fcacad
> ql/src/test/results/clientpositive/vectorization_short_regress.q.out b9ab174
>
> Diff: https://reviews.apache.org/r/34143/diff/
>
>
> Testing
> -------
>
>
> Thanks,
>
> pengcheng xiong
>
>
Re: Review Request 34143: Fix stats annotation
Posted by Ashutosh Chauhan <ha...@apache.org>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/34143/#review84434
-----------------------------------------------------------
ql/src/test/results/clientpositive/spark/union7.q.out
<https://reviews.apache.org/r/34143/#comment135695>
You can use --SORT_QUERY_RESULT directive to assure fixed ordering.
ql/src/test/results/clientpositive/tez/auto_sortmerge_join_12.q.out
<https://reviews.apache.org/r/34143/#comment135746>
Seems like cloning bug? Says Map 5, but its really Map 3.
ql/src/test/results/clientpositive/tez/hybridgrace_hashjoin_2.q.out
<https://reviews.apache.org/r/34143/#comment135747>
GBy followed by gby has double the # of rows. Expected it to go lower.
- Ashutosh Chauhan
On May 14, 2015, 4:50 p.m., pengcheng xiong wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/34143/
> -----------------------------------------------------------
>
> (Updated May 14, 2015, 4:50 p.m.)
>
>
> Review request for hive, Ashutosh Chauhan and John Pullokkaran.
>
>
> Repository: hive-git
>
>
> Description
> -------
>
> This is a umbrella patch for a bunch of issues: HIVE-8769 Physical optimizer : Incorrect CE results in a shuffle join instead of a Map join (PK/FK pattern not detected) HIVE-9392 JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column names having duplicated fqColumnName HIVE-10107 Union All : Vertex missing stats resulting in OOM and in-efficient plans
>
>
> Diffs
> -----
>
> hbase-handler/src/test/results/positive/external_table_ppd.q.out 6d48edb
> hbase-handler/src/test/results/positive/hbase_custom_key2.q.out c9b5a84
> hbase-handler/src/test/results/positive/hbase_custom_key3.q.out 76848e0
> hbase-handler/src/test/results/positive/hbase_ppd_key_range.q.out 6174bfb
> hbase-handler/src/test/results/positive/hbase_pushdown.q.out 8a979bf
> hbase-handler/src/test/results/positive/hbase_queries.q.out 7863f69
> hbase-handler/src/test/results/positive/hbase_timestamp.q.out 3aae7d0
> hbase-handler/src/test/results/positive/ppd_key_ranges.q.out 5936735
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/RelOptHiveTable.java 0de7488
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/stats/annotation/StatsRulesProcFactory.java 44269f0
> ql/src/java/org/apache/hadoop/hive/ql/plan/AbstractOperatorDesc.java 0a83440
> ql/src/java/org/apache/hadoop/hive/ql/plan/ColStatistics.java c420190
> ql/src/java/org/apache/hadoop/hive/ql/plan/Statistics.java f66279f
> ql/src/java/org/apache/hadoop/hive/ql/stats/StatsUtils.java 508d880
> ql/src/test/results/clientpositive/annotate_stats_filter.q.out e8cd06d
> ql/src/test/results/clientpositive/annotate_stats_limit.q.out 5f8b6f8
> ql/src/test/results/clientpositive/annotate_stats_part.q.out 241192b
> ql/src/test/results/clientpositive/annotate_stats_select.q.out 753ab4e
> ql/src/test/results/clientpositive/annotate_stats_table.q.out 9bf82ac
> ql/src/test/results/clientpositive/auto_join30.q.out b068493
> ql/src/test/results/clientpositive/auto_join31.q.out 1e19dd0
> ql/src/test/results/clientpositive/auto_join32.q.out bfc8be8
> ql/src/test/results/clientpositive/auto_join_stats.q.out 9100762
> ql/src/test/results/clientpositive/auto_join_stats2.q.out ed09875
> ql/src/test/results/clientpositive/auto_join_without_localtask.q.out ce4ad8a
> ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out 383defd
> ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out e9fb705
> ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out 43504d8
> ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out afd5518
> ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out c089419
> ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out 6e443fa
> ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out feaea04
> ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out f64ecf0
> ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out f039dda
> ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out e89f548
> ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out 44c037f
> ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out 65aa3ef
> ql/src/test/results/clientpositive/binarysortable_1.q.out c4ba7e0
> ql/src/test/results/clientpositive/bucket_map_join_1.q.out d778203
> ql/src/test/results/clientpositive/bucket_map_join_2.q.out aef77aa
> ql/src/test/results/clientpositive/bucketmapjoin1.q.out 72f2a07
> ql/src/test/results/clientpositive/bucketsortoptimize_insert_2.q.out eec099c
> ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out 1a644a9
> ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out e4f90e4
> ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out 307c83b
> ql/src/test/results/clientpositive/column_access_stats.q.out a779564
> ql/src/test/results/clientpositive/complex_alias.q.out 133ce91
> ql/src/test/results/clientpositive/correlationoptimizer1.q.out 0eb1596
> ql/src/test/results/clientpositive/correlationoptimizer10.q.out 3c3564d
> ql/src/test/results/clientpositive/correlationoptimizer11.q.out bd86942
> ql/src/test/results/clientpositive/correlationoptimizer15.q.out b57203e
> ql/src/test/results/clientpositive/correlationoptimizer2.q.out 43d209f
> ql/src/test/results/clientpositive/correlationoptimizer3.q.out 5389647
> ql/src/test/results/clientpositive/correlationoptimizer4.q.out b350816
> ql/src/test/results/clientpositive/correlationoptimizer5.q.out 6ba3462
> ql/src/test/results/clientpositive/correlationoptimizer6.q.out be518dc
> ql/src/test/results/clientpositive/cross_product_check_2.q.out 500f912
> ql/src/test/results/clientpositive/decimal_precision2.q.out dafc2c3
> ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_dynamic.q.out 22cbce9
> ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_static.q.out 96f8b6a
> ql/src/test/results/clientpositive/explain_logical.q.out 9b86ce8
> ql/src/test/results/clientpositive/explain_rearrange.q.out c4a015e
> ql/src/test/results/clientpositive/filter_numeric.q.out b6b8339
> ql/src/test/results/clientpositive/fold_case.q.out de6c43e
> ql/src/test/results/clientpositive/fold_when.q.out 37803e0
> ql/src/test/results/clientpositive/groupby_cube1.q.out 659ac52
> ql/src/test/results/clientpositive/groupby_grouping_sets2.q.out 5acac64
> ql/src/test/results/clientpositive/groupby_grouping_sets3.q.out b96521a
> ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out a00f94b
> ql/src/test/results/clientpositive/groupby_grouping_sets5.q.out b2625fe
> ql/src/test/results/clientpositive/groupby_grouping_sets6.q.out 587a8c3
> ql/src/test/results/clientpositive/groupby_ppd.q.out dbbab88
> ql/src/test/results/clientpositive/groupby_rollup1.q.out faa6583
> ql/src/test/results/clientpositive/groupby_sort_6.q.out c5cb8b9
> ql/src/test/results/clientpositive/having2.q.out 9539394
> ql/src/test/results/clientpositive/identity_project_remove_skip.q.out e7bd0ed
> ql/src/test/results/clientpositive/implicit_cast1.q.out d4bcd64
> ql/src/test/results/clientpositive/index_auto_empty.q.out f824ce5
> ql/src/test/results/clientpositive/index_serde.q.out 182d681
> ql/src/test/results/clientpositive/index_skewtable.q.out fac53e5
> ql/src/test/results/clientpositive/infer_const_type.q.out 09803b4
> ql/src/test/results/clientpositive/input21.q.out f6559f3
> ql/src/test/results/clientpositive/input23.q.out 73038c3
> ql/src/test/results/clientpositive/input24.q.out 63f2b64
> ql/src/test/results/clientpositive/input25.q.out bf9948a
> ql/src/test/results/clientpositive/input26.q.out 1b24aa6
> ql/src/test/results/clientpositive/input9.q.out d1824e5
> ql/src/test/results/clientpositive/input_part4.q.out 1ebf36b
> ql/src/test/results/clientpositive/insert1.q.out 5816a2c
> ql/src/test/results/clientpositive/join19.q.out 2570663
> ql/src/test/results/clientpositive/join29.q.out 63bd035
> ql/src/test/results/clientpositive/join31.q.out ddd4077
> ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out c1e1051
> ql/src/test/results/clientpositive/join_cond_pushdown_unqual2.q.out 678ddb8
> ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out 0adf5d7
> ql/src/test/results/clientpositive/join_cond_pushdown_unqual4.q.out 4668eb1
> ql/src/test/results/clientpositive/join_hive_626.q.out 4e29d42
> ql/src/test/results/clientpositive/join_reorder.q.out c9498bf
> ql/src/test/results/clientpositive/join_reorder2.q.out 0d56a42
> ql/src/test/results/clientpositive/join_reorder3.q.out eb847c2
> ql/src/test/results/clientpositive/join_reorder4.q.out 23f4e4c
> ql/src/test/results/clientpositive/join_view.q.out e703e0b
> ql/src/test/results/clientpositive/keyword_1.q.out a37093d
> ql/src/test/results/clientpositive/lateral_view_explode2.q.out 737d562
> ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out 13e601a
> ql/src/test/results/clientpositive/mapjoin_subquery2.q.out 507c7ca
> ql/src/test/results/clientpositive/merge_join_1.q.out 99c7efe
> ql/src/test/results/clientpositive/mergejoins.q.out 68416a0
> ql/src/test/results/clientpositive/mergejoins_mixed.q.out 6bcc3d5
> ql/src/test/results/clientpositive/metadataonly1.q.out e55efd5
> ql/src/test/results/clientpositive/multiMapJoin1.q.out c00ff29
> ql/src/test/results/clientpositive/multiMapJoin2.q.out 5a07fe0
> ql/src/test/results/clientpositive/multigroupby_singlemr.q.out 4b80693
> ql/src/test/results/clientpositive/nullformatCTAS.q.out 892de6e
> ql/src/test/results/clientpositive/nullgroup3.q.out 7712d4d
> ql/src/test/results/clientpositive/nullgroup5.q.out 8a94d62
> ql/src/test/results/clientpositive/optimize_nullscan.q.out 888af95
> ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out df5ee76
> ql/src/test/results/clientpositive/partition_boolexpr.q.out cfd03e2
> ql/src/test/results/clientpositive/ppd_gby_join.q.out be275bd
> ql/src/test/results/clientpositive/ppd_join.q.out d495a1a
> ql/src/test/results/clientpositive/ppd_join4.q.out 22f84ba
> ql/src/test/results/clientpositive/ppd_join5.q.out 85e357e
> ql/src/test/results/clientpositive/ppd_outer_join2.q.out 681c2ea
> ql/src/test/results/clientpositive/ppd_outer_join3.q.out 75f1020
> ql/src/test/results/clientpositive/ppd_outer_join4.q.out bb5b5cf
> ql/src/test/results/clientpositive/ppd_outer_join5.q.out 43c792f
> ql/src/test/results/clientpositive/ppd_repeated_alias.q.out 7d3482b
> ql/src/test/results/clientpositive/ppd_udf_col.q.out c3e7d1b
> ql/src/test/results/clientpositive/ppd_union_view.q.out a13ef7a
> ql/src/test/results/clientpositive/ql_rewrite_gbtoidx.q.out 0a3c427
> ql/src/test/results/clientpositive/ql_rewrite_gbtoidx_cbo_1.q.out 5ca966f
> ql/src/test/results/clientpositive/ql_rewrite_gbtoidx_cbo_2.q.out 381e58f
> ql/src/test/results/clientpositive/query_result_fileformat.q.out 3848bd4
> ql/src/test/results/clientpositive/quote1.q.out 20f754f
> ql/src/test/results/clientpositive/quotedid_basic.q.out 507369c
> ql/src/test/results/clientpositive/quotedid_skew.q.out f604cdd
> ql/src/test/results/clientpositive/reduce_deduplicate.q.out fa714b8
> ql/src/test/results/clientpositive/runtime_skewjoin_mapjoin_spark.q.out 889a9d0
> ql/src/test/results/clientpositive/sample6.q.out 9891cbb
> ql/src/test/results/clientpositive/select_dummy_source.q.out b1f0939
> ql/src/test/results/clientpositive/semijoin.q.out 97eb9fb
> ql/src/test/results/clientpositive/skewjoin.q.out 27f2ffc
> ql/src/test/results/clientpositive/skewjoin_mapjoin1.q.out 9f10861
> ql/src/test/results/clientpositive/skewjoin_mapjoin10.q.out 27b1aee
> ql/src/test/results/clientpositive/skewjoin_mapjoin11.q.out dd084e8
> ql/src/test/results/clientpositive/skewjoin_mapjoin2.q.out 7e3046f
> ql/src/test/results/clientpositive/skewjoin_mapjoin3.q.out 40e4de2
> ql/src/test/results/clientpositive/skewjoin_mapjoin4.q.out b7c12f9
> ql/src/test/results/clientpositive/skewjoin_mapjoin5.q.out 7c04a9d
> ql/src/test/results/clientpositive/skewjoin_mapjoin6.q.out d3183f8
> ql/src/test/results/clientpositive/skewjoin_mapjoin7.q.out aaf7de3
> ql/src/test/results/clientpositive/skewjoin_mapjoin8.q.out 5d1a3e8
> ql/src/test/results/clientpositive/skewjoin_mapjoin9.q.out c7271b0
> ql/src/test/results/clientpositive/skewjoin_union_remove_1.q.out c67b681
> ql/src/test/results/clientpositive/skewjoin_union_remove_2.q.out 2979c42
> ql/src/test/results/clientpositive/skewjoinopt1.q.out 61e9a8e
> ql/src/test/results/clientpositive/skewjoinopt10.q.out 90925a0
> ql/src/test/results/clientpositive/skewjoinopt11.q.out 2504c17
> ql/src/test/results/clientpositive/skewjoinopt12.q.out 5ac7677
> ql/src/test/results/clientpositive/skewjoinopt13.q.out d6ede51
> ql/src/test/results/clientpositive/skewjoinopt14.q.out 8a4802e
> ql/src/test/results/clientpositive/skewjoinopt15.q.out 3abf5b7
> ql/src/test/results/clientpositive/skewjoinopt16.q.out 894a265
> ql/src/test/results/clientpositive/skewjoinopt17.q.out d27929f
> ql/src/test/results/clientpositive/skewjoinopt18.q.out 33a0ed9
> ql/src/test/results/clientpositive/skewjoinopt19.q.out fd43409
> ql/src/test/results/clientpositive/skewjoinopt2.q.out d613f10
> ql/src/test/results/clientpositive/skewjoinopt20.q.out a28e433
> ql/src/test/results/clientpositive/skewjoinopt3.q.out bd87ccd
> ql/src/test/results/clientpositive/skewjoinopt4.q.out 47f5a92
> ql/src/test/results/clientpositive/skewjoinopt5.q.out d46214c
> ql/src/test/results/clientpositive/skewjoinopt6.q.out c42a3ef
> ql/src/test/results/clientpositive/skewjoinopt7.q.out 97482f0
> ql/src/test/results/clientpositive/skewjoinopt8.q.out 244c2be
> ql/src/test/results/clientpositive/skewjoinopt9.q.out f877e56
> ql/src/test/results/clientpositive/smb_mapjoin9.q.out cbaf7e1
> ql/src/test/results/clientpositive/spark/auto_join27.q.out 0ae494e
> ql/src/test/results/clientpositive/spark/auto_join32.q.out c537b95
> ql/src/test/results/clientpositive/spark/auto_join_stats.q.out 1fa1a74
> ql/src/test/results/clientpositive/spark/auto_join_stats2.q.out c6473d3
> ql/src/test/results/clientpositive/spark/auto_sortmerge_join_10.q.out 2b245fb
> ql/src/test/results/clientpositive/spark/auto_sortmerge_join_12.q.out 8102ec1
> ql/src/test/results/clientpositive/spark/bucket_map_join_1.q.out 4e8ce0d
> ql/src/test/results/clientpositive/spark/bucket_map_join_2.q.out c0a3c3d
> ql/src/test/results/clientpositive/spark/bucketmapjoin1.q.out 44f4d0c
> ql/src/test/results/clientpositive/spark/column_access_stats.q.out 3e16f61
> ql/src/test/results/clientpositive/spark/groupby_cube1.q.out 8191b64
> ql/src/test/results/clientpositive/spark/groupby_rollup1.q.out 25029d0
> ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out cfbce61
> ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out 9343805
> ql/src/test/results/clientpositive/spark/insert1.q.out ba8876f
> ql/src/test/results/clientpositive/spark/join19.q.out f84ce2d
> ql/src/test/results/clientpositive/spark/join34.q.out 54b7ba0
> ql/src/test/results/clientpositive/spark/join35.q.out 3d14a79
> ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual1.q.out 687f2e9
> ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual2.q.out 949fdee
> ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual3.q.out 2d70084
> ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual4.q.out 3de2aed
> ql/src/test/results/clientpositive/spark/join_hive_626.q.out bb65240
> ql/src/test/results/clientpositive/spark/join_reorder.q.out 69b90b5
> ql/src/test/results/clientpositive/spark/join_reorder2.q.out 9f9104c
> ql/src/test/results/clientpositive/spark/join_reorder3.q.out 9813110
> ql/src/test/results/clientpositive/spark/join_reorder4.q.out 5cc30f7
> ql/src/test/results/clientpositive/spark/join_view.q.out f6e0542
> ql/src/test/results/clientpositive/spark/lateral_view_explode2.q.out 41d60f5
> ql/src/test/results/clientpositive/spark/load_dyn_part13.q.out 51e57e8
> ql/src/test/results/clientpositive/spark/load_dyn_part14.q.out ca36ac6
> ql/src/test/results/clientpositive/spark/mapjoin_subquery2.q.out 06b2cbe
> ql/src/test/results/clientpositive/spark/mergejoins.q.out 86ee699
> ql/src/test/results/clientpositive/spark/mergejoins_mixed.q.out 8dcf5ac
> ql/src/test/results/clientpositive/spark/multi_insert.q.out 137082a
> ql/src/test/results/clientpositive/spark/multi_insert_move_tasks_share_dependencies.q.out 4645a65
> ql/src/test/results/clientpositive/spark/multi_join_union.q.out bda569d
> ql/src/test/results/clientpositive/spark/multigroupby_singlemr.q.out c1480e3
> ql/src/test/results/clientpositive/spark/optimize_nullscan.q.out b5eff31
> ql/src/test/results/clientpositive/spark/ppd_gby_join.q.out e76f9cf
> ql/src/test/results/clientpositive/spark/ppd_join.q.out 2925a83
> ql/src/test/results/clientpositive/spark/ppd_join4.q.out 193311a
> ql/src/test/results/clientpositive/spark/ppd_join5.q.out 5943e7c
> ql/src/test/results/clientpositive/spark/ppd_outer_join1.q.out 7c10afe
> ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out c70133e
> ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out 9bcacb3
> ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out 690a9e3
> ql/src/test/results/clientpositive/spark/ql_rewrite_gbtoidx.q.out 45712d6
> ql/src/test/results/clientpositive/spark/ql_rewrite_gbtoidx_cbo_1.q.out aec0204
> ql/src/test/results/clientpositive/spark/reduce_deduplicate.q.out 7b92c73
> ql/src/test/results/clientpositive/spark/runtime_skewjoin_mapjoin_spark.q.out 2348058
> ql/src/test/results/clientpositive/spark/sample6.q.out 4117732
> ql/src/test/results/clientpositive/spark/semijoin.q.out 96edf5f
> ql/src/test/results/clientpositive/spark/skewjoin.q.out 35d4f6f
> ql/src/test/results/clientpositive/spark/skewjoin_union_remove_1.q.out 0ce2bb9
> ql/src/test/results/clientpositive/spark/skewjoin_union_remove_2.q.out 3d629be
> ql/src/test/results/clientpositive/spark/skewjoinopt1.q.out 93e08eb
> ql/src/test/results/clientpositive/spark/skewjoinopt10.q.out a30ccc9
> ql/src/test/results/clientpositive/spark/skewjoinopt11.q.out 2dfe692
> ql/src/test/results/clientpositive/spark/skewjoinopt12.q.out 667ec5c
> ql/src/test/results/clientpositive/spark/skewjoinopt13.q.out 88d84c4
> ql/src/test/results/clientpositive/spark/skewjoinopt14.q.out 5bc8a76
> ql/src/test/results/clientpositive/spark/skewjoinopt15.q.out 3ac7511
> ql/src/test/results/clientpositive/spark/skewjoinopt16.q.out 46a28de
> ql/src/test/results/clientpositive/spark/skewjoinopt17.q.out 8c7d620
> ql/src/test/results/clientpositive/spark/skewjoinopt18.q.out 60c4677
> ql/src/test/results/clientpositive/spark/skewjoinopt19.q.out eb9bb84
> ql/src/test/results/clientpositive/spark/skewjoinopt2.q.out 1c5f36d
> ql/src/test/results/clientpositive/spark/skewjoinopt20.q.out 22de156
> ql/src/test/results/clientpositive/spark/skewjoinopt3.q.out 0707b4c
> ql/src/test/results/clientpositive/spark/skewjoinopt4.q.out cff75a6
> ql/src/test/results/clientpositive/spark/skewjoinopt5.q.out 3c4cb67
> ql/src/test/results/clientpositive/spark/skewjoinopt6.q.out 16a218b
> ql/src/test/results/clientpositive/spark/skewjoinopt7.q.out bba46c0
> ql/src/test/results/clientpositive/spark/skewjoinopt8.q.out 7c8328f
> ql/src/test/results/clientpositive/spark/skewjoinopt9.q.out 4c789cf
> ql/src/test/results/clientpositive/spark/stats1.q.out fa8d05f
> ql/src/test/results/clientpositive/spark/stats12.q.out 0e25ac1
> ql/src/test/results/clientpositive/spark/stats13.q.out 4934aec
> ql/src/test/results/clientpositive/spark/stats2.q.out ad7ba0d
> ql/src/test/results/clientpositive/spark/stats7.q.out 32b09a0
> ql/src/test/results/clientpositive/spark/stats8.q.out 54eb2a1
> ql/src/test/results/clientpositive/spark/subquery_multiinsert.q.java1.7.out 92a8595
> ql/src/test/results/clientpositive/spark/temp_table.q.out 16d663d
> ql/src/test/results/clientpositive/spark/transform1.q.out 4a79875
> ql/src/test/results/clientpositive/spark/udf_in_file.q.out c769d1f
> ql/src/test/results/clientpositive/spark/union.q.out f2bd7b0
> ql/src/test/results/clientpositive/spark/union10.q.out 3138618
> ql/src/test/results/clientpositive/spark/union11.q.out 2689bb6
> ql/src/test/results/clientpositive/spark/union12.q.out cd21b73
> ql/src/test/results/clientpositive/spark/union13.q.out b995d22
> ql/src/test/results/clientpositive/spark/union14.q.out 4027393
> ql/src/test/results/clientpositive/spark/union15.q.out fcc1cf7
> ql/src/test/results/clientpositive/spark/union16.q.out 51ba287
> ql/src/test/results/clientpositive/spark/union17.q.out 4b0b682
> ql/src/test/results/clientpositive/spark/union18.q.out 3e25a49
> ql/src/test/results/clientpositive/spark/union19.q.out b6b172f
> ql/src/test/results/clientpositive/spark/union2.q.out 3ab9069
> ql/src/test/results/clientpositive/spark/union20.q.out d1e23f6
> ql/src/test/results/clientpositive/spark/union21.q.out 8a26f5e
> ql/src/test/results/clientpositive/spark/union22.q.out 4cb7bf0
> ql/src/test/results/clientpositive/spark/union23.q.out dda7234
> ql/src/test/results/clientpositive/spark/union24.q.out 22ec159
> ql/src/test/results/clientpositive/spark/union25.q.out 67416a3
> ql/src/test/results/clientpositive/spark/union26.q.out fa996ed
> ql/src/test/results/clientpositive/spark/union27.q.out e66db27
> ql/src/test/results/clientpositive/spark/union28.q.out 0294bad
> ql/src/test/results/clientpositive/spark/union29.q.out daa581f
> ql/src/test/results/clientpositive/spark/union3.q.out 25e78e3
> ql/src/test/results/clientpositive/spark/union30.q.out b9b59d4
> ql/src/test/results/clientpositive/spark/union31.q.out d58d17c
> ql/src/test/results/clientpositive/spark/union32.q.out c8909a5
> ql/src/test/results/clientpositive/spark/union33.q.out 2de2984
> ql/src/test/results/clientpositive/spark/union34.q.out d5e7e4a
> ql/src/test/results/clientpositive/spark/union4.q.out a7308ec
> ql/src/test/results/clientpositive/spark/union5.q.out f8cd94b
> ql/src/test/results/clientpositive/spark/union6.q.out f2c3411
> ql/src/test/results/clientpositive/spark/union7.q.out 73042d6
> ql/src/test/results/clientpositive/spark/union8.q.out 2766dc2
> ql/src/test/results/clientpositive/spark/union9.q.out 73cf3d5
> ql/src/test/results/clientpositive/spark/union_lateralview.q.out 126ca0c
> ql/src/test/results/clientpositive/spark/union_ppr.q.out 5d77bef
> ql/src/test/results/clientpositive/spark/union_remove_1.q.out 027ede7
> ql/src/test/results/clientpositive/spark/union_remove_10.q.out 2bc06d3
> ql/src/test/results/clientpositive/spark/union_remove_11.q.out 76cd688
> ql/src/test/results/clientpositive/spark/union_remove_12.q.out 81f815f
> ql/src/test/results/clientpositive/spark/union_remove_13.q.out bf25b54
> ql/src/test/results/clientpositive/spark/union_remove_14.q.out 8259c08
> ql/src/test/results/clientpositive/spark/union_remove_15.q.out 1f1e3c8
> ql/src/test/results/clientpositive/spark/union_remove_16.q.out f17b7a4
> ql/src/test/results/clientpositive/spark/union_remove_17.q.out 9704d0f
> ql/src/test/results/clientpositive/spark/union_remove_18.q.out 4b71e77
> ql/src/test/results/clientpositive/spark/union_remove_19.q.out 290d11a
> ql/src/test/results/clientpositive/spark/union_remove_2.q.out 06d4ad8
> ql/src/test/results/clientpositive/spark/union_remove_20.q.out bd8f9d7
> ql/src/test/results/clientpositive/spark/union_remove_21.q.out 9379e34
> ql/src/test/results/clientpositive/spark/union_remove_22.q.out 8fe568a
> ql/src/test/results/clientpositive/spark/union_remove_23.q.out 4add1d6
> ql/src/test/results/clientpositive/spark/union_remove_24.q.out 881e4ed
> ql/src/test/results/clientpositive/spark/union_remove_25.q.out 5853cc0
> ql/src/test/results/clientpositive/spark/union_remove_3.q.out df17b35
> ql/src/test/results/clientpositive/spark/union_remove_4.q.out 5d6dd88
> ql/src/test/results/clientpositive/spark/union_remove_5.q.out 554cffc
> ql/src/test/results/clientpositive/spark/union_remove_6.q.out ea0a1a0
> ql/src/test/results/clientpositive/spark/union_remove_6_subq.q.out 977d0f5
> ql/src/test/results/clientpositive/spark/union_remove_7.q.out d8f4c03
> ql/src/test/results/clientpositive/spark/union_remove_8.q.out 994552e
> ql/src/test/results/clientpositive/spark/union_remove_9.q.out a16ca19
> ql/src/test/results/clientpositive/spark/union_top_level.q.out a64fc95
> ql/src/test/results/clientpositive/spark/union_view.q.out 2ca9e13
> ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out a4b8e05
> ql/src/test/results/clientpositive/stats12.q.out f8aa4d0
> ql/src/test/results/clientpositive/stats13.q.out 10ecfd2
> ql/src/test/results/clientpositive/stats2.q.out 694c1a2
> ql/src/test/results/clientpositive/stats7.q.out 1162103
> ql/src/test/results/clientpositive/stats8.q.out 11b2010
> ql/src/test/results/clientpositive/subq_where_serialization.q.out 94d3685
> ql/src/test/results/clientpositive/subquery_in_having.q.out 862c6ad
> ql/src/test/results/clientpositive/subquery_multiinsert.q.java1.7.out 4f8ad0a
> ql/src/test/results/clientpositive/subquery_notin.q.out 733e8ff
> ql/src/test/results/clientpositive/subquery_notin_having.q.java1.7.out 2d5b486
> ql/src/test/results/clientpositive/subquery_unqual_corr_expr.q.out e3dd5ed
> ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out cf22ca6
> ql/src/test/results/clientpositive/subquery_views.q.out e495acc
> ql/src/test/results/clientpositive/symlink_text_input_format.q.out 6e3b31f
> ql/src/test/results/clientpositive/tez/auto_sortmerge_join_10.q.out 28268fc
> ql/src/test/results/clientpositive/tez/auto_sortmerge_join_12.q.out 8c8a3bf
> ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out 8b3d637
> ql/src/test/results/clientpositive/tez/dynamic_partition_pruning_2.q.out 8c8531c
> ql/src/test/results/clientpositive/tez/explainuser_1.q.out b684858
> ql/src/test/results/clientpositive/tez/explainuser_2.q.out f84524b
> ql/src/test/results/clientpositive/tez/hybridgrace_hashjoin_2.q.out 4ad143c
> ql/src/test/results/clientpositive/tez/mergejoin.q.out 97df12a
> ql/src/test/results/clientpositive/tez/metadataonly1.q.out 2850314
> ql/src/test/results/clientpositive/tez/optimize_nullscan.q.out 2c7528e
> ql/src/test/results/clientpositive/tez/selectDistinctStar.q.out f387cd0
> ql/src/test/results/clientpositive/tez/skewjoin.q.out ab2ce24
> ql/src/test/results/clientpositive/tez/temp_table.q.out 1bf4085
> ql/src/test/results/clientpositive/tez/tez_join.q.out b87b71c
> ql/src/test/results/clientpositive/tez/tez_join_hash.q.out c4bec62
> ql/src/test/results/clientpositive/tez/tez_smb_main.q.out 6183390
> ql/src/test/results/clientpositive/tez/tez_union.q.out 4c9368e
> ql/src/test/results/clientpositive/tez/tez_union2.q.out 4e4ed9f
> ql/src/test/results/clientpositive/tez/tez_union_group_by.q.out 654b34b
> ql/src/test/results/clientpositive/tez/tez_union_multiinsert.q.out e67bf3e
> ql/src/test/results/clientpositive/tez/transform1.q.out 718f128
> ql/src/test/results/clientpositive/tez/union2.q.out f3c5723
> ql/src/test/results/clientpositive/tez/union3.q.out 79e29a5
> ql/src/test/results/clientpositive/tez/union4.q.out e28af5e
> ql/src/test/results/clientpositive/tez/union5.q.out c771747
> ql/src/test/results/clientpositive/tez/union6.q.out 9d24ea1
> ql/src/test/results/clientpositive/tez/union7.q.out 2e07bad
> ql/src/test/results/clientpositive/tez/union8.q.out 3ee38b2
> ql/src/test/results/clientpositive/tez/union9.q.out e6464a0
> ql/src/test/results/clientpositive/tez/unionDistinct_1.q.out 9940e4b
> ql/src/test/results/clientpositive/tez/vector_bucket.q.out 410212a
> ql/src/test/results/clientpositive/tez/vector_date_1.q.out 8d1192a
> ql/src/test/results/clientpositive/tez/vector_interval_2.q.out 0f32cee
> ql/src/test/results/clientpositive/tez/vector_leftsemi_mapjoin.q.out 564f59d
> ql/src/test/results/clientpositive/tez/vector_mr_diff_schema_alias.q.out fafccdc
> ql/src/test/results/clientpositive/tez/vectorization_short_regress.q.out a3c723d
> ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out fd6c629
> ql/src/test/results/clientpositive/timestamp_literal.q.out 13ffaf1
> ql/src/test/results/clientpositive/transform1.q.out 9382cf0
> ql/src/test/results/clientpositive/type_widening.q.out e6617d4
> ql/src/test/results/clientpositive/udf_add_months.q.out 8c37fc2
> ql/src/test/results/clientpositive/udf_bitwise_shiftleft.q.out 6703d95
> ql/src/test/results/clientpositive/udf_bitwise_shiftright.q.out dbfe390
> ql/src/test/results/clientpositive/udf_bitwise_shiftrightunsigned.q.out c20029e
> ql/src/test/results/clientpositive/udf_cbrt.q.out 4cdaf15
> ql/src/test/results/clientpositive/udf_current_database.q.out e22165e
> ql/src/test/results/clientpositive/udf_date_format.q.out acca21e
> ql/src/test/results/clientpositive/udf_decode.q.out 107712a
> ql/src/test/results/clientpositive/udf_factorial.q.out b9b7bf9
> ql/src/test/results/clientpositive/udf_from_utc_timestamp.q.out 4df872c
> ql/src/test/results/clientpositive/udf_in_file.q.out 5564890
> ql/src/test/results/clientpositive/udf_last_day.q.out 2d39e38
> ql/src/test/results/clientpositive/udf_length.q.out f4b0b18
> ql/src/test/results/clientpositive/udf_levenshtein.q.out 1a60822
> ql/src/test/results/clientpositive/udf_md5.q.out 01744fe
> ql/src/test/results/clientpositive/udf_months_between.q.out 95f756f
> ql/src/test/results/clientpositive/udf_quarter.q.out b29ba4a
> ql/src/test/results/clientpositive/udf_soundex.q.out 9895a90
> ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out e70b401
> ql/src/test/results/clientpositive/udf_trunc.q.out 6cc18c2
> ql/src/test/results/clientpositive/udtf_stack.q.out 4e9c2fd
> ql/src/test/results/clientpositive/union10.q.out 53490e6
> ql/src/test/results/clientpositive/union11.q.out c77a766
> ql/src/test/results/clientpositive/union12.q.out d65086b
> ql/src/test/results/clientpositive/union14.q.out 5bd1556
> ql/src/test/results/clientpositive/union15.q.out 55d5510
> ql/src/test/results/clientpositive/union17.q.out 56b335a
> ql/src/test/results/clientpositive/union18.q.out a76d7fd
> ql/src/test/results/clientpositive/union19.q.out da94293
> ql/src/test/results/clientpositive/union20.q.out b80ec1e
> ql/src/test/results/clientpositive/union21.q.out b24c276
> ql/src/test/results/clientpositive/union22.q.out 9115287
> ql/src/test/results/clientpositive/union4.q.out b7f03ea
> ql/src/test/results/clientpositive/union5.q.out 0b0d7c6
> ql/src/test/results/clientpositive/union7.q.out 5be3185
> ql/src/test/results/clientpositive/unionDistinct_1.q.out c102b46
> ql/src/test/results/clientpositive/union_remove_1.q.out f30f39b
> ql/src/test/results/clientpositive/union_remove_10.q.out e720c37
> ql/src/test/results/clientpositive/union_remove_11.q.out 571b398
> ql/src/test/results/clientpositive/union_remove_12.q.out 4d6f4a1
> ql/src/test/results/clientpositive/union_remove_13.q.out a558967
> ql/src/test/results/clientpositive/union_remove_14.q.out 1502749
> ql/src/test/results/clientpositive/union_remove_15.q.out 2b3c109
> ql/src/test/results/clientpositive/union_remove_16.q.out ef32e1c
> ql/src/test/results/clientpositive/union_remove_17.q.out 56b22d9
> ql/src/test/results/clientpositive/union_remove_18.q.out 80971dd
> ql/src/test/results/clientpositive/union_remove_19.q.out 030c5ce
> ql/src/test/results/clientpositive/union_remove_2.q.out 1593029
> ql/src/test/results/clientpositive/union_remove_20.q.out fc8464d
> ql/src/test/results/clientpositive/union_remove_21.q.out 842e67f
> ql/src/test/results/clientpositive/union_remove_22.q.out 71054ae
> ql/src/test/results/clientpositive/union_remove_23.q.out 96e7d3d
> ql/src/test/results/clientpositive/union_remove_24.q.out d9e86bf
> ql/src/test/results/clientpositive/union_remove_25.q.out 0435ad5
> ql/src/test/results/clientpositive/union_remove_3.q.out 0de46d0
> ql/src/test/results/clientpositive/union_remove_4.q.out b83a0a8
> ql/src/test/results/clientpositive/union_remove_5.q.out 81e64b4
> ql/src/test/results/clientpositive/union_remove_6.q.out 215e90e
> ql/src/test/results/clientpositive/union_remove_6_subq.q.out 2661bcb
> ql/src/test/results/clientpositive/union_remove_7.q.out 4feb092
> ql/src/test/results/clientpositive/union_remove_8.q.out 5d22aa5
> ql/src/test/results/clientpositive/union_remove_9.q.out 7380d12
> ql/src/test/results/clientpositive/union_view.q.out 9181e9b
> ql/src/test/results/clientpositive/vector_bucket.q.out 1ac37a7
> ql/src/test/results/clientpositive/vector_date_1.q.out 5ed7424
> ql/src/test/results/clientpositive/vector_interval_2.q.out b70ef7a
> ql/src/test/results/clientpositive/vector_leftsemi_mapjoin.q.out 23a8adb
> ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out 27af52c
> ql/src/test/results/clientpositive/vector_mr_diff_schema_alias.q.out 59985cb
> ql/src/test/results/clientpositive/vector_multi_insert.q.out 2fcacad
> ql/src/test/results/clientpositive/vectorization_short_regress.q.out b9ab174
>
> Diff: https://reviews.apache.org/r/34143/diff/
>
>
> Testing
> -------
>
>
> Thanks,
>
> pengcheng xiong
>
>
Re: Review Request 34143: Fix stats annotation
Posted by pengcheng xiong <px...@hortonworks.com>.
> On May 20, 2015, 1 a.m., Ashutosh Chauhan wrote:
> > ql/src/test/results/clientpositive/spark/union24.q.out, line 212
> > <https://reviews.apache.org/r/34143/diff/2/?file=959957#file959957line212>
> >
> > File Sink has more 3 times more rows than Select. I was expecting it to be same as select.
this is because file sink has 3 parents after union is removed.
> On May 20, 2015, 1 a.m., Ashutosh Chauhan wrote:
> > ql/src/test/results/clientpositive/spark/union25.q.out, line 87
> > <https://reviews.apache.org/r/34143/diff/2/?file=959958#file959958line87>
> >
> > Group by should result in reduction of # of rows. No of rows instead doubled.
the same reason, 2SEL-SEL-GRY, both sel and GRY has 2 parents.
> On May 20, 2015, 1 a.m., Ashutosh Chauhan wrote:
> > ql/src/test/results/clientpositive/spark/union25.q.out, line 106
> > <https://reviews.apache.org/r/34143/diff/2/?file=959958#file959958line106>
> >
> > Select operator after select operator. Should be same (or less). Instead doubled.
more details
Union 5 [SIMPLE_EDGE]
|<-Map 4 [CONTAINS]
| Reduce Output Operator [RS_12]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
| Statistics:Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
| Group By Operator [GBY_11]
| keys:_col0 (type: string)
| outputColumnNames:["_col0"]
| Statistics:Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
| Select Operator [SEL_10]
| outputColumnNames:["_col0"]
| Statistics:Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
| Select Operator [SEL_5]
| outputColumnNames:["_col0"]
| Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
| TableScan [TS_3]
| alias:a
| Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
|<-Map 7 [CONTAINS]
Reduce Output Operator [RS_12]
key expressions:_col0 (type: string)
Map-reduce partition columns:_col0 (type: string)
sort order:+
Statistics:Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
Group By Operator [GBY_11]
keys:_col0 (type: string)
outputColumnNames:["_col0"]
Statistics:Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
Select Operator [SEL_10]
outputColumnNames:["_col0"]
Statistics:Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
Select Operator [SEL_8]
outputColumnNames:["_col0"]
Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
TableScan [TS_6]
alias:b
Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
> On May 20, 2015, 1 a.m., Ashutosh Chauhan wrote:
> > ql/src/test/results/clientpositive/spark/union26.q.out, line 156
> > <https://reviews.apache.org/r/34143/diff/2/?file=959959#file959959line156>
> >
> > join followed by gby. Gby should have lesser # of rows. Instead it increased to 5 times.
Lateral View Join Operator with union.
> On May 20, 2015, 1 a.m., Ashutosh Chauhan wrote:
> > ql/src/test/results/clientpositive/spark/union30.q.out, line 193
> > <https://reviews.apache.org/r/34143/diff/2/?file=959964#file959964line193>
> >
> > cascade of select operator. With each one increasing # of rows, looks wrong.
add up of the parents of 1000 and 500.
- pengcheng
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/34143/#review84416
-----------------------------------------------------------
On May 14, 2015, 4:50 p.m., pengcheng xiong wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/34143/
> -----------------------------------------------------------
>
> (Updated May 14, 2015, 4:50 p.m.)
>
>
> Review request for hive, Ashutosh Chauhan and John Pullokkaran.
>
>
> Repository: hive-git
>
>
> Description
> -------
>
> This is a umbrella patch for a bunch of issues: HIVE-8769 Physical optimizer : Incorrect CE results in a shuffle join instead of a Map join (PK/FK pattern not detected) HIVE-9392 JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column names having duplicated fqColumnName HIVE-10107 Union All : Vertex missing stats resulting in OOM and in-efficient plans
>
>
> Diffs
> -----
>
> hbase-handler/src/test/results/positive/external_table_ppd.q.out 6d48edb
> hbase-handler/src/test/results/positive/hbase_custom_key2.q.out c9b5a84
> hbase-handler/src/test/results/positive/hbase_custom_key3.q.out 76848e0
> hbase-handler/src/test/results/positive/hbase_ppd_key_range.q.out 6174bfb
> hbase-handler/src/test/results/positive/hbase_pushdown.q.out 8a979bf
> hbase-handler/src/test/results/positive/hbase_queries.q.out 7863f69
> hbase-handler/src/test/results/positive/hbase_timestamp.q.out 3aae7d0
> hbase-handler/src/test/results/positive/ppd_key_ranges.q.out 5936735
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/RelOptHiveTable.java 0de7488
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/stats/annotation/StatsRulesProcFactory.java 44269f0
> ql/src/java/org/apache/hadoop/hive/ql/plan/AbstractOperatorDesc.java 0a83440
> ql/src/java/org/apache/hadoop/hive/ql/plan/ColStatistics.java c420190
> ql/src/java/org/apache/hadoop/hive/ql/plan/Statistics.java f66279f
> ql/src/java/org/apache/hadoop/hive/ql/stats/StatsUtils.java 508d880
> ql/src/test/results/clientpositive/annotate_stats_filter.q.out e8cd06d
> ql/src/test/results/clientpositive/annotate_stats_limit.q.out 5f8b6f8
> ql/src/test/results/clientpositive/annotate_stats_part.q.out 241192b
> ql/src/test/results/clientpositive/annotate_stats_select.q.out 753ab4e
> ql/src/test/results/clientpositive/annotate_stats_table.q.out 9bf82ac
> ql/src/test/results/clientpositive/auto_join30.q.out b068493
> ql/src/test/results/clientpositive/auto_join31.q.out 1e19dd0
> ql/src/test/results/clientpositive/auto_join32.q.out bfc8be8
> ql/src/test/results/clientpositive/auto_join_stats.q.out 9100762
> ql/src/test/results/clientpositive/auto_join_stats2.q.out ed09875
> ql/src/test/results/clientpositive/auto_join_without_localtask.q.out ce4ad8a
> ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out 383defd
> ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out e9fb705
> ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out 43504d8
> ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out afd5518
> ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out c089419
> ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out 6e443fa
> ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out feaea04
> ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out f64ecf0
> ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out f039dda
> ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out e89f548
> ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out 44c037f
> ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out 65aa3ef
> ql/src/test/results/clientpositive/binarysortable_1.q.out c4ba7e0
> ql/src/test/results/clientpositive/bucket_map_join_1.q.out d778203
> ql/src/test/results/clientpositive/bucket_map_join_2.q.out aef77aa
> ql/src/test/results/clientpositive/bucketmapjoin1.q.out 72f2a07
> ql/src/test/results/clientpositive/bucketsortoptimize_insert_2.q.out eec099c
> ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out 1a644a9
> ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out e4f90e4
> ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out 307c83b
> ql/src/test/results/clientpositive/column_access_stats.q.out a779564
> ql/src/test/results/clientpositive/complex_alias.q.out 133ce91
> ql/src/test/results/clientpositive/correlationoptimizer1.q.out 0eb1596
> ql/src/test/results/clientpositive/correlationoptimizer10.q.out 3c3564d
> ql/src/test/results/clientpositive/correlationoptimizer11.q.out bd86942
> ql/src/test/results/clientpositive/correlationoptimizer15.q.out b57203e
> ql/src/test/results/clientpositive/correlationoptimizer2.q.out 43d209f
> ql/src/test/results/clientpositive/correlationoptimizer3.q.out 5389647
> ql/src/test/results/clientpositive/correlationoptimizer4.q.out b350816
> ql/src/test/results/clientpositive/correlationoptimizer5.q.out 6ba3462
> ql/src/test/results/clientpositive/correlationoptimizer6.q.out be518dc
> ql/src/test/results/clientpositive/cross_product_check_2.q.out 500f912
> ql/src/test/results/clientpositive/decimal_precision2.q.out dafc2c3
> ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_dynamic.q.out 22cbce9
> ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_static.q.out 96f8b6a
> ql/src/test/results/clientpositive/explain_logical.q.out 9b86ce8
> ql/src/test/results/clientpositive/explain_rearrange.q.out c4a015e
> ql/src/test/results/clientpositive/filter_numeric.q.out b6b8339
> ql/src/test/results/clientpositive/fold_case.q.out de6c43e
> ql/src/test/results/clientpositive/fold_when.q.out 37803e0
> ql/src/test/results/clientpositive/groupby_cube1.q.out 659ac52
> ql/src/test/results/clientpositive/groupby_grouping_sets2.q.out 5acac64
> ql/src/test/results/clientpositive/groupby_grouping_sets3.q.out b96521a
> ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out a00f94b
> ql/src/test/results/clientpositive/groupby_grouping_sets5.q.out b2625fe
> ql/src/test/results/clientpositive/groupby_grouping_sets6.q.out 587a8c3
> ql/src/test/results/clientpositive/groupby_ppd.q.out dbbab88
> ql/src/test/results/clientpositive/groupby_rollup1.q.out faa6583
> ql/src/test/results/clientpositive/groupby_sort_6.q.out c5cb8b9
> ql/src/test/results/clientpositive/having2.q.out 9539394
> ql/src/test/results/clientpositive/identity_project_remove_skip.q.out e7bd0ed
> ql/src/test/results/clientpositive/implicit_cast1.q.out d4bcd64
> ql/src/test/results/clientpositive/index_auto_empty.q.out f824ce5
> ql/src/test/results/clientpositive/index_serde.q.out 182d681
> ql/src/test/results/clientpositive/index_skewtable.q.out fac53e5
> ql/src/test/results/clientpositive/infer_const_type.q.out 09803b4
> ql/src/test/results/clientpositive/input21.q.out f6559f3
> ql/src/test/results/clientpositive/input23.q.out 73038c3
> ql/src/test/results/clientpositive/input24.q.out 63f2b64
> ql/src/test/results/clientpositive/input25.q.out bf9948a
> ql/src/test/results/clientpositive/input26.q.out 1b24aa6
> ql/src/test/results/clientpositive/input9.q.out d1824e5
> ql/src/test/results/clientpositive/input_part4.q.out 1ebf36b
> ql/src/test/results/clientpositive/insert1.q.out 5816a2c
> ql/src/test/results/clientpositive/join19.q.out 2570663
> ql/src/test/results/clientpositive/join29.q.out 63bd035
> ql/src/test/results/clientpositive/join31.q.out ddd4077
> ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out c1e1051
> ql/src/test/results/clientpositive/join_cond_pushdown_unqual2.q.out 678ddb8
> ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out 0adf5d7
> ql/src/test/results/clientpositive/join_cond_pushdown_unqual4.q.out 4668eb1
> ql/src/test/results/clientpositive/join_hive_626.q.out 4e29d42
> ql/src/test/results/clientpositive/join_reorder.q.out c9498bf
> ql/src/test/results/clientpositive/join_reorder2.q.out 0d56a42
> ql/src/test/results/clientpositive/join_reorder3.q.out eb847c2
> ql/src/test/results/clientpositive/join_reorder4.q.out 23f4e4c
> ql/src/test/results/clientpositive/join_view.q.out e703e0b
> ql/src/test/results/clientpositive/keyword_1.q.out a37093d
> ql/src/test/results/clientpositive/lateral_view_explode2.q.out 737d562
> ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out 13e601a
> ql/src/test/results/clientpositive/mapjoin_subquery2.q.out 507c7ca
> ql/src/test/results/clientpositive/merge_join_1.q.out 99c7efe
> ql/src/test/results/clientpositive/mergejoins.q.out 68416a0
> ql/src/test/results/clientpositive/mergejoins_mixed.q.out 6bcc3d5
> ql/src/test/results/clientpositive/metadataonly1.q.out e55efd5
> ql/src/test/results/clientpositive/multiMapJoin1.q.out c00ff29
> ql/src/test/results/clientpositive/multiMapJoin2.q.out 5a07fe0
> ql/src/test/results/clientpositive/multigroupby_singlemr.q.out 4b80693
> ql/src/test/results/clientpositive/nullformatCTAS.q.out 892de6e
> ql/src/test/results/clientpositive/nullgroup3.q.out 7712d4d
> ql/src/test/results/clientpositive/nullgroup5.q.out 8a94d62
> ql/src/test/results/clientpositive/optimize_nullscan.q.out 888af95
> ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out df5ee76
> ql/src/test/results/clientpositive/partition_boolexpr.q.out cfd03e2
> ql/src/test/results/clientpositive/ppd_gby_join.q.out be275bd
> ql/src/test/results/clientpositive/ppd_join.q.out d495a1a
> ql/src/test/results/clientpositive/ppd_join4.q.out 22f84ba
> ql/src/test/results/clientpositive/ppd_join5.q.out 85e357e
> ql/src/test/results/clientpositive/ppd_outer_join2.q.out 681c2ea
> ql/src/test/results/clientpositive/ppd_outer_join3.q.out 75f1020
> ql/src/test/results/clientpositive/ppd_outer_join4.q.out bb5b5cf
> ql/src/test/results/clientpositive/ppd_outer_join5.q.out 43c792f
> ql/src/test/results/clientpositive/ppd_repeated_alias.q.out 7d3482b
> ql/src/test/results/clientpositive/ppd_udf_col.q.out c3e7d1b
> ql/src/test/results/clientpositive/ppd_union_view.q.out a13ef7a
> ql/src/test/results/clientpositive/ql_rewrite_gbtoidx.q.out 0a3c427
> ql/src/test/results/clientpositive/ql_rewrite_gbtoidx_cbo_1.q.out 5ca966f
> ql/src/test/results/clientpositive/ql_rewrite_gbtoidx_cbo_2.q.out 381e58f
> ql/src/test/results/clientpositive/query_result_fileformat.q.out 3848bd4
> ql/src/test/results/clientpositive/quote1.q.out 20f754f
> ql/src/test/results/clientpositive/quotedid_basic.q.out 507369c
> ql/src/test/results/clientpositive/quotedid_skew.q.out f604cdd
> ql/src/test/results/clientpositive/reduce_deduplicate.q.out fa714b8
> ql/src/test/results/clientpositive/runtime_skewjoin_mapjoin_spark.q.out 889a9d0
> ql/src/test/results/clientpositive/sample6.q.out 9891cbb
> ql/src/test/results/clientpositive/select_dummy_source.q.out b1f0939
> ql/src/test/results/clientpositive/semijoin.q.out 97eb9fb
> ql/src/test/results/clientpositive/skewjoin.q.out 27f2ffc
> ql/src/test/results/clientpositive/skewjoin_mapjoin1.q.out 9f10861
> ql/src/test/results/clientpositive/skewjoin_mapjoin10.q.out 27b1aee
> ql/src/test/results/clientpositive/skewjoin_mapjoin11.q.out dd084e8
> ql/src/test/results/clientpositive/skewjoin_mapjoin2.q.out 7e3046f
> ql/src/test/results/clientpositive/skewjoin_mapjoin3.q.out 40e4de2
> ql/src/test/results/clientpositive/skewjoin_mapjoin4.q.out b7c12f9
> ql/src/test/results/clientpositive/skewjoin_mapjoin5.q.out 7c04a9d
> ql/src/test/results/clientpositive/skewjoin_mapjoin6.q.out d3183f8
> ql/src/test/results/clientpositive/skewjoin_mapjoin7.q.out aaf7de3
> ql/src/test/results/clientpositive/skewjoin_mapjoin8.q.out 5d1a3e8
> ql/src/test/results/clientpositive/skewjoin_mapjoin9.q.out c7271b0
> ql/src/test/results/clientpositive/skewjoin_union_remove_1.q.out c67b681
> ql/src/test/results/clientpositive/skewjoin_union_remove_2.q.out 2979c42
> ql/src/test/results/clientpositive/skewjoinopt1.q.out 61e9a8e
> ql/src/test/results/clientpositive/skewjoinopt10.q.out 90925a0
> ql/src/test/results/clientpositive/skewjoinopt11.q.out 2504c17
> ql/src/test/results/clientpositive/skewjoinopt12.q.out 5ac7677
> ql/src/test/results/clientpositive/skewjoinopt13.q.out d6ede51
> ql/src/test/results/clientpositive/skewjoinopt14.q.out 8a4802e
> ql/src/test/results/clientpositive/skewjoinopt15.q.out 3abf5b7
> ql/src/test/results/clientpositive/skewjoinopt16.q.out 894a265
> ql/src/test/results/clientpositive/skewjoinopt17.q.out d27929f
> ql/src/test/results/clientpositive/skewjoinopt18.q.out 33a0ed9
> ql/src/test/results/clientpositive/skewjoinopt19.q.out fd43409
> ql/src/test/results/clientpositive/skewjoinopt2.q.out d613f10
> ql/src/test/results/clientpositive/skewjoinopt20.q.out a28e433
> ql/src/test/results/clientpositive/skewjoinopt3.q.out bd87ccd
> ql/src/test/results/clientpositive/skewjoinopt4.q.out 47f5a92
> ql/src/test/results/clientpositive/skewjoinopt5.q.out d46214c
> ql/src/test/results/clientpositive/skewjoinopt6.q.out c42a3ef
> ql/src/test/results/clientpositive/skewjoinopt7.q.out 97482f0
> ql/src/test/results/clientpositive/skewjoinopt8.q.out 244c2be
> ql/src/test/results/clientpositive/skewjoinopt9.q.out f877e56
> ql/src/test/results/clientpositive/smb_mapjoin9.q.out cbaf7e1
> ql/src/test/results/clientpositive/spark/auto_join27.q.out 0ae494e
> ql/src/test/results/clientpositive/spark/auto_join32.q.out c537b95
> ql/src/test/results/clientpositive/spark/auto_join_stats.q.out 1fa1a74
> ql/src/test/results/clientpositive/spark/auto_join_stats2.q.out c6473d3
> ql/src/test/results/clientpositive/spark/auto_sortmerge_join_10.q.out 2b245fb
> ql/src/test/results/clientpositive/spark/auto_sortmerge_join_12.q.out 8102ec1
> ql/src/test/results/clientpositive/spark/bucket_map_join_1.q.out 4e8ce0d
> ql/src/test/results/clientpositive/spark/bucket_map_join_2.q.out c0a3c3d
> ql/src/test/results/clientpositive/spark/bucketmapjoin1.q.out 44f4d0c
> ql/src/test/results/clientpositive/spark/column_access_stats.q.out 3e16f61
> ql/src/test/results/clientpositive/spark/groupby_cube1.q.out 8191b64
> ql/src/test/results/clientpositive/spark/groupby_rollup1.q.out 25029d0
> ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out cfbce61
> ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out 9343805
> ql/src/test/results/clientpositive/spark/insert1.q.out ba8876f
> ql/src/test/results/clientpositive/spark/join19.q.out f84ce2d
> ql/src/test/results/clientpositive/spark/join34.q.out 54b7ba0
> ql/src/test/results/clientpositive/spark/join35.q.out 3d14a79
> ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual1.q.out 687f2e9
> ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual2.q.out 949fdee
> ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual3.q.out 2d70084
> ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual4.q.out 3de2aed
> ql/src/test/results/clientpositive/spark/join_hive_626.q.out bb65240
> ql/src/test/results/clientpositive/spark/join_reorder.q.out 69b90b5
> ql/src/test/results/clientpositive/spark/join_reorder2.q.out 9f9104c
> ql/src/test/results/clientpositive/spark/join_reorder3.q.out 9813110
> ql/src/test/results/clientpositive/spark/join_reorder4.q.out 5cc30f7
> ql/src/test/results/clientpositive/spark/join_view.q.out f6e0542
> ql/src/test/results/clientpositive/spark/lateral_view_explode2.q.out 41d60f5
> ql/src/test/results/clientpositive/spark/load_dyn_part13.q.out 51e57e8
> ql/src/test/results/clientpositive/spark/load_dyn_part14.q.out ca36ac6
> ql/src/test/results/clientpositive/spark/mapjoin_subquery2.q.out 06b2cbe
> ql/src/test/results/clientpositive/spark/mergejoins.q.out 86ee699
> ql/src/test/results/clientpositive/spark/mergejoins_mixed.q.out 8dcf5ac
> ql/src/test/results/clientpositive/spark/multi_insert.q.out 137082a
> ql/src/test/results/clientpositive/spark/multi_insert_move_tasks_share_dependencies.q.out 4645a65
> ql/src/test/results/clientpositive/spark/multi_join_union.q.out bda569d
> ql/src/test/results/clientpositive/spark/multigroupby_singlemr.q.out c1480e3
> ql/src/test/results/clientpositive/spark/optimize_nullscan.q.out b5eff31
> ql/src/test/results/clientpositive/spark/ppd_gby_join.q.out e76f9cf
> ql/src/test/results/clientpositive/spark/ppd_join.q.out 2925a83
> ql/src/test/results/clientpositive/spark/ppd_join4.q.out 193311a
> ql/src/test/results/clientpositive/spark/ppd_join5.q.out 5943e7c
> ql/src/test/results/clientpositive/spark/ppd_outer_join1.q.out 7c10afe
> ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out c70133e
> ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out 9bcacb3
> ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out 690a9e3
> ql/src/test/results/clientpositive/spark/ql_rewrite_gbtoidx.q.out 45712d6
> ql/src/test/results/clientpositive/spark/ql_rewrite_gbtoidx_cbo_1.q.out aec0204
> ql/src/test/results/clientpositive/spark/reduce_deduplicate.q.out 7b92c73
> ql/src/test/results/clientpositive/spark/runtime_skewjoin_mapjoin_spark.q.out 2348058
> ql/src/test/results/clientpositive/spark/sample6.q.out 4117732
> ql/src/test/results/clientpositive/spark/semijoin.q.out 96edf5f
> ql/src/test/results/clientpositive/spark/skewjoin.q.out 35d4f6f
> ql/src/test/results/clientpositive/spark/skewjoin_union_remove_1.q.out 0ce2bb9
> ql/src/test/results/clientpositive/spark/skewjoin_union_remove_2.q.out 3d629be
> ql/src/test/results/clientpositive/spark/skewjoinopt1.q.out 93e08eb
> ql/src/test/results/clientpositive/spark/skewjoinopt10.q.out a30ccc9
> ql/src/test/results/clientpositive/spark/skewjoinopt11.q.out 2dfe692
> ql/src/test/results/clientpositive/spark/skewjoinopt12.q.out 667ec5c
> ql/src/test/results/clientpositive/spark/skewjoinopt13.q.out 88d84c4
> ql/src/test/results/clientpositive/spark/skewjoinopt14.q.out 5bc8a76
> ql/src/test/results/clientpositive/spark/skewjoinopt15.q.out 3ac7511
> ql/src/test/results/clientpositive/spark/skewjoinopt16.q.out 46a28de
> ql/src/test/results/clientpositive/spark/skewjoinopt17.q.out 8c7d620
> ql/src/test/results/clientpositive/spark/skewjoinopt18.q.out 60c4677
> ql/src/test/results/clientpositive/spark/skewjoinopt19.q.out eb9bb84
> ql/src/test/results/clientpositive/spark/skewjoinopt2.q.out 1c5f36d
> ql/src/test/results/clientpositive/spark/skewjoinopt20.q.out 22de156
> ql/src/test/results/clientpositive/spark/skewjoinopt3.q.out 0707b4c
> ql/src/test/results/clientpositive/spark/skewjoinopt4.q.out cff75a6
> ql/src/test/results/clientpositive/spark/skewjoinopt5.q.out 3c4cb67
> ql/src/test/results/clientpositive/spark/skewjoinopt6.q.out 16a218b
> ql/src/test/results/clientpositive/spark/skewjoinopt7.q.out bba46c0
> ql/src/test/results/clientpositive/spark/skewjoinopt8.q.out 7c8328f
> ql/src/test/results/clientpositive/spark/skewjoinopt9.q.out 4c789cf
> ql/src/test/results/clientpositive/spark/stats1.q.out fa8d05f
> ql/src/test/results/clientpositive/spark/stats12.q.out 0e25ac1
> ql/src/test/results/clientpositive/spark/stats13.q.out 4934aec
> ql/src/test/results/clientpositive/spark/stats2.q.out ad7ba0d
> ql/src/test/results/clientpositive/spark/stats7.q.out 32b09a0
> ql/src/test/results/clientpositive/spark/stats8.q.out 54eb2a1
> ql/src/test/results/clientpositive/spark/subquery_multiinsert.q.java1.7.out 92a8595
> ql/src/test/results/clientpositive/spark/temp_table.q.out 16d663d
> ql/src/test/results/clientpositive/spark/transform1.q.out 4a79875
> ql/src/test/results/clientpositive/spark/udf_in_file.q.out c769d1f
> ql/src/test/results/clientpositive/spark/union.q.out f2bd7b0
> ql/src/test/results/clientpositive/spark/union10.q.out 3138618
> ql/src/test/results/clientpositive/spark/union11.q.out 2689bb6
> ql/src/test/results/clientpositive/spark/union12.q.out cd21b73
> ql/src/test/results/clientpositive/spark/union13.q.out b995d22
> ql/src/test/results/clientpositive/spark/union14.q.out 4027393
> ql/src/test/results/clientpositive/spark/union15.q.out fcc1cf7
> ql/src/test/results/clientpositive/spark/union16.q.out 51ba287
> ql/src/test/results/clientpositive/spark/union17.q.out 4b0b682
> ql/src/test/results/clientpositive/spark/union18.q.out 3e25a49
> ql/src/test/results/clientpositive/spark/union19.q.out b6b172f
> ql/src/test/results/clientpositive/spark/union2.q.out 3ab9069
> ql/src/test/results/clientpositive/spark/union20.q.out d1e23f6
> ql/src/test/results/clientpositive/spark/union21.q.out 8a26f5e
> ql/src/test/results/clientpositive/spark/union22.q.out 4cb7bf0
> ql/src/test/results/clientpositive/spark/union23.q.out dda7234
> ql/src/test/results/clientpositive/spark/union24.q.out 22ec159
> ql/src/test/results/clientpositive/spark/union25.q.out 67416a3
> ql/src/test/results/clientpositive/spark/union26.q.out fa996ed
> ql/src/test/results/clientpositive/spark/union27.q.out e66db27
> ql/src/test/results/clientpositive/spark/union28.q.out 0294bad
> ql/src/test/results/clientpositive/spark/union29.q.out daa581f
> ql/src/test/results/clientpositive/spark/union3.q.out 25e78e3
> ql/src/test/results/clientpositive/spark/union30.q.out b9b59d4
> ql/src/test/results/clientpositive/spark/union31.q.out d58d17c
> ql/src/test/results/clientpositive/spark/union32.q.out c8909a5
> ql/src/test/results/clientpositive/spark/union33.q.out 2de2984
> ql/src/test/results/clientpositive/spark/union34.q.out d5e7e4a
> ql/src/test/results/clientpositive/spark/union4.q.out a7308ec
> ql/src/test/results/clientpositive/spark/union5.q.out f8cd94b
> ql/src/test/results/clientpositive/spark/union6.q.out f2c3411
> ql/src/test/results/clientpositive/spark/union7.q.out 73042d6
> ql/src/test/results/clientpositive/spark/union8.q.out 2766dc2
> ql/src/test/results/clientpositive/spark/union9.q.out 73cf3d5
> ql/src/test/results/clientpositive/spark/union_lateralview.q.out 126ca0c
> ql/src/test/results/clientpositive/spark/union_ppr.q.out 5d77bef
> ql/src/test/results/clientpositive/spark/union_remove_1.q.out 027ede7
> ql/src/test/results/clientpositive/spark/union_remove_10.q.out 2bc06d3
> ql/src/test/results/clientpositive/spark/union_remove_11.q.out 76cd688
> ql/src/test/results/clientpositive/spark/union_remove_12.q.out 81f815f
> ql/src/test/results/clientpositive/spark/union_remove_13.q.out bf25b54
> ql/src/test/results/clientpositive/spark/union_remove_14.q.out 8259c08
> ql/src/test/results/clientpositive/spark/union_remove_15.q.out 1f1e3c8
> ql/src/test/results/clientpositive/spark/union_remove_16.q.out f17b7a4
> ql/src/test/results/clientpositive/spark/union_remove_17.q.out 9704d0f
> ql/src/test/results/clientpositive/spark/union_remove_18.q.out 4b71e77
> ql/src/test/results/clientpositive/spark/union_remove_19.q.out 290d11a
> ql/src/test/results/clientpositive/spark/union_remove_2.q.out 06d4ad8
> ql/src/test/results/clientpositive/spark/union_remove_20.q.out bd8f9d7
> ql/src/test/results/clientpositive/spark/union_remove_21.q.out 9379e34
> ql/src/test/results/clientpositive/spark/union_remove_22.q.out 8fe568a
> ql/src/test/results/clientpositive/spark/union_remove_23.q.out 4add1d6
> ql/src/test/results/clientpositive/spark/union_remove_24.q.out 881e4ed
> ql/src/test/results/clientpositive/spark/union_remove_25.q.out 5853cc0
> ql/src/test/results/clientpositive/spark/union_remove_3.q.out df17b35
> ql/src/test/results/clientpositive/spark/union_remove_4.q.out 5d6dd88
> ql/src/test/results/clientpositive/spark/union_remove_5.q.out 554cffc
> ql/src/test/results/clientpositive/spark/union_remove_6.q.out ea0a1a0
> ql/src/test/results/clientpositive/spark/union_remove_6_subq.q.out 977d0f5
> ql/src/test/results/clientpositive/spark/union_remove_7.q.out d8f4c03
> ql/src/test/results/clientpositive/spark/union_remove_8.q.out 994552e
> ql/src/test/results/clientpositive/spark/union_remove_9.q.out a16ca19
> ql/src/test/results/clientpositive/spark/union_top_level.q.out a64fc95
> ql/src/test/results/clientpositive/spark/union_view.q.out 2ca9e13
> ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out a4b8e05
> ql/src/test/results/clientpositive/stats12.q.out f8aa4d0
> ql/src/test/results/clientpositive/stats13.q.out 10ecfd2
> ql/src/test/results/clientpositive/stats2.q.out 694c1a2
> ql/src/test/results/clientpositive/stats7.q.out 1162103
> ql/src/test/results/clientpositive/stats8.q.out 11b2010
> ql/src/test/results/clientpositive/subq_where_serialization.q.out 94d3685
> ql/src/test/results/clientpositive/subquery_in_having.q.out 862c6ad
> ql/src/test/results/clientpositive/subquery_multiinsert.q.java1.7.out 4f8ad0a
> ql/src/test/results/clientpositive/subquery_notin.q.out 733e8ff
> ql/src/test/results/clientpositive/subquery_notin_having.q.java1.7.out 2d5b486
> ql/src/test/results/clientpositive/subquery_unqual_corr_expr.q.out e3dd5ed
> ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out cf22ca6
> ql/src/test/results/clientpositive/subquery_views.q.out e495acc
> ql/src/test/results/clientpositive/symlink_text_input_format.q.out 6e3b31f
> ql/src/test/results/clientpositive/tez/auto_sortmerge_join_10.q.out 28268fc
> ql/src/test/results/clientpositive/tez/auto_sortmerge_join_12.q.out 8c8a3bf
> ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out 8b3d637
> ql/src/test/results/clientpositive/tez/dynamic_partition_pruning_2.q.out 8c8531c
> ql/src/test/results/clientpositive/tez/explainuser_1.q.out b684858
> ql/src/test/results/clientpositive/tez/explainuser_2.q.out f84524b
> ql/src/test/results/clientpositive/tez/hybridgrace_hashjoin_2.q.out 4ad143c
> ql/src/test/results/clientpositive/tez/mergejoin.q.out 97df12a
> ql/src/test/results/clientpositive/tez/metadataonly1.q.out 2850314
> ql/src/test/results/clientpositive/tez/optimize_nullscan.q.out 2c7528e
> ql/src/test/results/clientpositive/tez/selectDistinctStar.q.out f387cd0
> ql/src/test/results/clientpositive/tez/skewjoin.q.out ab2ce24
> ql/src/test/results/clientpositive/tez/temp_table.q.out 1bf4085
> ql/src/test/results/clientpositive/tez/tez_join.q.out b87b71c
> ql/src/test/results/clientpositive/tez/tez_join_hash.q.out c4bec62
> ql/src/test/results/clientpositive/tez/tez_smb_main.q.out 6183390
> ql/src/test/results/clientpositive/tez/tez_union.q.out 4c9368e
> ql/src/test/results/clientpositive/tez/tez_union2.q.out 4e4ed9f
> ql/src/test/results/clientpositive/tez/tez_union_group_by.q.out 654b34b
> ql/src/test/results/clientpositive/tez/tez_union_multiinsert.q.out e67bf3e
> ql/src/test/results/clientpositive/tez/transform1.q.out 718f128
> ql/src/test/results/clientpositive/tez/union2.q.out f3c5723
> ql/src/test/results/clientpositive/tez/union3.q.out 79e29a5
> ql/src/test/results/clientpositive/tez/union4.q.out e28af5e
> ql/src/test/results/clientpositive/tez/union5.q.out c771747
> ql/src/test/results/clientpositive/tez/union6.q.out 9d24ea1
> ql/src/test/results/clientpositive/tez/union7.q.out 2e07bad
> ql/src/test/results/clientpositive/tez/union8.q.out 3ee38b2
> ql/src/test/results/clientpositive/tez/union9.q.out e6464a0
> ql/src/test/results/clientpositive/tez/unionDistinct_1.q.out 9940e4b
> ql/src/test/results/clientpositive/tez/vector_bucket.q.out 410212a
> ql/src/test/results/clientpositive/tez/vector_date_1.q.out 8d1192a
> ql/src/test/results/clientpositive/tez/vector_interval_2.q.out 0f32cee
> ql/src/test/results/clientpositive/tez/vector_leftsemi_mapjoin.q.out 564f59d
> ql/src/test/results/clientpositive/tez/vector_mr_diff_schema_alias.q.out fafccdc
> ql/src/test/results/clientpositive/tez/vectorization_short_regress.q.out a3c723d
> ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out fd6c629
> ql/src/test/results/clientpositive/timestamp_literal.q.out 13ffaf1
> ql/src/test/results/clientpositive/transform1.q.out 9382cf0
> ql/src/test/results/clientpositive/type_widening.q.out e6617d4
> ql/src/test/results/clientpositive/udf_add_months.q.out 8c37fc2
> ql/src/test/results/clientpositive/udf_bitwise_shiftleft.q.out 6703d95
> ql/src/test/results/clientpositive/udf_bitwise_shiftright.q.out dbfe390
> ql/src/test/results/clientpositive/udf_bitwise_shiftrightunsigned.q.out c20029e
> ql/src/test/results/clientpositive/udf_cbrt.q.out 4cdaf15
> ql/src/test/results/clientpositive/udf_current_database.q.out e22165e
> ql/src/test/results/clientpositive/udf_date_format.q.out acca21e
> ql/src/test/results/clientpositive/udf_decode.q.out 107712a
> ql/src/test/results/clientpositive/udf_factorial.q.out b9b7bf9
> ql/src/test/results/clientpositive/udf_from_utc_timestamp.q.out 4df872c
> ql/src/test/results/clientpositive/udf_in_file.q.out 5564890
> ql/src/test/results/clientpositive/udf_last_day.q.out 2d39e38
> ql/src/test/results/clientpositive/udf_length.q.out f4b0b18
> ql/src/test/results/clientpositive/udf_levenshtein.q.out 1a60822
> ql/src/test/results/clientpositive/udf_md5.q.out 01744fe
> ql/src/test/results/clientpositive/udf_months_between.q.out 95f756f
> ql/src/test/results/clientpositive/udf_quarter.q.out b29ba4a
> ql/src/test/results/clientpositive/udf_soundex.q.out 9895a90
> ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out e70b401
> ql/src/test/results/clientpositive/udf_trunc.q.out 6cc18c2
> ql/src/test/results/clientpositive/udtf_stack.q.out 4e9c2fd
> ql/src/test/results/clientpositive/union10.q.out 53490e6
> ql/src/test/results/clientpositive/union11.q.out c77a766
> ql/src/test/results/clientpositive/union12.q.out d65086b
> ql/src/test/results/clientpositive/union14.q.out 5bd1556
> ql/src/test/results/clientpositive/union15.q.out 55d5510
> ql/src/test/results/clientpositive/union17.q.out 56b335a
> ql/src/test/results/clientpositive/union18.q.out a76d7fd
> ql/src/test/results/clientpositive/union19.q.out da94293
> ql/src/test/results/clientpositive/union20.q.out b80ec1e
> ql/src/test/results/clientpositive/union21.q.out b24c276
> ql/src/test/results/clientpositive/union22.q.out 9115287
> ql/src/test/results/clientpositive/union4.q.out b7f03ea
> ql/src/test/results/clientpositive/union5.q.out 0b0d7c6
> ql/src/test/results/clientpositive/union7.q.out 5be3185
> ql/src/test/results/clientpositive/unionDistinct_1.q.out c102b46
> ql/src/test/results/clientpositive/union_remove_1.q.out f30f39b
> ql/src/test/results/clientpositive/union_remove_10.q.out e720c37
> ql/src/test/results/clientpositive/union_remove_11.q.out 571b398
> ql/src/test/results/clientpositive/union_remove_12.q.out 4d6f4a1
> ql/src/test/results/clientpositive/union_remove_13.q.out a558967
> ql/src/test/results/clientpositive/union_remove_14.q.out 1502749
> ql/src/test/results/clientpositive/union_remove_15.q.out 2b3c109
> ql/src/test/results/clientpositive/union_remove_16.q.out ef32e1c
> ql/src/test/results/clientpositive/union_remove_17.q.out 56b22d9
> ql/src/test/results/clientpositive/union_remove_18.q.out 80971dd
> ql/src/test/results/clientpositive/union_remove_19.q.out 030c5ce
> ql/src/test/results/clientpositive/union_remove_2.q.out 1593029
> ql/src/test/results/clientpositive/union_remove_20.q.out fc8464d
> ql/src/test/results/clientpositive/union_remove_21.q.out 842e67f
> ql/src/test/results/clientpositive/union_remove_22.q.out 71054ae
> ql/src/test/results/clientpositive/union_remove_23.q.out 96e7d3d
> ql/src/test/results/clientpositive/union_remove_24.q.out d9e86bf
> ql/src/test/results/clientpositive/union_remove_25.q.out 0435ad5
> ql/src/test/results/clientpositive/union_remove_3.q.out 0de46d0
> ql/src/test/results/clientpositive/union_remove_4.q.out b83a0a8
> ql/src/test/results/clientpositive/union_remove_5.q.out 81e64b4
> ql/src/test/results/clientpositive/union_remove_6.q.out 215e90e
> ql/src/test/results/clientpositive/union_remove_6_subq.q.out 2661bcb
> ql/src/test/results/clientpositive/union_remove_7.q.out 4feb092
> ql/src/test/results/clientpositive/union_remove_8.q.out 5d22aa5
> ql/src/test/results/clientpositive/union_remove_9.q.out 7380d12
> ql/src/test/results/clientpositive/union_view.q.out 9181e9b
> ql/src/test/results/clientpositive/vector_bucket.q.out 1ac37a7
> ql/src/test/results/clientpositive/vector_date_1.q.out 5ed7424
> ql/src/test/results/clientpositive/vector_interval_2.q.out b70ef7a
> ql/src/test/results/clientpositive/vector_leftsemi_mapjoin.q.out 23a8adb
> ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out 27af52c
> ql/src/test/results/clientpositive/vector_mr_diff_schema_alias.q.out 59985cb
> ql/src/test/results/clientpositive/vector_multi_insert.q.out 2fcacad
> ql/src/test/results/clientpositive/vectorization_short_regress.q.out b9ab174
>
> Diff: https://reviews.apache.org/r/34143/diff/
>
>
> Testing
> -------
>
>
> Thanks,
>
> pengcheng xiong
>
>
Re: Review Request 34143: Fix stats annotation
Posted by Ashutosh Chauhan <ha...@apache.org>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/34143/#review84416
-----------------------------------------------------------
ql/src/java/org/apache/hadoop/hive/ql/plan/AbstractOperatorDesc.java
<https://reviews.apache.org/r/34143/#comment135652>
In Utilities.runtimeSerializationKryo::initialValue() can you add removeField() for Statistics. That will make sure we are not serializing Stats object before sending them to task nodes.
ql/src/test/results/clientpositive/spark/union24.q.out
<https://reviews.apache.org/r/34143/#comment135682>
File Sink has more 3 times more rows than Select. I was expecting it to be same as select.
ql/src/test/results/clientpositive/spark/union25.q.out
<https://reviews.apache.org/r/34143/#comment135683>
Group by should result in reduction of # of rows. No of rows instead doubled.
ql/src/test/results/clientpositive/spark/union25.q.out
<https://reviews.apache.org/r/34143/#comment135684>
Select operator after select operator. Should be same (or less). Instead doubled.
ql/src/test/results/clientpositive/spark/union26.q.out
<https://reviews.apache.org/r/34143/#comment135685>
join followed by gby. Gby should have lesser # of rows. Instead it increased to 5 times.
ql/src/test/results/clientpositive/spark/union27.q.out
<https://reviews.apache.org/r/34143/#comment135686>
Reduce sink after select. twice # of rows. expected to remain constant.
ql/src/test/results/clientpositive/spark/union30.q.out
<https://reviews.apache.org/r/34143/#comment135688>
cascade of select operator. With each one increasing # of rows, looks wrong.
- Ashutosh Chauhan
On May 14, 2015, 4:50 p.m., pengcheng xiong wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/34143/
> -----------------------------------------------------------
>
> (Updated May 14, 2015, 4:50 p.m.)
>
>
> Review request for hive, Ashutosh Chauhan and John Pullokkaran.
>
>
> Repository: hive-git
>
>
> Description
> -------
>
> This is a umbrella patch for a bunch of issues: HIVE-8769 Physical optimizer : Incorrect CE results in a shuffle join instead of a Map join (PK/FK pattern not detected) HIVE-9392 JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column names having duplicated fqColumnName HIVE-10107 Union All : Vertex missing stats resulting in OOM and in-efficient plans
>
>
> Diffs
> -----
>
> hbase-handler/src/test/results/positive/external_table_ppd.q.out 6d48edb
> hbase-handler/src/test/results/positive/hbase_custom_key2.q.out c9b5a84
> hbase-handler/src/test/results/positive/hbase_custom_key3.q.out 76848e0
> hbase-handler/src/test/results/positive/hbase_ppd_key_range.q.out 6174bfb
> hbase-handler/src/test/results/positive/hbase_pushdown.q.out 8a979bf
> hbase-handler/src/test/results/positive/hbase_queries.q.out 7863f69
> hbase-handler/src/test/results/positive/hbase_timestamp.q.out 3aae7d0
> hbase-handler/src/test/results/positive/ppd_key_ranges.q.out 5936735
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/RelOptHiveTable.java 0de7488
> ql/src/java/org/apache/hadoop/hive/ql/optimizer/stats/annotation/StatsRulesProcFactory.java 44269f0
> ql/src/java/org/apache/hadoop/hive/ql/plan/AbstractOperatorDesc.java 0a83440
> ql/src/java/org/apache/hadoop/hive/ql/plan/ColStatistics.java c420190
> ql/src/java/org/apache/hadoop/hive/ql/plan/Statistics.java f66279f
> ql/src/java/org/apache/hadoop/hive/ql/stats/StatsUtils.java 508d880
> ql/src/test/results/clientpositive/annotate_stats_filter.q.out e8cd06d
> ql/src/test/results/clientpositive/annotate_stats_limit.q.out 5f8b6f8
> ql/src/test/results/clientpositive/annotate_stats_part.q.out 241192b
> ql/src/test/results/clientpositive/annotate_stats_select.q.out 753ab4e
> ql/src/test/results/clientpositive/annotate_stats_table.q.out 9bf82ac
> ql/src/test/results/clientpositive/auto_join30.q.out b068493
> ql/src/test/results/clientpositive/auto_join31.q.out 1e19dd0
> ql/src/test/results/clientpositive/auto_join32.q.out bfc8be8
> ql/src/test/results/clientpositive/auto_join_stats.q.out 9100762
> ql/src/test/results/clientpositive/auto_join_stats2.q.out ed09875
> ql/src/test/results/clientpositive/auto_join_without_localtask.q.out ce4ad8a
> ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out 383defd
> ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out e9fb705
> ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out 43504d8
> ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out afd5518
> ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out c089419
> ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out 6e443fa
> ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out feaea04
> ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out f64ecf0
> ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out f039dda
> ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out e89f548
> ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out 44c037f
> ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out 65aa3ef
> ql/src/test/results/clientpositive/binarysortable_1.q.out c4ba7e0
> ql/src/test/results/clientpositive/bucket_map_join_1.q.out d778203
> ql/src/test/results/clientpositive/bucket_map_join_2.q.out aef77aa
> ql/src/test/results/clientpositive/bucketmapjoin1.q.out 72f2a07
> ql/src/test/results/clientpositive/bucketsortoptimize_insert_2.q.out eec099c
> ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out 1a644a9
> ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out e4f90e4
> ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out 307c83b
> ql/src/test/results/clientpositive/column_access_stats.q.out a779564
> ql/src/test/results/clientpositive/complex_alias.q.out 133ce91
> ql/src/test/results/clientpositive/correlationoptimizer1.q.out 0eb1596
> ql/src/test/results/clientpositive/correlationoptimizer10.q.out 3c3564d
> ql/src/test/results/clientpositive/correlationoptimizer11.q.out bd86942
> ql/src/test/results/clientpositive/correlationoptimizer15.q.out b57203e
> ql/src/test/results/clientpositive/correlationoptimizer2.q.out 43d209f
> ql/src/test/results/clientpositive/correlationoptimizer3.q.out 5389647
> ql/src/test/results/clientpositive/correlationoptimizer4.q.out b350816
> ql/src/test/results/clientpositive/correlationoptimizer5.q.out 6ba3462
> ql/src/test/results/clientpositive/correlationoptimizer6.q.out be518dc
> ql/src/test/results/clientpositive/cross_product_check_2.q.out 500f912
> ql/src/test/results/clientpositive/decimal_precision2.q.out dafc2c3
> ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_dynamic.q.out 22cbce9
> ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_static.q.out 96f8b6a
> ql/src/test/results/clientpositive/explain_logical.q.out 9b86ce8
> ql/src/test/results/clientpositive/explain_rearrange.q.out c4a015e
> ql/src/test/results/clientpositive/filter_numeric.q.out b6b8339
> ql/src/test/results/clientpositive/fold_case.q.out de6c43e
> ql/src/test/results/clientpositive/fold_when.q.out 37803e0
> ql/src/test/results/clientpositive/groupby_cube1.q.out 659ac52
> ql/src/test/results/clientpositive/groupby_grouping_sets2.q.out 5acac64
> ql/src/test/results/clientpositive/groupby_grouping_sets3.q.out b96521a
> ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out a00f94b
> ql/src/test/results/clientpositive/groupby_grouping_sets5.q.out b2625fe
> ql/src/test/results/clientpositive/groupby_grouping_sets6.q.out 587a8c3
> ql/src/test/results/clientpositive/groupby_ppd.q.out dbbab88
> ql/src/test/results/clientpositive/groupby_rollup1.q.out faa6583
> ql/src/test/results/clientpositive/groupby_sort_6.q.out c5cb8b9
> ql/src/test/results/clientpositive/having2.q.out 9539394
> ql/src/test/results/clientpositive/identity_project_remove_skip.q.out e7bd0ed
> ql/src/test/results/clientpositive/implicit_cast1.q.out d4bcd64
> ql/src/test/results/clientpositive/index_auto_empty.q.out f824ce5
> ql/src/test/results/clientpositive/index_serde.q.out 182d681
> ql/src/test/results/clientpositive/index_skewtable.q.out fac53e5
> ql/src/test/results/clientpositive/infer_const_type.q.out 09803b4
> ql/src/test/results/clientpositive/input21.q.out f6559f3
> ql/src/test/results/clientpositive/input23.q.out 73038c3
> ql/src/test/results/clientpositive/input24.q.out 63f2b64
> ql/src/test/results/clientpositive/input25.q.out bf9948a
> ql/src/test/results/clientpositive/input26.q.out 1b24aa6
> ql/src/test/results/clientpositive/input9.q.out d1824e5
> ql/src/test/results/clientpositive/input_part4.q.out 1ebf36b
> ql/src/test/results/clientpositive/insert1.q.out 5816a2c
> ql/src/test/results/clientpositive/join19.q.out 2570663
> ql/src/test/results/clientpositive/join29.q.out 63bd035
> ql/src/test/results/clientpositive/join31.q.out ddd4077
> ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out c1e1051
> ql/src/test/results/clientpositive/join_cond_pushdown_unqual2.q.out 678ddb8
> ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out 0adf5d7
> ql/src/test/results/clientpositive/join_cond_pushdown_unqual4.q.out 4668eb1
> ql/src/test/results/clientpositive/join_hive_626.q.out 4e29d42
> ql/src/test/results/clientpositive/join_reorder.q.out c9498bf
> ql/src/test/results/clientpositive/join_reorder2.q.out 0d56a42
> ql/src/test/results/clientpositive/join_reorder3.q.out eb847c2
> ql/src/test/results/clientpositive/join_reorder4.q.out 23f4e4c
> ql/src/test/results/clientpositive/join_view.q.out e703e0b
> ql/src/test/results/clientpositive/keyword_1.q.out a37093d
> ql/src/test/results/clientpositive/lateral_view_explode2.q.out 737d562
> ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out 13e601a
> ql/src/test/results/clientpositive/mapjoin_subquery2.q.out 507c7ca
> ql/src/test/results/clientpositive/merge_join_1.q.out 99c7efe
> ql/src/test/results/clientpositive/mergejoins.q.out 68416a0
> ql/src/test/results/clientpositive/mergejoins_mixed.q.out 6bcc3d5
> ql/src/test/results/clientpositive/metadataonly1.q.out e55efd5
> ql/src/test/results/clientpositive/multiMapJoin1.q.out c00ff29
> ql/src/test/results/clientpositive/multiMapJoin2.q.out 5a07fe0
> ql/src/test/results/clientpositive/multigroupby_singlemr.q.out 4b80693
> ql/src/test/results/clientpositive/nullformatCTAS.q.out 892de6e
> ql/src/test/results/clientpositive/nullgroup3.q.out 7712d4d
> ql/src/test/results/clientpositive/nullgroup5.q.out 8a94d62
> ql/src/test/results/clientpositive/optimize_nullscan.q.out 888af95
> ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out df5ee76
> ql/src/test/results/clientpositive/partition_boolexpr.q.out cfd03e2
> ql/src/test/results/clientpositive/ppd_gby_join.q.out be275bd
> ql/src/test/results/clientpositive/ppd_join.q.out d495a1a
> ql/src/test/results/clientpositive/ppd_join4.q.out 22f84ba
> ql/src/test/results/clientpositive/ppd_join5.q.out 85e357e
> ql/src/test/results/clientpositive/ppd_outer_join2.q.out 681c2ea
> ql/src/test/results/clientpositive/ppd_outer_join3.q.out 75f1020
> ql/src/test/results/clientpositive/ppd_outer_join4.q.out bb5b5cf
> ql/src/test/results/clientpositive/ppd_outer_join5.q.out 43c792f
> ql/src/test/results/clientpositive/ppd_repeated_alias.q.out 7d3482b
> ql/src/test/results/clientpositive/ppd_udf_col.q.out c3e7d1b
> ql/src/test/results/clientpositive/ppd_union_view.q.out a13ef7a
> ql/src/test/results/clientpositive/ql_rewrite_gbtoidx.q.out 0a3c427
> ql/src/test/results/clientpositive/ql_rewrite_gbtoidx_cbo_1.q.out 5ca966f
> ql/src/test/results/clientpositive/ql_rewrite_gbtoidx_cbo_2.q.out 381e58f
> ql/src/test/results/clientpositive/query_result_fileformat.q.out 3848bd4
> ql/src/test/results/clientpositive/quote1.q.out 20f754f
> ql/src/test/results/clientpositive/quotedid_basic.q.out 507369c
> ql/src/test/results/clientpositive/quotedid_skew.q.out f604cdd
> ql/src/test/results/clientpositive/reduce_deduplicate.q.out fa714b8
> ql/src/test/results/clientpositive/runtime_skewjoin_mapjoin_spark.q.out 889a9d0
> ql/src/test/results/clientpositive/sample6.q.out 9891cbb
> ql/src/test/results/clientpositive/select_dummy_source.q.out b1f0939
> ql/src/test/results/clientpositive/semijoin.q.out 97eb9fb
> ql/src/test/results/clientpositive/skewjoin.q.out 27f2ffc
> ql/src/test/results/clientpositive/skewjoin_mapjoin1.q.out 9f10861
> ql/src/test/results/clientpositive/skewjoin_mapjoin10.q.out 27b1aee
> ql/src/test/results/clientpositive/skewjoin_mapjoin11.q.out dd084e8
> ql/src/test/results/clientpositive/skewjoin_mapjoin2.q.out 7e3046f
> ql/src/test/results/clientpositive/skewjoin_mapjoin3.q.out 40e4de2
> ql/src/test/results/clientpositive/skewjoin_mapjoin4.q.out b7c12f9
> ql/src/test/results/clientpositive/skewjoin_mapjoin5.q.out 7c04a9d
> ql/src/test/results/clientpositive/skewjoin_mapjoin6.q.out d3183f8
> ql/src/test/results/clientpositive/skewjoin_mapjoin7.q.out aaf7de3
> ql/src/test/results/clientpositive/skewjoin_mapjoin8.q.out 5d1a3e8
> ql/src/test/results/clientpositive/skewjoin_mapjoin9.q.out c7271b0
> ql/src/test/results/clientpositive/skewjoin_union_remove_1.q.out c67b681
> ql/src/test/results/clientpositive/skewjoin_union_remove_2.q.out 2979c42
> ql/src/test/results/clientpositive/skewjoinopt1.q.out 61e9a8e
> ql/src/test/results/clientpositive/skewjoinopt10.q.out 90925a0
> ql/src/test/results/clientpositive/skewjoinopt11.q.out 2504c17
> ql/src/test/results/clientpositive/skewjoinopt12.q.out 5ac7677
> ql/src/test/results/clientpositive/skewjoinopt13.q.out d6ede51
> ql/src/test/results/clientpositive/skewjoinopt14.q.out 8a4802e
> ql/src/test/results/clientpositive/skewjoinopt15.q.out 3abf5b7
> ql/src/test/results/clientpositive/skewjoinopt16.q.out 894a265
> ql/src/test/results/clientpositive/skewjoinopt17.q.out d27929f
> ql/src/test/results/clientpositive/skewjoinopt18.q.out 33a0ed9
> ql/src/test/results/clientpositive/skewjoinopt19.q.out fd43409
> ql/src/test/results/clientpositive/skewjoinopt2.q.out d613f10
> ql/src/test/results/clientpositive/skewjoinopt20.q.out a28e433
> ql/src/test/results/clientpositive/skewjoinopt3.q.out bd87ccd
> ql/src/test/results/clientpositive/skewjoinopt4.q.out 47f5a92
> ql/src/test/results/clientpositive/skewjoinopt5.q.out d46214c
> ql/src/test/results/clientpositive/skewjoinopt6.q.out c42a3ef
> ql/src/test/results/clientpositive/skewjoinopt7.q.out 97482f0
> ql/src/test/results/clientpositive/skewjoinopt8.q.out 244c2be
> ql/src/test/results/clientpositive/skewjoinopt9.q.out f877e56
> ql/src/test/results/clientpositive/smb_mapjoin9.q.out cbaf7e1
> ql/src/test/results/clientpositive/spark/auto_join27.q.out 0ae494e
> ql/src/test/results/clientpositive/spark/auto_join32.q.out c537b95
> ql/src/test/results/clientpositive/spark/auto_join_stats.q.out 1fa1a74
> ql/src/test/results/clientpositive/spark/auto_join_stats2.q.out c6473d3
> ql/src/test/results/clientpositive/spark/auto_sortmerge_join_10.q.out 2b245fb
> ql/src/test/results/clientpositive/spark/auto_sortmerge_join_12.q.out 8102ec1
> ql/src/test/results/clientpositive/spark/bucket_map_join_1.q.out 4e8ce0d
> ql/src/test/results/clientpositive/spark/bucket_map_join_2.q.out c0a3c3d
> ql/src/test/results/clientpositive/spark/bucketmapjoin1.q.out 44f4d0c
> ql/src/test/results/clientpositive/spark/column_access_stats.q.out 3e16f61
> ql/src/test/results/clientpositive/spark/groupby_cube1.q.out 8191b64
> ql/src/test/results/clientpositive/spark/groupby_rollup1.q.out 25029d0
> ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out cfbce61
> ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out 9343805
> ql/src/test/results/clientpositive/spark/insert1.q.out ba8876f
> ql/src/test/results/clientpositive/spark/join19.q.out f84ce2d
> ql/src/test/results/clientpositive/spark/join34.q.out 54b7ba0
> ql/src/test/results/clientpositive/spark/join35.q.out 3d14a79
> ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual1.q.out 687f2e9
> ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual2.q.out 949fdee
> ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual3.q.out 2d70084
> ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual4.q.out 3de2aed
> ql/src/test/results/clientpositive/spark/join_hive_626.q.out bb65240
> ql/src/test/results/clientpositive/spark/join_reorder.q.out 69b90b5
> ql/src/test/results/clientpositive/spark/join_reorder2.q.out 9f9104c
> ql/src/test/results/clientpositive/spark/join_reorder3.q.out 9813110
> ql/src/test/results/clientpositive/spark/join_reorder4.q.out 5cc30f7
> ql/src/test/results/clientpositive/spark/join_view.q.out f6e0542
> ql/src/test/results/clientpositive/spark/lateral_view_explode2.q.out 41d60f5
> ql/src/test/results/clientpositive/spark/load_dyn_part13.q.out 51e57e8
> ql/src/test/results/clientpositive/spark/load_dyn_part14.q.out ca36ac6
> ql/src/test/results/clientpositive/spark/mapjoin_subquery2.q.out 06b2cbe
> ql/src/test/results/clientpositive/spark/mergejoins.q.out 86ee699
> ql/src/test/results/clientpositive/spark/mergejoins_mixed.q.out 8dcf5ac
> ql/src/test/results/clientpositive/spark/multi_insert.q.out 137082a
> ql/src/test/results/clientpositive/spark/multi_insert_move_tasks_share_dependencies.q.out 4645a65
> ql/src/test/results/clientpositive/spark/multi_join_union.q.out bda569d
> ql/src/test/results/clientpositive/spark/multigroupby_singlemr.q.out c1480e3
> ql/src/test/results/clientpositive/spark/optimize_nullscan.q.out b5eff31
> ql/src/test/results/clientpositive/spark/ppd_gby_join.q.out e76f9cf
> ql/src/test/results/clientpositive/spark/ppd_join.q.out 2925a83
> ql/src/test/results/clientpositive/spark/ppd_join4.q.out 193311a
> ql/src/test/results/clientpositive/spark/ppd_join5.q.out 5943e7c
> ql/src/test/results/clientpositive/spark/ppd_outer_join1.q.out 7c10afe
> ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out c70133e
> ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out 9bcacb3
> ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out 690a9e3
> ql/src/test/results/clientpositive/spark/ql_rewrite_gbtoidx.q.out 45712d6
> ql/src/test/results/clientpositive/spark/ql_rewrite_gbtoidx_cbo_1.q.out aec0204
> ql/src/test/results/clientpositive/spark/reduce_deduplicate.q.out 7b92c73
> ql/src/test/results/clientpositive/spark/runtime_skewjoin_mapjoin_spark.q.out 2348058
> ql/src/test/results/clientpositive/spark/sample6.q.out 4117732
> ql/src/test/results/clientpositive/spark/semijoin.q.out 96edf5f
> ql/src/test/results/clientpositive/spark/skewjoin.q.out 35d4f6f
> ql/src/test/results/clientpositive/spark/skewjoin_union_remove_1.q.out 0ce2bb9
> ql/src/test/results/clientpositive/spark/skewjoin_union_remove_2.q.out 3d629be
> ql/src/test/results/clientpositive/spark/skewjoinopt1.q.out 93e08eb
> ql/src/test/results/clientpositive/spark/skewjoinopt10.q.out a30ccc9
> ql/src/test/results/clientpositive/spark/skewjoinopt11.q.out 2dfe692
> ql/src/test/results/clientpositive/spark/skewjoinopt12.q.out 667ec5c
> ql/src/test/results/clientpositive/spark/skewjoinopt13.q.out 88d84c4
> ql/src/test/results/clientpositive/spark/skewjoinopt14.q.out 5bc8a76
> ql/src/test/results/clientpositive/spark/skewjoinopt15.q.out 3ac7511
> ql/src/test/results/clientpositive/spark/skewjoinopt16.q.out 46a28de
> ql/src/test/results/clientpositive/spark/skewjoinopt17.q.out 8c7d620
> ql/src/test/results/clientpositive/spark/skewjoinopt18.q.out 60c4677
> ql/src/test/results/clientpositive/spark/skewjoinopt19.q.out eb9bb84
> ql/src/test/results/clientpositive/spark/skewjoinopt2.q.out 1c5f36d
> ql/src/test/results/clientpositive/spark/skewjoinopt20.q.out 22de156
> ql/src/test/results/clientpositive/spark/skewjoinopt3.q.out 0707b4c
> ql/src/test/results/clientpositive/spark/skewjoinopt4.q.out cff75a6
> ql/src/test/results/clientpositive/spark/skewjoinopt5.q.out 3c4cb67
> ql/src/test/results/clientpositive/spark/skewjoinopt6.q.out 16a218b
> ql/src/test/results/clientpositive/spark/skewjoinopt7.q.out bba46c0
> ql/src/test/results/clientpositive/spark/skewjoinopt8.q.out 7c8328f
> ql/src/test/results/clientpositive/spark/skewjoinopt9.q.out 4c789cf
> ql/src/test/results/clientpositive/spark/stats1.q.out fa8d05f
> ql/src/test/results/clientpositive/spark/stats12.q.out 0e25ac1
> ql/src/test/results/clientpositive/spark/stats13.q.out 4934aec
> ql/src/test/results/clientpositive/spark/stats2.q.out ad7ba0d
> ql/src/test/results/clientpositive/spark/stats7.q.out 32b09a0
> ql/src/test/results/clientpositive/spark/stats8.q.out 54eb2a1
> ql/src/test/results/clientpositive/spark/subquery_multiinsert.q.java1.7.out 92a8595
> ql/src/test/results/clientpositive/spark/temp_table.q.out 16d663d
> ql/src/test/results/clientpositive/spark/transform1.q.out 4a79875
> ql/src/test/results/clientpositive/spark/udf_in_file.q.out c769d1f
> ql/src/test/results/clientpositive/spark/union.q.out f2bd7b0
> ql/src/test/results/clientpositive/spark/union10.q.out 3138618
> ql/src/test/results/clientpositive/spark/union11.q.out 2689bb6
> ql/src/test/results/clientpositive/spark/union12.q.out cd21b73
> ql/src/test/results/clientpositive/spark/union13.q.out b995d22
> ql/src/test/results/clientpositive/spark/union14.q.out 4027393
> ql/src/test/results/clientpositive/spark/union15.q.out fcc1cf7
> ql/src/test/results/clientpositive/spark/union16.q.out 51ba287
> ql/src/test/results/clientpositive/spark/union17.q.out 4b0b682
> ql/src/test/results/clientpositive/spark/union18.q.out 3e25a49
> ql/src/test/results/clientpositive/spark/union19.q.out b6b172f
> ql/src/test/results/clientpositive/spark/union2.q.out 3ab9069
> ql/src/test/results/clientpositive/spark/union20.q.out d1e23f6
> ql/src/test/results/clientpositive/spark/union21.q.out 8a26f5e
> ql/src/test/results/clientpositive/spark/union22.q.out 4cb7bf0
> ql/src/test/results/clientpositive/spark/union23.q.out dda7234
> ql/src/test/results/clientpositive/spark/union24.q.out 22ec159
> ql/src/test/results/clientpositive/spark/union25.q.out 67416a3
> ql/src/test/results/clientpositive/spark/union26.q.out fa996ed
> ql/src/test/results/clientpositive/spark/union27.q.out e66db27
> ql/src/test/results/clientpositive/spark/union28.q.out 0294bad
> ql/src/test/results/clientpositive/spark/union29.q.out daa581f
> ql/src/test/results/clientpositive/spark/union3.q.out 25e78e3
> ql/src/test/results/clientpositive/spark/union30.q.out b9b59d4
> ql/src/test/results/clientpositive/spark/union31.q.out d58d17c
> ql/src/test/results/clientpositive/spark/union32.q.out c8909a5
> ql/src/test/results/clientpositive/spark/union33.q.out 2de2984
> ql/src/test/results/clientpositive/spark/union34.q.out d5e7e4a
> ql/src/test/results/clientpositive/spark/union4.q.out a7308ec
> ql/src/test/results/clientpositive/spark/union5.q.out f8cd94b
> ql/src/test/results/clientpositive/spark/union6.q.out f2c3411
> ql/src/test/results/clientpositive/spark/union7.q.out 73042d6
> ql/src/test/results/clientpositive/spark/union8.q.out 2766dc2
> ql/src/test/results/clientpositive/spark/union9.q.out 73cf3d5
> ql/src/test/results/clientpositive/spark/union_lateralview.q.out 126ca0c
> ql/src/test/results/clientpositive/spark/union_ppr.q.out 5d77bef
> ql/src/test/results/clientpositive/spark/union_remove_1.q.out 027ede7
> ql/src/test/results/clientpositive/spark/union_remove_10.q.out 2bc06d3
> ql/src/test/results/clientpositive/spark/union_remove_11.q.out 76cd688
> ql/src/test/results/clientpositive/spark/union_remove_12.q.out 81f815f
> ql/src/test/results/clientpositive/spark/union_remove_13.q.out bf25b54
> ql/src/test/results/clientpositive/spark/union_remove_14.q.out 8259c08
> ql/src/test/results/clientpositive/spark/union_remove_15.q.out 1f1e3c8
> ql/src/test/results/clientpositive/spark/union_remove_16.q.out f17b7a4
> ql/src/test/results/clientpositive/spark/union_remove_17.q.out 9704d0f
> ql/src/test/results/clientpositive/spark/union_remove_18.q.out 4b71e77
> ql/src/test/results/clientpositive/spark/union_remove_19.q.out 290d11a
> ql/src/test/results/clientpositive/spark/union_remove_2.q.out 06d4ad8
> ql/src/test/results/clientpositive/spark/union_remove_20.q.out bd8f9d7
> ql/src/test/results/clientpositive/spark/union_remove_21.q.out 9379e34
> ql/src/test/results/clientpositive/spark/union_remove_22.q.out 8fe568a
> ql/src/test/results/clientpositive/spark/union_remove_23.q.out 4add1d6
> ql/src/test/results/clientpositive/spark/union_remove_24.q.out 881e4ed
> ql/src/test/results/clientpositive/spark/union_remove_25.q.out 5853cc0
> ql/src/test/results/clientpositive/spark/union_remove_3.q.out df17b35
> ql/src/test/results/clientpositive/spark/union_remove_4.q.out 5d6dd88
> ql/src/test/results/clientpositive/spark/union_remove_5.q.out 554cffc
> ql/src/test/results/clientpositive/spark/union_remove_6.q.out ea0a1a0
> ql/src/test/results/clientpositive/spark/union_remove_6_subq.q.out 977d0f5
> ql/src/test/results/clientpositive/spark/union_remove_7.q.out d8f4c03
> ql/src/test/results/clientpositive/spark/union_remove_8.q.out 994552e
> ql/src/test/results/clientpositive/spark/union_remove_9.q.out a16ca19
> ql/src/test/results/clientpositive/spark/union_top_level.q.out a64fc95
> ql/src/test/results/clientpositive/spark/union_view.q.out 2ca9e13
> ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out a4b8e05
> ql/src/test/results/clientpositive/stats12.q.out f8aa4d0
> ql/src/test/results/clientpositive/stats13.q.out 10ecfd2
> ql/src/test/results/clientpositive/stats2.q.out 694c1a2
> ql/src/test/results/clientpositive/stats7.q.out 1162103
> ql/src/test/results/clientpositive/stats8.q.out 11b2010
> ql/src/test/results/clientpositive/subq_where_serialization.q.out 94d3685
> ql/src/test/results/clientpositive/subquery_in_having.q.out 862c6ad
> ql/src/test/results/clientpositive/subquery_multiinsert.q.java1.7.out 4f8ad0a
> ql/src/test/results/clientpositive/subquery_notin.q.out 733e8ff
> ql/src/test/results/clientpositive/subquery_notin_having.q.java1.7.out 2d5b486
> ql/src/test/results/clientpositive/subquery_unqual_corr_expr.q.out e3dd5ed
> ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out cf22ca6
> ql/src/test/results/clientpositive/subquery_views.q.out e495acc
> ql/src/test/results/clientpositive/symlink_text_input_format.q.out 6e3b31f
> ql/src/test/results/clientpositive/tez/auto_sortmerge_join_10.q.out 28268fc
> ql/src/test/results/clientpositive/tez/auto_sortmerge_join_12.q.out 8c8a3bf
> ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out 8b3d637
> ql/src/test/results/clientpositive/tez/dynamic_partition_pruning_2.q.out 8c8531c
> ql/src/test/results/clientpositive/tez/explainuser_1.q.out b684858
> ql/src/test/results/clientpositive/tez/explainuser_2.q.out f84524b
> ql/src/test/results/clientpositive/tez/hybridgrace_hashjoin_2.q.out 4ad143c
> ql/src/test/results/clientpositive/tez/mergejoin.q.out 97df12a
> ql/src/test/results/clientpositive/tez/metadataonly1.q.out 2850314
> ql/src/test/results/clientpositive/tez/optimize_nullscan.q.out 2c7528e
> ql/src/test/results/clientpositive/tez/selectDistinctStar.q.out f387cd0
> ql/src/test/results/clientpositive/tez/skewjoin.q.out ab2ce24
> ql/src/test/results/clientpositive/tez/temp_table.q.out 1bf4085
> ql/src/test/results/clientpositive/tez/tez_join.q.out b87b71c
> ql/src/test/results/clientpositive/tez/tez_join_hash.q.out c4bec62
> ql/src/test/results/clientpositive/tez/tez_smb_main.q.out 6183390
> ql/src/test/results/clientpositive/tez/tez_union.q.out 4c9368e
> ql/src/test/results/clientpositive/tez/tez_union2.q.out 4e4ed9f
> ql/src/test/results/clientpositive/tez/tez_union_group_by.q.out 654b34b
> ql/src/test/results/clientpositive/tez/tez_union_multiinsert.q.out e67bf3e
> ql/src/test/results/clientpositive/tez/transform1.q.out 718f128
> ql/src/test/results/clientpositive/tez/union2.q.out f3c5723
> ql/src/test/results/clientpositive/tez/union3.q.out 79e29a5
> ql/src/test/results/clientpositive/tez/union4.q.out e28af5e
> ql/src/test/results/clientpositive/tez/union5.q.out c771747
> ql/src/test/results/clientpositive/tez/union6.q.out 9d24ea1
> ql/src/test/results/clientpositive/tez/union7.q.out 2e07bad
> ql/src/test/results/clientpositive/tez/union8.q.out 3ee38b2
> ql/src/test/results/clientpositive/tez/union9.q.out e6464a0
> ql/src/test/results/clientpositive/tez/unionDistinct_1.q.out 9940e4b
> ql/src/test/results/clientpositive/tez/vector_bucket.q.out 410212a
> ql/src/test/results/clientpositive/tez/vector_date_1.q.out 8d1192a
> ql/src/test/results/clientpositive/tez/vector_interval_2.q.out 0f32cee
> ql/src/test/results/clientpositive/tez/vector_leftsemi_mapjoin.q.out 564f59d
> ql/src/test/results/clientpositive/tez/vector_mr_diff_schema_alias.q.out fafccdc
> ql/src/test/results/clientpositive/tez/vectorization_short_regress.q.out a3c723d
> ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out fd6c629
> ql/src/test/results/clientpositive/timestamp_literal.q.out 13ffaf1
> ql/src/test/results/clientpositive/transform1.q.out 9382cf0
> ql/src/test/results/clientpositive/type_widening.q.out e6617d4
> ql/src/test/results/clientpositive/udf_add_months.q.out 8c37fc2
> ql/src/test/results/clientpositive/udf_bitwise_shiftleft.q.out 6703d95
> ql/src/test/results/clientpositive/udf_bitwise_shiftright.q.out dbfe390
> ql/src/test/results/clientpositive/udf_bitwise_shiftrightunsigned.q.out c20029e
> ql/src/test/results/clientpositive/udf_cbrt.q.out 4cdaf15
> ql/src/test/results/clientpositive/udf_current_database.q.out e22165e
> ql/src/test/results/clientpositive/udf_date_format.q.out acca21e
> ql/src/test/results/clientpositive/udf_decode.q.out 107712a
> ql/src/test/results/clientpositive/udf_factorial.q.out b9b7bf9
> ql/src/test/results/clientpositive/udf_from_utc_timestamp.q.out 4df872c
> ql/src/test/results/clientpositive/udf_in_file.q.out 5564890
> ql/src/test/results/clientpositive/udf_last_day.q.out 2d39e38
> ql/src/test/results/clientpositive/udf_length.q.out f4b0b18
> ql/src/test/results/clientpositive/udf_levenshtein.q.out 1a60822
> ql/src/test/results/clientpositive/udf_md5.q.out 01744fe
> ql/src/test/results/clientpositive/udf_months_between.q.out 95f756f
> ql/src/test/results/clientpositive/udf_quarter.q.out b29ba4a
> ql/src/test/results/clientpositive/udf_soundex.q.out 9895a90
> ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out e70b401
> ql/src/test/results/clientpositive/udf_trunc.q.out 6cc18c2
> ql/src/test/results/clientpositive/udtf_stack.q.out 4e9c2fd
> ql/src/test/results/clientpositive/union10.q.out 53490e6
> ql/src/test/results/clientpositive/union11.q.out c77a766
> ql/src/test/results/clientpositive/union12.q.out d65086b
> ql/src/test/results/clientpositive/union14.q.out 5bd1556
> ql/src/test/results/clientpositive/union15.q.out 55d5510
> ql/src/test/results/clientpositive/union17.q.out 56b335a
> ql/src/test/results/clientpositive/union18.q.out a76d7fd
> ql/src/test/results/clientpositive/union19.q.out da94293
> ql/src/test/results/clientpositive/union20.q.out b80ec1e
> ql/src/test/results/clientpositive/union21.q.out b24c276
> ql/src/test/results/clientpositive/union22.q.out 9115287
> ql/src/test/results/clientpositive/union4.q.out b7f03ea
> ql/src/test/results/clientpositive/union5.q.out 0b0d7c6
> ql/src/test/results/clientpositive/union7.q.out 5be3185
> ql/src/test/results/clientpositive/unionDistinct_1.q.out c102b46
> ql/src/test/results/clientpositive/union_remove_1.q.out f30f39b
> ql/src/test/results/clientpositive/union_remove_10.q.out e720c37
> ql/src/test/results/clientpositive/union_remove_11.q.out 571b398
> ql/src/test/results/clientpositive/union_remove_12.q.out 4d6f4a1
> ql/src/test/results/clientpositive/union_remove_13.q.out a558967
> ql/src/test/results/clientpositive/union_remove_14.q.out 1502749
> ql/src/test/results/clientpositive/union_remove_15.q.out 2b3c109
> ql/src/test/results/clientpositive/union_remove_16.q.out ef32e1c
> ql/src/test/results/clientpositive/union_remove_17.q.out 56b22d9
> ql/src/test/results/clientpositive/union_remove_18.q.out 80971dd
> ql/src/test/results/clientpositive/union_remove_19.q.out 030c5ce
> ql/src/test/results/clientpositive/union_remove_2.q.out 1593029
> ql/src/test/results/clientpositive/union_remove_20.q.out fc8464d
> ql/src/test/results/clientpositive/union_remove_21.q.out 842e67f
> ql/src/test/results/clientpositive/union_remove_22.q.out 71054ae
> ql/src/test/results/clientpositive/union_remove_23.q.out 96e7d3d
> ql/src/test/results/clientpositive/union_remove_24.q.out d9e86bf
> ql/src/test/results/clientpositive/union_remove_25.q.out 0435ad5
> ql/src/test/results/clientpositive/union_remove_3.q.out 0de46d0
> ql/src/test/results/clientpositive/union_remove_4.q.out b83a0a8
> ql/src/test/results/clientpositive/union_remove_5.q.out 81e64b4
> ql/src/test/results/clientpositive/union_remove_6.q.out 215e90e
> ql/src/test/results/clientpositive/union_remove_6_subq.q.out 2661bcb
> ql/src/test/results/clientpositive/union_remove_7.q.out 4feb092
> ql/src/test/results/clientpositive/union_remove_8.q.out 5d22aa5
> ql/src/test/results/clientpositive/union_remove_9.q.out 7380d12
> ql/src/test/results/clientpositive/union_view.q.out 9181e9b
> ql/src/test/results/clientpositive/vector_bucket.q.out 1ac37a7
> ql/src/test/results/clientpositive/vector_date_1.q.out 5ed7424
> ql/src/test/results/clientpositive/vector_interval_2.q.out b70ef7a
> ql/src/test/results/clientpositive/vector_leftsemi_mapjoin.q.out 23a8adb
> ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out 27af52c
> ql/src/test/results/clientpositive/vector_mr_diff_schema_alias.q.out 59985cb
> ql/src/test/results/clientpositive/vector_multi_insert.q.out 2fcacad
> ql/src/test/results/clientpositive/vectorization_short_regress.q.out b9ab174
>
> Diff: https://reviews.apache.org/r/34143/diff/
>
>
> Testing
> -------
>
>
> Thanks,
>
> pengcheng xiong
>
>
Re: Review Request 34143: Fix stats annotation
Posted by pengcheng xiong <px...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/34143/
-----------------------------------------------------------
(Updated May 23, 2015, 6:10 a.m.)
Review request for hive, Ashutosh Chauhan and John Pullokkaran.
Repository: hive-git
Description
-------
This is a umbrella patch for a bunch of issues: HIVE-8769 Physical optimizer : Incorrect CE results in a shuffle join instead of a Map join (PK/FK pattern not detected) HIVE-9392 JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column names having duplicated fqColumnName HIVE-10107 Union All : Vertex missing stats resulting in OOM and in-efficient plans
Diffs (updated)
-----
hbase-handler/src/test/results/positive/external_table_ppd.q.out 6d48edb
hbase-handler/src/test/results/positive/hbase_custom_key2.q.out c9b5a84
hbase-handler/src/test/results/positive/hbase_custom_key3.q.out 76848e0
hbase-handler/src/test/results/positive/hbase_ppd_key_range.q.out 6174bfb
hbase-handler/src/test/results/positive/hbase_pushdown.q.out 8a979bf
hbase-handler/src/test/results/positive/hbase_queries.q.out 7863f69
hbase-handler/src/test/results/positive/hbase_timestamp.q.out 3aae7d0
hbase-handler/src/test/results/positive/ppd_key_ranges.q.out 5936735
ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/RelOptHiveTable.java 0de7488
ql/src/java/org/apache/hadoop/hive/ql/optimizer/stats/annotation/StatsRulesProcFactory.java 44269f0
ql/src/java/org/apache/hadoop/hive/ql/plan/AbstractOperatorDesc.java 0a83440
ql/src/java/org/apache/hadoop/hive/ql/plan/ColStatistics.java c420190
ql/src/java/org/apache/hadoop/hive/ql/plan/Statistics.java f66279f
ql/src/java/org/apache/hadoop/hive/ql/stats/StatsUtils.java 10871e4
ql/src/test/results/clientpositive/annotate_stats_filter.q.out aa66bc6
ql/src/test/results/clientpositive/annotate_stats_limit.q.out 5f8b6f8
ql/src/test/results/clientpositive/annotate_stats_part.q.out 241192b
ql/src/test/results/clientpositive/annotate_stats_select.q.out 753ab4e
ql/src/test/results/clientpositive/annotate_stats_table.q.out 9bf82ac
ql/src/test/results/clientpositive/auto_join30.q.out b068493
ql/src/test/results/clientpositive/auto_join31.q.out 1e19dd0
ql/src/test/results/clientpositive/auto_join32.q.out bfc8be8
ql/src/test/results/clientpositive/auto_join_stats.q.out 9100762
ql/src/test/results/clientpositive/auto_join_stats2.q.out ed09875
ql/src/test/results/clientpositive/auto_join_without_localtask.q.out ce4ad8a
ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out 383defd
ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out e9fb705
ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out 43504d8
ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out afd5518
ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out c089419
ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out 6e443fa
ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out feaea04
ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out f64ecf0
ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out f039dda
ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out e89f548
ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out 44c037f
ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out 65aa3ef
ql/src/test/results/clientpositive/binarysortable_1.q.out c4ba7e0
ql/src/test/results/clientpositive/bucket_map_join_1.q.out d778203
ql/src/test/results/clientpositive/bucket_map_join_2.q.out aef77aa
ql/src/test/results/clientpositive/bucketmapjoin1.q.out 72f2a07
ql/src/test/results/clientpositive/bucketsortoptimize_insert_2.q.out eec099c
ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out 1a644a9
ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out e4f90e4
ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out 307c83b
ql/src/test/results/clientpositive/column_access_stats.q.out a779564
ql/src/test/results/clientpositive/complex_alias.q.out 133ce91
ql/src/test/results/clientpositive/correlationoptimizer1.q.out 0eb1596
ql/src/test/results/clientpositive/correlationoptimizer10.q.out 3c3564d
ql/src/test/results/clientpositive/correlationoptimizer11.q.out bd86942
ql/src/test/results/clientpositive/correlationoptimizer15.q.out b57203e
ql/src/test/results/clientpositive/correlationoptimizer2.q.out 43d209f
ql/src/test/results/clientpositive/correlationoptimizer3.q.out 5389647
ql/src/test/results/clientpositive/correlationoptimizer4.q.out b350816
ql/src/test/results/clientpositive/correlationoptimizer5.q.out 6ba3462
ql/src/test/results/clientpositive/correlationoptimizer6.q.out be518dc
ql/src/test/results/clientpositive/cross_product_check_2.q.out 500f912
ql/src/test/results/clientpositive/decimal_precision2.q.out dafc2c3
ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_dynamic.q.out 31d9a6e
ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_static.q.out b0773ec
ql/src/test/results/clientpositive/explain_logical.q.out 9b86ce8
ql/src/test/results/clientpositive/explain_rearrange.q.out c4a015e
ql/src/test/results/clientpositive/filter_numeric.q.out b6b8339
ql/src/test/results/clientpositive/fold_case.q.out de6c43e
ql/src/test/results/clientpositive/fold_when.q.out 51d4767
ql/src/test/results/clientpositive/groupby_cube1.q.out 659ac52
ql/src/test/results/clientpositive/groupby_grouping_sets2.q.out 5acac64
ql/src/test/results/clientpositive/groupby_grouping_sets3.q.out b96521a
ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out a00f94b
ql/src/test/results/clientpositive/groupby_grouping_sets5.q.out b2625fe
ql/src/test/results/clientpositive/groupby_grouping_sets6.q.out 587a8c3
ql/src/test/results/clientpositive/groupby_ppd.q.out dbbab88
ql/src/test/results/clientpositive/groupby_rollup1.q.out faa6583
ql/src/test/results/clientpositive/groupby_sort_6.q.out c5cb8b9
ql/src/test/results/clientpositive/having2.q.out 9539394
ql/src/test/results/clientpositive/identity_project_remove_skip.q.out e7bd0ed
ql/src/test/results/clientpositive/implicit_cast1.q.out d4bcd64
ql/src/test/results/clientpositive/index_auto_empty.q.out f824ce5
ql/src/test/results/clientpositive/index_serde.q.out 182d681
ql/src/test/results/clientpositive/index_skewtable.q.out fac53e5
ql/src/test/results/clientpositive/infer_const_type.q.out 09803b4
ql/src/test/results/clientpositive/input21.q.out f6559f3
ql/src/test/results/clientpositive/input23.q.out 73038c3
ql/src/test/results/clientpositive/input24.q.out 63f2b64
ql/src/test/results/clientpositive/input25.q.out bf9948a
ql/src/test/results/clientpositive/input26.q.out 1b24aa6
ql/src/test/results/clientpositive/input9.q.out d1824e5
ql/src/test/results/clientpositive/input_part4.q.out 1ebf36b
ql/src/test/results/clientpositive/insert1.q.out 5816a2c
ql/src/test/results/clientpositive/join19.q.out 2570663
ql/src/test/results/clientpositive/join29.q.out 63bd035
ql/src/test/results/clientpositive/join31.q.out ddd4077
ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out c1e1051
ql/src/test/results/clientpositive/join_cond_pushdown_unqual2.q.out 678ddb8
ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out 0adf5d7
ql/src/test/results/clientpositive/join_cond_pushdown_unqual4.q.out 4668eb1
ql/src/test/results/clientpositive/join_hive_626.q.out 4e29d42
ql/src/test/results/clientpositive/join_reorder.q.out c9498bf
ql/src/test/results/clientpositive/join_reorder2.q.out 0d56a42
ql/src/test/results/clientpositive/join_reorder3.q.out eb847c2
ql/src/test/results/clientpositive/join_reorder4.q.out 23f4e4c
ql/src/test/results/clientpositive/join_view.q.out e703e0b
ql/src/test/results/clientpositive/keyword_1.q.out a37093d
ql/src/test/results/clientpositive/lateral_view_explode2.q.out 737d562
ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out 13e601a
ql/src/test/results/clientpositive/mapjoin_subquery2.q.out 507c7ca
ql/src/test/results/clientpositive/merge_join_1.q.out 99c7efe
ql/src/test/results/clientpositive/mergejoins.q.out 68416a0
ql/src/test/results/clientpositive/mergejoins_mixed.q.out 6bcc3d5
ql/src/test/results/clientpositive/metadataonly1.q.out e55efd5
ql/src/test/results/clientpositive/multiMapJoin1.q.out c00ff29
ql/src/test/results/clientpositive/multiMapJoin2.q.out 5a07fe0
ql/src/test/results/clientpositive/multigroupby_singlemr.q.out 4b80693
ql/src/test/results/clientpositive/nullformatCTAS.q.out 892de6e
ql/src/test/results/clientpositive/nullgroup3.q.out 7712d4d
ql/src/test/results/clientpositive/nullgroup5.q.out 8a94d62
ql/src/test/results/clientpositive/optimize_nullscan.q.out 888af95
ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out df5ee76
ql/src/test/results/clientpositive/partition_boolexpr.q.out cfd03e2
ql/src/test/results/clientpositive/ppd_gby_join.q.out be275bd
ql/src/test/results/clientpositive/ppd_join.q.out d495a1a
ql/src/test/results/clientpositive/ppd_join4.q.out 22f84ba
ql/src/test/results/clientpositive/ppd_join5.q.out 85e357e
ql/src/test/results/clientpositive/ppd_outer_join2.q.out 681c2ea
ql/src/test/results/clientpositive/ppd_outer_join3.q.out 75f1020
ql/src/test/results/clientpositive/ppd_outer_join4.q.out bb5b5cf
ql/src/test/results/clientpositive/ppd_outer_join5.q.out 43c792f
ql/src/test/results/clientpositive/ppd_repeated_alias.q.out 7d3482b
ql/src/test/results/clientpositive/ppd_udf_col.q.out c3e7d1b
ql/src/test/results/clientpositive/ppd_union_view.q.out a13ef7a
ql/src/test/results/clientpositive/ql_rewrite_gbtoidx.q.out 0a3c427
ql/src/test/results/clientpositive/ql_rewrite_gbtoidx_cbo_1.q.out 5ca966f
ql/src/test/results/clientpositive/ql_rewrite_gbtoidx_cbo_2.q.out 381e58f
ql/src/test/results/clientpositive/query_result_fileformat.q.out 3848bd4
ql/src/test/results/clientpositive/quote1.q.out 20f754f
ql/src/test/results/clientpositive/quotedid_basic.q.out 507369c
ql/src/test/results/clientpositive/quotedid_skew.q.out f604cdd
ql/src/test/results/clientpositive/reduce_deduplicate.q.out fa714b8
ql/src/test/results/clientpositive/runtime_skewjoin_mapjoin_spark.q.out 889a9d0
ql/src/test/results/clientpositive/sample6.q.out 9891cbb
ql/src/test/results/clientpositive/select_dummy_source.q.out b1f0939
ql/src/test/results/clientpositive/semijoin.q.out 97eb9fb
ql/src/test/results/clientpositive/skewjoin.q.out 27f2ffc
ql/src/test/results/clientpositive/skewjoin_mapjoin1.q.out 9f10861
ql/src/test/results/clientpositive/skewjoin_mapjoin10.q.out 27b1aee
ql/src/test/results/clientpositive/skewjoin_mapjoin11.q.out dd084e8
ql/src/test/results/clientpositive/skewjoin_mapjoin2.q.out 7e3046f
ql/src/test/results/clientpositive/skewjoin_mapjoin3.q.out 40e4de2
ql/src/test/results/clientpositive/skewjoin_mapjoin4.q.out b7c12f9
ql/src/test/results/clientpositive/skewjoin_mapjoin5.q.out 7c04a9d
ql/src/test/results/clientpositive/skewjoin_mapjoin6.q.out d3183f8
ql/src/test/results/clientpositive/skewjoin_mapjoin7.q.out aaf7de3
ql/src/test/results/clientpositive/skewjoin_mapjoin8.q.out 5d1a3e8
ql/src/test/results/clientpositive/skewjoin_mapjoin9.q.out c7271b0
ql/src/test/results/clientpositive/skewjoin_union_remove_1.q.out c67b681
ql/src/test/results/clientpositive/skewjoin_union_remove_2.q.out 2979c42
ql/src/test/results/clientpositive/skewjoinopt1.q.out 61e9a8e
ql/src/test/results/clientpositive/skewjoinopt10.q.out 90925a0
ql/src/test/results/clientpositive/skewjoinopt11.q.out 2504c17
ql/src/test/results/clientpositive/skewjoinopt12.q.out 5ac7677
ql/src/test/results/clientpositive/skewjoinopt13.q.out d6ede51
ql/src/test/results/clientpositive/skewjoinopt14.q.out 8a4802e
ql/src/test/results/clientpositive/skewjoinopt15.q.out 3abf5b7
ql/src/test/results/clientpositive/skewjoinopt16.q.out 894a265
ql/src/test/results/clientpositive/skewjoinopt17.q.out d27929f
ql/src/test/results/clientpositive/skewjoinopt18.q.out 33a0ed9
ql/src/test/results/clientpositive/skewjoinopt19.q.out fd43409
ql/src/test/results/clientpositive/skewjoinopt2.q.out d613f10
ql/src/test/results/clientpositive/skewjoinopt20.q.out a28e433
ql/src/test/results/clientpositive/skewjoinopt3.q.out bd87ccd
ql/src/test/results/clientpositive/skewjoinopt4.q.out 47f5a92
ql/src/test/results/clientpositive/skewjoinopt5.q.out d46214c
ql/src/test/results/clientpositive/skewjoinopt6.q.out c42a3ef
ql/src/test/results/clientpositive/skewjoinopt7.q.out 97482f0
ql/src/test/results/clientpositive/skewjoinopt8.q.out 244c2be
ql/src/test/results/clientpositive/skewjoinopt9.q.out f877e56
ql/src/test/results/clientpositive/smb_mapjoin9.q.out cbaf7e1
ql/src/test/results/clientpositive/spark/auto_join27.q.out 0ae494e
ql/src/test/results/clientpositive/spark/auto_join32.q.out 361a968
ql/src/test/results/clientpositive/spark/auto_join_stats.q.out 1fa1a74
ql/src/test/results/clientpositive/spark/auto_join_stats2.q.out c6473d3
ql/src/test/results/clientpositive/spark/auto_sortmerge_join_10.q.out 2b245fb
ql/src/test/results/clientpositive/spark/auto_sortmerge_join_12.q.out 8102ec1
ql/src/test/results/clientpositive/spark/bucket_map_join_1.q.out 4e8ce0d
ql/src/test/results/clientpositive/spark/bucket_map_join_2.q.out c0a3c3d
ql/src/test/results/clientpositive/spark/bucketmapjoin1.q.out 44f4d0c
ql/src/test/results/clientpositive/spark/column_access_stats.q.out 3e16f61
ql/src/test/results/clientpositive/spark/groupby_cube1.q.out 8191b64
ql/src/test/results/clientpositive/spark/groupby_rollup1.q.out 25029d0
ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out cfbce61
ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out 9343805
ql/src/test/results/clientpositive/spark/insert1.q.out ba8876f
ql/src/test/results/clientpositive/spark/join19.q.out f84ce2d
ql/src/test/results/clientpositive/spark/join34.q.out 54b7ba0
ql/src/test/results/clientpositive/spark/join35.q.out 3d14a79
ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual1.q.out 687f2e9
ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual2.q.out 949fdee
ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual3.q.out 2d70084
ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual4.q.out 3de2aed
ql/src/test/results/clientpositive/spark/join_hive_626.q.out bb65240
ql/src/test/results/clientpositive/spark/join_reorder.q.out 69b90b5
ql/src/test/results/clientpositive/spark/join_reorder2.q.out 9f9104c
ql/src/test/results/clientpositive/spark/join_reorder3.q.out 9813110
ql/src/test/results/clientpositive/spark/join_reorder4.q.out 5cc30f7
ql/src/test/results/clientpositive/spark/join_view.q.out f6e0542
ql/src/test/results/clientpositive/spark/lateral_view_explode2.q.out 41d60f5
ql/src/test/results/clientpositive/spark/load_dyn_part13.q.out 51e57e8
ql/src/test/results/clientpositive/spark/load_dyn_part14.q.out ca36ac6
ql/src/test/results/clientpositive/spark/mapjoin_subquery2.q.out 06b2cbe
ql/src/test/results/clientpositive/spark/mergejoins.q.out 86ee699
ql/src/test/results/clientpositive/spark/mergejoins_mixed.q.out 8dcf5ac
ql/src/test/results/clientpositive/spark/multi_insert.q.out 137082a
ql/src/test/results/clientpositive/spark/multi_insert_move_tasks_share_dependencies.q.out 4645a65
ql/src/test/results/clientpositive/spark/multi_join_union.q.out bda569d
ql/src/test/results/clientpositive/spark/multigroupby_singlemr.q.out c1480e3
ql/src/test/results/clientpositive/spark/optimize_nullscan.q.out b5eff31
ql/src/test/results/clientpositive/spark/ppd_gby_join.q.out e76f9cf
ql/src/test/results/clientpositive/spark/ppd_join.q.out 2925a83
ql/src/test/results/clientpositive/spark/ppd_join4.q.out 193311a
ql/src/test/results/clientpositive/spark/ppd_join5.q.out 5943e7c
ql/src/test/results/clientpositive/spark/ppd_outer_join1.q.out 7c10afe
ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out c70133e
ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out 9bcacb3
ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out 690a9e3
ql/src/test/results/clientpositive/spark/ql_rewrite_gbtoidx.q.out 45712d6
ql/src/test/results/clientpositive/spark/ql_rewrite_gbtoidx_cbo_1.q.out aec0204
ql/src/test/results/clientpositive/spark/reduce_deduplicate.q.out 7b92c73
ql/src/test/results/clientpositive/spark/runtime_skewjoin_mapjoin_spark.q.out 2348058
ql/src/test/results/clientpositive/spark/sample6.q.out 4117732
ql/src/test/results/clientpositive/spark/semijoin.q.out 96edf5f
ql/src/test/results/clientpositive/spark/skewjoin.q.out 35d4f6f
ql/src/test/results/clientpositive/spark/skewjoin_union_remove_1.q.out 0ce2bb9
ql/src/test/results/clientpositive/spark/skewjoin_union_remove_2.q.out 3d629be
ql/src/test/results/clientpositive/spark/skewjoinopt1.q.out 93e08eb
ql/src/test/results/clientpositive/spark/skewjoinopt10.q.out a30ccc9
ql/src/test/results/clientpositive/spark/skewjoinopt11.q.out 2dfe692
ql/src/test/results/clientpositive/spark/skewjoinopt12.q.out 667ec5c
ql/src/test/results/clientpositive/spark/skewjoinopt13.q.out 88d84c4
ql/src/test/results/clientpositive/spark/skewjoinopt14.q.out 5bc8a76
ql/src/test/results/clientpositive/spark/skewjoinopt15.q.out 3ac7511
ql/src/test/results/clientpositive/spark/skewjoinopt16.q.out 46a28de
ql/src/test/results/clientpositive/spark/skewjoinopt17.q.out 8c7d620
ql/src/test/results/clientpositive/spark/skewjoinopt18.q.out 60c4677
ql/src/test/results/clientpositive/spark/skewjoinopt19.q.out eb9bb84
ql/src/test/results/clientpositive/spark/skewjoinopt2.q.out 1c5f36d
ql/src/test/results/clientpositive/spark/skewjoinopt20.q.out 22de156
ql/src/test/results/clientpositive/spark/skewjoinopt3.q.out 0707b4c
ql/src/test/results/clientpositive/spark/skewjoinopt4.q.out cff75a6
ql/src/test/results/clientpositive/spark/skewjoinopt5.q.out 3c4cb67
ql/src/test/results/clientpositive/spark/skewjoinopt6.q.out 16a218b
ql/src/test/results/clientpositive/spark/skewjoinopt7.q.out bba46c0
ql/src/test/results/clientpositive/spark/skewjoinopt8.q.out 7c8328f
ql/src/test/results/clientpositive/spark/skewjoinopt9.q.out 4c789cf
ql/src/test/results/clientpositive/spark/stats1.q.out fa8d05f
ql/src/test/results/clientpositive/spark/stats12.q.out 0e25ac1
ql/src/test/results/clientpositive/spark/stats13.q.out 4934aec
ql/src/test/results/clientpositive/spark/stats2.q.out ad7ba0d
ql/src/test/results/clientpositive/spark/stats7.q.out 32b09a0
ql/src/test/results/clientpositive/spark/stats8.q.out 54eb2a1
ql/src/test/results/clientpositive/spark/subquery_multiinsert.q.java1.7.out 92a8595
ql/src/test/results/clientpositive/spark/temp_table.q.out 16d663d
ql/src/test/results/clientpositive/spark/transform1.q.out 4a79875
ql/src/test/results/clientpositive/spark/udf_in_file.q.out c769d1f
ql/src/test/results/clientpositive/spark/union.q.out f2bd7b0
ql/src/test/results/clientpositive/spark/union10.q.out 3138618
ql/src/test/results/clientpositive/spark/union11.q.out 2689bb6
ql/src/test/results/clientpositive/spark/union12.q.out cd21b73
ql/src/test/results/clientpositive/spark/union13.q.out b995d22
ql/src/test/results/clientpositive/spark/union14.q.out 4027393
ql/src/test/results/clientpositive/spark/union15.q.out fcc1cf7
ql/src/test/results/clientpositive/spark/union16.q.out 51ba287
ql/src/test/results/clientpositive/spark/union17.q.out 4b0b682
ql/src/test/results/clientpositive/spark/union18.q.out 3e25a49
ql/src/test/results/clientpositive/spark/union19.q.out b6b172f
ql/src/test/results/clientpositive/spark/union2.q.out 3ab9069
ql/src/test/results/clientpositive/spark/union20.q.out d1e23f6
ql/src/test/results/clientpositive/spark/union21.q.out 8a26f5e
ql/src/test/results/clientpositive/spark/union22.q.out 4cb7bf0
ql/src/test/results/clientpositive/spark/union23.q.out dda7234
ql/src/test/results/clientpositive/spark/union24.q.out 22ec159
ql/src/test/results/clientpositive/spark/union25.q.out 67416a3
ql/src/test/results/clientpositive/spark/union26.q.out fa996ed
ql/src/test/results/clientpositive/spark/union27.q.out e66db27
ql/src/test/results/clientpositive/spark/union28.q.out 0294bad
ql/src/test/results/clientpositive/spark/union29.q.out daa581f
ql/src/test/results/clientpositive/spark/union3.q.out 25e78e3
ql/src/test/results/clientpositive/spark/union30.q.out b9b59d4
ql/src/test/results/clientpositive/spark/union31.q.out d58d17c
ql/src/test/results/clientpositive/spark/union32.q.out c8909a5
ql/src/test/results/clientpositive/spark/union33.q.out 2de2984
ql/src/test/results/clientpositive/spark/union34.q.out d5e7e4a
ql/src/test/results/clientpositive/spark/union4.q.out a7308ec
ql/src/test/results/clientpositive/spark/union5.q.out f8cd94b
ql/src/test/results/clientpositive/spark/union6.q.out f2c3411
ql/src/test/results/clientpositive/spark/union7.q.out 73042d6
ql/src/test/results/clientpositive/spark/union8.q.out 2766dc2
ql/src/test/results/clientpositive/spark/union9.q.out 73cf3d5
ql/src/test/results/clientpositive/spark/union_lateralview.q.out 126ca0c
ql/src/test/results/clientpositive/spark/union_ppr.q.out 5d77bef
ql/src/test/results/clientpositive/spark/union_remove_1.q.out 027ede7
ql/src/test/results/clientpositive/spark/union_remove_10.q.out 2bc06d3
ql/src/test/results/clientpositive/spark/union_remove_11.q.out 76cd688
ql/src/test/results/clientpositive/spark/union_remove_12.q.out 81f815f
ql/src/test/results/clientpositive/spark/union_remove_13.q.out bf25b54
ql/src/test/results/clientpositive/spark/union_remove_14.q.out 8259c08
ql/src/test/results/clientpositive/spark/union_remove_15.q.out 1f1e3c8
ql/src/test/results/clientpositive/spark/union_remove_16.q.out f17b7a4
ql/src/test/results/clientpositive/spark/union_remove_17.q.out 9704d0f
ql/src/test/results/clientpositive/spark/union_remove_18.q.out 4b71e77
ql/src/test/results/clientpositive/spark/union_remove_19.q.out 290d11a
ql/src/test/results/clientpositive/spark/union_remove_2.q.out 06d4ad8
ql/src/test/results/clientpositive/spark/union_remove_20.q.out bd8f9d7
ql/src/test/results/clientpositive/spark/union_remove_21.q.out 9379e34
ql/src/test/results/clientpositive/spark/union_remove_22.q.out 8fe568a
ql/src/test/results/clientpositive/spark/union_remove_23.q.out 4add1d6
ql/src/test/results/clientpositive/spark/union_remove_24.q.out 881e4ed
ql/src/test/results/clientpositive/spark/union_remove_25.q.out 5853cc0
ql/src/test/results/clientpositive/spark/union_remove_3.q.out df17b35
ql/src/test/results/clientpositive/spark/union_remove_4.q.out 5d6dd88
ql/src/test/results/clientpositive/spark/union_remove_5.q.out 554cffc
ql/src/test/results/clientpositive/spark/union_remove_6.q.out ea0a1a0
ql/src/test/results/clientpositive/spark/union_remove_6_subq.q.out 977d0f5
ql/src/test/results/clientpositive/spark/union_remove_7.q.out d8f4c03
ql/src/test/results/clientpositive/spark/union_remove_8.q.out 994552e
ql/src/test/results/clientpositive/spark/union_remove_9.q.out a16ca19
ql/src/test/results/clientpositive/spark/union_top_level.q.out a64fc95
ql/src/test/results/clientpositive/spark/union_view.q.out 2ca9e13
ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out 25eb161
ql/src/test/results/clientpositive/stats12.q.out f8aa4d0
ql/src/test/results/clientpositive/stats13.q.out 10ecfd2
ql/src/test/results/clientpositive/stats2.q.out 694c1a2
ql/src/test/results/clientpositive/stats7.q.out 1162103
ql/src/test/results/clientpositive/stats8.q.out 11b2010
ql/src/test/results/clientpositive/subq_where_serialization.q.out 94d3685
ql/src/test/results/clientpositive/subquery_in_having.q.out 862c6ad
ql/src/test/results/clientpositive/subquery_multiinsert.q.java1.7.out 4f8ad0a
ql/src/test/results/clientpositive/subquery_notin.q.out 733e8ff
ql/src/test/results/clientpositive/subquery_notin_having.q.java1.7.out c1bbf0e
ql/src/test/results/clientpositive/subquery_unqual_corr_expr.q.out e3dd5ed
ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out cf22ca6
ql/src/test/results/clientpositive/subquery_views.q.out e495acc
ql/src/test/results/clientpositive/symlink_text_input_format.q.out 6e3b31f
ql/src/test/results/clientpositive/tez/auto_sortmerge_join_10.q.out 28268fc
ql/src/test/results/clientpositive/tez/auto_sortmerge_join_12.q.out 8c8a3bf
ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out 8b3d637
ql/src/test/results/clientpositive/tez/dynamic_partition_pruning_2.q.out 8b0b81d
ql/src/test/results/clientpositive/tez/explainuser_1.q.out b684858
ql/src/test/results/clientpositive/tez/explainuser_2.q.out f84524b
ql/src/test/results/clientpositive/tez/hybridgrace_hashjoin_2.q.out 4ad143c
ql/src/test/results/clientpositive/tez/mergejoin.q.out 97df12a
ql/src/test/results/clientpositive/tez/metadataonly1.q.out 2850314
ql/src/test/results/clientpositive/tez/optimize_nullscan.q.out 2c7528e
ql/src/test/results/clientpositive/tez/selectDistinctStar.q.out f387cd0
ql/src/test/results/clientpositive/tez/skewjoin.q.out ab2ce24
ql/src/test/results/clientpositive/tez/temp_table.q.out 1bf4085
ql/src/test/results/clientpositive/tez/tez_join.q.out b87b71c
ql/src/test/results/clientpositive/tez/tez_join_hash.q.out c4bec62
ql/src/test/results/clientpositive/tez/tez_smb_main.q.out 6183390
ql/src/test/results/clientpositive/tez/tez_union.q.out 4c9368e
ql/src/test/results/clientpositive/tez/tez_union2.q.out 4e4ed9f
ql/src/test/results/clientpositive/tez/tez_union_group_by.q.out 654b34b
ql/src/test/results/clientpositive/tez/tez_union_multiinsert.q.out e67bf3e
ql/src/test/results/clientpositive/tez/transform1.q.out 718f128
ql/src/test/results/clientpositive/tez/union2.q.out f3c5723
ql/src/test/results/clientpositive/tez/union3.q.out 79e29a5
ql/src/test/results/clientpositive/tez/union4.q.out e28af5e
ql/src/test/results/clientpositive/tez/union5.q.out c771747
ql/src/test/results/clientpositive/tez/union6.q.out 9d24ea1
ql/src/test/results/clientpositive/tez/union7.q.out 2e07bad
ql/src/test/results/clientpositive/tez/union8.q.out 3ee38b2
ql/src/test/results/clientpositive/tez/union9.q.out e6464a0
ql/src/test/results/clientpositive/tez/unionDistinct_1.q.out 9940e4b
ql/src/test/results/clientpositive/tez/vector_bucket.q.out 410212a
ql/src/test/results/clientpositive/tez/vector_date_1.q.out 8d1192a
ql/src/test/results/clientpositive/tez/vector_interval_2.q.out 0f32cee
ql/src/test/results/clientpositive/tez/vector_leftsemi_mapjoin.q.out 564f59d
ql/src/test/results/clientpositive/tez/vector_mr_diff_schema_alias.q.out fafccdc
ql/src/test/results/clientpositive/tez/vectorization_short_regress.q.out bf01f78
ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out fd6c629
ql/src/test/results/clientpositive/timestamp_literal.q.out 13ffaf1
ql/src/test/results/clientpositive/transform1.q.out 9382cf0
ql/src/test/results/clientpositive/type_widening.q.out e6617d4
ql/src/test/results/clientpositive/udf_add_months.q.out 8c37fc2
ql/src/test/results/clientpositive/udf_bitwise_shiftleft.q.out 6703d95
ql/src/test/results/clientpositive/udf_bitwise_shiftright.q.out dbfe390
ql/src/test/results/clientpositive/udf_bitwise_shiftrightunsigned.q.out c20029e
ql/src/test/results/clientpositive/udf_cbrt.q.out 4cdaf15
ql/src/test/results/clientpositive/udf_current_database.q.out e22165e
ql/src/test/results/clientpositive/udf_date_format.q.out acca21e
ql/src/test/results/clientpositive/udf_decode.q.out 107712a
ql/src/test/results/clientpositive/udf_factorial.q.out b9b7bf9
ql/src/test/results/clientpositive/udf_from_utc_timestamp.q.out 4df872c
ql/src/test/results/clientpositive/udf_in_file.q.out 5564890
ql/src/test/results/clientpositive/udf_last_day.q.out 2d39e38
ql/src/test/results/clientpositive/udf_length.q.out f4b0b18
ql/src/test/results/clientpositive/udf_levenshtein.q.out 1a60822
ql/src/test/results/clientpositive/udf_md5.q.out 01744fe
ql/src/test/results/clientpositive/udf_months_between.q.out 95f756f
ql/src/test/results/clientpositive/udf_quarter.q.out b29ba4a
ql/src/test/results/clientpositive/udf_sha2.q.out e39da08
ql/src/test/results/clientpositive/udf_soundex.q.out 9895a90
ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out e70b401
ql/src/test/results/clientpositive/udf_trunc.q.out 6cc18c2
ql/src/test/results/clientpositive/udtf_stack.q.out 4e9c2fd
ql/src/test/results/clientpositive/union10.q.out 53490e6
ql/src/test/results/clientpositive/union11.q.out c77a766
ql/src/test/results/clientpositive/union12.q.out d65086b
ql/src/test/results/clientpositive/union14.q.out 5bd1556
ql/src/test/results/clientpositive/union15.q.out 55d5510
ql/src/test/results/clientpositive/union17.q.out 56b335a
ql/src/test/results/clientpositive/union18.q.out a76d7fd
ql/src/test/results/clientpositive/union19.q.out da94293
ql/src/test/results/clientpositive/union20.q.out b80ec1e
ql/src/test/results/clientpositive/union21.q.out b24c276
ql/src/test/results/clientpositive/union22.q.out 9115287
ql/src/test/results/clientpositive/union4.q.out b7f03ea
ql/src/test/results/clientpositive/union5.q.out 0b0d7c6
ql/src/test/results/clientpositive/union7.q.out 5be3185
ql/src/test/results/clientpositive/unionDistinct_1.q.out c102b46
ql/src/test/results/clientpositive/union_remove_1.q.out f30f39b
ql/src/test/results/clientpositive/union_remove_10.q.out e720c37
ql/src/test/results/clientpositive/union_remove_11.q.out 571b398
ql/src/test/results/clientpositive/union_remove_12.q.out 4d6f4a1
ql/src/test/results/clientpositive/union_remove_13.q.out a558967
ql/src/test/results/clientpositive/union_remove_14.q.out 1502749
ql/src/test/results/clientpositive/union_remove_15.q.out 2b3c109
ql/src/test/results/clientpositive/union_remove_16.q.out ef32e1c
ql/src/test/results/clientpositive/union_remove_17.q.out 56b22d9
ql/src/test/results/clientpositive/union_remove_18.q.out 80971dd
ql/src/test/results/clientpositive/union_remove_19.q.out 030c5ce
ql/src/test/results/clientpositive/union_remove_2.q.out 1593029
ql/src/test/results/clientpositive/union_remove_20.q.out fc8464d
ql/src/test/results/clientpositive/union_remove_21.q.out 842e67f
ql/src/test/results/clientpositive/union_remove_22.q.out 71054ae
ql/src/test/results/clientpositive/union_remove_23.q.out 96e7d3d
ql/src/test/results/clientpositive/union_remove_24.q.out d9e86bf
ql/src/test/results/clientpositive/union_remove_25.q.out 0435ad5
ql/src/test/results/clientpositive/union_remove_3.q.out 0de46d0
ql/src/test/results/clientpositive/union_remove_4.q.out b83a0a8
ql/src/test/results/clientpositive/union_remove_5.q.out 81e64b4
ql/src/test/results/clientpositive/union_remove_6.q.out 215e90e
ql/src/test/results/clientpositive/union_remove_6_subq.q.out 2661bcb
ql/src/test/results/clientpositive/union_remove_7.q.out 4feb092
ql/src/test/results/clientpositive/union_remove_8.q.out 5d22aa5
ql/src/test/results/clientpositive/union_remove_9.q.out 7380d12
ql/src/test/results/clientpositive/union_view.q.out 9181e9b
ql/src/test/results/clientpositive/vector_bucket.q.out 1ac37a7
ql/src/test/results/clientpositive/vector_date_1.q.out 5ed7424
ql/src/test/results/clientpositive/vector_interval_2.q.out b70ef7a
ql/src/test/results/clientpositive/vector_leftsemi_mapjoin.q.out 23a8adb
ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out 27af52c
ql/src/test/results/clientpositive/vector_mr_diff_schema_alias.q.out 59985cb
ql/src/test/results/clientpositive/vector_multi_insert.q.out 2fcacad
ql/src/test/results/clientpositive/vectorization_short_regress.q.out b823d4b
Diff: https://reviews.apache.org/r/34143/diff/
Testing
-------
Thanks,
pengcheng xiong
Re: Review Request 34143: Fix stats annotation
Posted by pengcheng xiong <px...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/34143/
-----------------------------------------------------------
(Updated May 14, 2015, 4:50 p.m.)
Review request for hive, Ashutosh Chauhan and John Pullokkaran.
Changes
-------
update the failing q tests.
Repository: hive-git
Description
-------
This is a umbrella patch for a bunch of issues: HIVE-8769 Physical optimizer : Incorrect CE results in a shuffle join instead of a Map join (PK/FK pattern not detected) HIVE-9392 JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column names having duplicated fqColumnName HIVE-10107 Union All : Vertex missing stats resulting in OOM and in-efficient plans
Diffs (updated)
-----
hbase-handler/src/test/results/positive/external_table_ppd.q.out 6d48edb
hbase-handler/src/test/results/positive/hbase_custom_key2.q.out c9b5a84
hbase-handler/src/test/results/positive/hbase_custom_key3.q.out 76848e0
hbase-handler/src/test/results/positive/hbase_ppd_key_range.q.out 6174bfb
hbase-handler/src/test/results/positive/hbase_pushdown.q.out 8a979bf
hbase-handler/src/test/results/positive/hbase_queries.q.out 7863f69
hbase-handler/src/test/results/positive/hbase_timestamp.q.out 3aae7d0
hbase-handler/src/test/results/positive/ppd_key_ranges.q.out 5936735
ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/RelOptHiveTable.java 0de7488
ql/src/java/org/apache/hadoop/hive/ql/optimizer/stats/annotation/StatsRulesProcFactory.java 44269f0
ql/src/java/org/apache/hadoop/hive/ql/plan/AbstractOperatorDesc.java 0a83440
ql/src/java/org/apache/hadoop/hive/ql/plan/ColStatistics.java c420190
ql/src/java/org/apache/hadoop/hive/ql/plan/Statistics.java f66279f
ql/src/java/org/apache/hadoop/hive/ql/stats/StatsUtils.java 508d880
ql/src/test/results/clientpositive/annotate_stats_filter.q.out e8cd06d
ql/src/test/results/clientpositive/annotate_stats_limit.q.out 5f8b6f8
ql/src/test/results/clientpositive/annotate_stats_part.q.out 241192b
ql/src/test/results/clientpositive/annotate_stats_select.q.out 753ab4e
ql/src/test/results/clientpositive/annotate_stats_table.q.out 9bf82ac
ql/src/test/results/clientpositive/auto_join30.q.out b068493
ql/src/test/results/clientpositive/auto_join31.q.out 1e19dd0
ql/src/test/results/clientpositive/auto_join32.q.out bfc8be8
ql/src/test/results/clientpositive/auto_join_stats.q.out 9100762
ql/src/test/results/clientpositive/auto_join_stats2.q.out ed09875
ql/src/test/results/clientpositive/auto_join_without_localtask.q.out ce4ad8a
ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out 383defd
ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out e9fb705
ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out 43504d8
ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out afd5518
ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out c089419
ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out 6e443fa
ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out feaea04
ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out f64ecf0
ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out f039dda
ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out e89f548
ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out 44c037f
ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out 65aa3ef
ql/src/test/results/clientpositive/binarysortable_1.q.out c4ba7e0
ql/src/test/results/clientpositive/bucket_map_join_1.q.out d778203
ql/src/test/results/clientpositive/bucket_map_join_2.q.out aef77aa
ql/src/test/results/clientpositive/bucketmapjoin1.q.out 72f2a07
ql/src/test/results/clientpositive/bucketsortoptimize_insert_2.q.out eec099c
ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out 1a644a9
ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out e4f90e4
ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out 307c83b
ql/src/test/results/clientpositive/column_access_stats.q.out a779564
ql/src/test/results/clientpositive/complex_alias.q.out 133ce91
ql/src/test/results/clientpositive/correlationoptimizer1.q.out 0eb1596
ql/src/test/results/clientpositive/correlationoptimizer10.q.out 3c3564d
ql/src/test/results/clientpositive/correlationoptimizer11.q.out bd86942
ql/src/test/results/clientpositive/correlationoptimizer15.q.out b57203e
ql/src/test/results/clientpositive/correlationoptimizer2.q.out 43d209f
ql/src/test/results/clientpositive/correlationoptimizer3.q.out 5389647
ql/src/test/results/clientpositive/correlationoptimizer4.q.out b350816
ql/src/test/results/clientpositive/correlationoptimizer5.q.out 6ba3462
ql/src/test/results/clientpositive/correlationoptimizer6.q.out be518dc
ql/src/test/results/clientpositive/cross_product_check_2.q.out 500f912
ql/src/test/results/clientpositive/decimal_precision2.q.out dafc2c3
ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_dynamic.q.out 22cbce9
ql/src/test/results/clientpositive/encrypted/encryption_insert_partition_static.q.out 96f8b6a
ql/src/test/results/clientpositive/explain_logical.q.out 9b86ce8
ql/src/test/results/clientpositive/explain_rearrange.q.out c4a015e
ql/src/test/results/clientpositive/filter_numeric.q.out b6b8339
ql/src/test/results/clientpositive/fold_case.q.out de6c43e
ql/src/test/results/clientpositive/fold_when.q.out 37803e0
ql/src/test/results/clientpositive/groupby_cube1.q.out 659ac52
ql/src/test/results/clientpositive/groupby_grouping_sets2.q.out 5acac64
ql/src/test/results/clientpositive/groupby_grouping_sets3.q.out b96521a
ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out a00f94b
ql/src/test/results/clientpositive/groupby_grouping_sets5.q.out b2625fe
ql/src/test/results/clientpositive/groupby_grouping_sets6.q.out 587a8c3
ql/src/test/results/clientpositive/groupby_ppd.q.out dbbab88
ql/src/test/results/clientpositive/groupby_rollup1.q.out faa6583
ql/src/test/results/clientpositive/groupby_sort_6.q.out c5cb8b9
ql/src/test/results/clientpositive/having2.q.out 9539394
ql/src/test/results/clientpositive/identity_project_remove_skip.q.out e7bd0ed
ql/src/test/results/clientpositive/implicit_cast1.q.out d4bcd64
ql/src/test/results/clientpositive/index_auto_empty.q.out f824ce5
ql/src/test/results/clientpositive/index_serde.q.out 182d681
ql/src/test/results/clientpositive/index_skewtable.q.out fac53e5
ql/src/test/results/clientpositive/infer_const_type.q.out 09803b4
ql/src/test/results/clientpositive/input21.q.out f6559f3
ql/src/test/results/clientpositive/input23.q.out 73038c3
ql/src/test/results/clientpositive/input24.q.out 63f2b64
ql/src/test/results/clientpositive/input25.q.out bf9948a
ql/src/test/results/clientpositive/input26.q.out 1b24aa6
ql/src/test/results/clientpositive/input9.q.out d1824e5
ql/src/test/results/clientpositive/input_part4.q.out 1ebf36b
ql/src/test/results/clientpositive/insert1.q.out 5816a2c
ql/src/test/results/clientpositive/join19.q.out 2570663
ql/src/test/results/clientpositive/join29.q.out 63bd035
ql/src/test/results/clientpositive/join31.q.out ddd4077
ql/src/test/results/clientpositive/join_cond_pushdown_unqual1.q.out c1e1051
ql/src/test/results/clientpositive/join_cond_pushdown_unqual2.q.out 678ddb8
ql/src/test/results/clientpositive/join_cond_pushdown_unqual3.q.out 0adf5d7
ql/src/test/results/clientpositive/join_cond_pushdown_unqual4.q.out 4668eb1
ql/src/test/results/clientpositive/join_hive_626.q.out 4e29d42
ql/src/test/results/clientpositive/join_reorder.q.out c9498bf
ql/src/test/results/clientpositive/join_reorder2.q.out 0d56a42
ql/src/test/results/clientpositive/join_reorder3.q.out eb847c2
ql/src/test/results/clientpositive/join_reorder4.q.out 23f4e4c
ql/src/test/results/clientpositive/join_view.q.out e703e0b
ql/src/test/results/clientpositive/keyword_1.q.out a37093d
ql/src/test/results/clientpositive/lateral_view_explode2.q.out 737d562
ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out 13e601a
ql/src/test/results/clientpositive/mapjoin_subquery2.q.out 507c7ca
ql/src/test/results/clientpositive/merge_join_1.q.out 99c7efe
ql/src/test/results/clientpositive/mergejoins.q.out 68416a0
ql/src/test/results/clientpositive/mergejoins_mixed.q.out 6bcc3d5
ql/src/test/results/clientpositive/metadataonly1.q.out e55efd5
ql/src/test/results/clientpositive/multiMapJoin1.q.out c00ff29
ql/src/test/results/clientpositive/multiMapJoin2.q.out 5a07fe0
ql/src/test/results/clientpositive/multigroupby_singlemr.q.out 4b80693
ql/src/test/results/clientpositive/nullformatCTAS.q.out 892de6e
ql/src/test/results/clientpositive/nullgroup3.q.out 7712d4d
ql/src/test/results/clientpositive/nullgroup5.q.out 8a94d62
ql/src/test/results/clientpositive/optimize_nullscan.q.out 888af95
ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out df5ee76
ql/src/test/results/clientpositive/partition_boolexpr.q.out cfd03e2
ql/src/test/results/clientpositive/ppd_gby_join.q.out be275bd
ql/src/test/results/clientpositive/ppd_join.q.out d495a1a
ql/src/test/results/clientpositive/ppd_join4.q.out 22f84ba
ql/src/test/results/clientpositive/ppd_join5.q.out 85e357e
ql/src/test/results/clientpositive/ppd_outer_join2.q.out 681c2ea
ql/src/test/results/clientpositive/ppd_outer_join3.q.out 75f1020
ql/src/test/results/clientpositive/ppd_outer_join4.q.out bb5b5cf
ql/src/test/results/clientpositive/ppd_outer_join5.q.out 43c792f
ql/src/test/results/clientpositive/ppd_repeated_alias.q.out 7d3482b
ql/src/test/results/clientpositive/ppd_udf_col.q.out c3e7d1b
ql/src/test/results/clientpositive/ppd_union_view.q.out a13ef7a
ql/src/test/results/clientpositive/ql_rewrite_gbtoidx.q.out 0a3c427
ql/src/test/results/clientpositive/ql_rewrite_gbtoidx_cbo_1.q.out 5ca966f
ql/src/test/results/clientpositive/ql_rewrite_gbtoidx_cbo_2.q.out 381e58f
ql/src/test/results/clientpositive/query_result_fileformat.q.out 3848bd4
ql/src/test/results/clientpositive/quote1.q.out 20f754f
ql/src/test/results/clientpositive/quotedid_basic.q.out 507369c
ql/src/test/results/clientpositive/quotedid_skew.q.out f604cdd
ql/src/test/results/clientpositive/reduce_deduplicate.q.out fa714b8
ql/src/test/results/clientpositive/runtime_skewjoin_mapjoin_spark.q.out 889a9d0
ql/src/test/results/clientpositive/sample6.q.out 9891cbb
ql/src/test/results/clientpositive/select_dummy_source.q.out b1f0939
ql/src/test/results/clientpositive/semijoin.q.out 97eb9fb
ql/src/test/results/clientpositive/skewjoin.q.out 27f2ffc
ql/src/test/results/clientpositive/skewjoin_mapjoin1.q.out 9f10861
ql/src/test/results/clientpositive/skewjoin_mapjoin10.q.out 27b1aee
ql/src/test/results/clientpositive/skewjoin_mapjoin11.q.out dd084e8
ql/src/test/results/clientpositive/skewjoin_mapjoin2.q.out 7e3046f
ql/src/test/results/clientpositive/skewjoin_mapjoin3.q.out 40e4de2
ql/src/test/results/clientpositive/skewjoin_mapjoin4.q.out b7c12f9
ql/src/test/results/clientpositive/skewjoin_mapjoin5.q.out 7c04a9d
ql/src/test/results/clientpositive/skewjoin_mapjoin6.q.out d3183f8
ql/src/test/results/clientpositive/skewjoin_mapjoin7.q.out aaf7de3
ql/src/test/results/clientpositive/skewjoin_mapjoin8.q.out 5d1a3e8
ql/src/test/results/clientpositive/skewjoin_mapjoin9.q.out c7271b0
ql/src/test/results/clientpositive/skewjoin_union_remove_1.q.out c67b681
ql/src/test/results/clientpositive/skewjoin_union_remove_2.q.out 2979c42
ql/src/test/results/clientpositive/skewjoinopt1.q.out 61e9a8e
ql/src/test/results/clientpositive/skewjoinopt10.q.out 90925a0
ql/src/test/results/clientpositive/skewjoinopt11.q.out 2504c17
ql/src/test/results/clientpositive/skewjoinopt12.q.out 5ac7677
ql/src/test/results/clientpositive/skewjoinopt13.q.out d6ede51
ql/src/test/results/clientpositive/skewjoinopt14.q.out 8a4802e
ql/src/test/results/clientpositive/skewjoinopt15.q.out 3abf5b7
ql/src/test/results/clientpositive/skewjoinopt16.q.out 894a265
ql/src/test/results/clientpositive/skewjoinopt17.q.out d27929f
ql/src/test/results/clientpositive/skewjoinopt18.q.out 33a0ed9
ql/src/test/results/clientpositive/skewjoinopt19.q.out fd43409
ql/src/test/results/clientpositive/skewjoinopt2.q.out d613f10
ql/src/test/results/clientpositive/skewjoinopt20.q.out a28e433
ql/src/test/results/clientpositive/skewjoinopt3.q.out bd87ccd
ql/src/test/results/clientpositive/skewjoinopt4.q.out 47f5a92
ql/src/test/results/clientpositive/skewjoinopt5.q.out d46214c
ql/src/test/results/clientpositive/skewjoinopt6.q.out c42a3ef
ql/src/test/results/clientpositive/skewjoinopt7.q.out 97482f0
ql/src/test/results/clientpositive/skewjoinopt8.q.out 244c2be
ql/src/test/results/clientpositive/skewjoinopt9.q.out f877e56
ql/src/test/results/clientpositive/smb_mapjoin9.q.out cbaf7e1
ql/src/test/results/clientpositive/spark/auto_join27.q.out 0ae494e
ql/src/test/results/clientpositive/spark/auto_join32.q.out c537b95
ql/src/test/results/clientpositive/spark/auto_join_stats.q.out 1fa1a74
ql/src/test/results/clientpositive/spark/auto_join_stats2.q.out c6473d3
ql/src/test/results/clientpositive/spark/auto_sortmerge_join_10.q.out 2b245fb
ql/src/test/results/clientpositive/spark/auto_sortmerge_join_12.q.out 8102ec1
ql/src/test/results/clientpositive/spark/bucket_map_join_1.q.out 4e8ce0d
ql/src/test/results/clientpositive/spark/bucket_map_join_2.q.out c0a3c3d
ql/src/test/results/clientpositive/spark/bucketmapjoin1.q.out 44f4d0c
ql/src/test/results/clientpositive/spark/column_access_stats.q.out 3e16f61
ql/src/test/results/clientpositive/spark/groupby_cube1.q.out 8191b64
ql/src/test/results/clientpositive/spark/groupby_rollup1.q.out 25029d0
ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out cfbce61
ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out 9343805
ql/src/test/results/clientpositive/spark/insert1.q.out ba8876f
ql/src/test/results/clientpositive/spark/join19.q.out f84ce2d
ql/src/test/results/clientpositive/spark/join34.q.out 54b7ba0
ql/src/test/results/clientpositive/spark/join35.q.out 3d14a79
ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual1.q.out 687f2e9
ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual2.q.out 949fdee
ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual3.q.out 2d70084
ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual4.q.out 3de2aed
ql/src/test/results/clientpositive/spark/join_hive_626.q.out bb65240
ql/src/test/results/clientpositive/spark/join_reorder.q.out 69b90b5
ql/src/test/results/clientpositive/spark/join_reorder2.q.out 9f9104c
ql/src/test/results/clientpositive/spark/join_reorder3.q.out 9813110
ql/src/test/results/clientpositive/spark/join_reorder4.q.out 5cc30f7
ql/src/test/results/clientpositive/spark/join_view.q.out f6e0542
ql/src/test/results/clientpositive/spark/lateral_view_explode2.q.out 41d60f5
ql/src/test/results/clientpositive/spark/load_dyn_part13.q.out 51e57e8
ql/src/test/results/clientpositive/spark/load_dyn_part14.q.out ca36ac6
ql/src/test/results/clientpositive/spark/mapjoin_subquery2.q.out 06b2cbe
ql/src/test/results/clientpositive/spark/mergejoins.q.out 86ee699
ql/src/test/results/clientpositive/spark/mergejoins_mixed.q.out 8dcf5ac
ql/src/test/results/clientpositive/spark/multi_insert.q.out 137082a
ql/src/test/results/clientpositive/spark/multi_insert_move_tasks_share_dependencies.q.out 4645a65
ql/src/test/results/clientpositive/spark/multi_join_union.q.out bda569d
ql/src/test/results/clientpositive/spark/multigroupby_singlemr.q.out c1480e3
ql/src/test/results/clientpositive/spark/optimize_nullscan.q.out b5eff31
ql/src/test/results/clientpositive/spark/ppd_gby_join.q.out e76f9cf
ql/src/test/results/clientpositive/spark/ppd_join.q.out 2925a83
ql/src/test/results/clientpositive/spark/ppd_join4.q.out 193311a
ql/src/test/results/clientpositive/spark/ppd_join5.q.out 5943e7c
ql/src/test/results/clientpositive/spark/ppd_outer_join1.q.out 7c10afe
ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out c70133e
ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out 9bcacb3
ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out 690a9e3
ql/src/test/results/clientpositive/spark/ql_rewrite_gbtoidx.q.out 45712d6
ql/src/test/results/clientpositive/spark/ql_rewrite_gbtoidx_cbo_1.q.out aec0204
ql/src/test/results/clientpositive/spark/reduce_deduplicate.q.out 7b92c73
ql/src/test/results/clientpositive/spark/runtime_skewjoin_mapjoin_spark.q.out 2348058
ql/src/test/results/clientpositive/spark/sample6.q.out 4117732
ql/src/test/results/clientpositive/spark/semijoin.q.out 96edf5f
ql/src/test/results/clientpositive/spark/skewjoin.q.out 35d4f6f
ql/src/test/results/clientpositive/spark/skewjoin_union_remove_1.q.out 0ce2bb9
ql/src/test/results/clientpositive/spark/skewjoin_union_remove_2.q.out 3d629be
ql/src/test/results/clientpositive/spark/skewjoinopt1.q.out 93e08eb
ql/src/test/results/clientpositive/spark/skewjoinopt10.q.out a30ccc9
ql/src/test/results/clientpositive/spark/skewjoinopt11.q.out 2dfe692
ql/src/test/results/clientpositive/spark/skewjoinopt12.q.out 667ec5c
ql/src/test/results/clientpositive/spark/skewjoinopt13.q.out 88d84c4
ql/src/test/results/clientpositive/spark/skewjoinopt14.q.out 5bc8a76
ql/src/test/results/clientpositive/spark/skewjoinopt15.q.out 3ac7511
ql/src/test/results/clientpositive/spark/skewjoinopt16.q.out 46a28de
ql/src/test/results/clientpositive/spark/skewjoinopt17.q.out 8c7d620
ql/src/test/results/clientpositive/spark/skewjoinopt18.q.out 60c4677
ql/src/test/results/clientpositive/spark/skewjoinopt19.q.out eb9bb84
ql/src/test/results/clientpositive/spark/skewjoinopt2.q.out 1c5f36d
ql/src/test/results/clientpositive/spark/skewjoinopt20.q.out 22de156
ql/src/test/results/clientpositive/spark/skewjoinopt3.q.out 0707b4c
ql/src/test/results/clientpositive/spark/skewjoinopt4.q.out cff75a6
ql/src/test/results/clientpositive/spark/skewjoinopt5.q.out 3c4cb67
ql/src/test/results/clientpositive/spark/skewjoinopt6.q.out 16a218b
ql/src/test/results/clientpositive/spark/skewjoinopt7.q.out bba46c0
ql/src/test/results/clientpositive/spark/skewjoinopt8.q.out 7c8328f
ql/src/test/results/clientpositive/spark/skewjoinopt9.q.out 4c789cf
ql/src/test/results/clientpositive/spark/stats1.q.out fa8d05f
ql/src/test/results/clientpositive/spark/stats12.q.out 0e25ac1
ql/src/test/results/clientpositive/spark/stats13.q.out 4934aec
ql/src/test/results/clientpositive/spark/stats2.q.out ad7ba0d
ql/src/test/results/clientpositive/spark/stats7.q.out 32b09a0
ql/src/test/results/clientpositive/spark/stats8.q.out 54eb2a1
ql/src/test/results/clientpositive/spark/subquery_multiinsert.q.java1.7.out 92a8595
ql/src/test/results/clientpositive/spark/temp_table.q.out 16d663d
ql/src/test/results/clientpositive/spark/transform1.q.out 4a79875
ql/src/test/results/clientpositive/spark/udf_in_file.q.out c769d1f
ql/src/test/results/clientpositive/spark/union.q.out f2bd7b0
ql/src/test/results/clientpositive/spark/union10.q.out 3138618
ql/src/test/results/clientpositive/spark/union11.q.out 2689bb6
ql/src/test/results/clientpositive/spark/union12.q.out cd21b73
ql/src/test/results/clientpositive/spark/union13.q.out b995d22
ql/src/test/results/clientpositive/spark/union14.q.out 4027393
ql/src/test/results/clientpositive/spark/union15.q.out fcc1cf7
ql/src/test/results/clientpositive/spark/union16.q.out 51ba287
ql/src/test/results/clientpositive/spark/union17.q.out 4b0b682
ql/src/test/results/clientpositive/spark/union18.q.out 3e25a49
ql/src/test/results/clientpositive/spark/union19.q.out b6b172f
ql/src/test/results/clientpositive/spark/union2.q.out 3ab9069
ql/src/test/results/clientpositive/spark/union20.q.out d1e23f6
ql/src/test/results/clientpositive/spark/union21.q.out 8a26f5e
ql/src/test/results/clientpositive/spark/union22.q.out 4cb7bf0
ql/src/test/results/clientpositive/spark/union23.q.out dda7234
ql/src/test/results/clientpositive/spark/union24.q.out 22ec159
ql/src/test/results/clientpositive/spark/union25.q.out 67416a3
ql/src/test/results/clientpositive/spark/union26.q.out fa996ed
ql/src/test/results/clientpositive/spark/union27.q.out e66db27
ql/src/test/results/clientpositive/spark/union28.q.out 0294bad
ql/src/test/results/clientpositive/spark/union29.q.out daa581f
ql/src/test/results/clientpositive/spark/union3.q.out 25e78e3
ql/src/test/results/clientpositive/spark/union30.q.out b9b59d4
ql/src/test/results/clientpositive/spark/union31.q.out d58d17c
ql/src/test/results/clientpositive/spark/union32.q.out c8909a5
ql/src/test/results/clientpositive/spark/union33.q.out 2de2984
ql/src/test/results/clientpositive/spark/union34.q.out d5e7e4a
ql/src/test/results/clientpositive/spark/union4.q.out a7308ec
ql/src/test/results/clientpositive/spark/union5.q.out f8cd94b
ql/src/test/results/clientpositive/spark/union6.q.out f2c3411
ql/src/test/results/clientpositive/spark/union7.q.out 73042d6
ql/src/test/results/clientpositive/spark/union8.q.out 2766dc2
ql/src/test/results/clientpositive/spark/union9.q.out 73cf3d5
ql/src/test/results/clientpositive/spark/union_lateralview.q.out 126ca0c
ql/src/test/results/clientpositive/spark/union_ppr.q.out 5d77bef
ql/src/test/results/clientpositive/spark/union_remove_1.q.out 027ede7
ql/src/test/results/clientpositive/spark/union_remove_10.q.out 2bc06d3
ql/src/test/results/clientpositive/spark/union_remove_11.q.out 76cd688
ql/src/test/results/clientpositive/spark/union_remove_12.q.out 81f815f
ql/src/test/results/clientpositive/spark/union_remove_13.q.out bf25b54
ql/src/test/results/clientpositive/spark/union_remove_14.q.out 8259c08
ql/src/test/results/clientpositive/spark/union_remove_15.q.out 1f1e3c8
ql/src/test/results/clientpositive/spark/union_remove_16.q.out f17b7a4
ql/src/test/results/clientpositive/spark/union_remove_17.q.out 9704d0f
ql/src/test/results/clientpositive/spark/union_remove_18.q.out 4b71e77
ql/src/test/results/clientpositive/spark/union_remove_19.q.out 290d11a
ql/src/test/results/clientpositive/spark/union_remove_2.q.out 06d4ad8
ql/src/test/results/clientpositive/spark/union_remove_20.q.out bd8f9d7
ql/src/test/results/clientpositive/spark/union_remove_21.q.out 9379e34
ql/src/test/results/clientpositive/spark/union_remove_22.q.out 8fe568a
ql/src/test/results/clientpositive/spark/union_remove_23.q.out 4add1d6
ql/src/test/results/clientpositive/spark/union_remove_24.q.out 881e4ed
ql/src/test/results/clientpositive/spark/union_remove_25.q.out 5853cc0
ql/src/test/results/clientpositive/spark/union_remove_3.q.out df17b35
ql/src/test/results/clientpositive/spark/union_remove_4.q.out 5d6dd88
ql/src/test/results/clientpositive/spark/union_remove_5.q.out 554cffc
ql/src/test/results/clientpositive/spark/union_remove_6.q.out ea0a1a0
ql/src/test/results/clientpositive/spark/union_remove_6_subq.q.out 977d0f5
ql/src/test/results/clientpositive/spark/union_remove_7.q.out d8f4c03
ql/src/test/results/clientpositive/spark/union_remove_8.q.out 994552e
ql/src/test/results/clientpositive/spark/union_remove_9.q.out a16ca19
ql/src/test/results/clientpositive/spark/union_top_level.q.out a64fc95
ql/src/test/results/clientpositive/spark/union_view.q.out 2ca9e13
ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out a4b8e05
ql/src/test/results/clientpositive/stats12.q.out f8aa4d0
ql/src/test/results/clientpositive/stats13.q.out 10ecfd2
ql/src/test/results/clientpositive/stats2.q.out 694c1a2
ql/src/test/results/clientpositive/stats7.q.out 1162103
ql/src/test/results/clientpositive/stats8.q.out 11b2010
ql/src/test/results/clientpositive/subq_where_serialization.q.out 94d3685
ql/src/test/results/clientpositive/subquery_in_having.q.out 862c6ad
ql/src/test/results/clientpositive/subquery_multiinsert.q.java1.7.out 4f8ad0a
ql/src/test/results/clientpositive/subquery_notin.q.out 733e8ff
ql/src/test/results/clientpositive/subquery_notin_having.q.java1.7.out 2d5b486
ql/src/test/results/clientpositive/subquery_unqual_corr_expr.q.out e3dd5ed
ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out cf22ca6
ql/src/test/results/clientpositive/subquery_views.q.out e495acc
ql/src/test/results/clientpositive/symlink_text_input_format.q.out 6e3b31f
ql/src/test/results/clientpositive/tez/auto_sortmerge_join_10.q.out 28268fc
ql/src/test/results/clientpositive/tez/auto_sortmerge_join_12.q.out 8c8a3bf
ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out 8b3d637
ql/src/test/results/clientpositive/tez/dynamic_partition_pruning_2.q.out 8c8531c
ql/src/test/results/clientpositive/tez/explainuser_1.q.out b684858
ql/src/test/results/clientpositive/tez/explainuser_2.q.out f84524b
ql/src/test/results/clientpositive/tez/hybridgrace_hashjoin_2.q.out 4ad143c
ql/src/test/results/clientpositive/tez/mergejoin.q.out 97df12a
ql/src/test/results/clientpositive/tez/metadataonly1.q.out 2850314
ql/src/test/results/clientpositive/tez/optimize_nullscan.q.out 2c7528e
ql/src/test/results/clientpositive/tez/selectDistinctStar.q.out f387cd0
ql/src/test/results/clientpositive/tez/skewjoin.q.out ab2ce24
ql/src/test/results/clientpositive/tez/temp_table.q.out 1bf4085
ql/src/test/results/clientpositive/tez/tez_join.q.out b87b71c
ql/src/test/results/clientpositive/tez/tez_join_hash.q.out c4bec62
ql/src/test/results/clientpositive/tez/tez_smb_main.q.out 6183390
ql/src/test/results/clientpositive/tez/tez_union.q.out 4c9368e
ql/src/test/results/clientpositive/tez/tez_union2.q.out 4e4ed9f
ql/src/test/results/clientpositive/tez/tez_union_group_by.q.out 654b34b
ql/src/test/results/clientpositive/tez/tez_union_multiinsert.q.out e67bf3e
ql/src/test/results/clientpositive/tez/transform1.q.out 718f128
ql/src/test/results/clientpositive/tez/union2.q.out f3c5723
ql/src/test/results/clientpositive/tez/union3.q.out 79e29a5
ql/src/test/results/clientpositive/tez/union4.q.out e28af5e
ql/src/test/results/clientpositive/tez/union5.q.out c771747
ql/src/test/results/clientpositive/tez/union6.q.out 9d24ea1
ql/src/test/results/clientpositive/tez/union7.q.out 2e07bad
ql/src/test/results/clientpositive/tez/union8.q.out 3ee38b2
ql/src/test/results/clientpositive/tez/union9.q.out e6464a0
ql/src/test/results/clientpositive/tez/unionDistinct_1.q.out 9940e4b
ql/src/test/results/clientpositive/tez/vector_bucket.q.out 410212a
ql/src/test/results/clientpositive/tez/vector_date_1.q.out 8d1192a
ql/src/test/results/clientpositive/tez/vector_interval_2.q.out 0f32cee
ql/src/test/results/clientpositive/tez/vector_leftsemi_mapjoin.q.out 564f59d
ql/src/test/results/clientpositive/tez/vector_mr_diff_schema_alias.q.out fafccdc
ql/src/test/results/clientpositive/tez/vectorization_short_regress.q.out a3c723d
ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out fd6c629
ql/src/test/results/clientpositive/timestamp_literal.q.out 13ffaf1
ql/src/test/results/clientpositive/transform1.q.out 9382cf0
ql/src/test/results/clientpositive/type_widening.q.out e6617d4
ql/src/test/results/clientpositive/udf_add_months.q.out 8c37fc2
ql/src/test/results/clientpositive/udf_bitwise_shiftleft.q.out 6703d95
ql/src/test/results/clientpositive/udf_bitwise_shiftright.q.out dbfe390
ql/src/test/results/clientpositive/udf_bitwise_shiftrightunsigned.q.out c20029e
ql/src/test/results/clientpositive/udf_cbrt.q.out 4cdaf15
ql/src/test/results/clientpositive/udf_current_database.q.out e22165e
ql/src/test/results/clientpositive/udf_date_format.q.out acca21e
ql/src/test/results/clientpositive/udf_decode.q.out 107712a
ql/src/test/results/clientpositive/udf_factorial.q.out b9b7bf9
ql/src/test/results/clientpositive/udf_from_utc_timestamp.q.out 4df872c
ql/src/test/results/clientpositive/udf_in_file.q.out 5564890
ql/src/test/results/clientpositive/udf_last_day.q.out 2d39e38
ql/src/test/results/clientpositive/udf_length.q.out f4b0b18
ql/src/test/results/clientpositive/udf_levenshtein.q.out 1a60822
ql/src/test/results/clientpositive/udf_md5.q.out 01744fe
ql/src/test/results/clientpositive/udf_months_between.q.out 95f756f
ql/src/test/results/clientpositive/udf_quarter.q.out b29ba4a
ql/src/test/results/clientpositive/udf_soundex.q.out 9895a90
ql/src/test/results/clientpositive/udf_to_utc_timestamp.q.out e70b401
ql/src/test/results/clientpositive/udf_trunc.q.out 6cc18c2
ql/src/test/results/clientpositive/udtf_stack.q.out 4e9c2fd
ql/src/test/results/clientpositive/union10.q.out 53490e6
ql/src/test/results/clientpositive/union11.q.out c77a766
ql/src/test/results/clientpositive/union12.q.out d65086b
ql/src/test/results/clientpositive/union14.q.out 5bd1556
ql/src/test/results/clientpositive/union15.q.out 55d5510
ql/src/test/results/clientpositive/union17.q.out 56b335a
ql/src/test/results/clientpositive/union18.q.out a76d7fd
ql/src/test/results/clientpositive/union19.q.out da94293
ql/src/test/results/clientpositive/union20.q.out b80ec1e
ql/src/test/results/clientpositive/union21.q.out b24c276
ql/src/test/results/clientpositive/union22.q.out 9115287
ql/src/test/results/clientpositive/union4.q.out b7f03ea
ql/src/test/results/clientpositive/union5.q.out 0b0d7c6
ql/src/test/results/clientpositive/union7.q.out 5be3185
ql/src/test/results/clientpositive/unionDistinct_1.q.out c102b46
ql/src/test/results/clientpositive/union_remove_1.q.out f30f39b
ql/src/test/results/clientpositive/union_remove_10.q.out e720c37
ql/src/test/results/clientpositive/union_remove_11.q.out 571b398
ql/src/test/results/clientpositive/union_remove_12.q.out 4d6f4a1
ql/src/test/results/clientpositive/union_remove_13.q.out a558967
ql/src/test/results/clientpositive/union_remove_14.q.out 1502749
ql/src/test/results/clientpositive/union_remove_15.q.out 2b3c109
ql/src/test/results/clientpositive/union_remove_16.q.out ef32e1c
ql/src/test/results/clientpositive/union_remove_17.q.out 56b22d9
ql/src/test/results/clientpositive/union_remove_18.q.out 80971dd
ql/src/test/results/clientpositive/union_remove_19.q.out 030c5ce
ql/src/test/results/clientpositive/union_remove_2.q.out 1593029
ql/src/test/results/clientpositive/union_remove_20.q.out fc8464d
ql/src/test/results/clientpositive/union_remove_21.q.out 842e67f
ql/src/test/results/clientpositive/union_remove_22.q.out 71054ae
ql/src/test/results/clientpositive/union_remove_23.q.out 96e7d3d
ql/src/test/results/clientpositive/union_remove_24.q.out d9e86bf
ql/src/test/results/clientpositive/union_remove_25.q.out 0435ad5
ql/src/test/results/clientpositive/union_remove_3.q.out 0de46d0
ql/src/test/results/clientpositive/union_remove_4.q.out b83a0a8
ql/src/test/results/clientpositive/union_remove_5.q.out 81e64b4
ql/src/test/results/clientpositive/union_remove_6.q.out 215e90e
ql/src/test/results/clientpositive/union_remove_6_subq.q.out 2661bcb
ql/src/test/results/clientpositive/union_remove_7.q.out 4feb092
ql/src/test/results/clientpositive/union_remove_8.q.out 5d22aa5
ql/src/test/results/clientpositive/union_remove_9.q.out 7380d12
ql/src/test/results/clientpositive/union_view.q.out 9181e9b
ql/src/test/results/clientpositive/vector_bucket.q.out 1ac37a7
ql/src/test/results/clientpositive/vector_date_1.q.out 5ed7424
ql/src/test/results/clientpositive/vector_interval_2.q.out b70ef7a
ql/src/test/results/clientpositive/vector_leftsemi_mapjoin.q.out 23a8adb
ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out 27af52c
ql/src/test/results/clientpositive/vector_mr_diff_schema_alias.q.out 59985cb
ql/src/test/results/clientpositive/vector_multi_insert.q.out 2fcacad
ql/src/test/results/clientpositive/vectorization_short_regress.q.out b9ab174
Diff: https://reviews.apache.org/r/34143/diff/
Testing
-------
Thanks,
pengcheng xiong