----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/42904/ -----------------------------------------------------------
(Updated Feb. 1, 2016, 12:45 p.m.) Review request for hive, Ashutosh Chauhan and John Pullokkaran. Bugs: HIVE-12543 https://issues.apache.org/jira/browse/HIVE-12543 Repository: hive-git Description ------- Disable Hive ConstantPropagate optimizer when CBO has optimized the plan Diffs (updated) ----- hbase-handler/src/test/results/positive/hbase_ppd_key_range.q.out 97e9aa23583a356a01c278e910eab9a0dbce2513 hbase-handler/src/test/results/positive/hbase_pushdown.q.out be96eecc8642f85a493ae6c72964bc4e30c4db57 ql/src/java/org/apache/hadoop/hive/ql/optimizer/Optimizer.java 60a2e0223ee92665f2815e3102bdb77303c557ff ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveRexUtil.java PRE-CREATION ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveReduceExpressionsRule.java 50e139b4045ebac5a15bca05b1660dfeed4fe08c ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/translator/ExprNodeConverter.java b42e78f796fb91b2bff3443972ad7512b18d68ee ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/translator/RexNodeConverter.java 122546fffdf10d866b480029930c582de41598f4 ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/translator/SqlFunctionConverter.java 75c38fa0d30ec4a3fcf240b7f5d6e3c739a3aa17 ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java e2d404b0bd1d3916e498bc4c4076cdf168ef2272 ql/src/test/results/clientpositive/annotate_stats_join_pkfk.q.out 26656e2137f7c63986bea94c095724297d84be88 ql/src/test/results/clientpositive/auto_join32.q.out 17192cbc91ed2cd89fd37623a6f3f8403e492e3d ql/src/test/results/clientpositive/auto_join_without_localtask.q.out 1521a714bb6f99f4314c6fdf7456dadac9fa1c7c ql/src/test/results/clientpositive/bucketsortoptimize_insert_7.q.out b5dfce36288755acf8e6f94903854832f0858101 ql/src/test/results/clientpositive/cbo_rp_lineage2.q.out d4bc93c598fa25d5da54a0ac3faff8d6f5986c60 ql/src/test/results/clientpositive/constprog_partitioner.q.out a1c4a22437a77709c6639c14aa85ffd2f20f972f ql/src/test/results/clientpositive/correlationoptimizer13.q.out 048f63b330e9332133be0b100f0ed72c08e85a52 ql/src/test/results/clientpositive/correlationoptimizer8.q.out ba54b87195ea4dee3465bbaae6b0b62750340cac ql/src/test/results/clientpositive/correlationoptimizer9.q.out b6876168a60c4823077a124178086ca4791e858f ql/src/test/results/clientpositive/decimal_udf.q.out 0b18d484d489d95c6d3dcfaf923d9d6f28afb92d ql/src/test/results/clientpositive/dynamic_rdd_cache.q.out a8be1518340201966d74b2737959adef8d1e9d78 ql/src/test/results/clientpositive/filter_cond_pushdown.q.out 1c3a5ab54f20c2b3dcb11f1e1fc5a34b3f16aa89 ql/src/test/results/clientpositive/filter_join_breaktask.q.out c17b48abc1d7730d9dd0bbe011e6b4b258a38565 ql/src/test/results/clientpositive/fold_eq_with_case_when.q.out b7e795bf979465fa3743bcb6ca3551e624abb78a ql/src/test/results/clientpositive/index_auto_self_join.q.out 793af78bb5494c7c42e70ec709d81a58cc55fb15 ql/src/test/results/clientpositive/index_auto_unused.q.out e1ddff8517bffc197b85ba9fe298bb83f4108121 ql/src/test/results/clientpositive/join34.q.out f1bf4942041f88abced02ba018ecc72c4a1ce7d2 ql/src/test/results/clientpositive/join35.q.out 3ff41ea82ed9e04c6abcbdf79a694cc9af1933b8 ql/src/test/results/clientpositive/join42.q.out 4f9e2a9b7e1674927743b38b2bfa9d6caff1ef63 ql/src/test/results/clientpositive/join_grp_diff_keys.q.out b24bcba950a8f8506d843522c19f2aedf3fc0d1a ql/src/test/results/clientpositive/lineage2.q.out ec64c10d0c598ca813d10e52f01526a3f81da63c ql/src/test/results/clientpositive/lineage3.q.out ca7d6e08a361cdaea3179afa3b946ce173893a26 ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out faa3de1cea5f11feaa3b9a9c7599b2b881181ae9 ql/src/test/results/clientpositive/llap/dynamic_partition_pruning_2.q.out 86d0c1cb8e9925eab82fcd6becb3a236ddfdba3b ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_1.q.out e2598fd8c25046fd6082c32121a1168143b13eca ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_1.q.out ce462bdc57ecb93aa9f356b4c346c2fcc8098412 ql/src/test/results/clientpositive/llap/tez_self_join.q.out 04871ae42b75a83d33900a6592e000095a7d36f1 ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out efff327c17ee2afb151616954def2e293a7bc731 ql/src/test/results/clientpositive/llap/vectorized_dynamic_partition_pruning.q.out dc2346aa122b0f1693a33c149492266211f2a364 ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out 6193580166d23419ef539ba1c21de2ebe08b4e43 ql/src/test/results/clientpositive/merge_dynamic_partition.q.out da19b325e9a66dd713a68927614b60e8dda821e3 ql/src/test/results/clientpositive/perf/query21.q.out cbd117777994790a0174d5b282b150afacce950f ql/src/test/results/clientpositive/perf/query31.q.out a16eeadbee51b9427895fe4a7fce0e14575d6bba ql/src/test/results/clientpositive/perf/query32.q.out dc085dde85a60006aec6406276270688884355a2 ql/src/test/results/clientpositive/perf/query34.q.out 037bc76a6b32ae4c67698cf5de561930a9ddd1c2 ql/src/test/results/clientpositive/perf/query39.q.out 7dcf01d16478c1a9533d43a8d6935bd327d8d51e ql/src/test/results/clientpositive/perf/query45.q.out 35befff199470f12a27e1a747c84aedaec84c69e ql/src/test/results/clientpositive/perf/query58.q.out bfda69f961183805f4a71c25d86111bf6946e313 ql/src/test/results/clientpositive/perf/query64.q.out 2f52a47d9e8e2bc870a07a5a94fe34ade71f0034 ql/src/test/results/clientpositive/perf/query70.q.out 9b58fdb238ac8c718df5a357fd82b8fdf1d075e3 ql/src/test/results/clientpositive/perf/query71.q.out 11c3a0cec48371a5e5cc74c950fd3e76d3001a3b ql/src/test/results/clientpositive/perf/query72.q.out 99e00a766673c9189d3249bf233f95b65b0990cc ql/src/test/results/clientpositive/perf/query73.q.out af359d05d22074acd3d4eb036f25af2979eded97 ql/src/test/results/clientpositive/perf/query75.q.out 37916216ce01c8ecb40c3ca02dc1698d5f8980af ql/src/test/results/clientpositive/perf/query85.q.out ad9aa897bdbcacf07a88a5eba4b870ea7ac41d9c ql/src/test/results/clientpositive/perf/query87.q.out 734b334965849ef3a5b3973321e07b4f7bc4ef60 ql/src/test/results/clientpositive/perf/query89.q.out 4d0fb37daf6a6460307fd1b74b8794a2cb258b78 ql/src/test/results/clientpositive/perf/query92.q.out 8ec1db2421d6a2add6a5471cab6cd63404d4ff49 ql/src/test/results/clientpositive/perf/query94.q.out 876a9ed2c9100bff3bc0005c1e808a9f6e1d80c7 ql/src/test/results/clientpositive/perf/query95.q.out 2c682e7a781a139e164f4802661f136195134761 ql/src/test/results/clientpositive/perf/query97.q.out 812333a49c6fb613989fad28c7482f2f0e9d5725 ql/src/test/results/clientpositive/ppd2.q.out d583b1741e1d1586e647d22112a610b4375df90f ql/src/test/results/clientpositive/ppd_join2.q.out 955f4ad193ba930153df6c1b9b66da8b80ed50a6 ql/src/test/results/clientpositive/ppd_join5.q.out 18a75c65b4f784e92e56ab93a7aef51e1ff25f73 ql/src/test/results/clientpositive/ppd_outer_join5.q.out b2dd5efd1ed7208efedbcd975647c8ea43f15fb2 ql/src/test/results/clientpositive/ppd_repeated_alias.q.out c0644ef2fe618b5dafa301f35791ac764213f544 ql/src/test/results/clientpositive/ppd_udf_case.q.out d09ed3139fd5a4d6130f6fbd5ccfd728f7e6ef67 ql/src/test/results/clientpositive/ppd_union_view.q.out ddd236a1bd82290835c4ec0fd1341e19810954ec ql/src/test/results/clientpositive/ppr_allchildsarenull.q.out 1be8a381cc9e733b11d773201f4944049385f6d5 ql/src/test/results/clientpositive/semijoin.q.out 11b1891d62afefc08787fa7cbece7a9b9e78cc9f ql/src/test/results/clientpositive/semijoin4.q.out 77f2615b981215532d6f6092f339ce7bd5bea2a7 ql/src/test/results/clientpositive/smb_mapjoin_25.q.out 57ee16a814ff204354e4dac322bfceb3bbbbdffe ql/src/test/results/clientpositive/spark/auto_join32.q.out fe8f96768c755c8c9251ea59998768efe487421d ql/src/test/results/clientpositive/spark/auto_join_without_localtask.q.out 68e51a7ed91dce8ad73cca0c9c1830f47b279ce0 ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_7.q.out 5bc777d7d570464c5d09a54059431782560c915b ql/src/test/results/clientpositive/spark/constprog_partitioner.q.out 66cd5cc4aca19cc641087cf8f917618bb66fd540 ql/src/test/results/clientpositive/spark/dynamic_rdd_cache.q.out 8639871652be3540e1394fb901b3a6f0da4464ff ql/src/test/results/clientpositive/spark/filter_join_breaktask.q.out fa5a5c62d7f354aeee9314833a447a03c4ecb699 ql/src/test/results/clientpositive/spark/index_auto_self_join.q.out 38e8c9ad23b17e6ad374842ddf95c96d95dc6378 ql/src/test/results/clientpositive/spark/join34.q.out e99fd5b1e88f42e017fc9ffe2141e579c8c41e81 ql/src/test/results/clientpositive/spark/join35.q.out 817ae5da6252096fcfb12f3da82aa17c5a44e366 ql/src/test/results/clientpositive/spark/mapjoin_mapjoin.q.out e77fbef03eac6e886b138cce64f6a4f032bca9d0 ql/src/test/results/clientpositive/spark/ppd_join2.q.out f7721fb2d61e68b494a806a0f11842f5ed6d54d2 ql/src/test/results/clientpositive/spark/ppd_join5.q.out 272912a60a9e82603da538732d8d57527c8e0a03 ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out 7f60d1d65aa00f1e08fc225aa5fb7ae74776c413 ql/src/test/results/clientpositive/spark/semijoin.q.out 36153d6a0981bdef7818bad9eaa31136b85c950b ql/src/test/results/clientpositive/spark/smb_mapjoin_25.q.out afd1e5d2ceb9a31e1f10416735a8cb0cba5c401c ql/src/test/results/clientpositive/spark/subquery_exists.q.out 53fe78b9cf3de05dc376b148c2c4adaf7a81b72e ql/src/test/results/clientpositive/spark/subquery_in.q.out dc9109c1afa3e1bfec8f546bc3aa84bd5b854de6 ql/src/test/results/clientpositive/spark/table_access_keys_stats.q.out f2c7b08deb91e007496f8247411de307a6e3d597 ql/src/test/results/clientpositive/spark/union_remove_19.q.out df0fecddac24dee9bb231f2cd282c4330e46fc36 ql/src/test/results/clientpositive/spark/vector_mapjoin_reduce.q.out 010bb0c432dc44341e966833313941ce86429978 ql/src/test/results/clientpositive/spark/vectorization_short_regress.q.out d6b7208ccc969e8037fe22c1b841a48bd8aba387 ql/src/test/results/clientpositive/subquery_exists.q.out 698db03708c2f8d635ed9e6818d1e5c12b7f6aae ql/src/test/results/clientpositive/subquery_in.q.out 0bbefc2c1db11667599f27d8234853a2b47db970 ql/src/test/results/clientpositive/subquery_notin.q.out e157ff4d511cd7a4729f3c1d39800e80788ee48a ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out 4cc5424086cd22c7465a839fffd2171a320c7c98 ql/src/test/results/clientpositive/table_access_keys_stats.q.out f2c7b08deb91e007496f8247411de307a6e3d597 ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out 799587328c2bb828848d87360125ddb13989f639 ql/src/test/results/clientpositive/tez/dynamic_partition_pruning_2.q.out ba686f9b1cb88db8eb61333a6e5004c3ac65753c ql/src/test/results/clientpositive/tez/explainuser_1.q.out 120894da3304d06eb9e227bb865e86b696359eb9 ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out f2a7aeff51febeca5530c307158cdedb04d70fad ql/src/test/results/clientpositive/tez/hybridgrace_hashjoin_1.q.out 64ba39f7acc40798f7f6bfff296c9a0f01dac7fb ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out c979ee9bd5dd44fa48c7bfbd7b1050656c578f98 ql/src/test/results/clientpositive/tez/subquery_exists.q.out d286ed00b45e7dbc1d5058939940ee9e4d7588b0 ql/src/test/results/clientpositive/tez/subquery_in.q.out 2c04009d19a1deafcfcd9252ace454f2194e821e ql/src/test/results/clientpositive/tez/tez_dynpart_hashjoin_1.q.out 7352d8eb146bbadd5a60dd90d9184f74d7b7efe8 ql/src/test/results/clientpositive/tez/tez_self_join.q.out 78156eeda0b695cfc7e461fb289eeb3e572139da ql/src/test/results/clientpositive/tez/tez_vector_dynpart_hashjoin_1.q.out d532d6b28524c63226e174dd14d87ab1b91de4cc ql/src/test/results/clientpositive/tez/vector_decimal_udf.q.out 8b8bc6ce1679c3264ae0dc36d23e72c75f83676d ql/src/test/results/clientpositive/tez/vector_if_expr.q.out 8b5e471c9d686ac77ed249a9cac689d2399bf1ba ql/src/test/results/clientpositive/tez/vector_leftsemi_mapjoin.q.out 9c79c1a22e8d5574e5ea6e23ad09ccacc12959ef ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out 2db5c7c1a77a5f88986065c946234d59fdbc25c6 ql/src/test/results/clientpositive/tez/vectorization_short_regress.q.out 4a3cee8be82bb92d2a25392f5a3fdf2939c28799 ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out 13735e6949e2f973f804ec226198592ac4272a22 ql/src/test/results/clientpositive/udf_case_column_pruning.q.out e9c5490d9383362306905d0a7dbfb3f242411e02 ql/src/test/results/clientpositive/union_remove_19.q.out bc00e1697f0c23c5256412c96a0fc0ba00370a1c ql/src/test/results/clientpositive/vector_decimal_udf.q.out 5de02efa02bb573b75c1de00acf67d02f8017ab8 ql/src/test/results/clientpositive/vector_if_expr.q.out ad1cfc79be81e3915e677917437eedfd28064e32 ql/src/test/results/clientpositive/vector_leftsemi_mapjoin.q.out 581ce6647ba4cda0207ac4af69270243c3dbf2bb ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out e8cd48a4b940f872dc5d6c688c7fe0903478bbb4 ql/src/test/results/clientpositive/vectorization_short_regress.q.out 78b5d073862edc0ef735aaca83041aa4d9ae0015 Diff: https://reviews.apache.org/r/42904/diff/ Testing ------- Thanks, Jesús Camacho Rodríguez