Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 08B95C7F5 for ; Thu, 4 Dec 2014 13:15:53 +0000 (UTC) Received: (qmail 64008 invoked by uid 500); 4 Dec 2014 13:15:52 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 63943 invoked by uid 500); 4 Dec 2014 13:15:52 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 96992 invoked by uid 99); 3 Dec 2014 17:00:52 -0000 Received: from reviews-vm.apache.org (HELO reviews.apache.org) (140.211.11.40) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Dec 2014 17:00:52 +0000 Received: from reviews.apache.org (localhost [127.0.0.1]) by reviews.apache.org (Postfix) with ESMTP id 7B64B1D214F; Wed, 3 Dec 2014 17:00:50 +0000 (UTC) Content-Type: multipart/alternative; boundary="===============8215178783598271207==" MIME-Version: 1.0 Subject: Review Request 28632: Turn CBO on From: "Ashutosh Chauhan" To: "Sergey Shelukhin" Cc: "Ashutosh Chauhan" , "hive" Date: Wed, 03 Dec 2014 17:00:50 -0000 Message-ID: <20141203170050.32525.83799@reviews.apache.org> X-ReviewBoard-URL: https://reviews.apache.org Auto-Submitted: auto-generated Sender: "Ashutosh Chauhan" X-ReviewGroup: hive X-ReviewRequest-URL: https://reviews.apache.org/r/28632/ X-Sender: "Ashutosh Chauhan" Reply-To: "Ashutosh Chauhan" X-ReviewRequest-Repository: hive-git --===============8215178783598271207== MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/28632/ ----------------------------------------------------------- Review request for hive and Sergey Shelukhin. Bugs: HIVE-8395 https://issues.apache.org/jira/browse/HIVE-8395 Repository: hive-git Description ------- Turn CBO on Diffs ----- accumulo-handler/src/test/results/positive/accumulo_predicate_pushdown.q.out 309f2f7 accumulo-handler/src/test/results/positive/accumulo_queries.q.out 8d7f19c common/src/java/org/apache/hadoop/hive/conf/HiveConf.java 2e2bf5a contrib/src/test/results/clientpositive/dboutput.q.out 554ca02 contrib/src/test/results/clientpositive/udaf_example_avg.q.out d300b0f contrib/src/test/results/clientpositive/udaf_example_group_concat.q.out 762461b contrib/src/test/results/clientpositive/udaf_example_max.q.out 82aeca7 contrib/src/test/results/clientpositive/udaf_example_max_n.q.out db95fcb contrib/src/test/results/clientpositive/udaf_example_min.q.out b62ff39 contrib/src/test/results/clientpositive/udaf_example_min_n.q.out 1344186 hbase-handler/src/test/results/positive/hbase_ppd_key_range.q.out 4e4364e hbase-handler/src/test/results/positive/hbase_queries.q.out 0b4ed37 hbase-handler/src/test/results/positive/hbase_timestamp.q.out f70d371 itests/hive-unit/src/test/java/org/apache/hive/jdbc/TestJdbcDriver2.java 23a1b97 ql/src/test/queries/clientnegative/join_nonexistent_part.q b4a4757 ql/src/test/queries/clientpositive/ambiguous_col.q 5ccd2c8 ql/src/test/queries/clientpositive/annotate_stats_groupby2.q 6e65577 ql/src/test/queries/clientpositive/constantPropagateForSubQuery.q 149a290 ql/src/test/queries/clientpositive/filter_join_breaktask2.q 7f4258f ql/src/test/queries/clientpositive/join_vc.q bbf3e85 ql/src/test/queries/clientpositive/mrr.q 9f068cc ql/src/test/queries/clientpositive/optimize_nullscan.q f3b896b ql/src/test/queries/clientpositive/ppd_gby_join.q 82f358b ql/src/test/queries/clientpositive/ql_rewrite_gbtoidx.q fbfcbe1 ql/src/test/queries/clientpositive/subquery_exists_explain_rewrite.q 60dfdaf ql/src/test/queries/clientpositive/subquery_in_explain_rewrite.q 1d1639d ql/src/test/results/clientnegative/join_nonexistent_part.q.out a924895 ql/src/test/results/clientnegative/ptf_negative_InvalidValueBoundary.q.out 6ad9905 ql/src/test/results/clientpositive/allcolref_in_udf.q.out 969f64b ql/src/test/results/clientpositive/alter_partition_coltype.q.out f71fa05 ql/src/test/results/clientpositive/ambiguous_col.q.out d583162 ql/src/test/results/clientpositive/annotate_stats_filter.q.out 70df189 ql/src/test/results/clientpositive/annotate_stats_groupby.q.out 2640ff7 ql/src/test/results/clientpositive/annotate_stats_groupby2.q.out 2f85c92 ql/src/test/results/clientpositive/annotate_stats_join.q.out ee46003 ql/src/test/results/clientpositive/annotate_stats_join_pkfk.q.out 70c9e1d ql/src/test/results/clientpositive/annotate_stats_limit.q.out b61a597 ql/src/test/results/clientpositive/annotate_stats_part.q.out fb3c17b ql/src/test/results/clientpositive/annotate_stats_select.q.out 8fbb208 ql/src/test/results/clientpositive/annotate_stats_table.q.out a74d85c ql/src/test/results/clientpositive/annotate_stats_union.q.out 919015a ql/src/test/results/clientpositive/ansi_sql_arithmetic.q.out 4917ac0 ql/src/test/results/clientpositive/authorization_explain.q.out 3d97227 ql/src/test/results/clientpositive/auto_join1.q.out 8096a94 ql/src/test/results/clientpositive/auto_join10.q.out 7fb3070 ql/src/test/results/clientpositive/auto_join11.q.out 98c8285 ql/src/test/results/clientpositive/auto_join12.q.out f116e23 ql/src/test/results/clientpositive/auto_join13.q.out 3396a0c ql/src/test/results/clientpositive/auto_join14.q.out 55c9b5d ql/src/test/results/clientpositive/auto_join16.q.out bd5b378 ql/src/test/results/clientpositive/auto_join17.q.out 0fa7aa9 ql/src/test/results/clientpositive/auto_join18.q.out 2303f18 ql/src/test/results/clientpositive/auto_join18_multi_distinct.q.out ee5a32c ql/src/test/results/clientpositive/auto_join19.q.out 4c2e26e ql/src/test/results/clientpositive/auto_join2.q.out 11d57e9 ql/src/test/results/clientpositive/auto_join22.q.out c4a0084 ql/src/test/results/clientpositive/auto_join25.q.out 08cbe42 ql/src/test/results/clientpositive/auto_join26.q.out a40615f ql/src/test/results/clientpositive/auto_join27.q.out db348b7 ql/src/test/results/clientpositive/auto_join3.q.out 0bfb27a ql/src/test/results/clientpositive/auto_join33.q.out e5a7c52 ql/src/test/results/clientpositive/auto_join4.q.out 6492a64 ql/src/test/results/clientpositive/auto_join5.q.out 1073302 ql/src/test/results/clientpositive/auto_join6.q.out 88b7770 ql/src/test/results/clientpositive/auto_join7.q.out 5de5640 ql/src/test/results/clientpositive/auto_join8.q.out bf9b8b4 ql/src/test/results/clientpositive/auto_join9.q.out b5581ed ql/src/test/results/clientpositive/auto_join_filters.q.out a8c0221 ql/src/test/results/clientpositive/auto_join_nulls.q.out 7abde8f ql/src/test/results/clientpositive/auto_join_reordering_values.q.out d9ab9af ql/src/test/results/clientpositive/auto_join_without_localtask.q.out cf065fb ql/src/test/results/clientpositive/autogen_colalias.q.out c748b27 ql/src/test/results/clientpositive/binarysortable_1.q.out e486466 ql/src/test/results/clientpositive/bucket_groupby.q.out 2f04051 ql/src/test/results/clientpositive/cast1.q.out 5fb0bc6 ql/src/test/results/clientpositive/combine2.q.out 1fc1f3e ql/src/test/results/clientpositive/constantPropagateForSubQuery.q.out 317a642 ql/src/test/results/clientpositive/constprog2.q.out 4c8b7c8 ql/src/test/results/clientpositive/correlationoptimizer1.q.out 1b6d2b2 ql/src/test/results/clientpositive/correlationoptimizer10.q.out 00d0c1e ql/src/test/results/clientpositive/correlationoptimizer12.q.out 8e01833 ql/src/test/results/clientpositive/correlationoptimizer13.q.out fd75fc9 ql/src/test/results/clientpositive/correlationoptimizer15.q.out 6b8cf50 ql/src/test/results/clientpositive/correlationoptimizer2.q.out 8782ac1 ql/src/test/results/clientpositive/correlationoptimizer3.q.out c59c0cc ql/src/test/results/clientpositive/correlationoptimizer6.q.out 852fac3 ql/src/test/results/clientpositive/correlationoptimizer7.q.out 15c0eb2 ql/src/test/results/clientpositive/correlationoptimizer8.q.out 2163365 ql/src/test/results/clientpositive/correlationoptimizer9.q.out ea0bef3 ql/src/test/results/clientpositive/count.q.out 835627a ql/src/test/results/clientpositive/create_genericudaf.q.out 0d4fa83 ql/src/test/results/clientpositive/create_view.q.out a028c62 ql/src/test/results/clientpositive/cross_join.q.out 6a657e9 ql/src/test/results/clientpositive/cross_product_check_1.q.out f56f6ea ql/src/test/results/clientpositive/cross_product_check_2.q.out fa5c784 ql/src/test/results/clientpositive/database.q.out ad25cd5 ql/src/test/results/clientpositive/decimal_precision.q.out f3f2cbc ql/src/test/results/clientpositive/decimal_udf.q.out 995401a ql/src/test/results/clientpositive/decimal_udf2.q.out d8511d6 ql/src/test/results/clientpositive/distinct_stats.q.out be46e25 ql/src/test/results/clientpositive/dynpart_sort_opt_vectorization.q.out 87dddc1 ql/src/test/results/clientpositive/dynpart_sort_optimization.q.out cdb783e ql/src/test/results/clientpositive/dynpart_sort_optimization2.q.out 8c58880 ql/src/test/results/clientpositive/explain_dependency.q.out 617ca50 ql/src/test/results/clientpositive/explain_logical.q.out ec2fd20 ql/src/test/results/clientpositive/fetch_aggregation.q.out f0a73f5 ql/src/test/results/clientpositive/filter_join_breaktask.q.out 9cba1c3 ql/src/test/results/clientpositive/filter_join_breaktask2.q.out d81bc93 ql/src/test/results/clientpositive/groupby1.q.out cb5c13a ql/src/test/results/clientpositive/groupby12.q.out b17da54 ql/src/test/results/clientpositive/groupby1_limit.q.out 68c262f ql/src/test/results/clientpositive/groupby1_map.q.out 9fec46c ql/src/test/results/clientpositive/groupby1_map_nomap.q.out cf42961 ql/src/test/results/clientpositive/groupby1_map_skew.q.out 7cca73a ql/src/test/results/clientpositive/groupby1_noskew.q.out 6929075 ql/src/test/results/clientpositive/groupby2.q.out 2460633 ql/src/test/results/clientpositive/groupby2_limit.q.out 8f185a3 ql/src/test/results/clientpositive/groupby2_map.q.out e426562 ql/src/test/results/clientpositive/groupby2_map_multi_distinct.q.out df666ef ql/src/test/results/clientpositive/groupby2_map_skew.q.out ad84cac ql/src/test/results/clientpositive/groupby2_noskew.q.out b83c105 ql/src/test/results/clientpositive/groupby2_noskew_multi_distinct.q.out e00a113 ql/src/test/results/clientpositive/groupby3.q.out 00653fe ql/src/test/results/clientpositive/groupby3_map.q.out 58f5362 ql/src/test/results/clientpositive/groupby3_map_multi_distinct.q.out d096406 ql/src/test/results/clientpositive/groupby3_map_skew.q.out d90ac3a ql/src/test/results/clientpositive/groupby3_noskew.q.out 178c550 ql/src/test/results/clientpositive/groupby3_noskew_multi_distinct.q.out 6b5a815 ql/src/test/results/clientpositive/groupby4.q.out 9b9cee1 ql/src/test/results/clientpositive/groupby4_map.q.out 89a0778 ql/src/test/results/clientpositive/groupby4_map_skew.q.out fc9e7d1 ql/src/test/results/clientpositive/groupby4_noskew.q.out 625f6a1 ql/src/test/results/clientpositive/groupby5.q.out b941252 ql/src/test/results/clientpositive/groupby5_map.q.out 5fbd3d7 ql/src/test/results/clientpositive/groupby5_map_skew.q.out 60b010b ql/src/test/results/clientpositive/groupby5_noskew.q.out e1b58ed ql/src/test/results/clientpositive/groupby6.q.out a042e43 ql/src/test/results/clientpositive/groupby6_map.q.out bcd127d ql/src/test/results/clientpositive/groupby6_map_skew.q.out cdeaffc ql/src/test/results/clientpositive/groupby6_noskew.q.out e19b420 ql/src/test/results/clientpositive/groupby_distinct_samekey.q.out 3871381 ql/src/test/results/clientpositive/groupby_map_ppr.q.out 3abe5d3 ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out b85b00b ql/src/test/results/clientpositive/groupby_position.q.out 375f2f3 ql/src/test/results/clientpositive/groupby_ppd.q.out 886a0c8 ql/src/test/results/clientpositive/groupby_ppr.q.out 8b9e34a ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out 19fefb4 ql/src/test/results/clientpositive/groupby_resolution.q.out 53af591 ql/src/test/results/clientpositive/groupby_sort_10.q.out 6a2f91e ql/src/test/results/clientpositive/groupby_sort_11.q.out a175852 ql/src/test/results/clientpositive/groupby_sort_1_23.q.out b199bf9 ql/src/test/results/clientpositive/groupby_sort_2.q.out d665ee3 ql/src/test/results/clientpositive/groupby_sort_3.q.out d682913 ql/src/test/results/clientpositive/groupby_sort_4.q.out c0f7f60 ql/src/test/results/clientpositive/groupby_sort_5.q.out abadeb6 ql/src/test/results/clientpositive/groupby_sort_6.q.out 67dee46 ql/src/test/results/clientpositive/groupby_sort_7.q.out aab1cbe ql/src/test/results/clientpositive/groupby_sort_8.q.out e70abeb ql/src/test/results/clientpositive/groupby_sort_9.q.out 0969c8d ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out 3e68cac ql/src/test/results/clientpositive/groupby_sort_test_1.q.out 9e27aaa ql/src/test/results/clientpositive/having.q.out 4dd52ff ql/src/test/results/clientpositive/having2.q.out 7a22550 ql/src/test/results/clientpositive/index_auto.q.out 124a9d2 ql/src/test/results/clientpositive/index_auto_empty.q.out 5039024 ql/src/test/results/clientpositive/index_auto_file_format.q.out 85a57f3 ql/src/test/results/clientpositive/index_auto_mult_tables.q.out edf356a ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out 8f03299 ql/src/test/results/clientpositive/index_auto_multiple.q.out 722ee6e ql/src/test/results/clientpositive/index_auto_partitioned.q.out 4777c53 ql/src/test/results/clientpositive/index_auto_self_join.q.out 1b6846a ql/src/test/results/clientpositive/index_auto_unused.q.out ad799e8 ql/src/test/results/clientpositive/index_auto_update.q.out 3c0320d ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out 052acbb ql/src/test/results/clientpositive/index_bitmap_compression.q.out f136259 ql/src/test/results/clientpositive/index_compression.q.out b44bce8 ql/src/test/results/clientpositive/index_stale.q.out 951bcf2 ql/src/test/results/clientpositive/index_stale_partitioned.q.out edd9746 ql/src/test/results/clientpositive/infer_bucket_sort.q.out 303929a ql/src/test/results/clientpositive/infer_bucket_sort_convert_join.q.out b82a0ea ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out 8f83ada ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out c4c7c7a ql/src/test/results/clientpositive/infer_bucket_sort_merge.q.out de252db ql/src/test/results/clientpositive/infer_bucket_sort_reducers_power_two.q.out acc4bcf ql/src/test/results/clientpositive/infer_const_type.q.out 4f4fe1c ql/src/test/results/clientpositive/innerjoin.q.out 34d6fde ql/src/test/results/clientpositive/input11.q.out afa231a ql/src/test/results/clientpositive/input11_limit.q.out a452b38 ql/src/test/results/clientpositive/input23.q.out 51a2329 ql/src/test/results/clientpositive/input24.q.out 75689b3 ql/src/test/results/clientpositive/input25.q.out 6d8cb15 ql/src/test/results/clientpositive/input26.q.out 443c1c5 ql/src/test/results/clientpositive/input2_limit.q.out cffde07 ql/src/test/results/clientpositive/input30.q.out cda0df6 ql/src/test/results/clientpositive/input31.q.out d3e38a7 ql/src/test/results/clientpositive/input32.q.out eba9518 ql/src/test/results/clientpositive/input42.q.out 8ecb492 ql/src/test/results/clientpositive/input8.q.out 986859d ql/src/test/results/clientpositive/input_part1.q.out 64a57bb ql/src/test/results/clientpositive/input_part4.q.out 85e9aa9 ql/src/test/results/clientpositive/input_part5.q.out ffc9251 ql/src/test/results/clientpositive/input_part6.q.out e094741 ql/src/test/results/clientpositive/join1.q.out a346a01 ql/src/test/results/clientpositive/join10.q.out 199a819 ql/src/test/results/clientpositive/join11.q.out d0f9726 ql/src/test/results/clientpositive/join12.q.out 29bbd97 ql/src/test/results/clientpositive/join13.q.out 819d40f ql/src/test/results/clientpositive/join14.q.out c363979 ql/src/test/results/clientpositive/join16.q.out 4573cb6 ql/src/test/results/clientpositive/join17.q.out a17df5f ql/src/test/results/clientpositive/join18.q.out fbde0c8 ql/src/test/results/clientpositive/join18_multi_distinct.q.out ac2b0f1 ql/src/test/results/clientpositive/join2.q.out b56f4a1 ql/src/test/results/clientpositive/join22.q.out 8cf051d ql/src/test/results/clientpositive/join28.q.out 2967ce4 ql/src/test/results/clientpositive/join29.q.out f4aab18 ql/src/test/results/clientpositive/join3.q.out bff1eda ql/src/test/results/clientpositive/join31.q.out 9d3b9c3 ql/src/test/results/clientpositive/join32.q.out 10ad2cf ql/src/test/results/clientpositive/join32_lessSize.q.out 0eb9c5d ql/src/test/results/clientpositive/join33.q.out 10ad2cf ql/src/test/results/clientpositive/join34.q.out 36aad35 ql/src/test/results/clientpositive/join35.q.out fd05212 ql/src/test/results/clientpositive/join4.q.out 4c51288 ql/src/test/results/clientpositive/join40.q.out 7a13fca ql/src/test/results/clientpositive/join5.q.out 7e69104 ql/src/test/results/clientpositive/join6.q.out 41640e1 ql/src/test/results/clientpositive/join7.q.out 31a7cba ql/src/test/results/clientpositive/join8.q.out ca38910 ql/src/test/results/clientpositive/join9.q.out 0258ac0 ql/src/test/results/clientpositive/join_alt_syntax.q.out cc1efe6 ql/src/test/results/clientpositive/join_cond_pushdown_1.q.out a0b5958 ql/src/test/results/clientpositive/join_cond_pushdown_2.q.out 34e97d4 ql/src/test/results/clientpositive/join_cond_pushdown_3.q.out 1ae7edf ql/src/test/results/clientpositive/join_cond_pushdown_4.q.out 2b2d654 ql/src/test/results/clientpositive/join_filters.q.out 8a4e2a2 ql/src/test/results/clientpositive/join_merge_multi_expressions.q.out a06c86c ql/src/test/results/clientpositive/join_merging.q.out f4a43f3 ql/src/test/results/clientpositive/join_nulls.q.out d5f20b7 ql/src/test/results/clientpositive/join_vc.q.out a4452b2 ql/src/test/results/clientpositive/limit_partition_metadataonly.q.out 7513886 ql/src/test/results/clientpositive/limit_pushdown.q.out ed6b7aa ql/src/test/results/clientpositive/limit_pushdown_negative.q.out 0691339 ql/src/test/results/clientpositive/lineage1.q.out 4bead1a ql/src/test/results/clientpositive/list_bucket_dml_1.q.out 735c200 ql/src/test/results/clientpositive/list_bucket_dml_11.q.out 9c936a0 ql/src/test/results/clientpositive/list_bucket_dml_12.q.out ea4b6b8 ql/src/test/results/clientpositive/list_bucket_dml_13.q.out 9b30a84 ql/src/test/results/clientpositive/list_bucket_dml_2.q.out 01f7218 ql/src/test/results/clientpositive/list_bucket_dml_3.q.out 227b55e ql/src/test/results/clientpositive/list_bucket_dml_4.q.out b517c83 ql/src/test/results/clientpositive/list_bucket_dml_5.q.out d8a0abf ql/src/test/results/clientpositive/list_bucket_dml_6.q.out 37db2cf ql/src/test/results/clientpositive/list_bucket_dml_7.q.out adaaba4 ql/src/test/results/clientpositive/list_bucket_dml_8.q.out 297029a ql/src/test/results/clientpositive/list_bucket_dml_9.q.out 135cd78 ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out 5e9c0ff ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out 2fc5d7f ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out d738dbf ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out f0c681c ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out 0ef749a ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out d6a075b ql/src/test/results/clientpositive/literal_ints.q.out 9a56ebd ql/src/test/results/clientpositive/load_dyn_part13.q.out 1bdfd04 ql/src/test/results/clientpositive/load_dyn_part14.q.out 42eec85 ql/src/test/results/clientpositive/louter_join_ppr.q.out 2c7aab6 ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out 49c039e ql/src/test/results/clientpositive/mapjoin_subquery.q.out 6f5f643 ql/src/test/results/clientpositive/merge1.q.out e237c01 ql/src/test/results/clientpositive/merge2.q.out 41eea17 ql/src/test/results/clientpositive/merge3.q.out a0dc3a8 ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out 7fd0bfc ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out 044b76f ql/src/test/results/clientpositive/mergejoins.q.out af3e404 ql/src/test/results/clientpositive/metadata_only_queries.q.out f5b9bd8 ql/src/test/results/clientpositive/metadataonly1.q.out f20b256 ql/src/test/results/clientpositive/multiMapJoin2.q.out 5ed27d6 ql/src/test/results/clientpositive/noalias_subq1.q.out 9f618b2 ql/src/test/results/clientpositive/nonblock_op_deduplicate.q.out d80e492 ql/src/test/results/clientpositive/nonmr_fetch.q.out e303b34 ql/src/test/results/clientpositive/notable_alias1.q.out 2a40bdd ql/src/test/results/clientpositive/notable_alias2.q.out 4139906 ql/src/test/results/clientpositive/nullgroup.q.out ffc2347 ql/src/test/results/clientpositive/nullgroup2.q.out 802650a ql/src/test/results/clientpositive/nullgroup3.q.out 54657a8 ql/src/test/results/clientpositive/nullgroup4.q.out a4ec2cd ql/src/test/results/clientpositive/nullgroup4_multi_distinct.q.out ef8f54d ql/src/test/results/clientpositive/num_op_type_conv.q.out f22d957 ql/src/test/results/clientpositive/optimize_nullscan.q.out ec8387f ql/src/test/results/clientpositive/optional_outer.q.out a38bee8 ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out 91fd38f ql/src/test/results/clientpositive/order2.q.out 3423a76 ql/src/test/results/clientpositive/outer_join_ppr.q.out 93cfde2 ql/src/test/results/clientpositive/parquet_ctas.q.out 363db53 ql/src/test/results/clientpositive/partition_boolexpr.q.out 7d414ff ql/src/test/results/clientpositive/partition_multilevels.q.out 107522d ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out b9cdde1 ql/src/test/results/clientpositive/pcr.q.out 07de2a1 ql/src/test/results/clientpositive/plan_json.q.out 9a57bc2 ql/src/test/results/clientpositive/ppd2.q.out d22be6d ql/src/test/results/clientpositive/ppd_constant_expr.q.out b0f4152 ql/src/test/results/clientpositive/ppd_gby.q.out 1d7731f ql/src/test/results/clientpositive/ppd_gby2.q.out ec4c801 ql/src/test/results/clientpositive/ppd_gby_join.q.out deb9f69 ql/src/test/results/clientpositive/ppd_join.q.out 59f0fd3 ql/src/test/results/clientpositive/ppd_join2.q.out fd06f65 ql/src/test/results/clientpositive/ppd_join3.q.out 9706852 ql/src/test/results/clientpositive/ppd_join_filter.q.out 09aec4c ql/src/test/results/clientpositive/ppd_outer_join1.q.out d2e542f ql/src/test/results/clientpositive/ppd_outer_join2.q.out dbcc587 ql/src/test/results/clientpositive/ppd_outer_join3.q.out a58289a ql/src/test/results/clientpositive/ppd_outer_join4.q.out 4289f58 ql/src/test/results/clientpositive/ppd_random.q.out e9322c2 ql/src/test/results/clientpositive/ppd_udf_case.q.out 1ac9368 ql/src/test/results/clientpositive/ppd_udf_col.q.out 64ebd5b ql/src/test/results/clientpositive/ppd_union.q.out 642c9a8 ql/src/test/results/clientpositive/ppd_union_view.q.out f7410e2 ql/src/test/results/clientpositive/ppd_vc.q.out 9622faa ql/src/test/results/clientpositive/ppr_allchildsarenull.q.out 0793098 ql/src/test/results/clientpositive/ppr_pushdown3.q.out 7b36b95 ql/src/test/results/clientpositive/print_header.q.out 48d7455 ql/src/test/results/clientpositive/query_properties.q.out 5684f0d ql/src/test/results/clientpositive/quote1.q.out f111265 ql/src/test/results/clientpositive/quotedid_basic.q.out 725a0fc ql/src/test/results/clientpositive/quotedid_partition.q.out 03db1b5 ql/src/test/results/clientpositive/rand_partitionpruner3.q.out 8cfa243 ql/src/test/results/clientpositive/rcfile_null_value.q.out d22e803 ql/src/test/results/clientpositive/reduce_deduplicate_extended.q.out b8ea616 ql/src/test/results/clientpositive/regex_col.q.out 7087f42 ql/src/test/results/clientpositive/router_join_ppr.q.out b89d92a ql/src/test/results/clientpositive/sample10.q.out fbccc0a ql/src/test/results/clientpositive/select_unquote_and.q.out 55d4a85 ql/src/test/results/clientpositive/select_unquote_not.q.out 9e0f928 ql/src/test/results/clientpositive/select_unquote_or.q.out f7fa467 ql/src/test/results/clientpositive/semijoin.q.out 45e9c1f ql/src/test/results/clientpositive/set_processor_namespaces.q.out 992865a ql/src/test/results/clientpositive/skewjoin.q.out c9a0e82 ql/src/test/results/clientpositive/skewjoin_noskew.q.out e995dc0 ql/src/test/results/clientpositive/stats1.q.out d317328 ql/src/test/results/clientpositive/stats_only_null.q.out 4549b79 ql/src/test/results/clientpositive/str_to_map.q.out ac522b7 ql/src/test/results/clientpositive/subq.q.out 6310c56 ql/src/test/results/clientpositive/subq2.q.out d91e352 ql/src/test/results/clientpositive/subq_where_serialization.q.out d72c3be ql/src/test/results/clientpositive/subquery_alias.q.out c0d80ea ql/src/test/results/clientpositive/subquery_exists.q.out 3989b27 ql/src/test/results/clientpositive/subquery_exists_having.q.out 41d35e9 ql/src/test/results/clientpositive/subquery_in.q.out bb0d876 ql/src/test/results/clientpositive/subquery_in_having.q.out f5cc6bb ql/src/test/results/clientpositive/subquery_notexists.q.out 21a7262 ql/src/test/results/clientpositive/subquery_notexists_having.q.out 7e45cd9 ql/src/test/results/clientpositive/subquery_notin.q.out 9514521 ql/src/test/results/clientpositive/subquery_notin_having.q.out 999c7f9 ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out bc382e9 ql/src/test/results/clientpositive/subquery_views.q.out 0a64c69 ql/src/test/results/clientpositive/symlink_text_input_format.q.out f9d517c ql/src/test/results/clientpositive/table_access_keys_stats.q.out 17c57ac ql/src/test/results/clientpositive/temp_table.q.out 7470384 ql/src/test/results/clientpositive/tez/auto_join1.q.out e2fb443 ql/src/test/results/clientpositive/tez/correlationoptimizer1.q.out 245bf4a ql/src/test/results/clientpositive/tez/count.q.out 026b5ff ql/src/test/results/clientpositive/tez/cross_join.q.out e40ca8c ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out 1e6ee1f ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out b1f7a91 ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out 97c57f0 ql/src/test/results/clientpositive/tez/dynpart_sort_opt_vectorization.q.out 909a201 ql/src/test/results/clientpositive/tez/dynpart_sort_optimization.q.out ab0cd53 ql/src/test/results/clientpositive/tez/dynpart_sort_optimization2.q.out 481ca10 ql/src/test/results/clientpositive/tez/filter_join_breaktask2.q.out d81bc93 ql/src/test/results/clientpositive/tez/groupby1.q.out e4ae68d ql/src/test/results/clientpositive/tez/groupby2.q.out 84c2ff1 ql/src/test/results/clientpositive/tez/groupby3.q.out a7eb437 ql/src/test/results/clientpositive/tez/having.q.out f0ffce3 ql/src/test/results/clientpositive/tez/join1.q.out 226bce5 ql/src/test/results/clientpositive/tez/limit_pushdown.q.out df18610 ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out efccbc6 ql/src/test/results/clientpositive/tez/merge1.q.out 1eca31b ql/src/test/results/clientpositive/tez/merge2.q.out c1070d5 ql/src/test/results/clientpositive/tez/metadata_only_queries.q.out 31c77bc ql/src/test/results/clientpositive/tez/metadataonly1.q.out f7774fe ql/src/test/results/clientpositive/tez/mrr.q.out 41c7760 ql/src/test/results/clientpositive/tez/optimize_nullscan.q.out 741eb4b ql/src/test/results/clientpositive/tez/skewjoin.q.out 7db7bce ql/src/test/results/clientpositive/tez/subquery_exists.q.out 15691b5 ql/src/test/results/clientpositive/tez/subquery_in.q.out 51d7d1c ql/src/test/results/clientpositive/tez/temp_table.q.out 26f068c ql/src/test/results/clientpositive/tez/tez_dml.q.out 48223f4 ql/src/test/results/clientpositive/tez/tez_join_tests.q.out 66d8798 ql/src/test/results/clientpositive/tez/tez_joins_explain.q.out dfd0a6f ql/src/test/results/clientpositive/tez/tez_smb_main.q.out 6db7150 ql/src/test/results/clientpositive/tez/tez_union.q.out 8ac475e ql/src/test/results/clientpositive/tez/union2.q.out 2249b1b ql/src/test/results/clientpositive/tez/union4.q.out f4a3528 ql/src/test/results/clientpositive/tez/union5.q.out 7fa6552 ql/src/test/results/clientpositive/tez/union6.q.out f976fcb ql/src/test/results/clientpositive/tez/union7.q.out 7d89cd8 ql/src/test/results/clientpositive/tez/union8.q.out c09124e ql/src/test/results/clientpositive/tez/union9.q.out d33824b ql/src/test/results/clientpositive/tez/vector_aggregate_9.q.out cb3e015 ql/src/test/results/clientpositive/tez/vector_cast_constant.q.out c2592dd ql/src/test/results/clientpositive/tez/vector_coalesce.q.out 646df51 ql/src/test/results/clientpositive/tez/vector_count_distinct.q.out 7c89109 ql/src/test/results/clientpositive/tez/vector_decimal_aggregate.q.out 13e047b ql/src/test/results/clientpositive/tez/vector_decimal_expressions.q.out a1e95e8 ql/src/test/results/clientpositive/tez/vector_decimal_math_funcs.q.out d6f0923 ql/src/test/results/clientpositive/tez/vector_decimal_precision.q.out 3d9d89a ql/src/test/results/clientpositive/tez/vector_decimal_round.q.out 9ea95b9 ql/src/test/results/clientpositive/tez/vector_decimal_udf.q.out d87bab7 ql/src/test/results/clientpositive/tez/vector_decimal_udf2.q.out 53ec5dc ql/src/test/results/clientpositive/tez/vector_distinct_2.q.out 61caf2e ql/src/test/results/clientpositive/tez/vector_elt.q.out d7a46e1 ql/src/test/results/clientpositive/tez/vector_groupby_3.q.out ccd8f09 ql/src/test/results/clientpositive/tez/vector_groupby_reduce.q.out 768a343 ql/src/test/results/clientpositive/tez/vector_left_outer_join.q.out 8ebbe9881 ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out 7eeadb9 ql/src/test/results/clientpositive/tez/vector_orderby_5.q.out c968d72 ql/src/test/results/clientpositive/tez/vector_partitioned_date_time.q.out dce61d5 ql/src/test/results/clientpositive/tez/vector_reduce_groupby_decimal.q.out 6c6c4a0 ql/src/test/results/clientpositive/tez/vectorization_0.q.out f7228df ql/src/test/results/clientpositive/tez/vectorization_13.q.out 6f062db ql/src/test/results/clientpositive/tez/vectorization_14.q.out 871d442 ql/src/test/results/clientpositive/tez/vectorization_15.q.out 79e6e9b ql/src/test/results/clientpositive/tez/vectorization_16.q.out a0327d6 ql/src/test/results/clientpositive/tez/vectorization_7.q.out 6c0b27f ql/src/test/results/clientpositive/tez/vectorization_8.q.out 0238f25 ql/src/test/results/clientpositive/tez/vectorization_9.q.out 0383de1 ql/src/test/results/clientpositive/tez/vectorization_div0.q.out 54b09d0 ql/src/test/results/clientpositive/tez/vectorization_limit.q.out 8e0d7a1 ql/src/test/results/clientpositive/tez/vectorization_part_project.q.out d3e3923 ql/src/test/results/clientpositive/tez/vectorization_pushdown.q.out e7b133f ql/src/test/results/clientpositive/tez/vectorization_short_regress.q.out aafa86c ql/src/test/results/clientpositive/tez/vectorized_case.q.out 449bdb8 ql/src/test/results/clientpositive/tez/vectorized_casts.q.out 4be6100 ql/src/test/results/clientpositive/tez/vectorized_date_funcs.q.out 27b678a ql/src/test/results/clientpositive/tez/vectorized_distinct_gby.q.out 6910325 ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out a21108b ql/src/test/results/clientpositive/tez/vectorized_mapjoin.q.out 92e6b06 ql/src/test/results/clientpositive/tez/vectorized_nested_mapjoin.q.out 40d18ae ql/src/test/results/clientpositive/tez/vectorized_parquet.q.out 0607cea ql/src/test/results/clientpositive/tez/vectorized_shufflejoin.q.out 726ac93 ql/src/test/results/clientpositive/tez/vectorized_timestamp_funcs.q.out b5b74fb ql/src/test/results/clientpositive/udaf_number_format.q.out e73f8e7 ql/src/test/results/clientpositive/udf1.q.out 49a1d55 ql/src/test/results/clientpositive/udf3.q.out 95762fa ql/src/test/results/clientpositive/udf8.q.out 985933b ql/src/test/results/clientpositive/udf9.q.out b03ccb6 ql/src/test/results/clientpositive/udf_10_trims.q.out 1cf4199 ql/src/test/results/clientpositive/udf_between.q.out cb63d1c ql/src/test/results/clientpositive/udf_case_column_pruning.q.out ed0bc54 ql/src/test/results/clientpositive/udf_count.q.out 78228ec ql/src/test/results/clientpositive/udf_hour.q.out 689ed30 ql/src/test/results/clientpositive/udf_like.q.out b198680 ql/src/test/results/clientpositive/udf_lower.q.out 94bb98d ql/src/test/results/clientpositive/udf_minute.q.out 0dd0b24 ql/src/test/results/clientpositive/udf_parse_url.q.out 22d3b15 ql/src/test/results/clientpositive/udf_second.q.out d80983a ql/src/test/results/clientpositive/udf_to_unix_timestamp.q.out 8292ca9 ql/src/test/results/clientpositive/udtf_explode.q.out 6a01366 ql/src/test/results/clientpositive/union.q.out 1d036d3 ql/src/test/results/clientpositive/union10.q.out d261a75 ql/src/test/results/clientpositive/union11.q.out fc9574c ql/src/test/results/clientpositive/union12.q.out 4df390e ql/src/test/results/clientpositive/union13.q.out b0b80e9 ql/src/test/results/clientpositive/union14.q.out c2bfc59 ql/src/test/results/clientpositive/union15.q.out 927262b ql/src/test/results/clientpositive/union16.q.out 1bf6d38 ql/src/test/results/clientpositive/union2.q.out d79fb32 ql/src/test/results/clientpositive/union20.q.out 280741e ql/src/test/results/clientpositive/union24.q.out 0d2d949 ql/src/test/results/clientpositive/union25.q.out f314f9f ql/src/test/results/clientpositive/union28.q.out de5a714 ql/src/test/results/clientpositive/union30.q.out 235b64a ql/src/test/results/clientpositive/union33.q.out 0d9c261 ql/src/test/results/clientpositive/union4.q.out 90daaad ql/src/test/results/clientpositive/union5.q.out 3ee93a6 ql/src/test/results/clientpositive/union6.q.out d5fe7ca ql/src/test/results/clientpositive/union7.q.out d724468 ql/src/test/results/clientpositive/union8.q.out 8cb2a5e ql/src/test/results/clientpositive/union9.q.out 3c47b47 ql/src/test/results/clientpositive/union_date_trim.q.out e0682e6 ql/src/test/results/clientpositive/union_remove_1.q.out 51525f7 ql/src/test/results/clientpositive/union_remove_10.q.out 9ae4571 ql/src/test/results/clientpositive/union_remove_15.q.out 4e60272 ql/src/test/results/clientpositive/union_remove_16.q.out 19417c2 ql/src/test/results/clientpositive/union_remove_18.q.out d1cff4a ql/src/test/results/clientpositive/union_remove_19.q.out 1f9bb35 ql/src/test/results/clientpositive/union_remove_2.q.out 899dadb ql/src/test/results/clientpositive/union_remove_20.q.out b4ba781 ql/src/test/results/clientpositive/union_remove_21.q.out 3cb3312 ql/src/test/results/clientpositive/union_remove_22.q.out 439e5a2 ql/src/test/results/clientpositive/union_remove_24.q.out c711ec8 ql/src/test/results/clientpositive/union_remove_25.q.out 6dc525b ql/src/test/results/clientpositive/union_remove_4.q.out bf35c18 ql/src/test/results/clientpositive/union_remove_5.q.out 12e3907 ql/src/test/results/clientpositive/union_remove_7.q.out 9d2caaa ql/src/test/results/clientpositive/union_remove_8.q.out ec9349a ql/src/test/results/clientpositive/union_remove_9.q.out abdb778 ql/src/test/results/clientpositive/union_top_level.q.out dd68775 ql/src/test/results/clientpositive/union_view.q.out 5e69ec2 ql/src/test/results/clientpositive/vector_aggregate_9.q.out 3a3e2de ql/src/test/results/clientpositive/vector_cast_constant.q.out 6ea3b54 ql/src/test/results/clientpositive/vector_char_2.q.out 117967a ql/src/test/results/clientpositive/vector_coalesce.q.out 8ad63e3 ql/src/test/results/clientpositive/vector_count_distinct.q.out becb4e2 ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out 787d5dd ql/src/test/results/clientpositive/vector_decimal_expressions.q.out 9c3b076 ql/src/test/results/clientpositive/vector_decimal_math_funcs.q.out 213b95f ql/src/test/results/clientpositive/vector_decimal_precision.q.out 438ebc4 ql/src/test/results/clientpositive/vector_decimal_round.q.out 25e5cfa ql/src/test/results/clientpositive/vector_decimal_udf.q.out cfea2bc ql/src/test/results/clientpositive/vector_decimal_udf2.q.out 0495761 ql/src/test/results/clientpositive/vector_distinct_2.q.out 9d780c8 ql/src/test/results/clientpositive/vector_elt.q.out e84c0a7 ql/src/test/results/clientpositive/vector_groupby_3.q.out ed7da3d ql/src/test/results/clientpositive/vector_groupby_reduce.q.out 2ae10ef ql/src/test/results/clientpositive/vector_left_outer_join.q.out e286d3f ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out 4c05f6c ql/src/test/results/clientpositive/vector_orderby_5.q.out 3e24a32 ql/src/test/results/clientpositive/vector_partitioned_date_time.q.out f3eff07 ql/src/test/results/clientpositive/vector_reduce_groupby_decimal.q.out 084d3d5 ql/src/test/results/clientpositive/vectorization_0.q.out 6c04bfe ql/src/test/results/clientpositive/vectorization_13.q.out 061cb0d ql/src/test/results/clientpositive/vectorization_14.q.out eb2c486 ql/src/test/results/clientpositive/vectorization_15.q.out e6be949 ql/src/test/results/clientpositive/vectorization_16.q.out c6d63b7 ql/src/test/results/clientpositive/vectorization_7.q.out a4b7b40 ql/src/test/results/clientpositive/vectorization_8.q.out c300faa ql/src/test/results/clientpositive/vectorization_9.q.out 9481d0a ql/src/test/results/clientpositive/vectorization_div0.q.out 962c466 ql/src/test/results/clientpositive/vectorization_limit.q.out 8c47ece ql/src/test/results/clientpositive/vectorization_part_project.q.out d2c2c38 ql/src/test/results/clientpositive/vectorization_pushdown.q.out 3a39a15 ql/src/test/results/clientpositive/vectorization_short_regress.q.out 77db10c ql/src/test/results/clientpositive/vectorized_case.q.out bec3de1 ql/src/test/results/clientpositive/vectorized_casts.q.out 8ce937f ql/src/test/results/clientpositive/vectorized_date_funcs.q.out 2d43528 ql/src/test/results/clientpositive/vectorized_distinct_gby.q.out e19186f ql/src/test/results/clientpositive/vectorized_mapjoin.q.out d574b20 ql/src/test/results/clientpositive/vectorized_nested_mapjoin.q.out 97dc5b8 ql/src/test/results/clientpositive/vectorized_parquet.q.out a81a9b3 ql/src/test/results/clientpositive/vectorized_shufflejoin.q.out ab27e0b ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out efde414 ql/src/test/results/clientpositive/windowing_streaming.q.out be97b61 Diff: https://reviews.apache.org/r/28632/diff/ Testing ------- existing tests. Thanks, Ashutosh Chauhan --===============8215178783598271207==--