You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by Jesús Camacho Rodríguez <jc...@hortonworks.com> on 2016/01/12 12:53:58 UTC

Review Request 42190: HIVE-12478

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

Review request for hive and John Pullokkaran.


Bugs: HIVE-12478
    https://issues.apache.org/jira/browse/HIVE-12478


Repository: hive-git


Description
-------

Improve Hive/Calcite Trasitive Predicate inference


Diffs
-----

  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveCalciteUtil.java 4825a617876374085b6fac1192ba1531ec916bce 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveDefaultRelMetadataProvider.java c0609d7773a1e49cc85a1d542caa16d74ac76efe 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/cost/HiveCost.java 3c5cac2f5b98925e8840466fa9d83cd28125ee03 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/cost/HiveCostModel.java d15d885d2348d666df069228a93d6c5f914c79df 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveUnion.java 8b57b3504c407b8a1e73d48ea240c4ec7558b327 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveFilterMergeRule.java PRE-CREATION 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinAddNotNullRule.java de880ce26f1e172288f700c8566fbe71f42af115 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinPushTransitivePredicatesRule.java 703c8c6dbdfa281443cbcf7b08de2266697da8a9 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HivePreFilteringRule.java d37fc0e08d5e41b29539a990e6638385c1135eec 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveReduceExpressionsRule.java 50e139b4045ebac5a15bca05b1660dfeed4fe08c 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/stats/HiveRelMdSyntheticSelectivityCost.java PRE-CREATION 
  ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java f50f4d323220b1f90e33d5cf7daef9162998f5ec 
  ql/src/test/results/clientpositive/annotate_stats_select.q.out b158d8567f6cc02d990d175e93996239aba0c5ed 
  ql/src/test/results/clientpositive/auto_join12.q.out 8ef3664764d04f53f3685d8f66dc4a353776a488 
  ql/src/test/results/clientpositive/auto_join16.q.out c1da6d2968697d304311044d358f1af267dc6e60 
  ql/src/test/results/clientpositive/bucketizedhiveinputformat.q.out cfb95be72b32a354faeddc79dc52bc29c7593a2b 
  ql/src/test/results/clientpositive/cast1.q.out 48a0c14031ef38dd5b4df7efa718a4d6ce04bc94 
  ql/src/test/results/clientpositive/cbo_SortUnionTransposeRule.q.out eef23891f3a155fac60628ee47afa08d77fa3a2e 
  ql/src/test/results/clientpositive/cbo_const.q.out adc5232a67b2243dd5f09acaf1f7c49baea5daad 
  ql/src/test/results/clientpositive/cbo_rp_lineage2.q.out 1b2a2ab1af5992753c37d053942ecb2ebf775921 
  ql/src/test/results/clientpositive/constprog_partitioner.q.out 08c0aebafe1644a5adbec6a56879b39617bfbf69 
  ql/src/test/results/clientpositive/correlationoptimizer13.q.out 61b7bcb675a80dc3267365c65545e107ecbe12d2 
  ql/src/test/results/clientpositive/correlationoptimizer8.q.out 368a1147d404ae9aab18a64618abf8ed7b3f7189 
  ql/src/test/results/clientpositive/correlationoptimizer9.q.out 104a97afbb6657255a027ff6d51101f6963c2358 
  ql/src/test/results/clientpositive/dynamic_rdd_cache.q.out 743865e073e1768f7f6234fde35ad2e56d8babe9 
  ql/src/test/results/clientpositive/filter_cond_pushdown.q.out 5e0edbc9efb442467c4998021ac1ecfb9d07579d 
  ql/src/test/results/clientpositive/filter_join_breaktask.q.out 13d17aafa8fc15c980ffa7366a4ca8c7abe8fd50 
  ql/src/test/results/clientpositive/groupby_position.q.out c2566f2ad5d426db8814b7ca85207807f4a5afc7 
  ql/src/test/results/clientpositive/groupby_ppd.q.out d17c4b6d9e88d49d64b9725be1e51ca258ad1167 
  ql/src/test/results/clientpositive/groupby_sort_1_23.q.out 9c45602a3898cbef90ac13c8f65cca54cb9a7bd8 
  ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out ad263bc4cb9885e9d06c2ec4716a2cce56d11065 
  ql/src/test/results/clientpositive/index_auto_mult_tables.q.out 8c71925fbc5352f42abb280fc45a1d5a5713ebad 
  ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out b3e698927689dad5229165189779300cb8beca9b 
  ql/src/test/results/clientpositive/input_part1.q.out c5c46af6a69ffb8613fd7d3898ca32d3c6b802f4 
  ql/src/test/results/clientpositive/input_part5.q.out c6ae2fd58d7d41e4b4c0f764de3e28484917cd97 
  ql/src/test/results/clientpositive/input_part6.q.out c01d8afb6230440103ed8c1ecb38aea9eaabc832 
  ql/src/test/results/clientpositive/join12.q.out 8217c86d0e41c78b8bf4ed120b30a85204fa9915 
  ql/src/test/results/clientpositive/join16.q.out 244eb46dc0ae3b61ed932f043a98bb64295776a1 
  ql/src/test/results/clientpositive/join34.q.out 795dd3a39c989301efdb900f90a51d725e9dad6b 
  ql/src/test/results/clientpositive/join35.q.out c5231543e3e954c72274dc3fb9e3f0e83fce5516 
  ql/src/test/results/clientpositive/join42.q.out 6e09e38102129edb7246b0a027c86ba1deed066c 
  ql/src/test/results/clientpositive/limit_join_transpose.q.out 759aebb5d2ec59267535e12cb20f4a812e8a80d0 
  ql/src/test/results/clientpositive/lineage2.q.out a189f82a3d29cd3b1e21a43afc85ef14fd74c79e 
  ql/src/test/results/clientpositive/lineage3.q.out f1162a213eea285a5d166731e0ce7e407f4106a7 
  ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out 9c406a720398c14f7df09045a07f0cad5afa5437 
  ql/src/test/results/clientpositive/llap/bucket_map_join_tez1.q.out 1fb76d8a8f32e0d63eba743d6007ffc7691b9b30 
  ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out d2c11d7644570217532f9b366926d8cc94a03e6a 
  ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_1.q.out b459692b443a1686def6615e9e9bcce5922335c3 
  ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out 6a57f1fd82ef3e3cf681138383534e7fea1c07df 
  ql/src/test/results/clientpositive/llap/vectorized_dynamic_partition_pruning.q.out 63121a9e5b043e2c27fe08ee54e6fe01e2dd6cae 
  ql/src/test/results/clientpositive/louter_join_ppr.q.out 1f685ae7ae5989ab14f045fcafa99dabf54bc1e1 
  ql/src/test/results/clientpositive/mergejoin.q.out acf816ebc2db9df7f2878375dea3c403fb513c08 
  ql/src/test/results/clientpositive/mergejoins.q.out 901041083f3182497361b8f27ed77c093e7ce237 
  ql/src/test/results/clientpositive/mergejoins_mixed.q.out 10f37f9fe34d79987333e3f8bb01166304fe5894 
  ql/src/test/results/clientpositive/multiMapJoin1.q.out e2efec0295e2d15aa1497b848eb6eb8838617b7f 
  ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out 90032fe53d37163e09fbf2b1bf7dac0e55b80b18 
  ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out 7c5be6dbe636f6cfcf8f4a3563d2b204d3cb2b46 
  ql/src/test/results/clientpositive/partition_multilevels.q.out 699c1790314f0ea3bff2eae4aa6f3231eddead51 
  ql/src/test/results/clientpositive/perf/query31.q.out 909d64cef12a9492c5d24ef5876609a77423d2d5 
  ql/src/test/results/clientpositive/perf/query39.q.out 9f3e650943c1d7ab04fc521509ca9372e4105a25 
  ql/src/test/results/clientpositive/perf/query40.q.out b2d6262d96b7dc1c25748a758af61988b39d7c45 
  ql/src/test/results/clientpositive/perf/query42.q.out 9ede45d24587228328671a40e9b3f9ca43e2a550 
  ql/src/test/results/clientpositive/perf/query52.q.out 7e7224ba54b49a68040a536adca665a8f510bdd7 
  ql/src/test/results/clientpositive/perf/query58.q.out c2f71892ee7ceb68449c6c4f13754052041de106 
  ql/src/test/results/clientpositive/perf/query64.q.out 9331673a663e9b31bfb00b443c4ae282ffe67e56 
  ql/src/test/results/clientpositive/perf/query66.q.out a25664e73afb1088e05ec3912dab253720bc4af4 
  ql/src/test/results/clientpositive/perf/query72.q.out bb56f0d695ede28d37b210fc1c6293444038154e 
  ql/src/test/results/clientpositive/perf/query75.q.out f3f9827a532b445e59642cbf9d169dc4147e03d2 
  ql/src/test/results/clientpositive/perf/query80.q.out 37cb542f008b21b26e2bdd03aac7144b7352893b 
  ql/src/test/results/clientpositive/perf/query85.q.out 54061ced073090cec35111081f21ac510d0bde92 
  ql/src/test/results/clientpositive/perf/query94.q.out 0357835f7f5e565f560e73506b10345c0fe089ff 
  ql/src/test/results/clientpositive/pointlookup2.q.out 1d7efe8d86c067b2000be3a740658ba1d5e8b754 
  ql/src/test/results/clientpositive/ppd_join3.q.out 0000db129c9428e34935397ab5c51f010987eca3 
  ql/src/test/results/clientpositive/ppd_outer_join2.q.out 82e4ef5332e6d178ab19a544179f415ffd9efede 
  ql/src/test/results/clientpositive/ppd_outer_join3.q.out de82fe0ee9d7480c693b87f22e4f9a82b509e9a4 
  ql/src/test/results/clientpositive/ppd_outer_join4.q.out 289798c5bc0113ea4864e2c287001805a8fc1ea9 
  ql/src/test/results/clientpositive/ppd_outer_join5.q.out 35fec7a46606b0489d9c4e9c472a26607b17a177 
  ql/src/test/results/clientpositive/ppd_udf_case.q.out 2b407a63d8b51cfedc020459240150b97044ffc3 
  ql/src/test/results/clientpositive/ppd_union_view.q.out ba51cbd4db0021b30b3592f740b895b0e20aa59a 
  ql/src/test/results/clientpositive/quotedid_basic.q.out 3c81e0bccce92d489d4f2eec874826a1d232c7be 
  ql/src/test/results/clientpositive/quotedid_partition.q.out a83c62b1826786f5213c8556bd275e4bd545fb6a 
  ql/src/test/results/clientpositive/router_join_ppr.q.out b486f21385f45d12c15013c848d724202e97d014 
  ql/src/test/results/clientpositive/skewjoin.q.out 4e98dfd9e7aedd8cffbe1aee64c03d62741763d7 
  ql/src/test/results/clientpositive/spark/auto_join12.q.out 158e53511f43bd12fc006bd595c4dab48dc1cf94 
  ql/src/test/results/clientpositive/spark/auto_join16.q.out ba6336aaa5213f0dcd292bd1fb07c9582fb1c6fd 
  ql/src/test/results/clientpositive/spark/bucket_map_join_tez1.q.out 57a89d67b56cc36dda8b42f21481e9363cff297a 
  ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_7.q.out 0b64a8735a6e9a668650db8907abce38c31ab70e 
  ql/src/test/results/clientpositive/spark/dynamic_rdd_cache.q.out 6e595ff4b19d188b041394aff5df6d93614fe813 
  ql/src/test/results/clientpositive/spark/filter_join_breaktask.q.out 74742b2f8887baa23023a61a8b7497eafce0d967 
  ql/src/test/results/clientpositive/spark/groupby_position.q.out 415703f638ede1e113fd3f7864f2f8688302c38d 
  ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out 0b54b85ea01b464a931c1761583b4eed63558634 
  ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out 0b8ec5439d5d1e78b95dda349ddeaf58815e021f 
  ql/src/test/results/clientpositive/spark/join12.q.out 2ad0a43853e832fe7d16678d38e6b5b1f43f467f 
  ql/src/test/results/clientpositive/spark/join16.q.out 2496ec2904272923c346d746f6150a34ffee63be 
  ql/src/test/results/clientpositive/spark/join34.q.out 0f2c413dd59f8926bf0c37706d064a313d090d97 
  ql/src/test/results/clientpositive/spark/join35.q.out 0519689c9a78ef75aabfcf663d95a96033ab6ae0 
  ql/src/test/results/clientpositive/spark/louter_join_ppr.q.out c22158ca7130c3839ea0133fe84d92a3f04e791b 
  ql/src/test/results/clientpositive/spark/mergejoins.q.out e6872400b45cadc969ef897cf42c38dd23b9581f 
  ql/src/test/results/clientpositive/spark/mergejoins_mixed.q.out 42ffebfde50472f1aec060c33037fe851921e88c 
  ql/src/test/results/clientpositive/spark/ppd_join3.q.out c78d4cb4580d17946375f6ee5b6c447741d7c6f4 
  ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out 869596140ea9878c41eb3d44643f1f5c0e682dc3 
  ql/src/test/results/clientpositive/spark/ppd_outer_join3.q.out 4a8c58cfaa3257b69398457c43e16cbfe630bb15 
  ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out 8d0830892ab997e489306ec2698e1c6fdf61996f 
  ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out 8e398580ac526c0acbd642bc91579fcea0d9b428 
  ql/src/test/results/clientpositive/spark/router_join_ppr.q.out 620e5d200c05d1e9e884160170128d3f61fa231d 
  ql/src/test/results/clientpositive/spark/skewjoin.q.out b2460460da36e856655ca12706678378b976f059 
  ql/src/test/results/clientpositive/spark/subquery_exists.q.out 5f41ac7aeaa5425004a4cd56638f0961a5a78a7e 
  ql/src/test/results/clientpositive/spark/subquery_in.q.out 1d813f8ae53e6cccde25e864d168380568e02e7a 
  ql/src/test/results/clientpositive/spark/union_remove_25.q.out 91aa1f2758ef402ddc88f31936abbd0a09315333 
  ql/src/test/results/clientpositive/spark/union_view.q.out 492f71b10b9e98cd9235fad4b40850b2aa2d9730 
  ql/src/test/results/clientpositive/spark/vector_mapjoin_reduce.q.out 296c256d09703a073a41a36dc96b526e78afb715 
  ql/src/test/results/clientpositive/subquery_exists.q.out f3a270589b7b50dd7ef2ec53d1bac7ae88f7f245 
  ql/src/test/results/clientpositive/subquery_in.q.out a374dc0f84aa78dcf099d8733b42f94e6cea7863 
  ql/src/test/results/clientpositive/subquery_in_having.q.out 87c5a623dfa44e903710794634e459dc66bbd86a 
  ql/src/test/results/clientpositive/subquery_notexists.q.out 215d855f20d09b9e92da7a753cbce90760a73f0c 
  ql/src/test/results/clientpositive/subquery_notexists_having.q.out 637fc62941e6f8b4852c4b1a4d51d6b2517912a3 
  ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out e34a401ca41faae0f25e7f398ac5c078f8f34df8 
  ql/src/test/results/clientpositive/subquery_views.q.out 76e53d3be56f3f8c2422317585d441cd14665294 
  ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out 4703cec3fdcbb79bbc4b0365b97600e760ac2748 
  ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out 58ab2c08554f4b2b4d06e79de22845445fc3c0e5 
  ql/src/test/results/clientpositive/tez/explainuser_1.q.out 8c78fd9d7f23f5272d88e83378485c83605c5b5a 
  ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out bb0c6f1b2d3e09fea294457f609194505218dd6b 
  ql/src/test/results/clientpositive/tez/mergejoin.q.out 4b2d9635fe602fa6aa03d20d32bb57770a92ac39 
  ql/src/test/results/clientpositive/tez/skewjoin.q.out fc084cc5b8c798ceb6bfc84ad1b29ca5d3c91f48 
  ql/src/test/results/clientpositive/tez/subquery_exists.q.out 5121a144c1d6c2c28890cd742e59d3c1bb868c9a 
  ql/src/test/results/clientpositive/tez/subquery_in.q.out a4887e4e69fd8d2734583586a67daf1bfeacf8ac 
  ql/src/test/results/clientpositive/tez/tez_dynpart_hashjoin_1.q.out e3131d5071c891b35340d040efb44ab3ea10a46c 
  ql/src/test/results/clientpositive/tez/tez_smb_empty.q.out 8c9ab2eda3b88362f38bf795e001dfc72ca52a73 
  ql/src/test/results/clientpositive/tez/tez_vector_dynpart_hashjoin_1.q.out 3711a10f425ba54153cf4fbca02ba86a09b401f6 
  ql/src/test/results/clientpositive/tez/vector_decimal_round.q.out 5bc04d7e02fa7b70050116ba8f1d062877691ae0 
  ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out 7eb28f8e2a5af32075e2fa1a1ad89af092a36e90 
  ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out cda76db1f9966a0b1969381faa3ad035568edb84 
  ql/src/test/results/clientpositive/udf1.q.out b3b694b8794ac6eb3fe6d0bbc29e51e7602f16e8 
  ql/src/test/results/clientpositive/udf_10_trims.q.out 3a5303adfe8450adff1eeb7f32f83b1150979c09 
  ql/src/test/results/clientpositive/udf_folder_constants.q.out ef07420325dd2d99322f4fc150951798dcdeafaa 
  ql/src/test/results/clientpositive/udf_unix_timestamp.q.out c64379d3e501793620a0b3dd010a2ada4912a118 
  ql/src/test/results/clientpositive/union_remove_25.q.out d82fcfc726428347159d6186d9c7fdce6034980e 
  ql/src/test/results/clientpositive/union_view.q.out 1d93159e2b2c1ede1c090fb82db1928872fd2c61 
  ql/src/test/results/clientpositive/vector_decimal_round.q.out ec6226ea74ece7b4129428dcf98d6f7af8f55e6e 
  ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out dd40f282c7392f4eb8ef674cb5f6629d41eacf01 

Diff: https://reviews.apache.org/r/42190/diff/


Testing
-------


Thanks,

Jesús Camacho Rodríguez

Re: Review Request 42190: HIVE-12478

Posted by Jesús Camacho Rodríguez <jc...@hortonworks.com>.

> On Jan. 23, 2016, 1:42 a.m., John Pullokkaran wrote:
> > ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveJoin.java, line 112
> > <https://reviews.apache.org/r/42190/diff/5/?file=1204755#file1204755line112>
> >
> >     What about other operators?
> >     HiveFilter, HiveProject .....

There is no need, as we match only Join/Semijoin in HivePushTransitivePredicate, right?


> On Jan. 23, 2016, 1:42 a.m., John Pullokkaran wrote:
> > ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveRulesRegistry.java, line 34
> > <https://reviews.apache.org/r/42190/diff/5/?file=1204761#file1204761line34>
> >
> >     Does this needs to be multimap?

I used a Multimap as we store the predicates that we have pushed for every input in the join, i.e. for a certain join, we will have two sets of predicates that have been pushed, one for each of its inputs.


- Jesús


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


On Jan. 21, 2016, 10:45 p.m., Jesús Camacho Rodríguez wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/42190/
> -----------------------------------------------------------
> 
> (Updated Jan. 21, 2016, 10:45 p.m.)
> 
> 
> Review request for hive and John Pullokkaran.
> 
> 
> Bugs: HIVE-12478
>     https://issues.apache.org/jira/browse/HIVE-12478
> 
> 
> Repository: hive-git
> 
> 
> Description
> -------
> 
> Improve Hive/Calcite Trasitive Predicate inference
> 
> 
> Diffs
> -----
> 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveCalciteUtil.java 4825a617876374085b6fac1192ba1531ec916bce 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveHepPlannerContext.java ad79aeec2fbc0454ab1ccc608944752d01324dca 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveVolcanoPlannerContext.java 8859fc268666cef1be283a9179aa0beb7ef1bdeb 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/cost/HiveCostModel.java d15d885d2348d666df069228a93d6c5f914c79df 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/cost/HiveVolcanoPlanner.java 8610edc5ddc00d523610fb29f5e504c3e876a542 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveJoin.java 27b1e76a104dc961cb4bce554602d90b3aa867e0 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveSemiJoin.java 35586768c2c2b81e4213495632e4457dd3d70443 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveUnion.java 8b57b3504c407b8a1e73d48ea240c4ec7558b327 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinAddNotNullRule.java de880ce26f1e172288f700c8566fbe71f42af115 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinPushTransitivePredicatesRule.java 703c8c6dbdfa281443cbcf7b08de2266697da8a9 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HivePreFilteringRule.java d37fc0e08d5e41b29539a990e6638385c1135eec 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveRulesRegistry.java 18a065e87e1ec266bf28b4ccfe10a1f863f847c2 
>   ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java 3fefbd710c4bb81d5f746cd91889b532b0a6029f 
>   ql/src/test/org/apache/hadoop/hive/ql/optimizer/calcite/TestCBORuleFiredOnlyOnce.java f1d8d1de00e9de7fa9ffea7d3aa2400e5073ac9c 
>   ql/src/test/results/clientpositive/annotate_stats_join.q.out 7fc754d5712d5f05efc943b66d3c829d47312d19 
>   ql/src/test/results/clientpositive/annotate_stats_join_pkfk.q.out f13643e8db57cc0a85b2626c37437fd030f72029 
>   ql/src/test/results/clientpositive/annotate_stats_select.q.out b158d8567f6cc02d990d175e93996239aba0c5ed 
>   ql/src/test/results/clientpositive/auto_join12.q.out 8ef3664764d04f53f3685d8f66dc4a353776a488 
>   ql/src/test/results/clientpositive/auto_join16.q.out c1da6d2968697d304311044d358f1af267dc6e60 
>   ql/src/test/results/clientpositive/auto_join_reordering_values.q.out 59aa738c779d50a760e1b0d36e4ce83295b0d70f 
>   ql/src/test/results/clientpositive/auto_join_without_localtask.q.out d40b1655e27fa70efc8dbf0475c688f6e2b3608f 
>   ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out cb87f761be7c58ecc6435bb0a9b0e96c46a36828 
>   ql/src/test/results/clientpositive/bucket_map_join_spark4.q.out 4abdab53b5562dc129a2d9a73c63cf44d066c05e 
>   ql/src/test/results/clientpositive/bucketizedhiveinputformat.q.out cfb95be72b32a354faeddc79dc52bc29c7593a2b 
>   ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out a7ad04c7208f8e8486e79c1e749184e5b532a1fc 
>   ql/src/test/results/clientpositive/cast1.q.out 48a0c14031ef38dd5b4df7efa718a4d6ce04bc94 
>   ql/src/test/results/clientpositive/cbo_const.q.out adc5232a67b2243dd5f09acaf1f7c49baea5daad 
>   ql/src/test/results/clientpositive/cbo_rp_cross_product_check_2.q.out f1707eb4146c55338500c1fcaf4ff7199750250f 
>   ql/src/test/results/clientpositive/cbo_rp_lineage2.q.out 1b2a2ab1af5992753c37d053942ecb2ebf775921 
>   ql/src/test/results/clientpositive/constprog_partitioner.q.out 08c0aebafe1644a5adbec6a56879b39617bfbf69 
>   ql/src/test/results/clientpositive/correlationoptimizer1.q.out 38764d6b127bd1aba1efa5800b16c0c1e387a310 
>   ql/src/test/results/clientpositive/correlationoptimizer10.q.out 6bac698155221be4b0cb5b0bb3b2cdbfec5236ea 
>   ql/src/test/results/clientpositive/correlationoptimizer13.q.out 61b7bcb675a80dc3267365c65545e107ecbe12d2 
>   ql/src/test/results/clientpositive/correlationoptimizer8.q.out 368a1147d404ae9aab18a64618abf8ed7b3f7189 
>   ql/src/test/results/clientpositive/correlationoptimizer9.q.out 104a97afbb6657255a027ff6d51101f6963c2358 
>   ql/src/test/results/clientpositive/cross_product_check_1.q.out 05eb270a292ecd9fe03db77511a7e2a08a28204c 
>   ql/src/test/results/clientpositive/cross_product_check_2.q.out a36560f23c1801f0bf988fa4e08dcf49376d8577 
>   ql/src/test/results/clientpositive/dynamic_rdd_cache.q.out 743865e073e1768f7f6234fde35ad2e56d8babe9 
>   ql/src/test/results/clientpositive/filter_cond_pushdown.q.out 5e0edbc9efb442467c4998021ac1ecfb9d07579d 
>   ql/src/test/results/clientpositive/groupby_position.q.out c2566f2ad5d426db8814b7ca85207807f4a5afc7 
>   ql/src/test/results/clientpositive/groupby_ppd.q.out d17c4b6d9e88d49d64b9725be1e51ca258ad1167 
>   ql/src/test/results/clientpositive/index_auto_mult_tables.q.out 8c71925fbc5352f42abb280fc45a1d5a5713ebad 
>   ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out b3e698927689dad5229165189779300cb8beca9b 
>   ql/src/test/results/clientpositive/index_auto_self_join.q.out 3cc1d7e8c7be8bd60e67f1a88a72ce9a89c5fe2c 
>   ql/src/test/results/clientpositive/index_bitmap3.q.out a8eecb5bd48bf07c648bf4425d66f566c7216d41 
>   ql/src/test/results/clientpositive/index_bitmap_auto.q.out d1fd59c8981e33e0e9da36c9811de45f9e625cd9 
>   ql/src/test/results/clientpositive/input_part1.q.out 501f7a9f87c66a1dd1d0fec0546597d810c0dbe9 
>   ql/src/test/results/clientpositive/input_part5.q.out c6ae2fd58d7d41e4b4c0f764de3e28484917cd97 
>   ql/src/test/results/clientpositive/input_part6.q.out c01d8afb6230440103ed8c1ecb38aea9eaabc832 
>   ql/src/test/results/clientpositive/join12.q.out 8217c86d0e41c78b8bf4ed120b30a85204fa9915 
>   ql/src/test/results/clientpositive/join16.q.out 244eb46dc0ae3b61ed932f043a98bb64295776a1 
>   ql/src/test/results/clientpositive/join19.q.out b1b9dfe8b59e7b75d4ba1a040844ae18af699336 
>   ql/src/test/results/clientpositive/join32.q.out 5cb124bddc85ee3f82464bb9a588bc4e64a639e6 
>   ql/src/test/results/clientpositive/join32_lessSize.q.out 544e814fd5194a28827de6fa4a3a394b23f7727d 
>   ql/src/test/results/clientpositive/join33.q.out 5cb124bddc85ee3f82464bb9a588bc4e64a639e6 
>   ql/src/test/results/clientpositive/join34.q.out e2c2b1a5ab742e26d953f11919e150f847a05157 
>   ql/src/test/results/clientpositive/join35.q.out 663642c7d1c00a47993c497ac76d6f036221f06b 
>   ql/src/test/results/clientpositive/join42.q.out 6e09e38102129edb7246b0a027c86ba1deed066c 
>   ql/src/test/results/clientpositive/join43.q.out b5006fa6fe86b377f2b5ec6498e5b731ef239296 
>   ql/src/test/results/clientpositive/join_alt_syntax.q.out 1c7f159aaed439c94607b815c30ec6c005d7dfb8 
>   ql/src/test/results/clientpositive/join_cond_pushdown_2.q.out 3a50651c955e7ecd24b0a9fe685bc5a7370a0b54 
>   ql/src/test/results/clientpositive/join_cond_pushdown_4.q.out af51f39f18f8dc499bcf0ad8c497b34ddb11b29d 
>   ql/src/test/results/clientpositive/join_cond_pushdown_unqual2.q.out 6a5608bdf1446fa3f6d45206021ce1fc9ed95301 
>   ql/src/test/results/clientpositive/join_cond_pushdown_unqual4.q.out d4a3549e3be54b1c8fd00309213666fef1ef6c58 
>   ql/src/test/results/clientpositive/join_grp_diff_keys.q.out da029c97a3438493163f08d0f8ef4c3c14043a22 
>   ql/src/test/results/clientpositive/join_hive_626.q.out f3d2cdc1dc2feaf2686325c076be6f6bf0c6768b 
>   ql/src/test/results/clientpositive/join_parse.q.out ab657cc48c6573fbf60e0cae812312fe02603555 
>   ql/src/test/results/clientpositive/join_star.q.out 78a615906aaa51b0254ba8df072af06456e87bdf 
>   ql/src/test/results/clientpositive/join_vc.q.out c93a258d69ab0349048e61014d79fbc93f8ffc82 
>   ql/src/test/results/clientpositive/lineage2.q.out a189f82a3d29cd3b1e21a43afc85ef14fd74c79e 
>   ql/src/test/results/clientpositive/lineage3.q.out f1162a213eea285a5d166731e0ce7e407f4106a7 
>   ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out 3dea672a11b65e9040d0d794bf03408fd6e3a755 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_tez1.q.out 1fb76d8a8f32e0d63eba743d6007ffc7691b9b30 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out 5e7af65ed954e3d61610ed21610d046db9eb5112 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out d2c11d7644570217532f9b366926d8cc94a03e6a 
>   ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_1.q.out b459692b443a1686def6615e9e9bcce5922335c3 
>   ql/src/test/results/clientpositive/llap/tez_join_hash.q.out 366fedc42819e0de586d00932621051ade288ed2 
>   ql/src/test/results/clientpositive/llap/tez_smb_main.q.out f15339b3828b710729466b59d20009af95c7d808 
>   ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out 6a57f1fd82ef3e3cf681138383534e7fea1c07df 
>   ql/src/test/results/clientpositive/llap/vectorized_dynamic_partition_pruning.q.out 63121a9e5b043e2c27fe08ee54e6fe01e2dd6cae 
>   ql/src/test/results/clientpositive/louter_join_ppr.q.out 553def9bb50e7e9c7e80bc422dc7bad56c5b5998 
>   ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out 41d824c9f3bcdbc30812e2cbb55539ed31421fe5 
>   ql/src/test/results/clientpositive/mergejoin.q.out acf816ebc2db9df7f2878375dea3c403fb513c08 
>   ql/src/test/results/clientpositive/mergejoins.q.out 901041083f3182497361b8f27ed77c093e7ce237 
>   ql/src/test/results/clientpositive/mergejoins_mixed.q.out 10f37f9fe34d79987333e3f8bb01166304fe5894 
>   ql/src/test/results/clientpositive/multiMapJoin1.q.out e2efec0295e2d15aa1497b848eb6eb8838617b7f 
>   ql/src/test/results/clientpositive/multi_join_union.q.out 8d7ff95461935bdab6ebc6aac8189e52ef2799de 
>   ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out 90032fe53d37163e09fbf2b1bf7dac0e55b80b18 
>   ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out 7c5be6dbe636f6cfcf8f4a3563d2b204d3cb2b46 
>   ql/src/test/results/clientpositive/partition_multilevels.q.out 699c1790314f0ea3bff2eae4aa6f3231eddead51 
>   ql/src/test/results/clientpositive/perf/query13.q.out 6113d18af3c9922b288d64c61ee0590d124b809b 
>   ql/src/test/results/clientpositive/perf/query15.q.out c2378282432aec3f46ab5928d709487c4829d0f2 
>   ql/src/test/results/clientpositive/perf/query17.q.out 0e42d053e37904af58735ff7d5021ab9ffe9e668 
>   ql/src/test/results/clientpositive/perf/query18.q.out 83f21dc7ebc2e8aaf2a0b081584e0fc98fdaf7a4 
>   ql/src/test/results/clientpositive/perf/query19.q.out d5658394163e7cdfd1876a3fb7449d7fd46f96df 
>   ql/src/test/results/clientpositive/perf/query20.q.out 40c9a17479c8cf83c1a4982a489be5099a81c783 
>   ql/src/test/results/clientpositive/perf/query21.q.out 2634d3d35ccf05584c719dd03c97e97f26d05eaf 
>   ql/src/test/results/clientpositive/perf/query22.q.out 72935ed2c5d7de7889b456da0c95c21b291b0b54 
>   ql/src/test/results/clientpositive/perf/query25.q.out dabc1c528e7cca0d8f83b4f1dd0938e56ff49f61 
>   ql/src/test/results/clientpositive/perf/query26.q.out 84cc23843e0931a8a55d39c354273cc6139425a5 
>   ql/src/test/results/clientpositive/perf/query27.q.out ac386835fae308bcbffdc5aa2e0492cde3d63852 
>   ql/src/test/results/clientpositive/perf/query29.q.out 8991f3562d5140611ce35513f1685e36bc070d9a 
>   ql/src/test/results/clientpositive/perf/query3.q.out 871ad740cd56c37129ad10a7df8fba24b1006d6b 
>   ql/src/test/results/clientpositive/perf/query31.q.out 909d64cef12a9492c5d24ef5876609a77423d2d5 
>   ql/src/test/results/clientpositive/perf/query32.q.out da2ac8fe18fc2d71f7b14c28396b741a31082fd2 
>   ql/src/test/results/clientpositive/perf/query34.q.out 1cb7c285f418476612fbc897f02e701e96995224 
>   ql/src/test/results/clientpositive/perf/query39.q.out 9f3e650943c1d7ab04fc521509ca9372e4105a25 
>   ql/src/test/results/clientpositive/perf/query40.q.out b2d6262d96b7dc1c25748a758af61988b39d7c45 
>   ql/src/test/results/clientpositive/perf/query42.q.out 9ede45d24587228328671a40e9b3f9ca43e2a550 
>   ql/src/test/results/clientpositive/perf/query43.q.out 7fa4f531722865710953f306c278fc5353e6a8bb 
>   ql/src/test/results/clientpositive/perf/query45.q.out f55f20cb0f13c661c5f50bf412042458de62c726 
>   ql/src/test/results/clientpositive/perf/query46.q.out 0ded91216db1e04548728a0025538929280b9dec 
>   ql/src/test/results/clientpositive/perf/query48.q.out 40b76f00d0bbbaffb5819a38eaaa7ca3914ad37c 
>   ql/src/test/results/clientpositive/perf/query50.q.out 8b41d05d312a0066644ff167c588d0d55e5770b3 
>   ql/src/test/results/clientpositive/perf/query52.q.out 7e7224ba54b49a68040a536adca665a8f510bdd7 
>   ql/src/test/results/clientpositive/perf/query54.q.out 56c70b7c6ab40cab7cf862023be36b3d88f3b288 
>   ql/src/test/results/clientpositive/perf/query55.q.out d36f3787f1d8b1d24306b38e6c65f6cbd583af80 
>   ql/src/test/results/clientpositive/perf/query58.q.out c2f71892ee7ceb68449c6c4f13754052041de106 
>   ql/src/test/results/clientpositive/perf/query64.q.out 9331673a663e9b31bfb00b443c4ae282ffe67e56 
>   ql/src/test/results/clientpositive/perf/query65.q.out 12bdd33c3aadc161faac927734de28d2da840650 
>   ql/src/test/results/clientpositive/perf/query66.q.out a25664e73afb1088e05ec3912dab253720bc4af4 
>   ql/src/test/results/clientpositive/perf/query67.q.out dda5347f54c65434e0edda80d327c04b76a5f484 
>   ql/src/test/results/clientpositive/perf/query68.q.out 8ecde892fa2f0011e16ec2e9c93e34dab7037e21 
>   ql/src/test/results/clientpositive/perf/query7.q.out a463a8b1fdb28d2f94301a5bc367da9c24469ecf 
>   ql/src/test/results/clientpositive/perf/query70.q.out d13165d844fc0cfb4d605ae428b5e29a9a3752d4 
>   ql/src/test/results/clientpositive/perf/query71.q.out fa50e5605878f1b090687160863156bc5f895055 
>   ql/src/test/results/clientpositive/perf/query72.q.out bb56f0d695ede28d37b210fc1c6293444038154e 
>   ql/src/test/results/clientpositive/perf/query73.q.out 9c888543d9115d2eb751fdf750fc95d964c9b093 
>   ql/src/test/results/clientpositive/perf/query75.q.out f3f9827a532b445e59642cbf9d169dc4147e03d2 
>   ql/src/test/results/clientpositive/perf/query76.q.out e540ee746f74df14c436290f55e4a2c4271d5bfc 
>   ql/src/test/results/clientpositive/perf/query79.q.out a0d5a516ceba5b3f5409fe120161f0c1edb42610 
>   ql/src/test/results/clientpositive/perf/query80.q.out 37cb542f008b21b26e2bdd03aac7144b7352893b 
>   ql/src/test/results/clientpositive/perf/query82.q.out 654a772070ffcd60b5201d5d8d7d1d635c4738d2 
>   ql/src/test/results/clientpositive/perf/query84.q.out e522f23800eb18b0abff741c3254b72eced931e8 
>   ql/src/test/results/clientpositive/perf/query85.q.out 54061ced073090cec35111081f21ac510d0bde92 
>   ql/src/test/results/clientpositive/perf/query87.q.out a3361898811f37271930a671381f6522724bf05d 
>   ql/src/test/results/clientpositive/perf/query88.q.out f139dd11c3cc65d78538426d68b452816117e3e3 
>   ql/src/test/results/clientpositive/perf/query89.q.out ee9eabc4330fcebd971a5c913888adcf67398ea5 
>   ql/src/test/results/clientpositive/perf/query90.q.out d34aaf4d65f7f614533390f4415666bc9879c88f 
>   ql/src/test/results/clientpositive/perf/query91.q.out 54f58e439bed7e44287ecc671c1db3e497ce4eae 
>   ql/src/test/results/clientpositive/perf/query92.q.out 6fb2133f2b8beaaaf32359d3d10770693125b505 
>   ql/src/test/results/clientpositive/perf/query93.q.out 52551459456d952ef1959515ec877b2fc992c6be 
>   ql/src/test/results/clientpositive/perf/query94.q.out 0357835f7f5e565f560e73506b10345c0fe089ff 
>   ql/src/test/results/clientpositive/perf/query95.q.out a7c6a981bfc07a9d08fefea511b57775aa9c4de7 
>   ql/src/test/results/clientpositive/perf/query96.q.out bba8965df34d208ab2fc825cdb2882e5a671f351 
>   ql/src/test/results/clientpositive/perf/query98.q.out baff7e04211c81bcb50ac9ca2553018989cb7800 
>   ql/src/test/results/clientpositive/pointlookup2.q.out 1cfa4b6345ab48f6cac437a2dbefc657016a4b6d 
>   ql/src/test/results/clientpositive/ppd_join2.q.out c5036525a685b5e76157dbf88a9e614727cb69ac 
>   ql/src/test/results/clientpositive/ppd_join3.q.out 0000db129c9428e34935397ab5c51f010987eca3 
>   ql/src/test/results/clientpositive/ppd_join5.q.out b68229eb08ca1fadd148387f2a361ca9c5237f12 
>   ql/src/test/results/clientpositive/ppd_outer_join4.q.out 289798c5bc0113ea4864e2c287001805a8fc1ea9 
>   ql/src/test/results/clientpositive/ppd_outer_join5.q.out 35fec7a46606b0489d9c4e9c472a26607b17a177 
>   ql/src/test/results/clientpositive/ppd_udf_case.q.out 2b407a63d8b51cfedc020459240150b97044ffc3 
>   ql/src/test/results/clientpositive/ppd_union_view.q.out d33cbd6b7b024fc789e3477e35afaeb7a58f052b 
>   ql/src/test/results/clientpositive/quotedid_basic.q.out 3c81e0bccce92d489d4f2eec874826a1d232c7be 
>   ql/src/test/results/clientpositive/quotedid_partition.q.out a83c62b1826786f5213c8556bd275e4bd545fb6a 
>   ql/src/test/results/clientpositive/regex_col.q.out 33e1a1273d49aba4c73540246288112781527496 
>   ql/src/test/results/clientpositive/router_join_ppr.q.out 7182f8deb6f74fc9250d6d55816c8a1debcb76ae 
>   ql/src/test/results/clientpositive/semijoin4.q.out 7489de2ebcc3d044b22cc2c64d4747b51285d111 
>   ql/src/test/results/clientpositive/skewjoin.q.out 4e98dfd9e7aedd8cffbe1aee64c03d62741763d7 
>   ql/src/test/results/clientpositive/skewjoin_mapjoin8.q.out ae0aafa49f5597c6fe3723a1c7c6de62dcc2012c 
>   ql/src/test/results/clientpositive/skewjoin_mapjoin9.q.out f9043d38d5d6fee8b9419abc21443538c690cddb 
>   ql/src/test/results/clientpositive/skewjoinopt12.q.out 5109173b4bcf3644bcf9c660b51a242d9483014c 
>   ql/src/test/results/clientpositive/skewjoinopt13.q.out 3f00c406460f7dfd43862a9e4ad07075ba0001b7 
>   ql/src/test/results/clientpositive/skewjoinopt14.q.out a8536def44f65d1bcaf3118c0143111e6bc893e2 
>   ql/src/test/results/clientpositive/skewjoinopt16.q.out de9869615e6bed1246288c5eb36e5b47f40559ef 
>   ql/src/test/results/clientpositive/skewjoinopt17.q.out ea2b670e1dde15dc8fd2e6728ae4e5fc5c7c90ce 
>   ql/src/test/results/clientpositive/skewjoinopt2.q.out c2ae731c38c766d1e3b43aa2d219927a8d3dfe95 
>   ql/src/test/results/clientpositive/spark/annotate_stats_join.q.out baa1dcb5c27dc709412466370acae31f75406562 
>   ql/src/test/results/clientpositive/spark/auto_join12.q.out 158e53511f43bd12fc006bd595c4dab48dc1cf94 
>   ql/src/test/results/clientpositive/spark/auto_join16.q.out ba6336aaa5213f0dcd292bd1fb07c9582fb1c6fd 
>   ql/src/test/results/clientpositive/spark/auto_join_reordering_values.q.out 8bf5977ceef03eb24fe3eed0b00f2f18580dbae2 
>   ql/src/test/results/clientpositive/spark/auto_join_without_localtask.q.out f055a59545c236b6cd4132700caf15fa4f72bfd2 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_6.q.out 41b2b0ae933946099505bee4c627d811ca21bed9 
>   ql/src/test/results/clientpositive/spark/bucket_map_join_spark4.q.out b00c223d2fc0d2d7a3daa4599e4069d07b80da79 
>   ql/src/test/results/clientpositive/spark/bucket_map_join_tez1.q.out 57a89d67b56cc36dda8b42f21481e9363cff297a 
>   ql/src/test/results/clientpositive/spark/bucket_map_join_tez2.q.out 31908d71d4ea174d8210822a70689084908e760b 
>   ql/src/test/results/clientpositive/spark/bucketizedhiveinputformat.q.out c8fc4d3ac6aacb8e7ce59792ab4f74cabde238e3 
>   ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_6.q.out e8e1e7e510c414255de72dfa86b8140f97ea5e87 
>   ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_7.q.out 0b64a8735a6e9a668650db8907abce38c31ab70e 
>   ql/src/test/results/clientpositive/spark/constprog_partitioner.q.out 8a6ab825c2be8e5a7d9715e93545421b7f16e1df 
>   ql/src/test/results/clientpositive/spark/cross_product_check_1.q.out 5e67607241b1c029e40ec82edb09ddad394af67c 
>   ql/src/test/results/clientpositive/spark/cross_product_check_2.q.out e8bcd7a6f346bfa02b4031abb6221bd65f7d15b4 
>   ql/src/test/results/clientpositive/spark/dynamic_rdd_cache.q.out 6e595ff4b19d188b041394aff5df6d93614fe813 
>   ql/src/test/results/clientpositive/spark/groupby_position.q.out 415703f638ede1e113fd3f7864f2f8688302c38d 
>   ql/src/test/results/clientpositive/spark/index_auto_self_join.q.out 40c09de04a4e8eb8b02a4b537ca58fbf57e831fa 
>   ql/src/test/results/clientpositive/spark/index_bitmap3.q.out b03ea990c06964b5d582967fd58d2cb40e955b59 
>   ql/src/test/results/clientpositive/spark/index_bitmap_auto.q.out c912379afcffd94d487999e4ed4ac7059860ebb9 
>   ql/src/test/results/clientpositive/spark/join12.q.out 2ad0a43853e832fe7d16678d38e6b5b1f43f467f 
>   ql/src/test/results/clientpositive/spark/join16.q.out 2496ec2904272923c346d746f6150a34ffee63be 
>   ql/src/test/results/clientpositive/spark/join19.q.out 5de045b133c1a40c1bee87e0ac8354d4806858d3 
>   ql/src/test/results/clientpositive/spark/join32.q.out 377121709ddaa0e8d13df067b11de491dc5c5cd5 
>   ql/src/test/results/clientpositive/spark/join32_lessSize.q.out c4ac2dd6dfadcaee944f0da7ae54f8e3eee49f23 
>   ql/src/test/results/clientpositive/spark/join33.q.out 377121709ddaa0e8d13df067b11de491dc5c5cd5 
>   ql/src/test/results/clientpositive/spark/join34.q.out a4cbc79b4755c0ab74177e7804bb4e16204345c2 
>   ql/src/test/results/clientpositive/spark/join35.q.out 598143f021681214e5da79f87c76dd676281f6a1 
>   ql/src/test/results/clientpositive/spark/join_alt_syntax.q.out fb50955e80839d39eef99db8f814f50d75f03412 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_2.q.out 1a1c15428614f83c92d9ac25e2126b37133e9e21 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_4.q.out 4fa5f5a9306ddbe6e5bc27634a34dd21739c2b6e 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual2.q.out 8b318d827dc5fa07b893313777dcc3f3ab5ae52d 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual4.q.out 15c45e67243687c32491a47b8ae1b94c8a55be02 
>   ql/src/test/results/clientpositive/spark/join_hive_626.q.out c07d12e7407f6a48fc0e20567f087c702510c5cc 
>   ql/src/test/results/clientpositive/spark/join_star.q.out dea7a81b8472c8af913f0578e0708934ae2c465a 
>   ql/src/test/results/clientpositive/spark/join_vc.q.out c1812a9ead215c1f872f177a13fc3a854ac38b9f 
>   ql/src/test/results/clientpositive/spark/louter_join_ppr.q.out 7f72b760929384c59d2e48827ff4ff652eb2b443 
>   ql/src/test/results/clientpositive/spark/mapjoin_mapjoin.q.out b7ac43de22bd600c7170fc7588a753b7c56edf5c 
>   ql/src/test/results/clientpositive/spark/mergejoins.q.out e6872400b45cadc969ef897cf42c38dd23b9581f 
>   ql/src/test/results/clientpositive/spark/mergejoins_mixed.q.out 42ffebfde50472f1aec060c33037fe851921e88c 
>   ql/src/test/results/clientpositive/spark/multi_join_union.q.out 5ddcb1bc1348b927ef1f521cf7691563cecb0a1d 
>   ql/src/test/results/clientpositive/spark/ppd_join2.q.out 5848609e67bedffbffe7cb8028588017eaf327a6 
>   ql/src/test/results/clientpositive/spark/ppd_join3.q.out c78d4cb4580d17946375f6ee5b6c447741d7c6f4 
>   ql/src/test/results/clientpositive/spark/ppd_join5.q.out 8b51969b4b5e8b2772c37dfb8ec8e17908fd58f2 
>   ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out 8d0830892ab997e489306ec2698e1c6fdf61996f 
>   ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out 8e398580ac526c0acbd642bc91579fcea0d9b428 
>   ql/src/test/results/clientpositive/spark/router_join_ppr.q.out 319dc0ad836129d2e551e3414ab52a74b9f49b8b 
>   ql/src/test/results/clientpositive/spark/skewjoin.q.out b2460460da36e856655ca12706678378b976f059 
>   ql/src/test/results/clientpositive/spark/skewjoinopt12.q.out 1e77aa746de5c950e1789b8d5b38e68650b53b3c 
>   ql/src/test/results/clientpositive/spark/skewjoinopt13.q.out f1a681df557d4ef22632096beb96fefc72baf3dc 
>   ql/src/test/results/clientpositive/spark/skewjoinopt14.q.out ef36afda6d70ea3c0d1bb2ebfdd90dcc82329ccd 
>   ql/src/test/results/clientpositive/spark/skewjoinopt16.q.out 3be7ce08d9a43ada35d5bbfebf4a567e8fcdde58 
>   ql/src/test/results/clientpositive/spark/skewjoinopt17.q.out ce8bbfa768ea8ad0ddc072bfb29cbacd82ef4a49 
>   ql/src/test/results/clientpositive/spark/skewjoinopt2.q.out b5fa077046bcf9ae14935b034f62d12786f38d1f 
>   ql/src/test/results/clientpositive/spark/subquery_exists.q.out 5f41ac7aeaa5425004a4cd56638f0961a5a78a7e 
>   ql/src/test/results/clientpositive/spark/subquery_in.q.out 1d813f8ae53e6cccde25e864d168380568e02e7a 
>   ql/src/test/results/clientpositive/spark/union_remove_25.q.out eb95cadde3f8f3006df4a1093bebf00dd55514f8 
>   ql/src/test/results/clientpositive/spark/union_view.q.out 492f71b10b9e98cd9235fad4b40850b2aa2d9730 
>   ql/src/test/results/clientpositive/spark/vector_mapjoin_reduce.q.out 296c256d09703a073a41a36dc96b526e78afb715 
>   ql/src/test/results/clientpositive/spark/vectorized_nested_mapjoin.q.out c4c86092eda1376da2669293bce7c05708aa7650 
>   ql/src/test/results/clientpositive/subquery_exists.q.out f3a270589b7b50dd7ef2ec53d1bac7ae88f7f245 
>   ql/src/test/results/clientpositive/subquery_in.q.out a374dc0f84aa78dcf099d8733b42f94e6cea7863 
>   ql/src/test/results/clientpositive/subquery_notin.q.out e157ff4d511cd7a4729f3c1d39800e80788ee48a 
>   ql/src/test/results/clientpositive/subquery_notin_having.q.java1.7.out 8f17b6c33b7842d805fa8fa412fed8149d3c219d 
>   ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out e34a401ca41faae0f25e7f398ac5c078f8f34df8 
>   ql/src/test/results/clientpositive/subquery_views.q.out 76e53d3be56f3f8c2422317585d441cd14665294 
>   ql/src/test/results/clientpositive/tez/auto_sortmerge_join_6.q.out 521485ae03a484704b84a3e8b9eb2eed992ffdc2 
>   ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out 4703cec3fdcbb79bbc4b0365b97600e760ac2748 
>   ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out c5cb360e0524e006a728105e2f0e17a1df8afa68 
>   ql/src/test/results/clientpositive/tez/correlationoptimizer1.q.out 20bec18f8e66d6fad385c3e28dfa940c5afd199c 
>   ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out d5530a579a011aefa2a7fea965d9617c45b86231 
>   ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out 45c4e3f153bd7d55e2f09c83fc989fd12fbf9b80 
>   ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out 58ab2c08554f4b2b4d06e79de22845445fc3c0e5 
>   ql/src/test/results/clientpositive/tez/explainuser_1.q.out 8c78fd9d7f23f5272d88e83378485c83605c5b5a 
>   ql/src/test/results/clientpositive/tez/explainuser_2.q.out eb7d564b774d5c486cd9e47086b2ef750ce17dd5 
>   ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out 3534a9cdcfe0ae1ee3404a9aa80131a0cedf265e 
>   ql/src/test/results/clientpositive/tez/mergejoin.q.out 4b2d9635fe602fa6aa03d20d32bb57770a92ac39 
>   ql/src/test/results/clientpositive/tez/skewjoin.q.out fc084cc5b8c798ceb6bfc84ad1b29ca5d3c91f48 
>   ql/src/test/results/clientpositive/tez/subquery_exists.q.out 5121a144c1d6c2c28890cd742e59d3c1bb868c9a 
>   ql/src/test/results/clientpositive/tez/subquery_in.q.out a4887e4e69fd8d2734583586a67daf1bfeacf8ac 
>   ql/src/test/results/clientpositive/tez/tez_dynpart_hashjoin_1.q.out e3131d5071c891b35340d040efb44ab3ea10a46c 
>   ql/src/test/results/clientpositive/tez/tez_join_hash.q.out 0202def4353e4bd492552a378ba0e83b360d6306 
>   ql/src/test/results/clientpositive/tez/tez_smb_empty.q.out 8c9ab2eda3b88362f38bf795e001dfc72ca52a73 
>   ql/src/test/results/clientpositive/tez/tez_smb_main.q.out b7110898237bb049f8fd78ce777c78315052c598 
>   ql/src/test/results/clientpositive/tez/tez_vector_dynpart_hashjoin_1.q.out 3711a10f425ba54153cf4fbca02ba86a09b401f6 
>   ql/src/test/results/clientpositive/tez/vector_decimal_round.q.out 5bc04d7e02fa7b70050116ba8f1d062877691ae0 
>   ql/src/test/results/clientpositive/tez/vector_groupby_mapjoin.q.out dedcec8aed37d2c03c4cd754d74112c474d5643a 
>   ql/src/test/results/clientpositive/tez/vector_interval_mapjoin.q.out 42ce4996b5836759dcc4fb47523809abb57c81ee 
>   ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out 7eb28f8e2a5af32075e2fa1a1ad89af092a36e90 
>   ql/src/test/results/clientpositive/tez/vector_mr_diff_schema_alias.q.out f60a5840d013154849f68769aa1050c98a893667 
>   ql/src/test/results/clientpositive/tez/vectorized_context.q.out 0eb48021eea290c7bb675d906722242645dc3517 
>   ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out cda76db1f9966a0b1969381faa3ad035568edb84 
>   ql/src/test/results/clientpositive/tez/vectorized_nested_mapjoin.q.out e1e95e7786cbbb7d2625ab52394d1b690d542112 
>   ql/src/test/results/clientpositive/udf1.q.out b3b694b8794ac6eb3fe6d0bbc29e51e7602f16e8 
>   ql/src/test/results/clientpositive/udf_10_trims.q.out 3a5303adfe8450adff1eeb7f32f83b1150979c09 
>   ql/src/test/results/clientpositive/udf_folder_constants.q.out ef07420325dd2d99322f4fc150951798dcdeafaa 
>   ql/src/test/results/clientpositive/union_remove_25.q.out 3869735f9f83a1c5538403f5563369eee7d77be9 
>   ql/src/test/results/clientpositive/union_view.q.out 1d93159e2b2c1ede1c090fb82db1928872fd2c61 
>   ql/src/test/results/clientpositive/vector_decimal_round.q.out ec6226ea74ece7b4129428dcf98d6f7af8f55e6e 
>   ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out 367eb5983b2a57322d22a84c4afd39e4e2080345 
>   ql/src/test/results/clientpositive/vector_interval_mapjoin.q.out 7cd7eb0c709831b1b4b264203301d2593a5d79a6 
>   ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out dd40f282c7392f4eb8ef674cb5f6629d41eacf01 
>   ql/src/test/results/clientpositive/vector_mr_diff_schema_alias.q.out 81724dcdc99f4ae4344a3f67e14cd49e2039b7ef 
>   ql/src/test/results/clientpositive/vectorized_context.q.out 2a37bc2c221e312abdea01242d7b4c013df7660d 
>   ql/src/test/results/clientpositive/vectorized_nested_mapjoin.q.out b18cf9d918f5746da04f6315828675fe6d829c7f 
> 
> Diff: https://reviews.apache.org/r/42190/diff/
> 
> 
> Testing
> -------
> 
> 
> Thanks,
> 
> Jesús Camacho Rodríguez
> 
>

Re: Review Request 42190: HIVE-12478

Posted by John Pullokkaran <jp...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/42190/#review115960
-----------------------------------------------------------




ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveCalciteUtil.java (line 636)
<https://reviews.apache.org/r/42190/#comment176997>

    NitPick: Doc seems unfinished



ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveJoin.java (line 112)
<https://reviews.apache.org/r/42190/#comment177001>

    What about other operators?
    HiveFilter, HiveProject .....



ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveRulesRegistry.java (line 34)
<https://reviews.apache.org/r/42190/#comment176996>

    Does this needs to be multimap?


- John Pullokkaran


On Jan. 21, 2016, 10:45 p.m., Jesús Camacho Rodríguez wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/42190/
> -----------------------------------------------------------
> 
> (Updated Jan. 21, 2016, 10:45 p.m.)
> 
> 
> Review request for hive and John Pullokkaran.
> 
> 
> Bugs: HIVE-12478
>     https://issues.apache.org/jira/browse/HIVE-12478
> 
> 
> Repository: hive-git
> 
> 
> Description
> -------
> 
> Improve Hive/Calcite Trasitive Predicate inference
> 
> 
> Diffs
> -----
> 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveCalciteUtil.java 4825a617876374085b6fac1192ba1531ec916bce 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveHepPlannerContext.java ad79aeec2fbc0454ab1ccc608944752d01324dca 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveVolcanoPlannerContext.java 8859fc268666cef1be283a9179aa0beb7ef1bdeb 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/cost/HiveCostModel.java d15d885d2348d666df069228a93d6c5f914c79df 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/cost/HiveVolcanoPlanner.java 8610edc5ddc00d523610fb29f5e504c3e876a542 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveJoin.java 27b1e76a104dc961cb4bce554602d90b3aa867e0 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveSemiJoin.java 35586768c2c2b81e4213495632e4457dd3d70443 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveUnion.java 8b57b3504c407b8a1e73d48ea240c4ec7558b327 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinAddNotNullRule.java de880ce26f1e172288f700c8566fbe71f42af115 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinPushTransitivePredicatesRule.java 703c8c6dbdfa281443cbcf7b08de2266697da8a9 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HivePreFilteringRule.java d37fc0e08d5e41b29539a990e6638385c1135eec 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveRulesRegistry.java 18a065e87e1ec266bf28b4ccfe10a1f863f847c2 
>   ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java 3fefbd710c4bb81d5f746cd91889b532b0a6029f 
>   ql/src/test/org/apache/hadoop/hive/ql/optimizer/calcite/TestCBORuleFiredOnlyOnce.java f1d8d1de00e9de7fa9ffea7d3aa2400e5073ac9c 
>   ql/src/test/results/clientpositive/annotate_stats_join.q.out 7fc754d5712d5f05efc943b66d3c829d47312d19 
>   ql/src/test/results/clientpositive/annotate_stats_join_pkfk.q.out f13643e8db57cc0a85b2626c37437fd030f72029 
>   ql/src/test/results/clientpositive/annotate_stats_select.q.out b158d8567f6cc02d990d175e93996239aba0c5ed 
>   ql/src/test/results/clientpositive/auto_join12.q.out 8ef3664764d04f53f3685d8f66dc4a353776a488 
>   ql/src/test/results/clientpositive/auto_join16.q.out c1da6d2968697d304311044d358f1af267dc6e60 
>   ql/src/test/results/clientpositive/auto_join_reordering_values.q.out 59aa738c779d50a760e1b0d36e4ce83295b0d70f 
>   ql/src/test/results/clientpositive/auto_join_without_localtask.q.out d40b1655e27fa70efc8dbf0475c688f6e2b3608f 
>   ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out cb87f761be7c58ecc6435bb0a9b0e96c46a36828 
>   ql/src/test/results/clientpositive/bucket_map_join_spark4.q.out 4abdab53b5562dc129a2d9a73c63cf44d066c05e 
>   ql/src/test/results/clientpositive/bucketizedhiveinputformat.q.out cfb95be72b32a354faeddc79dc52bc29c7593a2b 
>   ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out a7ad04c7208f8e8486e79c1e749184e5b532a1fc 
>   ql/src/test/results/clientpositive/cast1.q.out 48a0c14031ef38dd5b4df7efa718a4d6ce04bc94 
>   ql/src/test/results/clientpositive/cbo_const.q.out adc5232a67b2243dd5f09acaf1f7c49baea5daad 
>   ql/src/test/results/clientpositive/cbo_rp_cross_product_check_2.q.out f1707eb4146c55338500c1fcaf4ff7199750250f 
>   ql/src/test/results/clientpositive/cbo_rp_lineage2.q.out 1b2a2ab1af5992753c37d053942ecb2ebf775921 
>   ql/src/test/results/clientpositive/constprog_partitioner.q.out 08c0aebafe1644a5adbec6a56879b39617bfbf69 
>   ql/src/test/results/clientpositive/correlationoptimizer1.q.out 38764d6b127bd1aba1efa5800b16c0c1e387a310 
>   ql/src/test/results/clientpositive/correlationoptimizer10.q.out 6bac698155221be4b0cb5b0bb3b2cdbfec5236ea 
>   ql/src/test/results/clientpositive/correlationoptimizer13.q.out 61b7bcb675a80dc3267365c65545e107ecbe12d2 
>   ql/src/test/results/clientpositive/correlationoptimizer8.q.out 368a1147d404ae9aab18a64618abf8ed7b3f7189 
>   ql/src/test/results/clientpositive/correlationoptimizer9.q.out 104a97afbb6657255a027ff6d51101f6963c2358 
>   ql/src/test/results/clientpositive/cross_product_check_1.q.out 05eb270a292ecd9fe03db77511a7e2a08a28204c 
>   ql/src/test/results/clientpositive/cross_product_check_2.q.out a36560f23c1801f0bf988fa4e08dcf49376d8577 
>   ql/src/test/results/clientpositive/dynamic_rdd_cache.q.out 743865e073e1768f7f6234fde35ad2e56d8babe9 
>   ql/src/test/results/clientpositive/filter_cond_pushdown.q.out 5e0edbc9efb442467c4998021ac1ecfb9d07579d 
>   ql/src/test/results/clientpositive/groupby_position.q.out c2566f2ad5d426db8814b7ca85207807f4a5afc7 
>   ql/src/test/results/clientpositive/groupby_ppd.q.out d17c4b6d9e88d49d64b9725be1e51ca258ad1167 
>   ql/src/test/results/clientpositive/index_auto_mult_tables.q.out 8c71925fbc5352f42abb280fc45a1d5a5713ebad 
>   ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out b3e698927689dad5229165189779300cb8beca9b 
>   ql/src/test/results/clientpositive/index_auto_self_join.q.out 3cc1d7e8c7be8bd60e67f1a88a72ce9a89c5fe2c 
>   ql/src/test/results/clientpositive/index_bitmap3.q.out a8eecb5bd48bf07c648bf4425d66f566c7216d41 
>   ql/src/test/results/clientpositive/index_bitmap_auto.q.out d1fd59c8981e33e0e9da36c9811de45f9e625cd9 
>   ql/src/test/results/clientpositive/input_part1.q.out 501f7a9f87c66a1dd1d0fec0546597d810c0dbe9 
>   ql/src/test/results/clientpositive/input_part5.q.out c6ae2fd58d7d41e4b4c0f764de3e28484917cd97 
>   ql/src/test/results/clientpositive/input_part6.q.out c01d8afb6230440103ed8c1ecb38aea9eaabc832 
>   ql/src/test/results/clientpositive/join12.q.out 8217c86d0e41c78b8bf4ed120b30a85204fa9915 
>   ql/src/test/results/clientpositive/join16.q.out 244eb46dc0ae3b61ed932f043a98bb64295776a1 
>   ql/src/test/results/clientpositive/join19.q.out b1b9dfe8b59e7b75d4ba1a040844ae18af699336 
>   ql/src/test/results/clientpositive/join32.q.out 5cb124bddc85ee3f82464bb9a588bc4e64a639e6 
>   ql/src/test/results/clientpositive/join32_lessSize.q.out 544e814fd5194a28827de6fa4a3a394b23f7727d 
>   ql/src/test/results/clientpositive/join33.q.out 5cb124bddc85ee3f82464bb9a588bc4e64a639e6 
>   ql/src/test/results/clientpositive/join34.q.out e2c2b1a5ab742e26d953f11919e150f847a05157 
>   ql/src/test/results/clientpositive/join35.q.out 663642c7d1c00a47993c497ac76d6f036221f06b 
>   ql/src/test/results/clientpositive/join42.q.out 6e09e38102129edb7246b0a027c86ba1deed066c 
>   ql/src/test/results/clientpositive/join43.q.out b5006fa6fe86b377f2b5ec6498e5b731ef239296 
>   ql/src/test/results/clientpositive/join_alt_syntax.q.out 1c7f159aaed439c94607b815c30ec6c005d7dfb8 
>   ql/src/test/results/clientpositive/join_cond_pushdown_2.q.out 3a50651c955e7ecd24b0a9fe685bc5a7370a0b54 
>   ql/src/test/results/clientpositive/join_cond_pushdown_4.q.out af51f39f18f8dc499bcf0ad8c497b34ddb11b29d 
>   ql/src/test/results/clientpositive/join_cond_pushdown_unqual2.q.out 6a5608bdf1446fa3f6d45206021ce1fc9ed95301 
>   ql/src/test/results/clientpositive/join_cond_pushdown_unqual4.q.out d4a3549e3be54b1c8fd00309213666fef1ef6c58 
>   ql/src/test/results/clientpositive/join_grp_diff_keys.q.out da029c97a3438493163f08d0f8ef4c3c14043a22 
>   ql/src/test/results/clientpositive/join_hive_626.q.out f3d2cdc1dc2feaf2686325c076be6f6bf0c6768b 
>   ql/src/test/results/clientpositive/join_parse.q.out ab657cc48c6573fbf60e0cae812312fe02603555 
>   ql/src/test/results/clientpositive/join_star.q.out 78a615906aaa51b0254ba8df072af06456e87bdf 
>   ql/src/test/results/clientpositive/join_vc.q.out c93a258d69ab0349048e61014d79fbc93f8ffc82 
>   ql/src/test/results/clientpositive/lineage2.q.out a189f82a3d29cd3b1e21a43afc85ef14fd74c79e 
>   ql/src/test/results/clientpositive/lineage3.q.out f1162a213eea285a5d166731e0ce7e407f4106a7 
>   ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out 3dea672a11b65e9040d0d794bf03408fd6e3a755 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_tez1.q.out 1fb76d8a8f32e0d63eba743d6007ffc7691b9b30 
>   ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out 5e7af65ed954e3d61610ed21610d046db9eb5112 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out d2c11d7644570217532f9b366926d8cc94a03e6a 
>   ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_1.q.out b459692b443a1686def6615e9e9bcce5922335c3 
>   ql/src/test/results/clientpositive/llap/tez_join_hash.q.out 366fedc42819e0de586d00932621051ade288ed2 
>   ql/src/test/results/clientpositive/llap/tez_smb_main.q.out f15339b3828b710729466b59d20009af95c7d808 
>   ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out 6a57f1fd82ef3e3cf681138383534e7fea1c07df 
>   ql/src/test/results/clientpositive/llap/vectorized_dynamic_partition_pruning.q.out 63121a9e5b043e2c27fe08ee54e6fe01e2dd6cae 
>   ql/src/test/results/clientpositive/louter_join_ppr.q.out 553def9bb50e7e9c7e80bc422dc7bad56c5b5998 
>   ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out 41d824c9f3bcdbc30812e2cbb55539ed31421fe5 
>   ql/src/test/results/clientpositive/mergejoin.q.out acf816ebc2db9df7f2878375dea3c403fb513c08 
>   ql/src/test/results/clientpositive/mergejoins.q.out 901041083f3182497361b8f27ed77c093e7ce237 
>   ql/src/test/results/clientpositive/mergejoins_mixed.q.out 10f37f9fe34d79987333e3f8bb01166304fe5894 
>   ql/src/test/results/clientpositive/multiMapJoin1.q.out e2efec0295e2d15aa1497b848eb6eb8838617b7f 
>   ql/src/test/results/clientpositive/multi_join_union.q.out 8d7ff95461935bdab6ebc6aac8189e52ef2799de 
>   ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out 90032fe53d37163e09fbf2b1bf7dac0e55b80b18 
>   ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out 7c5be6dbe636f6cfcf8f4a3563d2b204d3cb2b46 
>   ql/src/test/results/clientpositive/partition_multilevels.q.out 699c1790314f0ea3bff2eae4aa6f3231eddead51 
>   ql/src/test/results/clientpositive/perf/query13.q.out 6113d18af3c9922b288d64c61ee0590d124b809b 
>   ql/src/test/results/clientpositive/perf/query15.q.out c2378282432aec3f46ab5928d709487c4829d0f2 
>   ql/src/test/results/clientpositive/perf/query17.q.out 0e42d053e37904af58735ff7d5021ab9ffe9e668 
>   ql/src/test/results/clientpositive/perf/query18.q.out 83f21dc7ebc2e8aaf2a0b081584e0fc98fdaf7a4 
>   ql/src/test/results/clientpositive/perf/query19.q.out d5658394163e7cdfd1876a3fb7449d7fd46f96df 
>   ql/src/test/results/clientpositive/perf/query20.q.out 40c9a17479c8cf83c1a4982a489be5099a81c783 
>   ql/src/test/results/clientpositive/perf/query21.q.out 2634d3d35ccf05584c719dd03c97e97f26d05eaf 
>   ql/src/test/results/clientpositive/perf/query22.q.out 72935ed2c5d7de7889b456da0c95c21b291b0b54 
>   ql/src/test/results/clientpositive/perf/query25.q.out dabc1c528e7cca0d8f83b4f1dd0938e56ff49f61 
>   ql/src/test/results/clientpositive/perf/query26.q.out 84cc23843e0931a8a55d39c354273cc6139425a5 
>   ql/src/test/results/clientpositive/perf/query27.q.out ac386835fae308bcbffdc5aa2e0492cde3d63852 
>   ql/src/test/results/clientpositive/perf/query29.q.out 8991f3562d5140611ce35513f1685e36bc070d9a 
>   ql/src/test/results/clientpositive/perf/query3.q.out 871ad740cd56c37129ad10a7df8fba24b1006d6b 
>   ql/src/test/results/clientpositive/perf/query31.q.out 909d64cef12a9492c5d24ef5876609a77423d2d5 
>   ql/src/test/results/clientpositive/perf/query32.q.out da2ac8fe18fc2d71f7b14c28396b741a31082fd2 
>   ql/src/test/results/clientpositive/perf/query34.q.out 1cb7c285f418476612fbc897f02e701e96995224 
>   ql/src/test/results/clientpositive/perf/query39.q.out 9f3e650943c1d7ab04fc521509ca9372e4105a25 
>   ql/src/test/results/clientpositive/perf/query40.q.out b2d6262d96b7dc1c25748a758af61988b39d7c45 
>   ql/src/test/results/clientpositive/perf/query42.q.out 9ede45d24587228328671a40e9b3f9ca43e2a550 
>   ql/src/test/results/clientpositive/perf/query43.q.out 7fa4f531722865710953f306c278fc5353e6a8bb 
>   ql/src/test/results/clientpositive/perf/query45.q.out f55f20cb0f13c661c5f50bf412042458de62c726 
>   ql/src/test/results/clientpositive/perf/query46.q.out 0ded91216db1e04548728a0025538929280b9dec 
>   ql/src/test/results/clientpositive/perf/query48.q.out 40b76f00d0bbbaffb5819a38eaaa7ca3914ad37c 
>   ql/src/test/results/clientpositive/perf/query50.q.out 8b41d05d312a0066644ff167c588d0d55e5770b3 
>   ql/src/test/results/clientpositive/perf/query52.q.out 7e7224ba54b49a68040a536adca665a8f510bdd7 
>   ql/src/test/results/clientpositive/perf/query54.q.out 56c70b7c6ab40cab7cf862023be36b3d88f3b288 
>   ql/src/test/results/clientpositive/perf/query55.q.out d36f3787f1d8b1d24306b38e6c65f6cbd583af80 
>   ql/src/test/results/clientpositive/perf/query58.q.out c2f71892ee7ceb68449c6c4f13754052041de106 
>   ql/src/test/results/clientpositive/perf/query64.q.out 9331673a663e9b31bfb00b443c4ae282ffe67e56 
>   ql/src/test/results/clientpositive/perf/query65.q.out 12bdd33c3aadc161faac927734de28d2da840650 
>   ql/src/test/results/clientpositive/perf/query66.q.out a25664e73afb1088e05ec3912dab253720bc4af4 
>   ql/src/test/results/clientpositive/perf/query67.q.out dda5347f54c65434e0edda80d327c04b76a5f484 
>   ql/src/test/results/clientpositive/perf/query68.q.out 8ecde892fa2f0011e16ec2e9c93e34dab7037e21 
>   ql/src/test/results/clientpositive/perf/query7.q.out a463a8b1fdb28d2f94301a5bc367da9c24469ecf 
>   ql/src/test/results/clientpositive/perf/query70.q.out d13165d844fc0cfb4d605ae428b5e29a9a3752d4 
>   ql/src/test/results/clientpositive/perf/query71.q.out fa50e5605878f1b090687160863156bc5f895055 
>   ql/src/test/results/clientpositive/perf/query72.q.out bb56f0d695ede28d37b210fc1c6293444038154e 
>   ql/src/test/results/clientpositive/perf/query73.q.out 9c888543d9115d2eb751fdf750fc95d964c9b093 
>   ql/src/test/results/clientpositive/perf/query75.q.out f3f9827a532b445e59642cbf9d169dc4147e03d2 
>   ql/src/test/results/clientpositive/perf/query76.q.out e540ee746f74df14c436290f55e4a2c4271d5bfc 
>   ql/src/test/results/clientpositive/perf/query79.q.out a0d5a516ceba5b3f5409fe120161f0c1edb42610 
>   ql/src/test/results/clientpositive/perf/query80.q.out 37cb542f008b21b26e2bdd03aac7144b7352893b 
>   ql/src/test/results/clientpositive/perf/query82.q.out 654a772070ffcd60b5201d5d8d7d1d635c4738d2 
>   ql/src/test/results/clientpositive/perf/query84.q.out e522f23800eb18b0abff741c3254b72eced931e8 
>   ql/src/test/results/clientpositive/perf/query85.q.out 54061ced073090cec35111081f21ac510d0bde92 
>   ql/src/test/results/clientpositive/perf/query87.q.out a3361898811f37271930a671381f6522724bf05d 
>   ql/src/test/results/clientpositive/perf/query88.q.out f139dd11c3cc65d78538426d68b452816117e3e3 
>   ql/src/test/results/clientpositive/perf/query89.q.out ee9eabc4330fcebd971a5c913888adcf67398ea5 
>   ql/src/test/results/clientpositive/perf/query90.q.out d34aaf4d65f7f614533390f4415666bc9879c88f 
>   ql/src/test/results/clientpositive/perf/query91.q.out 54f58e439bed7e44287ecc671c1db3e497ce4eae 
>   ql/src/test/results/clientpositive/perf/query92.q.out 6fb2133f2b8beaaaf32359d3d10770693125b505 
>   ql/src/test/results/clientpositive/perf/query93.q.out 52551459456d952ef1959515ec877b2fc992c6be 
>   ql/src/test/results/clientpositive/perf/query94.q.out 0357835f7f5e565f560e73506b10345c0fe089ff 
>   ql/src/test/results/clientpositive/perf/query95.q.out a7c6a981bfc07a9d08fefea511b57775aa9c4de7 
>   ql/src/test/results/clientpositive/perf/query96.q.out bba8965df34d208ab2fc825cdb2882e5a671f351 
>   ql/src/test/results/clientpositive/perf/query98.q.out baff7e04211c81bcb50ac9ca2553018989cb7800 
>   ql/src/test/results/clientpositive/pointlookup2.q.out 1cfa4b6345ab48f6cac437a2dbefc657016a4b6d 
>   ql/src/test/results/clientpositive/ppd_join2.q.out c5036525a685b5e76157dbf88a9e614727cb69ac 
>   ql/src/test/results/clientpositive/ppd_join3.q.out 0000db129c9428e34935397ab5c51f010987eca3 
>   ql/src/test/results/clientpositive/ppd_join5.q.out b68229eb08ca1fadd148387f2a361ca9c5237f12 
>   ql/src/test/results/clientpositive/ppd_outer_join4.q.out 289798c5bc0113ea4864e2c287001805a8fc1ea9 
>   ql/src/test/results/clientpositive/ppd_outer_join5.q.out 35fec7a46606b0489d9c4e9c472a26607b17a177 
>   ql/src/test/results/clientpositive/ppd_udf_case.q.out 2b407a63d8b51cfedc020459240150b97044ffc3 
>   ql/src/test/results/clientpositive/ppd_union_view.q.out d33cbd6b7b024fc789e3477e35afaeb7a58f052b 
>   ql/src/test/results/clientpositive/quotedid_basic.q.out 3c81e0bccce92d489d4f2eec874826a1d232c7be 
>   ql/src/test/results/clientpositive/quotedid_partition.q.out a83c62b1826786f5213c8556bd275e4bd545fb6a 
>   ql/src/test/results/clientpositive/regex_col.q.out 33e1a1273d49aba4c73540246288112781527496 
>   ql/src/test/results/clientpositive/router_join_ppr.q.out 7182f8deb6f74fc9250d6d55816c8a1debcb76ae 
>   ql/src/test/results/clientpositive/semijoin4.q.out 7489de2ebcc3d044b22cc2c64d4747b51285d111 
>   ql/src/test/results/clientpositive/skewjoin.q.out 4e98dfd9e7aedd8cffbe1aee64c03d62741763d7 
>   ql/src/test/results/clientpositive/skewjoin_mapjoin8.q.out ae0aafa49f5597c6fe3723a1c7c6de62dcc2012c 
>   ql/src/test/results/clientpositive/skewjoin_mapjoin9.q.out f9043d38d5d6fee8b9419abc21443538c690cddb 
>   ql/src/test/results/clientpositive/skewjoinopt12.q.out 5109173b4bcf3644bcf9c660b51a242d9483014c 
>   ql/src/test/results/clientpositive/skewjoinopt13.q.out 3f00c406460f7dfd43862a9e4ad07075ba0001b7 
>   ql/src/test/results/clientpositive/skewjoinopt14.q.out a8536def44f65d1bcaf3118c0143111e6bc893e2 
>   ql/src/test/results/clientpositive/skewjoinopt16.q.out de9869615e6bed1246288c5eb36e5b47f40559ef 
>   ql/src/test/results/clientpositive/skewjoinopt17.q.out ea2b670e1dde15dc8fd2e6728ae4e5fc5c7c90ce 
>   ql/src/test/results/clientpositive/skewjoinopt2.q.out c2ae731c38c766d1e3b43aa2d219927a8d3dfe95 
>   ql/src/test/results/clientpositive/spark/annotate_stats_join.q.out baa1dcb5c27dc709412466370acae31f75406562 
>   ql/src/test/results/clientpositive/spark/auto_join12.q.out 158e53511f43bd12fc006bd595c4dab48dc1cf94 
>   ql/src/test/results/clientpositive/spark/auto_join16.q.out ba6336aaa5213f0dcd292bd1fb07c9582fb1c6fd 
>   ql/src/test/results/clientpositive/spark/auto_join_reordering_values.q.out 8bf5977ceef03eb24fe3eed0b00f2f18580dbae2 
>   ql/src/test/results/clientpositive/spark/auto_join_without_localtask.q.out f055a59545c236b6cd4132700caf15fa4f72bfd2 
>   ql/src/test/results/clientpositive/spark/auto_sortmerge_join_6.q.out 41b2b0ae933946099505bee4c627d811ca21bed9 
>   ql/src/test/results/clientpositive/spark/bucket_map_join_spark4.q.out b00c223d2fc0d2d7a3daa4599e4069d07b80da79 
>   ql/src/test/results/clientpositive/spark/bucket_map_join_tez1.q.out 57a89d67b56cc36dda8b42f21481e9363cff297a 
>   ql/src/test/results/clientpositive/spark/bucket_map_join_tez2.q.out 31908d71d4ea174d8210822a70689084908e760b 
>   ql/src/test/results/clientpositive/spark/bucketizedhiveinputformat.q.out c8fc4d3ac6aacb8e7ce59792ab4f74cabde238e3 
>   ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_6.q.out e8e1e7e510c414255de72dfa86b8140f97ea5e87 
>   ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_7.q.out 0b64a8735a6e9a668650db8907abce38c31ab70e 
>   ql/src/test/results/clientpositive/spark/constprog_partitioner.q.out 8a6ab825c2be8e5a7d9715e93545421b7f16e1df 
>   ql/src/test/results/clientpositive/spark/cross_product_check_1.q.out 5e67607241b1c029e40ec82edb09ddad394af67c 
>   ql/src/test/results/clientpositive/spark/cross_product_check_2.q.out e8bcd7a6f346bfa02b4031abb6221bd65f7d15b4 
>   ql/src/test/results/clientpositive/spark/dynamic_rdd_cache.q.out 6e595ff4b19d188b041394aff5df6d93614fe813 
>   ql/src/test/results/clientpositive/spark/groupby_position.q.out 415703f638ede1e113fd3f7864f2f8688302c38d 
>   ql/src/test/results/clientpositive/spark/index_auto_self_join.q.out 40c09de04a4e8eb8b02a4b537ca58fbf57e831fa 
>   ql/src/test/results/clientpositive/spark/index_bitmap3.q.out b03ea990c06964b5d582967fd58d2cb40e955b59 
>   ql/src/test/results/clientpositive/spark/index_bitmap_auto.q.out c912379afcffd94d487999e4ed4ac7059860ebb9 
>   ql/src/test/results/clientpositive/spark/join12.q.out 2ad0a43853e832fe7d16678d38e6b5b1f43f467f 
>   ql/src/test/results/clientpositive/spark/join16.q.out 2496ec2904272923c346d746f6150a34ffee63be 
>   ql/src/test/results/clientpositive/spark/join19.q.out 5de045b133c1a40c1bee87e0ac8354d4806858d3 
>   ql/src/test/results/clientpositive/spark/join32.q.out 377121709ddaa0e8d13df067b11de491dc5c5cd5 
>   ql/src/test/results/clientpositive/spark/join32_lessSize.q.out c4ac2dd6dfadcaee944f0da7ae54f8e3eee49f23 
>   ql/src/test/results/clientpositive/spark/join33.q.out 377121709ddaa0e8d13df067b11de491dc5c5cd5 
>   ql/src/test/results/clientpositive/spark/join34.q.out a4cbc79b4755c0ab74177e7804bb4e16204345c2 
>   ql/src/test/results/clientpositive/spark/join35.q.out 598143f021681214e5da79f87c76dd676281f6a1 
>   ql/src/test/results/clientpositive/spark/join_alt_syntax.q.out fb50955e80839d39eef99db8f814f50d75f03412 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_2.q.out 1a1c15428614f83c92d9ac25e2126b37133e9e21 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_4.q.out 4fa5f5a9306ddbe6e5bc27634a34dd21739c2b6e 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual2.q.out 8b318d827dc5fa07b893313777dcc3f3ab5ae52d 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual4.q.out 15c45e67243687c32491a47b8ae1b94c8a55be02 
>   ql/src/test/results/clientpositive/spark/join_hive_626.q.out c07d12e7407f6a48fc0e20567f087c702510c5cc 
>   ql/src/test/results/clientpositive/spark/join_star.q.out dea7a81b8472c8af913f0578e0708934ae2c465a 
>   ql/src/test/results/clientpositive/spark/join_vc.q.out c1812a9ead215c1f872f177a13fc3a854ac38b9f 
>   ql/src/test/results/clientpositive/spark/louter_join_ppr.q.out 7f72b760929384c59d2e48827ff4ff652eb2b443 
>   ql/src/test/results/clientpositive/spark/mapjoin_mapjoin.q.out b7ac43de22bd600c7170fc7588a753b7c56edf5c 
>   ql/src/test/results/clientpositive/spark/mergejoins.q.out e6872400b45cadc969ef897cf42c38dd23b9581f 
>   ql/src/test/results/clientpositive/spark/mergejoins_mixed.q.out 42ffebfde50472f1aec060c33037fe851921e88c 
>   ql/src/test/results/clientpositive/spark/multi_join_union.q.out 5ddcb1bc1348b927ef1f521cf7691563cecb0a1d 
>   ql/src/test/results/clientpositive/spark/ppd_join2.q.out 5848609e67bedffbffe7cb8028588017eaf327a6 
>   ql/src/test/results/clientpositive/spark/ppd_join3.q.out c78d4cb4580d17946375f6ee5b6c447741d7c6f4 
>   ql/src/test/results/clientpositive/spark/ppd_join5.q.out 8b51969b4b5e8b2772c37dfb8ec8e17908fd58f2 
>   ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out 8d0830892ab997e489306ec2698e1c6fdf61996f 
>   ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out 8e398580ac526c0acbd642bc91579fcea0d9b428 
>   ql/src/test/results/clientpositive/spark/router_join_ppr.q.out 319dc0ad836129d2e551e3414ab52a74b9f49b8b 
>   ql/src/test/results/clientpositive/spark/skewjoin.q.out b2460460da36e856655ca12706678378b976f059 
>   ql/src/test/results/clientpositive/spark/skewjoinopt12.q.out 1e77aa746de5c950e1789b8d5b38e68650b53b3c 
>   ql/src/test/results/clientpositive/spark/skewjoinopt13.q.out f1a681df557d4ef22632096beb96fefc72baf3dc 
>   ql/src/test/results/clientpositive/spark/skewjoinopt14.q.out ef36afda6d70ea3c0d1bb2ebfdd90dcc82329ccd 
>   ql/src/test/results/clientpositive/spark/skewjoinopt16.q.out 3be7ce08d9a43ada35d5bbfebf4a567e8fcdde58 
>   ql/src/test/results/clientpositive/spark/skewjoinopt17.q.out ce8bbfa768ea8ad0ddc072bfb29cbacd82ef4a49 
>   ql/src/test/results/clientpositive/spark/skewjoinopt2.q.out b5fa077046bcf9ae14935b034f62d12786f38d1f 
>   ql/src/test/results/clientpositive/spark/subquery_exists.q.out 5f41ac7aeaa5425004a4cd56638f0961a5a78a7e 
>   ql/src/test/results/clientpositive/spark/subquery_in.q.out 1d813f8ae53e6cccde25e864d168380568e02e7a 
>   ql/src/test/results/clientpositive/spark/union_remove_25.q.out eb95cadde3f8f3006df4a1093bebf00dd55514f8 
>   ql/src/test/results/clientpositive/spark/union_view.q.out 492f71b10b9e98cd9235fad4b40850b2aa2d9730 
>   ql/src/test/results/clientpositive/spark/vector_mapjoin_reduce.q.out 296c256d09703a073a41a36dc96b526e78afb715 
>   ql/src/test/results/clientpositive/spark/vectorized_nested_mapjoin.q.out c4c86092eda1376da2669293bce7c05708aa7650 
>   ql/src/test/results/clientpositive/subquery_exists.q.out f3a270589b7b50dd7ef2ec53d1bac7ae88f7f245 
>   ql/src/test/results/clientpositive/subquery_in.q.out a374dc0f84aa78dcf099d8733b42f94e6cea7863 
>   ql/src/test/results/clientpositive/subquery_notin.q.out e157ff4d511cd7a4729f3c1d39800e80788ee48a 
>   ql/src/test/results/clientpositive/subquery_notin_having.q.java1.7.out 8f17b6c33b7842d805fa8fa412fed8149d3c219d 
>   ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out e34a401ca41faae0f25e7f398ac5c078f8f34df8 
>   ql/src/test/results/clientpositive/subquery_views.q.out 76e53d3be56f3f8c2422317585d441cd14665294 
>   ql/src/test/results/clientpositive/tez/auto_sortmerge_join_6.q.out 521485ae03a484704b84a3e8b9eb2eed992ffdc2 
>   ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out 4703cec3fdcbb79bbc4b0365b97600e760ac2748 
>   ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out c5cb360e0524e006a728105e2f0e17a1df8afa68 
>   ql/src/test/results/clientpositive/tez/correlationoptimizer1.q.out 20bec18f8e66d6fad385c3e28dfa940c5afd199c 
>   ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out d5530a579a011aefa2a7fea965d9617c45b86231 
>   ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out 45c4e3f153bd7d55e2f09c83fc989fd12fbf9b80 
>   ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out 58ab2c08554f4b2b4d06e79de22845445fc3c0e5 
>   ql/src/test/results/clientpositive/tez/explainuser_1.q.out 8c78fd9d7f23f5272d88e83378485c83605c5b5a 
>   ql/src/test/results/clientpositive/tez/explainuser_2.q.out eb7d564b774d5c486cd9e47086b2ef750ce17dd5 
>   ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out 3534a9cdcfe0ae1ee3404a9aa80131a0cedf265e 
>   ql/src/test/results/clientpositive/tez/mergejoin.q.out 4b2d9635fe602fa6aa03d20d32bb57770a92ac39 
>   ql/src/test/results/clientpositive/tez/skewjoin.q.out fc084cc5b8c798ceb6bfc84ad1b29ca5d3c91f48 
>   ql/src/test/results/clientpositive/tez/subquery_exists.q.out 5121a144c1d6c2c28890cd742e59d3c1bb868c9a 
>   ql/src/test/results/clientpositive/tez/subquery_in.q.out a4887e4e69fd8d2734583586a67daf1bfeacf8ac 
>   ql/src/test/results/clientpositive/tez/tez_dynpart_hashjoin_1.q.out e3131d5071c891b35340d040efb44ab3ea10a46c 
>   ql/src/test/results/clientpositive/tez/tez_join_hash.q.out 0202def4353e4bd492552a378ba0e83b360d6306 
>   ql/src/test/results/clientpositive/tez/tez_smb_empty.q.out 8c9ab2eda3b88362f38bf795e001dfc72ca52a73 
>   ql/src/test/results/clientpositive/tez/tez_smb_main.q.out b7110898237bb049f8fd78ce777c78315052c598 
>   ql/src/test/results/clientpositive/tez/tez_vector_dynpart_hashjoin_1.q.out 3711a10f425ba54153cf4fbca02ba86a09b401f6 
>   ql/src/test/results/clientpositive/tez/vector_decimal_round.q.out 5bc04d7e02fa7b70050116ba8f1d062877691ae0 
>   ql/src/test/results/clientpositive/tez/vector_groupby_mapjoin.q.out dedcec8aed37d2c03c4cd754d74112c474d5643a 
>   ql/src/test/results/clientpositive/tez/vector_interval_mapjoin.q.out 42ce4996b5836759dcc4fb47523809abb57c81ee 
>   ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out 7eb28f8e2a5af32075e2fa1a1ad89af092a36e90 
>   ql/src/test/results/clientpositive/tez/vector_mr_diff_schema_alias.q.out f60a5840d013154849f68769aa1050c98a893667 
>   ql/src/test/results/clientpositive/tez/vectorized_context.q.out 0eb48021eea290c7bb675d906722242645dc3517 
>   ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out cda76db1f9966a0b1969381faa3ad035568edb84 
>   ql/src/test/results/clientpositive/tez/vectorized_nested_mapjoin.q.out e1e95e7786cbbb7d2625ab52394d1b690d542112 
>   ql/src/test/results/clientpositive/udf1.q.out b3b694b8794ac6eb3fe6d0bbc29e51e7602f16e8 
>   ql/src/test/results/clientpositive/udf_10_trims.q.out 3a5303adfe8450adff1eeb7f32f83b1150979c09 
>   ql/src/test/results/clientpositive/udf_folder_constants.q.out ef07420325dd2d99322f4fc150951798dcdeafaa 
>   ql/src/test/results/clientpositive/union_remove_25.q.out 3869735f9f83a1c5538403f5563369eee7d77be9 
>   ql/src/test/results/clientpositive/union_view.q.out 1d93159e2b2c1ede1c090fb82db1928872fd2c61 
>   ql/src/test/results/clientpositive/vector_decimal_round.q.out ec6226ea74ece7b4129428dcf98d6f7af8f55e6e 
>   ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out 367eb5983b2a57322d22a84c4afd39e4e2080345 
>   ql/src/test/results/clientpositive/vector_interval_mapjoin.q.out 7cd7eb0c709831b1b4b264203301d2593a5d79a6 
>   ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out dd40f282c7392f4eb8ef674cb5f6629d41eacf01 
>   ql/src/test/results/clientpositive/vector_mr_diff_schema_alias.q.out 81724dcdc99f4ae4344a3f67e14cd49e2039b7ef 
>   ql/src/test/results/clientpositive/vectorized_context.q.out 2a37bc2c221e312abdea01242d7b4c013df7660d 
>   ql/src/test/results/clientpositive/vectorized_nested_mapjoin.q.out b18cf9d918f5746da04f6315828675fe6d829c7f 
> 
> Diff: https://reviews.apache.org/r/42190/diff/
> 
> 
> Testing
> -------
> 
> 
> Thanks,
> 
> Jesús Camacho Rodríguez
> 
>

Re: Review Request 42190: HIVE-12478

Posted by John Pullokkaran <jp...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/42190/#review116291
-----------------------------------------------------------


Ship it!




Ship It!

- John Pullokkaran


On Jan. 25, 2016, 7:20 p.m., Jesús Camacho Rodríguez wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/42190/
> -----------------------------------------------------------
> 
> (Updated Jan. 25, 2016, 7:20 p.m.)
> 
> 
> Review request for hive and John Pullokkaran.
> 
> 
> Bugs: HIVE-12478
>     https://issues.apache.org/jira/browse/HIVE-12478
> 
> 
> Repository: hive-git
> 
> 
> Description
> -------
> 
> Improve Hive/Calcite Trasitive Predicate inference
> 
> 
> Diffs
> -----
> 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveCalciteUtil.java 4825a617876374085b6fac1192ba1531ec916bce 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveHepPlannerContext.java ad79aeec2fbc0454ab1ccc608944752d01324dca 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveVolcanoPlannerContext.java 8859fc268666cef1be283a9179aa0beb7ef1bdeb 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/cost/HiveCostModel.java d15d885d2348d666df069228a93d6c5f914c79df 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/cost/HiveVolcanoPlanner.java 8610edc5ddc00d523610fb29f5e504c3e876a542 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveJoin.java 27b1e76a104dc961cb4bce554602d90b3aa867e0 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveSemiJoin.java 35586768c2c2b81e4213495632e4457dd3d70443 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveUnion.java 8b57b3504c407b8a1e73d48ea240c4ec7558b327 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinAddNotNullRule.java de880ce26f1e172288f700c8566fbe71f42af115 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinPushTransitivePredicatesRule.java 703c8c6dbdfa281443cbcf7b08de2266697da8a9 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HivePreFilteringRule.java d37fc0e08d5e41b29539a990e6638385c1135eec 
>   ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveRulesRegistry.java 18a065e87e1ec266bf28b4ccfe10a1f863f847c2 
>   ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java 3fefbd710c4bb81d5f746cd91889b532b0a6029f 
>   ql/src/test/org/apache/hadoop/hive/ql/optimizer/calcite/TestCBORuleFiredOnlyOnce.java f1d8d1de00e9de7fa9ffea7d3aa2400e5073ac9c 
>   ql/src/test/results/clientpositive/annotate_stats_join.q.out 7fc754d5712d5f05efc943b66d3c829d47312d19 
>   ql/src/test/results/clientpositive/annotate_stats_join_pkfk.q.out f13643e8db57cc0a85b2626c37437fd030f72029 
>   ql/src/test/results/clientpositive/auto_join12.q.out 8ef3664764d04f53f3685d8f66dc4a353776a488 
>   ql/src/test/results/clientpositive/auto_join16.q.out c1da6d2968697d304311044d358f1af267dc6e60 
>   ql/src/test/results/clientpositive/auto_join_without_localtask.q.out d40b1655e27fa70efc8dbf0475c688f6e2b3608f 
>   ql/src/test/results/clientpositive/bucketizedhiveinputformat.q.out cfb95be72b32a354faeddc79dc52bc29c7593a2b 
>   ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out a7ad04c7208f8e8486e79c1e749184e5b532a1fc 
>   ql/src/test/results/clientpositive/cbo_const.q.out adc5232a67b2243dd5f09acaf1f7c49baea5daad 
>   ql/src/test/results/clientpositive/cbo_rp_lineage2.q.out 1b2a2ab1af5992753c37d053942ecb2ebf775921 
>   ql/src/test/results/clientpositive/constprog_partitioner.q.out 08c0aebafe1644a5adbec6a56879b39617bfbf69 
>   ql/src/test/results/clientpositive/correlationoptimizer1.q.out 38764d6b127bd1aba1efa5800b16c0c1e387a310 
>   ql/src/test/results/clientpositive/correlationoptimizer10.q.out 6bac698155221be4b0cb5b0bb3b2cdbfec5236ea 
>   ql/src/test/results/clientpositive/correlationoptimizer13.q.out 61b7bcb675a80dc3267365c65545e107ecbe12d2 
>   ql/src/test/results/clientpositive/correlationoptimizer8.q.out 368a1147d404ae9aab18a64618abf8ed7b3f7189 
>   ql/src/test/results/clientpositive/correlationoptimizer9.q.out 104a97afbb6657255a027ff6d51101f6963c2358 
>   ql/src/test/results/clientpositive/dynamic_rdd_cache.q.out 743865e073e1768f7f6234fde35ad2e56d8babe9 
>   ql/src/test/results/clientpositive/filter_cond_pushdown.q.out 5e0edbc9efb442467c4998021ac1ecfb9d07579d 
>   ql/src/test/results/clientpositive/groupby_position.q.out c2566f2ad5d426db8814b7ca85207807f4a5afc7 
>   ql/src/test/results/clientpositive/groupby_ppd.q.out d17c4b6d9e88d49d64b9725be1e51ca258ad1167 
>   ql/src/test/results/clientpositive/index_auto_mult_tables.q.out 8c71925fbc5352f42abb280fc45a1d5a5713ebad 
>   ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out b3e698927689dad5229165189779300cb8beca9b 
>   ql/src/test/results/clientpositive/index_auto_self_join.q.out 3cc1d7e8c7be8bd60e67f1a88a72ce9a89c5fe2c 
>   ql/src/test/results/clientpositive/index_bitmap3.q.out a8eecb5bd48bf07c648bf4425d66f566c7216d41 
>   ql/src/test/results/clientpositive/index_bitmap_auto.q.out d1fd59c8981e33e0e9da36c9811de45f9e625cd9 
>   ql/src/test/results/clientpositive/join12.q.out 8217c86d0e41c78b8bf4ed120b30a85204fa9915 
>   ql/src/test/results/clientpositive/join16.q.out 244eb46dc0ae3b61ed932f043a98bb64295776a1 
>   ql/src/test/results/clientpositive/join34.q.out e2c2b1a5ab742e26d953f11919e150f847a05157 
>   ql/src/test/results/clientpositive/join35.q.out 663642c7d1c00a47993c497ac76d6f036221f06b 
>   ql/src/test/results/clientpositive/join42.q.out 6e09e38102129edb7246b0a027c86ba1deed066c 
>   ql/src/test/results/clientpositive/join43.q.out b5006fa6fe86b377f2b5ec6498e5b731ef239296 
>   ql/src/test/results/clientpositive/join_alt_syntax.q.out 1c7f159aaed439c94607b815c30ec6c005d7dfb8 
>   ql/src/test/results/clientpositive/join_cond_pushdown_2.q.out 3a50651c955e7ecd24b0a9fe685bc5a7370a0b54 
>   ql/src/test/results/clientpositive/join_cond_pushdown_4.q.out af51f39f18f8dc499bcf0ad8c497b34ddb11b29d 
>   ql/src/test/results/clientpositive/join_cond_pushdown_unqual2.q.out 6a5608bdf1446fa3f6d45206021ce1fc9ed95301 
>   ql/src/test/results/clientpositive/join_cond_pushdown_unqual4.q.out d4a3549e3be54b1c8fd00309213666fef1ef6c58 
>   ql/src/test/results/clientpositive/join_grp_diff_keys.q.out da029c97a3438493163f08d0f8ef4c3c14043a22 
>   ql/src/test/results/clientpositive/lineage2.q.out a189f82a3d29cd3b1e21a43afc85ef14fd74c79e 
>   ql/src/test/results/clientpositive/lineage3.q.out f1162a213eea285a5d166731e0ce7e407f4106a7 
>   ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out d2c11d7644570217532f9b366926d8cc94a03e6a 
>   ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_1.q.out b459692b443a1686def6615e9e9bcce5922335c3 
>   ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out 6a57f1fd82ef3e3cf681138383534e7fea1c07df 
>   ql/src/test/results/clientpositive/llap/vectorized_dynamic_partition_pruning.q.out 63121a9e5b043e2c27fe08ee54e6fe01e2dd6cae 
>   ql/src/test/results/clientpositive/louter_join_ppr.q.out 553def9bb50e7e9c7e80bc422dc7bad56c5b5998 
>   ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out 41d824c9f3bcdbc30812e2cbb55539ed31421fe5 
>   ql/src/test/results/clientpositive/mergejoin.q.out acf816ebc2db9df7f2878375dea3c403fb513c08 
>   ql/src/test/results/clientpositive/mergejoins.q.out 901041083f3182497361b8f27ed77c093e7ce237 
>   ql/src/test/results/clientpositive/mergejoins_mixed.q.out 10f37f9fe34d79987333e3f8bb01166304fe5894 
>   ql/src/test/results/clientpositive/perf/query13.q.out 6113d18af3c9922b288d64c61ee0590d124b809b 
>   ql/src/test/results/clientpositive/perf/query17.q.out 0e42d053e37904af58735ff7d5021ab9ffe9e668 
>   ql/src/test/results/clientpositive/perf/query18.q.out 83f21dc7ebc2e8aaf2a0b081584e0fc98fdaf7a4 
>   ql/src/test/results/clientpositive/perf/query19.q.out d5658394163e7cdfd1876a3fb7449d7fd46f96df 
>   ql/src/test/results/clientpositive/perf/query25.q.out dabc1c528e7cca0d8f83b4f1dd0938e56ff49f61 
>   ql/src/test/results/clientpositive/perf/query29.q.out 8991f3562d5140611ce35513f1685e36bc070d9a 
>   ql/src/test/results/clientpositive/perf/query31.q.out 909d64cef12a9492c5d24ef5876609a77423d2d5 
>   ql/src/test/results/clientpositive/perf/query32.q.out da2ac8fe18fc2d71f7b14c28396b741a31082fd2 
>   ql/src/test/results/clientpositive/perf/query34.q.out 1cb7c285f418476612fbc897f02e701e96995224 
>   ql/src/test/results/clientpositive/perf/query39.q.out 9f3e650943c1d7ab04fc521509ca9372e4105a25 
>   ql/src/test/results/clientpositive/perf/query40.q.out b2d6262d96b7dc1c25748a758af61988b39d7c45 
>   ql/src/test/results/clientpositive/perf/query42.q.out 9ede45d24587228328671a40e9b3f9ca43e2a550 
>   ql/src/test/results/clientpositive/perf/query45.q.out f55f20cb0f13c661c5f50bf412042458de62c726 
>   ql/src/test/results/clientpositive/perf/query46.q.out 0ded91216db1e04548728a0025538929280b9dec 
>   ql/src/test/results/clientpositive/perf/query48.q.out 40b76f00d0bbbaffb5819a38eaaa7ca3914ad37c 
>   ql/src/test/results/clientpositive/perf/query50.q.out 8b41d05d312a0066644ff167c588d0d55e5770b3 
>   ql/src/test/results/clientpositive/perf/query52.q.out 7e7224ba54b49a68040a536adca665a8f510bdd7 
>   ql/src/test/results/clientpositive/perf/query54.q.out 56c70b7c6ab40cab7cf862023be36b3d88f3b288 
>   ql/src/test/results/clientpositive/perf/query55.q.out d36f3787f1d8b1d24306b38e6c65f6cbd583af80 
>   ql/src/test/results/clientpositive/perf/query58.q.out c2f71892ee7ceb68449c6c4f13754052041de106 
>   ql/src/test/results/clientpositive/perf/query64.q.out 9331673a663e9b31bfb00b443c4ae282ffe67e56 
>   ql/src/test/results/clientpositive/perf/query65.q.out 12bdd33c3aadc161faac927734de28d2da840650 
>   ql/src/test/results/clientpositive/perf/query66.q.out a25664e73afb1088e05ec3912dab253720bc4af4 
>   ql/src/test/results/clientpositive/perf/query68.q.out 8ecde892fa2f0011e16ec2e9c93e34dab7037e21 
>   ql/src/test/results/clientpositive/perf/query70.q.out d13165d844fc0cfb4d605ae428b5e29a9a3752d4 
>   ql/src/test/results/clientpositive/perf/query71.q.out fa50e5605878f1b090687160863156bc5f895055 
>   ql/src/test/results/clientpositive/perf/query72.q.out bb56f0d695ede28d37b210fc1c6293444038154e 
>   ql/src/test/results/clientpositive/perf/query73.q.out 9c888543d9115d2eb751fdf750fc95d964c9b093 
>   ql/src/test/results/clientpositive/perf/query75.q.out f3f9827a532b445e59642cbf9d169dc4147e03d2 
>   ql/src/test/results/clientpositive/perf/query76.q.out e540ee746f74df14c436290f55e4a2c4271d5bfc 
>   ql/src/test/results/clientpositive/perf/query80.q.out 37cb542f008b21b26e2bdd03aac7144b7352893b 
>   ql/src/test/results/clientpositive/perf/query82.q.out 654a772070ffcd60b5201d5d8d7d1d635c4738d2 
>   ql/src/test/results/clientpositive/perf/query84.q.out e522f23800eb18b0abff741c3254b72eced931e8 
>   ql/src/test/results/clientpositive/perf/query85.q.out 54061ced073090cec35111081f21ac510d0bde92 
>   ql/src/test/results/clientpositive/perf/query87.q.out a3361898811f37271930a671381f6522724bf05d 
>   ql/src/test/results/clientpositive/perf/query88.q.out f139dd11c3cc65d78538426d68b452816117e3e3 
>   ql/src/test/results/clientpositive/perf/query89.q.out ee9eabc4330fcebd971a5c913888adcf67398ea5 
>   ql/src/test/results/clientpositive/perf/query90.q.out d34aaf4d65f7f614533390f4415666bc9879c88f 
>   ql/src/test/results/clientpositive/perf/query91.q.out 54f58e439bed7e44287ecc671c1db3e497ce4eae 
>   ql/src/test/results/clientpositive/perf/query92.q.out 6fb2133f2b8beaaaf32359d3d10770693125b505 
>   ql/src/test/results/clientpositive/perf/query93.q.out 52551459456d952ef1959515ec877b2fc992c6be 
>   ql/src/test/results/clientpositive/perf/query94.q.out 0357835f7f5e565f560e73506b10345c0fe089ff 
>   ql/src/test/results/clientpositive/perf/query95.q.out a7c6a981bfc07a9d08fefea511b57775aa9c4de7 
>   ql/src/test/results/clientpositive/perf/query96.q.out bba8965df34d208ab2fc825cdb2882e5a671f351 
>   ql/src/test/results/clientpositive/ppd_join2.q.out c5036525a685b5e76157dbf88a9e614727cb69ac 
>   ql/src/test/results/clientpositive/ppd_join3.q.out 0000db129c9428e34935397ab5c51f010987eca3 
>   ql/src/test/results/clientpositive/ppd_join5.q.out b68229eb08ca1fadd148387f2a361ca9c5237f12 
>   ql/src/test/results/clientpositive/ppd_outer_join4.q.out 289798c5bc0113ea4864e2c287001805a8fc1ea9 
>   ql/src/test/results/clientpositive/ppd_outer_join5.q.out 35fec7a46606b0489d9c4e9c472a26607b17a177 
>   ql/src/test/results/clientpositive/ppd_udf_case.q.out 2b407a63d8b51cfedc020459240150b97044ffc3 
>   ql/src/test/results/clientpositive/ppd_union_view.q.out d33cbd6b7b024fc789e3477e35afaeb7a58f052b 
>   ql/src/test/results/clientpositive/quotedid_basic.q.out 3c81e0bccce92d489d4f2eec874826a1d232c7be 
>   ql/src/test/results/clientpositive/regex_col.q.out 33e1a1273d49aba4c73540246288112781527496 
>   ql/src/test/results/clientpositive/router_join_ppr.q.out 7182f8deb6f74fc9250d6d55816c8a1debcb76ae 
>   ql/src/test/results/clientpositive/semijoin4.q.out 7489de2ebcc3d044b22cc2c64d4747b51285d111 
>   ql/src/test/results/clientpositive/skewjoin.q.out 4e98dfd9e7aedd8cffbe1aee64c03d62741763d7 
>   ql/src/test/results/clientpositive/skewjoinopt12.q.out 5109173b4bcf3644bcf9c660b51a242d9483014c 
>   ql/src/test/results/clientpositive/skewjoinopt16.q.out de9869615e6bed1246288c5eb36e5b47f40559ef 
>   ql/src/test/results/clientpositive/skewjoinopt17.q.out ea2b670e1dde15dc8fd2e6728ae4e5fc5c7c90ce 
>   ql/src/test/results/clientpositive/skewjoinopt2.q.out c2ae731c38c766d1e3b43aa2d219927a8d3dfe95 
>   ql/src/test/results/clientpositive/spark/annotate_stats_join.q.out baa1dcb5c27dc709412466370acae31f75406562 
>   ql/src/test/results/clientpositive/spark/auto_join12.q.out 158e53511f43bd12fc006bd595c4dab48dc1cf94 
>   ql/src/test/results/clientpositive/spark/auto_join16.q.out ba6336aaa5213f0dcd292bd1fb07c9582fb1c6fd 
>   ql/src/test/results/clientpositive/spark/auto_join_without_localtask.q.out f055a59545c236b6cd4132700caf15fa4f72bfd2 
>   ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_6.q.out e8e1e7e510c414255de72dfa86b8140f97ea5e87 
>   ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_7.q.out 0b64a8735a6e9a668650db8907abce38c31ab70e 
>   ql/src/test/results/clientpositive/spark/constprog_partitioner.q.out 8a6ab825c2be8e5a7d9715e93545421b7f16e1df 
>   ql/src/test/results/clientpositive/spark/dynamic_rdd_cache.q.out 6e595ff4b19d188b041394aff5df6d93614fe813 
>   ql/src/test/results/clientpositive/spark/groupby_position.q.out 415703f638ede1e113fd3f7864f2f8688302c38d 
>   ql/src/test/results/clientpositive/spark/index_auto_self_join.q.out 40c09de04a4e8eb8b02a4b537ca58fbf57e831fa 
>   ql/src/test/results/clientpositive/spark/index_bitmap3.q.out b03ea990c06964b5d582967fd58d2cb40e955b59 
>   ql/src/test/results/clientpositive/spark/index_bitmap_auto.q.out c912379afcffd94d487999e4ed4ac7059860ebb9 
>   ql/src/test/results/clientpositive/spark/join12.q.out 2ad0a43853e832fe7d16678d38e6b5b1f43f467f 
>   ql/src/test/results/clientpositive/spark/join16.q.out 2496ec2904272923c346d746f6150a34ffee63be 
>   ql/src/test/results/clientpositive/spark/join34.q.out a4cbc79b4755c0ab74177e7804bb4e16204345c2 
>   ql/src/test/results/clientpositive/spark/join35.q.out 598143f021681214e5da79f87c76dd676281f6a1 
>   ql/src/test/results/clientpositive/spark/join_alt_syntax.q.out fb50955e80839d39eef99db8f814f50d75f03412 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_2.q.out 1a1c15428614f83c92d9ac25e2126b37133e9e21 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_4.q.out 4fa5f5a9306ddbe6e5bc27634a34dd21739c2b6e 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual2.q.out 8b318d827dc5fa07b893313777dcc3f3ab5ae52d 
>   ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual4.q.out 15c45e67243687c32491a47b8ae1b94c8a55be02 
>   ql/src/test/results/clientpositive/spark/louter_join_ppr.q.out 7f72b760929384c59d2e48827ff4ff652eb2b443 
>   ql/src/test/results/clientpositive/spark/mapjoin_mapjoin.q.out b7ac43de22bd600c7170fc7588a753b7c56edf5c 
>   ql/src/test/results/clientpositive/spark/mergejoins.q.out e6872400b45cadc969ef897cf42c38dd23b9581f 
>   ql/src/test/results/clientpositive/spark/mergejoins_mixed.q.out 42ffebfde50472f1aec060c33037fe851921e88c 
>   ql/src/test/results/clientpositive/spark/ppd_join2.q.out 5848609e67bedffbffe7cb8028588017eaf327a6 
>   ql/src/test/results/clientpositive/spark/ppd_join3.q.out c78d4cb4580d17946375f6ee5b6c447741d7c6f4 
>   ql/src/test/results/clientpositive/spark/ppd_join5.q.out 8b51969b4b5e8b2772c37dfb8ec8e17908fd58f2 
>   ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out 8d0830892ab997e489306ec2698e1c6fdf61996f 
>   ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out 8e398580ac526c0acbd642bc91579fcea0d9b428 
>   ql/src/test/results/clientpositive/spark/router_join_ppr.q.out 319dc0ad836129d2e551e3414ab52a74b9f49b8b 
>   ql/src/test/results/clientpositive/spark/skewjoin.q.out b2460460da36e856655ca12706678378b976f059 
>   ql/src/test/results/clientpositive/spark/skewjoinopt12.q.out 1e77aa746de5c950e1789b8d5b38e68650b53b3c 
>   ql/src/test/results/clientpositive/spark/skewjoinopt16.q.out 3be7ce08d9a43ada35d5bbfebf4a567e8fcdde58 
>   ql/src/test/results/clientpositive/spark/skewjoinopt17.q.out ce8bbfa768ea8ad0ddc072bfb29cbacd82ef4a49 
>   ql/src/test/results/clientpositive/spark/skewjoinopt2.q.out b5fa077046bcf9ae14935b034f62d12786f38d1f 
>   ql/src/test/results/clientpositive/spark/subquery_exists.q.out 5f41ac7aeaa5425004a4cd56638f0961a5a78a7e 
>   ql/src/test/results/clientpositive/spark/subquery_in.q.out 1d813f8ae53e6cccde25e864d168380568e02e7a 
>   ql/src/test/results/clientpositive/spark/union_remove_25.q.out eb95cadde3f8f3006df4a1093bebf00dd55514f8 
>   ql/src/test/results/clientpositive/spark/union_view.q.out 492f71b10b9e98cd9235fad4b40850b2aa2d9730 
>   ql/src/test/results/clientpositive/spark/vector_mapjoin_reduce.q.out 296c256d09703a073a41a36dc96b526e78afb715 
>   ql/src/test/results/clientpositive/subquery_exists.q.out f3a270589b7b50dd7ef2ec53d1bac7ae88f7f245 
>   ql/src/test/results/clientpositive/subquery_in.q.out a374dc0f84aa78dcf099d8733b42f94e6cea7863 
>   ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out e34a401ca41faae0f25e7f398ac5c078f8f34df8 
>   ql/src/test/results/clientpositive/subquery_views.q.out 76e53d3be56f3f8c2422317585d441cd14665294 
>   ql/src/test/results/clientpositive/tez/correlationoptimizer1.q.out 20bec18f8e66d6fad385c3e28dfa940c5afd199c 
>   ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out 58ab2c08554f4b2b4d06e79de22845445fc3c0e5 
>   ql/src/test/results/clientpositive/tez/explainuser_1.q.out 8c78fd9d7f23f5272d88e83378485c83605c5b5a 
>   ql/src/test/results/clientpositive/tez/explainuser_2.q.out eb7d564b774d5c486cd9e47086b2ef750ce17dd5 
>   ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out 3534a9cdcfe0ae1ee3404a9aa80131a0cedf265e 
>   ql/src/test/results/clientpositive/tez/mergejoin.q.out 4b2d9635fe602fa6aa03d20d32bb57770a92ac39 
>   ql/src/test/results/clientpositive/tez/skewjoin.q.out fc084cc5b8c798ceb6bfc84ad1b29ca5d3c91f48 
>   ql/src/test/results/clientpositive/tez/subquery_exists.q.out 5121a144c1d6c2c28890cd742e59d3c1bb868c9a 
>   ql/src/test/results/clientpositive/tez/subquery_in.q.out a4887e4e69fd8d2734583586a67daf1bfeacf8ac 
>   ql/src/test/results/clientpositive/tez/tez_dynpart_hashjoin_1.q.out e3131d5071c891b35340d040efb44ab3ea10a46c 
>   ql/src/test/results/clientpositive/tez/tez_self_join.q.out 26545763f313ef4a09f265faf29f7cab97b9f6bf 
>   ql/src/test/results/clientpositive/tez/tez_smb_empty.q.out 8c9ab2eda3b88362f38bf795e001dfc72ca52a73 
>   ql/src/test/results/clientpositive/tez/tez_vector_dynpart_hashjoin_1.q.out 3711a10f425ba54153cf4fbca02ba86a09b401f6 
>   ql/src/test/results/clientpositive/tez/vector_interval_mapjoin.q.out 42ce4996b5836759dcc4fb47523809abb57c81ee 
>   ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out 7eb28f8e2a5af32075e2fa1a1ad89af092a36e90 
>   ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out cda76db1f9966a0b1969381faa3ad035568edb84 
>   ql/src/test/results/clientpositive/udf_folder_constants.q.out ef07420325dd2d99322f4fc150951798dcdeafaa 
>   ql/src/test/results/clientpositive/union_remove_25.q.out 3869735f9f83a1c5538403f5563369eee7d77be9 
>   ql/src/test/results/clientpositive/union_view.q.out 1d93159e2b2c1ede1c090fb82db1928872fd2c61 
>   ql/src/test/results/clientpositive/vector_interval_mapjoin.q.out 7cd7eb0c709831b1b4b264203301d2593a5d79a6 
>   ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out dd40f282c7392f4eb8ef674cb5f6629d41eacf01 
> 
> Diff: https://reviews.apache.org/r/42190/diff/
> 
> 
> Testing
> -------
> 
> 
> Thanks,
> 
> Jesús Camacho Rodríguez
> 
>

Re: Review Request 42190: HIVE-12478

Posted by Jesús Camacho Rodríguez <jc...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/42190/
-----------------------------------------------------------

(Updated Jan. 25, 2016, 7:20 p.m.)


Review request for hive and John Pullokkaran.


Bugs: HIVE-12478
    https://issues.apache.org/jira/browse/HIVE-12478


Repository: hive-git


Description
-------

Improve Hive/Calcite Trasitive Predicate inference


Diffs (updated)
-----

  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveCalciteUtil.java 4825a617876374085b6fac1192ba1531ec916bce 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveHepPlannerContext.java ad79aeec2fbc0454ab1ccc608944752d01324dca 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveVolcanoPlannerContext.java 8859fc268666cef1be283a9179aa0beb7ef1bdeb 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/cost/HiveCostModel.java d15d885d2348d666df069228a93d6c5f914c79df 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/cost/HiveVolcanoPlanner.java 8610edc5ddc00d523610fb29f5e504c3e876a542 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveJoin.java 27b1e76a104dc961cb4bce554602d90b3aa867e0 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveSemiJoin.java 35586768c2c2b81e4213495632e4457dd3d70443 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveUnion.java 8b57b3504c407b8a1e73d48ea240c4ec7558b327 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinAddNotNullRule.java de880ce26f1e172288f700c8566fbe71f42af115 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinPushTransitivePredicatesRule.java 703c8c6dbdfa281443cbcf7b08de2266697da8a9 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HivePreFilteringRule.java d37fc0e08d5e41b29539a990e6638385c1135eec 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveRulesRegistry.java 18a065e87e1ec266bf28b4ccfe10a1f863f847c2 
  ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java 3fefbd710c4bb81d5f746cd91889b532b0a6029f 
  ql/src/test/org/apache/hadoop/hive/ql/optimizer/calcite/TestCBORuleFiredOnlyOnce.java f1d8d1de00e9de7fa9ffea7d3aa2400e5073ac9c 
  ql/src/test/results/clientpositive/annotate_stats_join.q.out 7fc754d5712d5f05efc943b66d3c829d47312d19 
  ql/src/test/results/clientpositive/annotate_stats_join_pkfk.q.out f13643e8db57cc0a85b2626c37437fd030f72029 
  ql/src/test/results/clientpositive/auto_join12.q.out 8ef3664764d04f53f3685d8f66dc4a353776a488 
  ql/src/test/results/clientpositive/auto_join16.q.out c1da6d2968697d304311044d358f1af267dc6e60 
  ql/src/test/results/clientpositive/auto_join_without_localtask.q.out d40b1655e27fa70efc8dbf0475c688f6e2b3608f 
  ql/src/test/results/clientpositive/bucketizedhiveinputformat.q.out cfb95be72b32a354faeddc79dc52bc29c7593a2b 
  ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out a7ad04c7208f8e8486e79c1e749184e5b532a1fc 
  ql/src/test/results/clientpositive/cbo_const.q.out adc5232a67b2243dd5f09acaf1f7c49baea5daad 
  ql/src/test/results/clientpositive/cbo_rp_lineage2.q.out 1b2a2ab1af5992753c37d053942ecb2ebf775921 
  ql/src/test/results/clientpositive/constprog_partitioner.q.out 08c0aebafe1644a5adbec6a56879b39617bfbf69 
  ql/src/test/results/clientpositive/correlationoptimizer1.q.out 38764d6b127bd1aba1efa5800b16c0c1e387a310 
  ql/src/test/results/clientpositive/correlationoptimizer10.q.out 6bac698155221be4b0cb5b0bb3b2cdbfec5236ea 
  ql/src/test/results/clientpositive/correlationoptimizer13.q.out 61b7bcb675a80dc3267365c65545e107ecbe12d2 
  ql/src/test/results/clientpositive/correlationoptimizer8.q.out 368a1147d404ae9aab18a64618abf8ed7b3f7189 
  ql/src/test/results/clientpositive/correlationoptimizer9.q.out 104a97afbb6657255a027ff6d51101f6963c2358 
  ql/src/test/results/clientpositive/dynamic_rdd_cache.q.out 743865e073e1768f7f6234fde35ad2e56d8babe9 
  ql/src/test/results/clientpositive/filter_cond_pushdown.q.out 5e0edbc9efb442467c4998021ac1ecfb9d07579d 
  ql/src/test/results/clientpositive/groupby_position.q.out c2566f2ad5d426db8814b7ca85207807f4a5afc7 
  ql/src/test/results/clientpositive/groupby_ppd.q.out d17c4b6d9e88d49d64b9725be1e51ca258ad1167 
  ql/src/test/results/clientpositive/index_auto_mult_tables.q.out 8c71925fbc5352f42abb280fc45a1d5a5713ebad 
  ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out b3e698927689dad5229165189779300cb8beca9b 
  ql/src/test/results/clientpositive/index_auto_self_join.q.out 3cc1d7e8c7be8bd60e67f1a88a72ce9a89c5fe2c 
  ql/src/test/results/clientpositive/index_bitmap3.q.out a8eecb5bd48bf07c648bf4425d66f566c7216d41 
  ql/src/test/results/clientpositive/index_bitmap_auto.q.out d1fd59c8981e33e0e9da36c9811de45f9e625cd9 
  ql/src/test/results/clientpositive/join12.q.out 8217c86d0e41c78b8bf4ed120b30a85204fa9915 
  ql/src/test/results/clientpositive/join16.q.out 244eb46dc0ae3b61ed932f043a98bb64295776a1 
  ql/src/test/results/clientpositive/join34.q.out e2c2b1a5ab742e26d953f11919e150f847a05157 
  ql/src/test/results/clientpositive/join35.q.out 663642c7d1c00a47993c497ac76d6f036221f06b 
  ql/src/test/results/clientpositive/join42.q.out 6e09e38102129edb7246b0a027c86ba1deed066c 
  ql/src/test/results/clientpositive/join43.q.out b5006fa6fe86b377f2b5ec6498e5b731ef239296 
  ql/src/test/results/clientpositive/join_alt_syntax.q.out 1c7f159aaed439c94607b815c30ec6c005d7dfb8 
  ql/src/test/results/clientpositive/join_cond_pushdown_2.q.out 3a50651c955e7ecd24b0a9fe685bc5a7370a0b54 
  ql/src/test/results/clientpositive/join_cond_pushdown_4.q.out af51f39f18f8dc499bcf0ad8c497b34ddb11b29d 
  ql/src/test/results/clientpositive/join_cond_pushdown_unqual2.q.out 6a5608bdf1446fa3f6d45206021ce1fc9ed95301 
  ql/src/test/results/clientpositive/join_cond_pushdown_unqual4.q.out d4a3549e3be54b1c8fd00309213666fef1ef6c58 
  ql/src/test/results/clientpositive/join_grp_diff_keys.q.out da029c97a3438493163f08d0f8ef4c3c14043a22 
  ql/src/test/results/clientpositive/lineage2.q.out a189f82a3d29cd3b1e21a43afc85ef14fd74c79e 
  ql/src/test/results/clientpositive/lineage3.q.out f1162a213eea285a5d166731e0ce7e407f4106a7 
  ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out d2c11d7644570217532f9b366926d8cc94a03e6a 
  ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_1.q.out b459692b443a1686def6615e9e9bcce5922335c3 
  ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out 6a57f1fd82ef3e3cf681138383534e7fea1c07df 
  ql/src/test/results/clientpositive/llap/vectorized_dynamic_partition_pruning.q.out 63121a9e5b043e2c27fe08ee54e6fe01e2dd6cae 
  ql/src/test/results/clientpositive/louter_join_ppr.q.out 553def9bb50e7e9c7e80bc422dc7bad56c5b5998 
  ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out 41d824c9f3bcdbc30812e2cbb55539ed31421fe5 
  ql/src/test/results/clientpositive/mergejoin.q.out acf816ebc2db9df7f2878375dea3c403fb513c08 
  ql/src/test/results/clientpositive/mergejoins.q.out 901041083f3182497361b8f27ed77c093e7ce237 
  ql/src/test/results/clientpositive/mergejoins_mixed.q.out 10f37f9fe34d79987333e3f8bb01166304fe5894 
  ql/src/test/results/clientpositive/perf/query13.q.out 6113d18af3c9922b288d64c61ee0590d124b809b 
  ql/src/test/results/clientpositive/perf/query17.q.out 0e42d053e37904af58735ff7d5021ab9ffe9e668 
  ql/src/test/results/clientpositive/perf/query18.q.out 83f21dc7ebc2e8aaf2a0b081584e0fc98fdaf7a4 
  ql/src/test/results/clientpositive/perf/query19.q.out d5658394163e7cdfd1876a3fb7449d7fd46f96df 
  ql/src/test/results/clientpositive/perf/query25.q.out dabc1c528e7cca0d8f83b4f1dd0938e56ff49f61 
  ql/src/test/results/clientpositive/perf/query29.q.out 8991f3562d5140611ce35513f1685e36bc070d9a 
  ql/src/test/results/clientpositive/perf/query31.q.out 909d64cef12a9492c5d24ef5876609a77423d2d5 
  ql/src/test/results/clientpositive/perf/query32.q.out da2ac8fe18fc2d71f7b14c28396b741a31082fd2 
  ql/src/test/results/clientpositive/perf/query34.q.out 1cb7c285f418476612fbc897f02e701e96995224 
  ql/src/test/results/clientpositive/perf/query39.q.out 9f3e650943c1d7ab04fc521509ca9372e4105a25 
  ql/src/test/results/clientpositive/perf/query40.q.out b2d6262d96b7dc1c25748a758af61988b39d7c45 
  ql/src/test/results/clientpositive/perf/query42.q.out 9ede45d24587228328671a40e9b3f9ca43e2a550 
  ql/src/test/results/clientpositive/perf/query45.q.out f55f20cb0f13c661c5f50bf412042458de62c726 
  ql/src/test/results/clientpositive/perf/query46.q.out 0ded91216db1e04548728a0025538929280b9dec 
  ql/src/test/results/clientpositive/perf/query48.q.out 40b76f00d0bbbaffb5819a38eaaa7ca3914ad37c 
  ql/src/test/results/clientpositive/perf/query50.q.out 8b41d05d312a0066644ff167c588d0d55e5770b3 
  ql/src/test/results/clientpositive/perf/query52.q.out 7e7224ba54b49a68040a536adca665a8f510bdd7 
  ql/src/test/results/clientpositive/perf/query54.q.out 56c70b7c6ab40cab7cf862023be36b3d88f3b288 
  ql/src/test/results/clientpositive/perf/query55.q.out d36f3787f1d8b1d24306b38e6c65f6cbd583af80 
  ql/src/test/results/clientpositive/perf/query58.q.out c2f71892ee7ceb68449c6c4f13754052041de106 
  ql/src/test/results/clientpositive/perf/query64.q.out 9331673a663e9b31bfb00b443c4ae282ffe67e56 
  ql/src/test/results/clientpositive/perf/query65.q.out 12bdd33c3aadc161faac927734de28d2da840650 
  ql/src/test/results/clientpositive/perf/query66.q.out a25664e73afb1088e05ec3912dab253720bc4af4 
  ql/src/test/results/clientpositive/perf/query68.q.out 8ecde892fa2f0011e16ec2e9c93e34dab7037e21 
  ql/src/test/results/clientpositive/perf/query70.q.out d13165d844fc0cfb4d605ae428b5e29a9a3752d4 
  ql/src/test/results/clientpositive/perf/query71.q.out fa50e5605878f1b090687160863156bc5f895055 
  ql/src/test/results/clientpositive/perf/query72.q.out bb56f0d695ede28d37b210fc1c6293444038154e 
  ql/src/test/results/clientpositive/perf/query73.q.out 9c888543d9115d2eb751fdf750fc95d964c9b093 
  ql/src/test/results/clientpositive/perf/query75.q.out f3f9827a532b445e59642cbf9d169dc4147e03d2 
  ql/src/test/results/clientpositive/perf/query76.q.out e540ee746f74df14c436290f55e4a2c4271d5bfc 
  ql/src/test/results/clientpositive/perf/query80.q.out 37cb542f008b21b26e2bdd03aac7144b7352893b 
  ql/src/test/results/clientpositive/perf/query82.q.out 654a772070ffcd60b5201d5d8d7d1d635c4738d2 
  ql/src/test/results/clientpositive/perf/query84.q.out e522f23800eb18b0abff741c3254b72eced931e8 
  ql/src/test/results/clientpositive/perf/query85.q.out 54061ced073090cec35111081f21ac510d0bde92 
  ql/src/test/results/clientpositive/perf/query87.q.out a3361898811f37271930a671381f6522724bf05d 
  ql/src/test/results/clientpositive/perf/query88.q.out f139dd11c3cc65d78538426d68b452816117e3e3 
  ql/src/test/results/clientpositive/perf/query89.q.out ee9eabc4330fcebd971a5c913888adcf67398ea5 
  ql/src/test/results/clientpositive/perf/query90.q.out d34aaf4d65f7f614533390f4415666bc9879c88f 
  ql/src/test/results/clientpositive/perf/query91.q.out 54f58e439bed7e44287ecc671c1db3e497ce4eae 
  ql/src/test/results/clientpositive/perf/query92.q.out 6fb2133f2b8beaaaf32359d3d10770693125b505 
  ql/src/test/results/clientpositive/perf/query93.q.out 52551459456d952ef1959515ec877b2fc992c6be 
  ql/src/test/results/clientpositive/perf/query94.q.out 0357835f7f5e565f560e73506b10345c0fe089ff 
  ql/src/test/results/clientpositive/perf/query95.q.out a7c6a981bfc07a9d08fefea511b57775aa9c4de7 
  ql/src/test/results/clientpositive/perf/query96.q.out bba8965df34d208ab2fc825cdb2882e5a671f351 
  ql/src/test/results/clientpositive/ppd_join2.q.out c5036525a685b5e76157dbf88a9e614727cb69ac 
  ql/src/test/results/clientpositive/ppd_join3.q.out 0000db129c9428e34935397ab5c51f010987eca3 
  ql/src/test/results/clientpositive/ppd_join5.q.out b68229eb08ca1fadd148387f2a361ca9c5237f12 
  ql/src/test/results/clientpositive/ppd_outer_join4.q.out 289798c5bc0113ea4864e2c287001805a8fc1ea9 
  ql/src/test/results/clientpositive/ppd_outer_join5.q.out 35fec7a46606b0489d9c4e9c472a26607b17a177 
  ql/src/test/results/clientpositive/ppd_udf_case.q.out 2b407a63d8b51cfedc020459240150b97044ffc3 
  ql/src/test/results/clientpositive/ppd_union_view.q.out d33cbd6b7b024fc789e3477e35afaeb7a58f052b 
  ql/src/test/results/clientpositive/quotedid_basic.q.out 3c81e0bccce92d489d4f2eec874826a1d232c7be 
  ql/src/test/results/clientpositive/regex_col.q.out 33e1a1273d49aba4c73540246288112781527496 
  ql/src/test/results/clientpositive/router_join_ppr.q.out 7182f8deb6f74fc9250d6d55816c8a1debcb76ae 
  ql/src/test/results/clientpositive/semijoin4.q.out 7489de2ebcc3d044b22cc2c64d4747b51285d111 
  ql/src/test/results/clientpositive/skewjoin.q.out 4e98dfd9e7aedd8cffbe1aee64c03d62741763d7 
  ql/src/test/results/clientpositive/skewjoinopt12.q.out 5109173b4bcf3644bcf9c660b51a242d9483014c 
  ql/src/test/results/clientpositive/skewjoinopt16.q.out de9869615e6bed1246288c5eb36e5b47f40559ef 
  ql/src/test/results/clientpositive/skewjoinopt17.q.out ea2b670e1dde15dc8fd2e6728ae4e5fc5c7c90ce 
  ql/src/test/results/clientpositive/skewjoinopt2.q.out c2ae731c38c766d1e3b43aa2d219927a8d3dfe95 
  ql/src/test/results/clientpositive/spark/annotate_stats_join.q.out baa1dcb5c27dc709412466370acae31f75406562 
  ql/src/test/results/clientpositive/spark/auto_join12.q.out 158e53511f43bd12fc006bd595c4dab48dc1cf94 
  ql/src/test/results/clientpositive/spark/auto_join16.q.out ba6336aaa5213f0dcd292bd1fb07c9582fb1c6fd 
  ql/src/test/results/clientpositive/spark/auto_join_without_localtask.q.out f055a59545c236b6cd4132700caf15fa4f72bfd2 
  ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_6.q.out e8e1e7e510c414255de72dfa86b8140f97ea5e87 
  ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_7.q.out 0b64a8735a6e9a668650db8907abce38c31ab70e 
  ql/src/test/results/clientpositive/spark/constprog_partitioner.q.out 8a6ab825c2be8e5a7d9715e93545421b7f16e1df 
  ql/src/test/results/clientpositive/spark/dynamic_rdd_cache.q.out 6e595ff4b19d188b041394aff5df6d93614fe813 
  ql/src/test/results/clientpositive/spark/groupby_position.q.out 415703f638ede1e113fd3f7864f2f8688302c38d 
  ql/src/test/results/clientpositive/spark/index_auto_self_join.q.out 40c09de04a4e8eb8b02a4b537ca58fbf57e831fa 
  ql/src/test/results/clientpositive/spark/index_bitmap3.q.out b03ea990c06964b5d582967fd58d2cb40e955b59 
  ql/src/test/results/clientpositive/spark/index_bitmap_auto.q.out c912379afcffd94d487999e4ed4ac7059860ebb9 
  ql/src/test/results/clientpositive/spark/join12.q.out 2ad0a43853e832fe7d16678d38e6b5b1f43f467f 
  ql/src/test/results/clientpositive/spark/join16.q.out 2496ec2904272923c346d746f6150a34ffee63be 
  ql/src/test/results/clientpositive/spark/join34.q.out a4cbc79b4755c0ab74177e7804bb4e16204345c2 
  ql/src/test/results/clientpositive/spark/join35.q.out 598143f021681214e5da79f87c76dd676281f6a1 
  ql/src/test/results/clientpositive/spark/join_alt_syntax.q.out fb50955e80839d39eef99db8f814f50d75f03412 
  ql/src/test/results/clientpositive/spark/join_cond_pushdown_2.q.out 1a1c15428614f83c92d9ac25e2126b37133e9e21 
  ql/src/test/results/clientpositive/spark/join_cond_pushdown_4.q.out 4fa5f5a9306ddbe6e5bc27634a34dd21739c2b6e 
  ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual2.q.out 8b318d827dc5fa07b893313777dcc3f3ab5ae52d 
  ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual4.q.out 15c45e67243687c32491a47b8ae1b94c8a55be02 
  ql/src/test/results/clientpositive/spark/louter_join_ppr.q.out 7f72b760929384c59d2e48827ff4ff652eb2b443 
  ql/src/test/results/clientpositive/spark/mapjoin_mapjoin.q.out b7ac43de22bd600c7170fc7588a753b7c56edf5c 
  ql/src/test/results/clientpositive/spark/mergejoins.q.out e6872400b45cadc969ef897cf42c38dd23b9581f 
  ql/src/test/results/clientpositive/spark/mergejoins_mixed.q.out 42ffebfde50472f1aec060c33037fe851921e88c 
  ql/src/test/results/clientpositive/spark/ppd_join2.q.out 5848609e67bedffbffe7cb8028588017eaf327a6 
  ql/src/test/results/clientpositive/spark/ppd_join3.q.out c78d4cb4580d17946375f6ee5b6c447741d7c6f4 
  ql/src/test/results/clientpositive/spark/ppd_join5.q.out 8b51969b4b5e8b2772c37dfb8ec8e17908fd58f2 
  ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out 8d0830892ab997e489306ec2698e1c6fdf61996f 
  ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out 8e398580ac526c0acbd642bc91579fcea0d9b428 
  ql/src/test/results/clientpositive/spark/router_join_ppr.q.out 319dc0ad836129d2e551e3414ab52a74b9f49b8b 
  ql/src/test/results/clientpositive/spark/skewjoin.q.out b2460460da36e856655ca12706678378b976f059 
  ql/src/test/results/clientpositive/spark/skewjoinopt12.q.out 1e77aa746de5c950e1789b8d5b38e68650b53b3c 
  ql/src/test/results/clientpositive/spark/skewjoinopt16.q.out 3be7ce08d9a43ada35d5bbfebf4a567e8fcdde58 
  ql/src/test/results/clientpositive/spark/skewjoinopt17.q.out ce8bbfa768ea8ad0ddc072bfb29cbacd82ef4a49 
  ql/src/test/results/clientpositive/spark/skewjoinopt2.q.out b5fa077046bcf9ae14935b034f62d12786f38d1f 
  ql/src/test/results/clientpositive/spark/subquery_exists.q.out 5f41ac7aeaa5425004a4cd56638f0961a5a78a7e 
  ql/src/test/results/clientpositive/spark/subquery_in.q.out 1d813f8ae53e6cccde25e864d168380568e02e7a 
  ql/src/test/results/clientpositive/spark/union_remove_25.q.out eb95cadde3f8f3006df4a1093bebf00dd55514f8 
  ql/src/test/results/clientpositive/spark/union_view.q.out 492f71b10b9e98cd9235fad4b40850b2aa2d9730 
  ql/src/test/results/clientpositive/spark/vector_mapjoin_reduce.q.out 296c256d09703a073a41a36dc96b526e78afb715 
  ql/src/test/results/clientpositive/subquery_exists.q.out f3a270589b7b50dd7ef2ec53d1bac7ae88f7f245 
  ql/src/test/results/clientpositive/subquery_in.q.out a374dc0f84aa78dcf099d8733b42f94e6cea7863 
  ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out e34a401ca41faae0f25e7f398ac5c078f8f34df8 
  ql/src/test/results/clientpositive/subquery_views.q.out 76e53d3be56f3f8c2422317585d441cd14665294 
  ql/src/test/results/clientpositive/tez/correlationoptimizer1.q.out 20bec18f8e66d6fad385c3e28dfa940c5afd199c 
  ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out 58ab2c08554f4b2b4d06e79de22845445fc3c0e5 
  ql/src/test/results/clientpositive/tez/explainuser_1.q.out 8c78fd9d7f23f5272d88e83378485c83605c5b5a 
  ql/src/test/results/clientpositive/tez/explainuser_2.q.out eb7d564b774d5c486cd9e47086b2ef750ce17dd5 
  ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out 3534a9cdcfe0ae1ee3404a9aa80131a0cedf265e 
  ql/src/test/results/clientpositive/tez/mergejoin.q.out 4b2d9635fe602fa6aa03d20d32bb57770a92ac39 
  ql/src/test/results/clientpositive/tez/skewjoin.q.out fc084cc5b8c798ceb6bfc84ad1b29ca5d3c91f48 
  ql/src/test/results/clientpositive/tez/subquery_exists.q.out 5121a144c1d6c2c28890cd742e59d3c1bb868c9a 
  ql/src/test/results/clientpositive/tez/subquery_in.q.out a4887e4e69fd8d2734583586a67daf1bfeacf8ac 
  ql/src/test/results/clientpositive/tez/tez_dynpart_hashjoin_1.q.out e3131d5071c891b35340d040efb44ab3ea10a46c 
  ql/src/test/results/clientpositive/tez/tez_self_join.q.out 26545763f313ef4a09f265faf29f7cab97b9f6bf 
  ql/src/test/results/clientpositive/tez/tez_smb_empty.q.out 8c9ab2eda3b88362f38bf795e001dfc72ca52a73 
  ql/src/test/results/clientpositive/tez/tez_vector_dynpart_hashjoin_1.q.out 3711a10f425ba54153cf4fbca02ba86a09b401f6 
  ql/src/test/results/clientpositive/tez/vector_interval_mapjoin.q.out 42ce4996b5836759dcc4fb47523809abb57c81ee 
  ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out 7eb28f8e2a5af32075e2fa1a1ad89af092a36e90 
  ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out cda76db1f9966a0b1969381faa3ad035568edb84 
  ql/src/test/results/clientpositive/udf_folder_constants.q.out ef07420325dd2d99322f4fc150951798dcdeafaa 
  ql/src/test/results/clientpositive/union_remove_25.q.out 3869735f9f83a1c5538403f5563369eee7d77be9 
  ql/src/test/results/clientpositive/union_view.q.out 1d93159e2b2c1ede1c090fb82db1928872fd2c61 
  ql/src/test/results/clientpositive/vector_interval_mapjoin.q.out 7cd7eb0c709831b1b4b264203301d2593a5d79a6 
  ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out dd40f282c7392f4eb8ef674cb5f6629d41eacf01 

Diff: https://reviews.apache.org/r/42190/diff/


Testing
-------


Thanks,

Jesús Camacho Rodríguez

Re: Review Request 42190: HIVE-12478

Posted by Jesús Camacho Rodríguez <jc...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/42190/
-----------------------------------------------------------

(Updated Jan. 21, 2016, 10:45 p.m.)


Review request for hive and John Pullokkaran.


Bugs: HIVE-12478
    https://issues.apache.org/jira/browse/HIVE-12478


Repository: hive-git


Description
-------

Improve Hive/Calcite Trasitive Predicate inference


Diffs (updated)
-----

  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveCalciteUtil.java 4825a617876374085b6fac1192ba1531ec916bce 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveHepPlannerContext.java ad79aeec2fbc0454ab1ccc608944752d01324dca 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveVolcanoPlannerContext.java 8859fc268666cef1be283a9179aa0beb7ef1bdeb 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/cost/HiveCostModel.java d15d885d2348d666df069228a93d6c5f914c79df 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/cost/HiveVolcanoPlanner.java 8610edc5ddc00d523610fb29f5e504c3e876a542 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveJoin.java 27b1e76a104dc961cb4bce554602d90b3aa867e0 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveSemiJoin.java 35586768c2c2b81e4213495632e4457dd3d70443 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveUnion.java 8b57b3504c407b8a1e73d48ea240c4ec7558b327 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinAddNotNullRule.java de880ce26f1e172288f700c8566fbe71f42af115 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinPushTransitivePredicatesRule.java 703c8c6dbdfa281443cbcf7b08de2266697da8a9 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HivePreFilteringRule.java d37fc0e08d5e41b29539a990e6638385c1135eec 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveRulesRegistry.java 18a065e87e1ec266bf28b4ccfe10a1f863f847c2 
  ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java 3fefbd710c4bb81d5f746cd91889b532b0a6029f 
  ql/src/test/org/apache/hadoop/hive/ql/optimizer/calcite/TestCBORuleFiredOnlyOnce.java f1d8d1de00e9de7fa9ffea7d3aa2400e5073ac9c 
  ql/src/test/results/clientpositive/annotate_stats_join.q.out 7fc754d5712d5f05efc943b66d3c829d47312d19 
  ql/src/test/results/clientpositive/annotate_stats_join_pkfk.q.out f13643e8db57cc0a85b2626c37437fd030f72029 
  ql/src/test/results/clientpositive/annotate_stats_select.q.out b158d8567f6cc02d990d175e93996239aba0c5ed 
  ql/src/test/results/clientpositive/auto_join12.q.out 8ef3664764d04f53f3685d8f66dc4a353776a488 
  ql/src/test/results/clientpositive/auto_join16.q.out c1da6d2968697d304311044d358f1af267dc6e60 
  ql/src/test/results/clientpositive/auto_join_reordering_values.q.out 59aa738c779d50a760e1b0d36e4ce83295b0d70f 
  ql/src/test/results/clientpositive/auto_join_without_localtask.q.out d40b1655e27fa70efc8dbf0475c688f6e2b3608f 
  ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out cb87f761be7c58ecc6435bb0a9b0e96c46a36828 
  ql/src/test/results/clientpositive/bucket_map_join_spark4.q.out 4abdab53b5562dc129a2d9a73c63cf44d066c05e 
  ql/src/test/results/clientpositive/bucketizedhiveinputformat.q.out cfb95be72b32a354faeddc79dc52bc29c7593a2b 
  ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out a7ad04c7208f8e8486e79c1e749184e5b532a1fc 
  ql/src/test/results/clientpositive/cast1.q.out 48a0c14031ef38dd5b4df7efa718a4d6ce04bc94 
  ql/src/test/results/clientpositive/cbo_const.q.out adc5232a67b2243dd5f09acaf1f7c49baea5daad 
  ql/src/test/results/clientpositive/cbo_rp_cross_product_check_2.q.out f1707eb4146c55338500c1fcaf4ff7199750250f 
  ql/src/test/results/clientpositive/cbo_rp_lineage2.q.out 1b2a2ab1af5992753c37d053942ecb2ebf775921 
  ql/src/test/results/clientpositive/constprog_partitioner.q.out 08c0aebafe1644a5adbec6a56879b39617bfbf69 
  ql/src/test/results/clientpositive/correlationoptimizer1.q.out 38764d6b127bd1aba1efa5800b16c0c1e387a310 
  ql/src/test/results/clientpositive/correlationoptimizer10.q.out 6bac698155221be4b0cb5b0bb3b2cdbfec5236ea 
  ql/src/test/results/clientpositive/correlationoptimizer13.q.out 61b7bcb675a80dc3267365c65545e107ecbe12d2 
  ql/src/test/results/clientpositive/correlationoptimizer8.q.out 368a1147d404ae9aab18a64618abf8ed7b3f7189 
  ql/src/test/results/clientpositive/correlationoptimizer9.q.out 104a97afbb6657255a027ff6d51101f6963c2358 
  ql/src/test/results/clientpositive/cross_product_check_1.q.out 05eb270a292ecd9fe03db77511a7e2a08a28204c 
  ql/src/test/results/clientpositive/cross_product_check_2.q.out a36560f23c1801f0bf988fa4e08dcf49376d8577 
  ql/src/test/results/clientpositive/dynamic_rdd_cache.q.out 743865e073e1768f7f6234fde35ad2e56d8babe9 
  ql/src/test/results/clientpositive/filter_cond_pushdown.q.out 5e0edbc9efb442467c4998021ac1ecfb9d07579d 
  ql/src/test/results/clientpositive/groupby_position.q.out c2566f2ad5d426db8814b7ca85207807f4a5afc7 
  ql/src/test/results/clientpositive/groupby_ppd.q.out d17c4b6d9e88d49d64b9725be1e51ca258ad1167 
  ql/src/test/results/clientpositive/index_auto_mult_tables.q.out 8c71925fbc5352f42abb280fc45a1d5a5713ebad 
  ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out b3e698927689dad5229165189779300cb8beca9b 
  ql/src/test/results/clientpositive/index_auto_self_join.q.out 3cc1d7e8c7be8bd60e67f1a88a72ce9a89c5fe2c 
  ql/src/test/results/clientpositive/index_bitmap3.q.out a8eecb5bd48bf07c648bf4425d66f566c7216d41 
  ql/src/test/results/clientpositive/index_bitmap_auto.q.out d1fd59c8981e33e0e9da36c9811de45f9e625cd9 
  ql/src/test/results/clientpositive/input_part1.q.out 501f7a9f87c66a1dd1d0fec0546597d810c0dbe9 
  ql/src/test/results/clientpositive/input_part5.q.out c6ae2fd58d7d41e4b4c0f764de3e28484917cd97 
  ql/src/test/results/clientpositive/input_part6.q.out c01d8afb6230440103ed8c1ecb38aea9eaabc832 
  ql/src/test/results/clientpositive/join12.q.out 8217c86d0e41c78b8bf4ed120b30a85204fa9915 
  ql/src/test/results/clientpositive/join16.q.out 244eb46dc0ae3b61ed932f043a98bb64295776a1 
  ql/src/test/results/clientpositive/join19.q.out b1b9dfe8b59e7b75d4ba1a040844ae18af699336 
  ql/src/test/results/clientpositive/join32.q.out 5cb124bddc85ee3f82464bb9a588bc4e64a639e6 
  ql/src/test/results/clientpositive/join32_lessSize.q.out 544e814fd5194a28827de6fa4a3a394b23f7727d 
  ql/src/test/results/clientpositive/join33.q.out 5cb124bddc85ee3f82464bb9a588bc4e64a639e6 
  ql/src/test/results/clientpositive/join34.q.out e2c2b1a5ab742e26d953f11919e150f847a05157 
  ql/src/test/results/clientpositive/join35.q.out 663642c7d1c00a47993c497ac76d6f036221f06b 
  ql/src/test/results/clientpositive/join42.q.out 6e09e38102129edb7246b0a027c86ba1deed066c 
  ql/src/test/results/clientpositive/join43.q.out b5006fa6fe86b377f2b5ec6498e5b731ef239296 
  ql/src/test/results/clientpositive/join_alt_syntax.q.out 1c7f159aaed439c94607b815c30ec6c005d7dfb8 
  ql/src/test/results/clientpositive/join_cond_pushdown_2.q.out 3a50651c955e7ecd24b0a9fe685bc5a7370a0b54 
  ql/src/test/results/clientpositive/join_cond_pushdown_4.q.out af51f39f18f8dc499bcf0ad8c497b34ddb11b29d 
  ql/src/test/results/clientpositive/join_cond_pushdown_unqual2.q.out 6a5608bdf1446fa3f6d45206021ce1fc9ed95301 
  ql/src/test/results/clientpositive/join_cond_pushdown_unqual4.q.out d4a3549e3be54b1c8fd00309213666fef1ef6c58 
  ql/src/test/results/clientpositive/join_grp_diff_keys.q.out da029c97a3438493163f08d0f8ef4c3c14043a22 
  ql/src/test/results/clientpositive/join_hive_626.q.out f3d2cdc1dc2feaf2686325c076be6f6bf0c6768b 
  ql/src/test/results/clientpositive/join_parse.q.out ab657cc48c6573fbf60e0cae812312fe02603555 
  ql/src/test/results/clientpositive/join_star.q.out 78a615906aaa51b0254ba8df072af06456e87bdf 
  ql/src/test/results/clientpositive/join_vc.q.out c93a258d69ab0349048e61014d79fbc93f8ffc82 
  ql/src/test/results/clientpositive/lineage2.q.out a189f82a3d29cd3b1e21a43afc85ef14fd74c79e 
  ql/src/test/results/clientpositive/lineage3.q.out f1162a213eea285a5d166731e0ce7e407f4106a7 
  ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out 3dea672a11b65e9040d0d794bf03408fd6e3a755 
  ql/src/test/results/clientpositive/llap/bucket_map_join_tez1.q.out 1fb76d8a8f32e0d63eba743d6007ffc7691b9b30 
  ql/src/test/results/clientpositive/llap/bucket_map_join_tez2.q.out 5e7af65ed954e3d61610ed21610d046db9eb5112 
  ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out d2c11d7644570217532f9b366926d8cc94a03e6a 
  ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_1.q.out b459692b443a1686def6615e9e9bcce5922335c3 
  ql/src/test/results/clientpositive/llap/tez_join_hash.q.out 366fedc42819e0de586d00932621051ade288ed2 
  ql/src/test/results/clientpositive/llap/tez_smb_main.q.out f15339b3828b710729466b59d20009af95c7d808 
  ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out 6a57f1fd82ef3e3cf681138383534e7fea1c07df 
  ql/src/test/results/clientpositive/llap/vectorized_dynamic_partition_pruning.q.out 63121a9e5b043e2c27fe08ee54e6fe01e2dd6cae 
  ql/src/test/results/clientpositive/louter_join_ppr.q.out 553def9bb50e7e9c7e80bc422dc7bad56c5b5998 
  ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out 41d824c9f3bcdbc30812e2cbb55539ed31421fe5 
  ql/src/test/results/clientpositive/mergejoin.q.out acf816ebc2db9df7f2878375dea3c403fb513c08 
  ql/src/test/results/clientpositive/mergejoins.q.out 901041083f3182497361b8f27ed77c093e7ce237 
  ql/src/test/results/clientpositive/mergejoins_mixed.q.out 10f37f9fe34d79987333e3f8bb01166304fe5894 
  ql/src/test/results/clientpositive/multiMapJoin1.q.out e2efec0295e2d15aa1497b848eb6eb8838617b7f 
  ql/src/test/results/clientpositive/multi_join_union.q.out 8d7ff95461935bdab6ebc6aac8189e52ef2799de 
  ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out 90032fe53d37163e09fbf2b1bf7dac0e55b80b18 
  ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out 7c5be6dbe636f6cfcf8f4a3563d2b204d3cb2b46 
  ql/src/test/results/clientpositive/partition_multilevels.q.out 699c1790314f0ea3bff2eae4aa6f3231eddead51 
  ql/src/test/results/clientpositive/perf/query13.q.out 6113d18af3c9922b288d64c61ee0590d124b809b 
  ql/src/test/results/clientpositive/perf/query15.q.out c2378282432aec3f46ab5928d709487c4829d0f2 
  ql/src/test/results/clientpositive/perf/query17.q.out 0e42d053e37904af58735ff7d5021ab9ffe9e668 
  ql/src/test/results/clientpositive/perf/query18.q.out 83f21dc7ebc2e8aaf2a0b081584e0fc98fdaf7a4 
  ql/src/test/results/clientpositive/perf/query19.q.out d5658394163e7cdfd1876a3fb7449d7fd46f96df 
  ql/src/test/results/clientpositive/perf/query20.q.out 40c9a17479c8cf83c1a4982a489be5099a81c783 
  ql/src/test/results/clientpositive/perf/query21.q.out 2634d3d35ccf05584c719dd03c97e97f26d05eaf 
  ql/src/test/results/clientpositive/perf/query22.q.out 72935ed2c5d7de7889b456da0c95c21b291b0b54 
  ql/src/test/results/clientpositive/perf/query25.q.out dabc1c528e7cca0d8f83b4f1dd0938e56ff49f61 
  ql/src/test/results/clientpositive/perf/query26.q.out 84cc23843e0931a8a55d39c354273cc6139425a5 
  ql/src/test/results/clientpositive/perf/query27.q.out ac386835fae308bcbffdc5aa2e0492cde3d63852 
  ql/src/test/results/clientpositive/perf/query29.q.out 8991f3562d5140611ce35513f1685e36bc070d9a 
  ql/src/test/results/clientpositive/perf/query3.q.out 871ad740cd56c37129ad10a7df8fba24b1006d6b 
  ql/src/test/results/clientpositive/perf/query31.q.out 909d64cef12a9492c5d24ef5876609a77423d2d5 
  ql/src/test/results/clientpositive/perf/query32.q.out da2ac8fe18fc2d71f7b14c28396b741a31082fd2 
  ql/src/test/results/clientpositive/perf/query34.q.out 1cb7c285f418476612fbc897f02e701e96995224 
  ql/src/test/results/clientpositive/perf/query39.q.out 9f3e650943c1d7ab04fc521509ca9372e4105a25 
  ql/src/test/results/clientpositive/perf/query40.q.out b2d6262d96b7dc1c25748a758af61988b39d7c45 
  ql/src/test/results/clientpositive/perf/query42.q.out 9ede45d24587228328671a40e9b3f9ca43e2a550 
  ql/src/test/results/clientpositive/perf/query43.q.out 7fa4f531722865710953f306c278fc5353e6a8bb 
  ql/src/test/results/clientpositive/perf/query45.q.out f55f20cb0f13c661c5f50bf412042458de62c726 
  ql/src/test/results/clientpositive/perf/query46.q.out 0ded91216db1e04548728a0025538929280b9dec 
  ql/src/test/results/clientpositive/perf/query48.q.out 40b76f00d0bbbaffb5819a38eaaa7ca3914ad37c 
  ql/src/test/results/clientpositive/perf/query50.q.out 8b41d05d312a0066644ff167c588d0d55e5770b3 
  ql/src/test/results/clientpositive/perf/query52.q.out 7e7224ba54b49a68040a536adca665a8f510bdd7 
  ql/src/test/results/clientpositive/perf/query54.q.out 56c70b7c6ab40cab7cf862023be36b3d88f3b288 
  ql/src/test/results/clientpositive/perf/query55.q.out d36f3787f1d8b1d24306b38e6c65f6cbd583af80 
  ql/src/test/results/clientpositive/perf/query58.q.out c2f71892ee7ceb68449c6c4f13754052041de106 
  ql/src/test/results/clientpositive/perf/query64.q.out 9331673a663e9b31bfb00b443c4ae282ffe67e56 
  ql/src/test/results/clientpositive/perf/query65.q.out 12bdd33c3aadc161faac927734de28d2da840650 
  ql/src/test/results/clientpositive/perf/query66.q.out a25664e73afb1088e05ec3912dab253720bc4af4 
  ql/src/test/results/clientpositive/perf/query67.q.out dda5347f54c65434e0edda80d327c04b76a5f484 
  ql/src/test/results/clientpositive/perf/query68.q.out 8ecde892fa2f0011e16ec2e9c93e34dab7037e21 
  ql/src/test/results/clientpositive/perf/query7.q.out a463a8b1fdb28d2f94301a5bc367da9c24469ecf 
  ql/src/test/results/clientpositive/perf/query70.q.out d13165d844fc0cfb4d605ae428b5e29a9a3752d4 
  ql/src/test/results/clientpositive/perf/query71.q.out fa50e5605878f1b090687160863156bc5f895055 
  ql/src/test/results/clientpositive/perf/query72.q.out bb56f0d695ede28d37b210fc1c6293444038154e 
  ql/src/test/results/clientpositive/perf/query73.q.out 9c888543d9115d2eb751fdf750fc95d964c9b093 
  ql/src/test/results/clientpositive/perf/query75.q.out f3f9827a532b445e59642cbf9d169dc4147e03d2 
  ql/src/test/results/clientpositive/perf/query76.q.out e540ee746f74df14c436290f55e4a2c4271d5bfc 
  ql/src/test/results/clientpositive/perf/query79.q.out a0d5a516ceba5b3f5409fe120161f0c1edb42610 
  ql/src/test/results/clientpositive/perf/query80.q.out 37cb542f008b21b26e2bdd03aac7144b7352893b 
  ql/src/test/results/clientpositive/perf/query82.q.out 654a772070ffcd60b5201d5d8d7d1d635c4738d2 
  ql/src/test/results/clientpositive/perf/query84.q.out e522f23800eb18b0abff741c3254b72eced931e8 
  ql/src/test/results/clientpositive/perf/query85.q.out 54061ced073090cec35111081f21ac510d0bde92 
  ql/src/test/results/clientpositive/perf/query87.q.out a3361898811f37271930a671381f6522724bf05d 
  ql/src/test/results/clientpositive/perf/query88.q.out f139dd11c3cc65d78538426d68b452816117e3e3 
  ql/src/test/results/clientpositive/perf/query89.q.out ee9eabc4330fcebd971a5c913888adcf67398ea5 
  ql/src/test/results/clientpositive/perf/query90.q.out d34aaf4d65f7f614533390f4415666bc9879c88f 
  ql/src/test/results/clientpositive/perf/query91.q.out 54f58e439bed7e44287ecc671c1db3e497ce4eae 
  ql/src/test/results/clientpositive/perf/query92.q.out 6fb2133f2b8beaaaf32359d3d10770693125b505 
  ql/src/test/results/clientpositive/perf/query93.q.out 52551459456d952ef1959515ec877b2fc992c6be 
  ql/src/test/results/clientpositive/perf/query94.q.out 0357835f7f5e565f560e73506b10345c0fe089ff 
  ql/src/test/results/clientpositive/perf/query95.q.out a7c6a981bfc07a9d08fefea511b57775aa9c4de7 
  ql/src/test/results/clientpositive/perf/query96.q.out bba8965df34d208ab2fc825cdb2882e5a671f351 
  ql/src/test/results/clientpositive/perf/query98.q.out baff7e04211c81bcb50ac9ca2553018989cb7800 
  ql/src/test/results/clientpositive/pointlookup2.q.out 1cfa4b6345ab48f6cac437a2dbefc657016a4b6d 
  ql/src/test/results/clientpositive/ppd_join2.q.out c5036525a685b5e76157dbf88a9e614727cb69ac 
  ql/src/test/results/clientpositive/ppd_join3.q.out 0000db129c9428e34935397ab5c51f010987eca3 
  ql/src/test/results/clientpositive/ppd_join5.q.out b68229eb08ca1fadd148387f2a361ca9c5237f12 
  ql/src/test/results/clientpositive/ppd_outer_join4.q.out 289798c5bc0113ea4864e2c287001805a8fc1ea9 
  ql/src/test/results/clientpositive/ppd_outer_join5.q.out 35fec7a46606b0489d9c4e9c472a26607b17a177 
  ql/src/test/results/clientpositive/ppd_udf_case.q.out 2b407a63d8b51cfedc020459240150b97044ffc3 
  ql/src/test/results/clientpositive/ppd_union_view.q.out d33cbd6b7b024fc789e3477e35afaeb7a58f052b 
  ql/src/test/results/clientpositive/quotedid_basic.q.out 3c81e0bccce92d489d4f2eec874826a1d232c7be 
  ql/src/test/results/clientpositive/quotedid_partition.q.out a83c62b1826786f5213c8556bd275e4bd545fb6a 
  ql/src/test/results/clientpositive/regex_col.q.out 33e1a1273d49aba4c73540246288112781527496 
  ql/src/test/results/clientpositive/router_join_ppr.q.out 7182f8deb6f74fc9250d6d55816c8a1debcb76ae 
  ql/src/test/results/clientpositive/semijoin4.q.out 7489de2ebcc3d044b22cc2c64d4747b51285d111 
  ql/src/test/results/clientpositive/skewjoin.q.out 4e98dfd9e7aedd8cffbe1aee64c03d62741763d7 
  ql/src/test/results/clientpositive/skewjoin_mapjoin8.q.out ae0aafa49f5597c6fe3723a1c7c6de62dcc2012c 
  ql/src/test/results/clientpositive/skewjoin_mapjoin9.q.out f9043d38d5d6fee8b9419abc21443538c690cddb 
  ql/src/test/results/clientpositive/skewjoinopt12.q.out 5109173b4bcf3644bcf9c660b51a242d9483014c 
  ql/src/test/results/clientpositive/skewjoinopt13.q.out 3f00c406460f7dfd43862a9e4ad07075ba0001b7 
  ql/src/test/results/clientpositive/skewjoinopt14.q.out a8536def44f65d1bcaf3118c0143111e6bc893e2 
  ql/src/test/results/clientpositive/skewjoinopt16.q.out de9869615e6bed1246288c5eb36e5b47f40559ef 
  ql/src/test/results/clientpositive/skewjoinopt17.q.out ea2b670e1dde15dc8fd2e6728ae4e5fc5c7c90ce 
  ql/src/test/results/clientpositive/skewjoinopt2.q.out c2ae731c38c766d1e3b43aa2d219927a8d3dfe95 
  ql/src/test/results/clientpositive/spark/annotate_stats_join.q.out baa1dcb5c27dc709412466370acae31f75406562 
  ql/src/test/results/clientpositive/spark/auto_join12.q.out 158e53511f43bd12fc006bd595c4dab48dc1cf94 
  ql/src/test/results/clientpositive/spark/auto_join16.q.out ba6336aaa5213f0dcd292bd1fb07c9582fb1c6fd 
  ql/src/test/results/clientpositive/spark/auto_join_reordering_values.q.out 8bf5977ceef03eb24fe3eed0b00f2f18580dbae2 
  ql/src/test/results/clientpositive/spark/auto_join_without_localtask.q.out f055a59545c236b6cd4132700caf15fa4f72bfd2 
  ql/src/test/results/clientpositive/spark/auto_sortmerge_join_6.q.out 41b2b0ae933946099505bee4c627d811ca21bed9 
  ql/src/test/results/clientpositive/spark/bucket_map_join_spark4.q.out b00c223d2fc0d2d7a3daa4599e4069d07b80da79 
  ql/src/test/results/clientpositive/spark/bucket_map_join_tez1.q.out 57a89d67b56cc36dda8b42f21481e9363cff297a 
  ql/src/test/results/clientpositive/spark/bucket_map_join_tez2.q.out 31908d71d4ea174d8210822a70689084908e760b 
  ql/src/test/results/clientpositive/spark/bucketizedhiveinputformat.q.out c8fc4d3ac6aacb8e7ce59792ab4f74cabde238e3 
  ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_6.q.out e8e1e7e510c414255de72dfa86b8140f97ea5e87 
  ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_7.q.out 0b64a8735a6e9a668650db8907abce38c31ab70e 
  ql/src/test/results/clientpositive/spark/constprog_partitioner.q.out 8a6ab825c2be8e5a7d9715e93545421b7f16e1df 
  ql/src/test/results/clientpositive/spark/cross_product_check_1.q.out 5e67607241b1c029e40ec82edb09ddad394af67c 
  ql/src/test/results/clientpositive/spark/cross_product_check_2.q.out e8bcd7a6f346bfa02b4031abb6221bd65f7d15b4 
  ql/src/test/results/clientpositive/spark/dynamic_rdd_cache.q.out 6e595ff4b19d188b041394aff5df6d93614fe813 
  ql/src/test/results/clientpositive/spark/groupby_position.q.out 415703f638ede1e113fd3f7864f2f8688302c38d 
  ql/src/test/results/clientpositive/spark/index_auto_self_join.q.out 40c09de04a4e8eb8b02a4b537ca58fbf57e831fa 
  ql/src/test/results/clientpositive/spark/index_bitmap3.q.out b03ea990c06964b5d582967fd58d2cb40e955b59 
  ql/src/test/results/clientpositive/spark/index_bitmap_auto.q.out c912379afcffd94d487999e4ed4ac7059860ebb9 
  ql/src/test/results/clientpositive/spark/join12.q.out 2ad0a43853e832fe7d16678d38e6b5b1f43f467f 
  ql/src/test/results/clientpositive/spark/join16.q.out 2496ec2904272923c346d746f6150a34ffee63be 
  ql/src/test/results/clientpositive/spark/join19.q.out 5de045b133c1a40c1bee87e0ac8354d4806858d3 
  ql/src/test/results/clientpositive/spark/join32.q.out 377121709ddaa0e8d13df067b11de491dc5c5cd5 
  ql/src/test/results/clientpositive/spark/join32_lessSize.q.out c4ac2dd6dfadcaee944f0da7ae54f8e3eee49f23 
  ql/src/test/results/clientpositive/spark/join33.q.out 377121709ddaa0e8d13df067b11de491dc5c5cd5 
  ql/src/test/results/clientpositive/spark/join34.q.out a4cbc79b4755c0ab74177e7804bb4e16204345c2 
  ql/src/test/results/clientpositive/spark/join35.q.out 598143f021681214e5da79f87c76dd676281f6a1 
  ql/src/test/results/clientpositive/spark/join_alt_syntax.q.out fb50955e80839d39eef99db8f814f50d75f03412 
  ql/src/test/results/clientpositive/spark/join_cond_pushdown_2.q.out 1a1c15428614f83c92d9ac25e2126b37133e9e21 
  ql/src/test/results/clientpositive/spark/join_cond_pushdown_4.q.out 4fa5f5a9306ddbe6e5bc27634a34dd21739c2b6e 
  ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual2.q.out 8b318d827dc5fa07b893313777dcc3f3ab5ae52d 
  ql/src/test/results/clientpositive/spark/join_cond_pushdown_unqual4.q.out 15c45e67243687c32491a47b8ae1b94c8a55be02 
  ql/src/test/results/clientpositive/spark/join_hive_626.q.out c07d12e7407f6a48fc0e20567f087c702510c5cc 
  ql/src/test/results/clientpositive/spark/join_star.q.out dea7a81b8472c8af913f0578e0708934ae2c465a 
  ql/src/test/results/clientpositive/spark/join_vc.q.out c1812a9ead215c1f872f177a13fc3a854ac38b9f 
  ql/src/test/results/clientpositive/spark/louter_join_ppr.q.out 7f72b760929384c59d2e48827ff4ff652eb2b443 
  ql/src/test/results/clientpositive/spark/mapjoin_mapjoin.q.out b7ac43de22bd600c7170fc7588a753b7c56edf5c 
  ql/src/test/results/clientpositive/spark/mergejoins.q.out e6872400b45cadc969ef897cf42c38dd23b9581f 
  ql/src/test/results/clientpositive/spark/mergejoins_mixed.q.out 42ffebfde50472f1aec060c33037fe851921e88c 
  ql/src/test/results/clientpositive/spark/multi_join_union.q.out 5ddcb1bc1348b927ef1f521cf7691563cecb0a1d 
  ql/src/test/results/clientpositive/spark/ppd_join2.q.out 5848609e67bedffbffe7cb8028588017eaf327a6 
  ql/src/test/results/clientpositive/spark/ppd_join3.q.out c78d4cb4580d17946375f6ee5b6c447741d7c6f4 
  ql/src/test/results/clientpositive/spark/ppd_join5.q.out 8b51969b4b5e8b2772c37dfb8ec8e17908fd58f2 
  ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out 8d0830892ab997e489306ec2698e1c6fdf61996f 
  ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out 8e398580ac526c0acbd642bc91579fcea0d9b428 
  ql/src/test/results/clientpositive/spark/router_join_ppr.q.out 319dc0ad836129d2e551e3414ab52a74b9f49b8b 
  ql/src/test/results/clientpositive/spark/skewjoin.q.out b2460460da36e856655ca12706678378b976f059 
  ql/src/test/results/clientpositive/spark/skewjoinopt12.q.out 1e77aa746de5c950e1789b8d5b38e68650b53b3c 
  ql/src/test/results/clientpositive/spark/skewjoinopt13.q.out f1a681df557d4ef22632096beb96fefc72baf3dc 
  ql/src/test/results/clientpositive/spark/skewjoinopt14.q.out ef36afda6d70ea3c0d1bb2ebfdd90dcc82329ccd 
  ql/src/test/results/clientpositive/spark/skewjoinopt16.q.out 3be7ce08d9a43ada35d5bbfebf4a567e8fcdde58 
  ql/src/test/results/clientpositive/spark/skewjoinopt17.q.out ce8bbfa768ea8ad0ddc072bfb29cbacd82ef4a49 
  ql/src/test/results/clientpositive/spark/skewjoinopt2.q.out b5fa077046bcf9ae14935b034f62d12786f38d1f 
  ql/src/test/results/clientpositive/spark/subquery_exists.q.out 5f41ac7aeaa5425004a4cd56638f0961a5a78a7e 
  ql/src/test/results/clientpositive/spark/subquery_in.q.out 1d813f8ae53e6cccde25e864d168380568e02e7a 
  ql/src/test/results/clientpositive/spark/union_remove_25.q.out eb95cadde3f8f3006df4a1093bebf00dd55514f8 
  ql/src/test/results/clientpositive/spark/union_view.q.out 492f71b10b9e98cd9235fad4b40850b2aa2d9730 
  ql/src/test/results/clientpositive/spark/vector_mapjoin_reduce.q.out 296c256d09703a073a41a36dc96b526e78afb715 
  ql/src/test/results/clientpositive/spark/vectorized_nested_mapjoin.q.out c4c86092eda1376da2669293bce7c05708aa7650 
  ql/src/test/results/clientpositive/subquery_exists.q.out f3a270589b7b50dd7ef2ec53d1bac7ae88f7f245 
  ql/src/test/results/clientpositive/subquery_in.q.out a374dc0f84aa78dcf099d8733b42f94e6cea7863 
  ql/src/test/results/clientpositive/subquery_notin.q.out e157ff4d511cd7a4729f3c1d39800e80788ee48a 
  ql/src/test/results/clientpositive/subquery_notin_having.q.java1.7.out 8f17b6c33b7842d805fa8fa412fed8149d3c219d 
  ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out e34a401ca41faae0f25e7f398ac5c078f8f34df8 
  ql/src/test/results/clientpositive/subquery_views.q.out 76e53d3be56f3f8c2422317585d441cd14665294 
  ql/src/test/results/clientpositive/tez/auto_sortmerge_join_6.q.out 521485ae03a484704b84a3e8b9eb2eed992ffdc2 
  ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out 4703cec3fdcbb79bbc4b0365b97600e760ac2748 
  ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out c5cb360e0524e006a728105e2f0e17a1df8afa68 
  ql/src/test/results/clientpositive/tez/correlationoptimizer1.q.out 20bec18f8e66d6fad385c3e28dfa940c5afd199c 
  ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out d5530a579a011aefa2a7fea965d9617c45b86231 
  ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out 45c4e3f153bd7d55e2f09c83fc989fd12fbf9b80 
  ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out 58ab2c08554f4b2b4d06e79de22845445fc3c0e5 
  ql/src/test/results/clientpositive/tez/explainuser_1.q.out 8c78fd9d7f23f5272d88e83378485c83605c5b5a 
  ql/src/test/results/clientpositive/tez/explainuser_2.q.out eb7d564b774d5c486cd9e47086b2ef750ce17dd5 
  ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out 3534a9cdcfe0ae1ee3404a9aa80131a0cedf265e 
  ql/src/test/results/clientpositive/tez/mergejoin.q.out 4b2d9635fe602fa6aa03d20d32bb57770a92ac39 
  ql/src/test/results/clientpositive/tez/skewjoin.q.out fc084cc5b8c798ceb6bfc84ad1b29ca5d3c91f48 
  ql/src/test/results/clientpositive/tez/subquery_exists.q.out 5121a144c1d6c2c28890cd742e59d3c1bb868c9a 
  ql/src/test/results/clientpositive/tez/subquery_in.q.out a4887e4e69fd8d2734583586a67daf1bfeacf8ac 
  ql/src/test/results/clientpositive/tez/tez_dynpart_hashjoin_1.q.out e3131d5071c891b35340d040efb44ab3ea10a46c 
  ql/src/test/results/clientpositive/tez/tez_join_hash.q.out 0202def4353e4bd492552a378ba0e83b360d6306 
  ql/src/test/results/clientpositive/tez/tez_smb_empty.q.out 8c9ab2eda3b88362f38bf795e001dfc72ca52a73 
  ql/src/test/results/clientpositive/tez/tez_smb_main.q.out b7110898237bb049f8fd78ce777c78315052c598 
  ql/src/test/results/clientpositive/tez/tez_vector_dynpart_hashjoin_1.q.out 3711a10f425ba54153cf4fbca02ba86a09b401f6 
  ql/src/test/results/clientpositive/tez/vector_decimal_round.q.out 5bc04d7e02fa7b70050116ba8f1d062877691ae0 
  ql/src/test/results/clientpositive/tez/vector_groupby_mapjoin.q.out dedcec8aed37d2c03c4cd754d74112c474d5643a 
  ql/src/test/results/clientpositive/tez/vector_interval_mapjoin.q.out 42ce4996b5836759dcc4fb47523809abb57c81ee 
  ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out 7eb28f8e2a5af32075e2fa1a1ad89af092a36e90 
  ql/src/test/results/clientpositive/tez/vector_mr_diff_schema_alias.q.out f60a5840d013154849f68769aa1050c98a893667 
  ql/src/test/results/clientpositive/tez/vectorized_context.q.out 0eb48021eea290c7bb675d906722242645dc3517 
  ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out cda76db1f9966a0b1969381faa3ad035568edb84 
  ql/src/test/results/clientpositive/tez/vectorized_nested_mapjoin.q.out e1e95e7786cbbb7d2625ab52394d1b690d542112 
  ql/src/test/results/clientpositive/udf1.q.out b3b694b8794ac6eb3fe6d0bbc29e51e7602f16e8 
  ql/src/test/results/clientpositive/udf_10_trims.q.out 3a5303adfe8450adff1eeb7f32f83b1150979c09 
  ql/src/test/results/clientpositive/udf_folder_constants.q.out ef07420325dd2d99322f4fc150951798dcdeafaa 
  ql/src/test/results/clientpositive/union_remove_25.q.out 3869735f9f83a1c5538403f5563369eee7d77be9 
  ql/src/test/results/clientpositive/union_view.q.out 1d93159e2b2c1ede1c090fb82db1928872fd2c61 
  ql/src/test/results/clientpositive/vector_decimal_round.q.out ec6226ea74ece7b4129428dcf98d6f7af8f55e6e 
  ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out 367eb5983b2a57322d22a84c4afd39e4e2080345 
  ql/src/test/results/clientpositive/vector_interval_mapjoin.q.out 7cd7eb0c709831b1b4b264203301d2593a5d79a6 
  ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out dd40f282c7392f4eb8ef674cb5f6629d41eacf01 
  ql/src/test/results/clientpositive/vector_mr_diff_schema_alias.q.out 81724dcdc99f4ae4344a3f67e14cd49e2039b7ef 
  ql/src/test/results/clientpositive/vectorized_context.q.out 2a37bc2c221e312abdea01242d7b4c013df7660d 
  ql/src/test/results/clientpositive/vectorized_nested_mapjoin.q.out b18cf9d918f5746da04f6315828675fe6d829c7f 

Diff: https://reviews.apache.org/r/42190/diff/


Testing
-------


Thanks,

Jesús Camacho Rodríguez

Re: Review Request 42190: HIVE-12478

Posted by Jesús Camacho Rodríguez <jc...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/42190/
-----------------------------------------------------------

(Updated Jan. 20, 2016, 3:39 p.m.)


Review request for hive and John Pullokkaran.


Bugs: HIVE-12478
    https://issues.apache.org/jira/browse/HIVE-12478


Repository: hive-git


Description
-------

Improve Hive/Calcite Trasitive Predicate inference


Diffs (updated)
-----

  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveCalciteUtil.java 4825a617876374085b6fac1192ba1531ec916bce 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveHepPlannerContext.java ad79aeec2fbc0454ab1ccc608944752d01324dca 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveVolcanoPlannerContext.java 8859fc268666cef1be283a9179aa0beb7ef1bdeb 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/cost/HiveCostModel.java d15d885d2348d666df069228a93d6c5f914c79df 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/cost/HiveVolcanoPlanner.java 8610edc5ddc00d523610fb29f5e504c3e876a542 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveJoin.java 27b1e76a104dc961cb4bce554602d90b3aa867e0 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveSemiJoin.java 35586768c2c2b81e4213495632e4457dd3d70443 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveUnion.java 8b57b3504c407b8a1e73d48ea240c4ec7558b327 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinAddNotNullRule.java de880ce26f1e172288f700c8566fbe71f42af115 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinPushTransitivePredicatesRule.java 703c8c6dbdfa281443cbcf7b08de2266697da8a9 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HivePreFilteringRule.java d37fc0e08d5e41b29539a990e6638385c1135eec 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveRulesRegistry.java 18a065e87e1ec266bf28b4ccfe10a1f863f847c2 
  ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java 3fefbd710c4bb81d5f746cd91889b532b0a6029f 
  ql/src/test/org/apache/hadoop/hive/ql/optimizer/calcite/TestCBORuleFiredOnlyOnce.java f1d8d1de00e9de7fa9ffea7d3aa2400e5073ac9c 
  ql/src/test/results/clientpositive/annotate_stats_select.q.out b158d8567f6cc02d990d175e93996239aba0c5ed 
  ql/src/test/results/clientpositive/auto_join12.q.out 8ef3664764d04f53f3685d8f66dc4a353776a488 
  ql/src/test/results/clientpositive/auto_join16.q.out c1da6d2968697d304311044d358f1af267dc6e60 
  ql/src/test/results/clientpositive/bucketizedhiveinputformat.q.out cfb95be72b32a354faeddc79dc52bc29c7593a2b 
  ql/src/test/results/clientpositive/cast1.q.out 48a0c14031ef38dd5b4df7efa718a4d6ce04bc94 
  ql/src/test/results/clientpositive/cbo_const.q.out adc5232a67b2243dd5f09acaf1f7c49baea5daad 
  ql/src/test/results/clientpositive/cbo_rp_cross_product_check_2.q.out f1707eb4146c55338500c1fcaf4ff7199750250f 
  ql/src/test/results/clientpositive/cbo_rp_lineage2.q.out 1b2a2ab1af5992753c37d053942ecb2ebf775921 
  ql/src/test/results/clientpositive/constprog_partitioner.q.out 08c0aebafe1644a5adbec6a56879b39617bfbf69 
  ql/src/test/results/clientpositive/correlationoptimizer13.q.out 61b7bcb675a80dc3267365c65545e107ecbe12d2 
  ql/src/test/results/clientpositive/correlationoptimizer8.q.out 368a1147d404ae9aab18a64618abf8ed7b3f7189 
  ql/src/test/results/clientpositive/correlationoptimizer9.q.out 104a97afbb6657255a027ff6d51101f6963c2358 
  ql/src/test/results/clientpositive/cross_product_check_1.q.out 05eb270a292ecd9fe03db77511a7e2a08a28204c 
  ql/src/test/results/clientpositive/cross_product_check_2.q.out a36560f23c1801f0bf988fa4e08dcf49376d8577 
  ql/src/test/results/clientpositive/dynamic_rdd_cache.q.out 743865e073e1768f7f6234fde35ad2e56d8babe9 
  ql/src/test/results/clientpositive/filter_join_breaktask.q.out 53e9031d4219911f314bb31b74fe4931a32c65b0 
  ql/src/test/results/clientpositive/groupby_position.q.out c2566f2ad5d426db8814b7ca85207807f4a5afc7 
  ql/src/test/results/clientpositive/groupby_ppd.q.out d17c4b6d9e88d49d64b9725be1e51ca258ad1167 
  ql/src/test/results/clientpositive/index_auto_mult_tables.q.out 8c71925fbc5352f42abb280fc45a1d5a5713ebad 
  ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out b3e698927689dad5229165189779300cb8beca9b 
  ql/src/test/results/clientpositive/input_part1.q.out 501f7a9f87c66a1dd1d0fec0546597d810c0dbe9 
  ql/src/test/results/clientpositive/input_part5.q.out c6ae2fd58d7d41e4b4c0f764de3e28484917cd97 
  ql/src/test/results/clientpositive/input_part6.q.out c01d8afb6230440103ed8c1ecb38aea9eaabc832 
  ql/src/test/results/clientpositive/join12.q.out 8217c86d0e41c78b8bf4ed120b30a85204fa9915 
  ql/src/test/results/clientpositive/join16.q.out 244eb46dc0ae3b61ed932f043a98bb64295776a1 
  ql/src/test/results/clientpositive/join34.q.out e2c2b1a5ab742e26d953f11919e150f847a05157 
  ql/src/test/results/clientpositive/join35.q.out 663642c7d1c00a47993c497ac76d6f036221f06b 
  ql/src/test/results/clientpositive/join42.q.out 6e09e38102129edb7246b0a027c86ba1deed066c 
  ql/src/test/results/clientpositive/lineage2.q.out a189f82a3d29cd3b1e21a43afc85ef14fd74c79e 
  ql/src/test/results/clientpositive/lineage3.q.out f1162a213eea285a5d166731e0ce7e407f4106a7 
  ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out 3dea672a11b65e9040d0d794bf03408fd6e3a755 
  ql/src/test/results/clientpositive/llap/bucket_map_join_tez1.q.out 1fb76d8a8f32e0d63eba743d6007ffc7691b9b30 
  ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_1.q.out b459692b443a1686def6615e9e9bcce5922335c3 
  ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out 6a57f1fd82ef3e3cf681138383534e7fea1c07df 
  ql/src/test/results/clientpositive/louter_join_ppr.q.out 553def9bb50e7e9c7e80bc422dc7bad56c5b5998 
  ql/src/test/results/clientpositive/mergejoins.q.out 901041083f3182497361b8f27ed77c093e7ce237 
  ql/src/test/results/clientpositive/mergejoins_mixed.q.out 10f37f9fe34d79987333e3f8bb01166304fe5894 
  ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out 90032fe53d37163e09fbf2b1bf7dac0e55b80b18 
  ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out 7c5be6dbe636f6cfcf8f4a3563d2b204d3cb2b46 
  ql/src/test/results/clientpositive/partition_multilevels.q.out 699c1790314f0ea3bff2eae4aa6f3231eddead51 
  ql/src/test/results/clientpositive/perf/query31.q.out 909d64cef12a9492c5d24ef5876609a77423d2d5 
  ql/src/test/results/clientpositive/perf/query39.q.out 9f3e650943c1d7ab04fc521509ca9372e4105a25 
  ql/src/test/results/clientpositive/perf/query40.q.out b2d6262d96b7dc1c25748a758af61988b39d7c45 
  ql/src/test/results/clientpositive/perf/query42.q.out 9ede45d24587228328671a40e9b3f9ca43e2a550 
  ql/src/test/results/clientpositive/perf/query52.q.out 7e7224ba54b49a68040a536adca665a8f510bdd7 
  ql/src/test/results/clientpositive/perf/query64.q.out 9331673a663e9b31bfb00b443c4ae282ffe67e56 
  ql/src/test/results/clientpositive/perf/query66.q.out a25664e73afb1088e05ec3912dab253720bc4af4 
  ql/src/test/results/clientpositive/perf/query72.q.out bb56f0d695ede28d37b210fc1c6293444038154e 
  ql/src/test/results/clientpositive/perf/query75.q.out f3f9827a532b445e59642cbf9d169dc4147e03d2 
  ql/src/test/results/clientpositive/perf/query80.q.out 37cb542f008b21b26e2bdd03aac7144b7352893b 
  ql/src/test/results/clientpositive/perf/query85.q.out 54061ced073090cec35111081f21ac510d0bde92 
  ql/src/test/results/clientpositive/perf/query94.q.out 0357835f7f5e565f560e73506b10345c0fe089ff 
  ql/src/test/results/clientpositive/pointlookup2.q.out 1cfa4b6345ab48f6cac437a2dbefc657016a4b6d 
  ql/src/test/results/clientpositive/ppd_join2.q.out c5036525a685b5e76157dbf88a9e614727cb69ac 
  ql/src/test/results/clientpositive/ppd_join3.q.out 0000db129c9428e34935397ab5c51f010987eca3 
  ql/src/test/results/clientpositive/ppd_outer_join2.q.out 82e4ef5332e6d178ab19a544179f415ffd9efede 
  ql/src/test/results/clientpositive/ppd_outer_join3.q.out de82fe0ee9d7480c693b87f22e4f9a82b509e9a4 
  ql/src/test/results/clientpositive/ppd_outer_join4.q.out 289798c5bc0113ea4864e2c287001805a8fc1ea9 
  ql/src/test/results/clientpositive/ppd_outer_join5.q.out 35fec7a46606b0489d9c4e9c472a26607b17a177 
  ql/src/test/results/clientpositive/ppd_udf_case.q.out 2b407a63d8b51cfedc020459240150b97044ffc3 
  ql/src/test/results/clientpositive/ppd_union_view.q.out d33cbd6b7b024fc789e3477e35afaeb7a58f052b 
  ql/src/test/results/clientpositive/quotedid_basic.q.out 3c81e0bccce92d489d4f2eec874826a1d232c7be 
  ql/src/test/results/clientpositive/quotedid_partition.q.out a83c62b1826786f5213c8556bd275e4bd545fb6a 
  ql/src/test/results/clientpositive/router_join_ppr.q.out 7182f8deb6f74fc9250d6d55816c8a1debcb76ae 
  ql/src/test/results/clientpositive/semijoin4.q.out 7489de2ebcc3d044b22cc2c64d4747b51285d111 
  ql/src/test/results/clientpositive/skewjoin.q.out 4e98dfd9e7aedd8cffbe1aee64c03d62741763d7 
  ql/src/test/results/clientpositive/spark/auto_join12.q.out 158e53511f43bd12fc006bd595c4dab48dc1cf94 
  ql/src/test/results/clientpositive/spark/auto_join16.q.out ba6336aaa5213f0dcd292bd1fb07c9582fb1c6fd 
  ql/src/test/results/clientpositive/spark/bucket_map_join_tez1.q.out 57a89d67b56cc36dda8b42f21481e9363cff297a 
  ql/src/test/results/clientpositive/spark/bucketizedhiveinputformat.q.out c8fc4d3ac6aacb8e7ce59792ab4f74cabde238e3 
  ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_7.q.out 0b64a8735a6e9a668650db8907abce38c31ab70e 
  ql/src/test/results/clientpositive/spark/constprog_partitioner.q.out 8a6ab825c2be8e5a7d9715e93545421b7f16e1df 
  ql/src/test/results/clientpositive/spark/cross_product_check_1.q.out 5e67607241b1c029e40ec82edb09ddad394af67c 
  ql/src/test/results/clientpositive/spark/cross_product_check_2.q.out e8bcd7a6f346bfa02b4031abb6221bd65f7d15b4 
  ql/src/test/results/clientpositive/spark/dynamic_rdd_cache.q.out 6e595ff4b19d188b041394aff5df6d93614fe813 
  ql/src/test/results/clientpositive/spark/filter_join_breaktask.q.out 17a01c6860715fd4e30507b2ee02c97fe33c68ee 
  ql/src/test/results/clientpositive/spark/groupby_position.q.out 415703f638ede1e113fd3f7864f2f8688302c38d 
  ql/src/test/results/clientpositive/spark/join12.q.out 2ad0a43853e832fe7d16678d38e6b5b1f43f467f 
  ql/src/test/results/clientpositive/spark/join16.q.out 2496ec2904272923c346d746f6150a34ffee63be 
  ql/src/test/results/clientpositive/spark/join34.q.out a4cbc79b4755c0ab74177e7804bb4e16204345c2 
  ql/src/test/results/clientpositive/spark/join35.q.out 598143f021681214e5da79f87c76dd676281f6a1 
  ql/src/test/results/clientpositive/spark/louter_join_ppr.q.out 7f72b760929384c59d2e48827ff4ff652eb2b443 
  ql/src/test/results/clientpositive/spark/mergejoins.q.out e6872400b45cadc969ef897cf42c38dd23b9581f 
  ql/src/test/results/clientpositive/spark/mergejoins_mixed.q.out 42ffebfde50472f1aec060c33037fe851921e88c 
  ql/src/test/results/clientpositive/spark/ppd_join2.q.out 5848609e67bedffbffe7cb8028588017eaf327a6 
  ql/src/test/results/clientpositive/spark/ppd_join3.q.out c78d4cb4580d17946375f6ee5b6c447741d7c6f4 
  ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out 869596140ea9878c41eb3d44643f1f5c0e682dc3 
  ql/src/test/results/clientpositive/spark/ppd_outer_join3.q.out 4a8c58cfaa3257b69398457c43e16cbfe630bb15 
  ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out 8d0830892ab997e489306ec2698e1c6fdf61996f 
  ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out 8e398580ac526c0acbd642bc91579fcea0d9b428 
  ql/src/test/results/clientpositive/spark/router_join_ppr.q.out 319dc0ad836129d2e551e3414ab52a74b9f49b8b 
  ql/src/test/results/clientpositive/spark/skewjoin.q.out b2460460da36e856655ca12706678378b976f059 
  ql/src/test/results/clientpositive/spark/subquery_exists.q.out 5f41ac7aeaa5425004a4cd56638f0961a5a78a7e 
  ql/src/test/results/clientpositive/spark/subquery_in.q.out 1d813f8ae53e6cccde25e864d168380568e02e7a 
  ql/src/test/results/clientpositive/spark/union_remove_25.q.out eb95cadde3f8f3006df4a1093bebf00dd55514f8 
  ql/src/test/results/clientpositive/spark/union_view.q.out 492f71b10b9e98cd9235fad4b40850b2aa2d9730 
  ql/src/test/results/clientpositive/spark/vector_mapjoin_reduce.q.out 296c256d09703a073a41a36dc96b526e78afb715 
  ql/src/test/results/clientpositive/subquery_exists.q.out f3a270589b7b50dd7ef2ec53d1bac7ae88f7f245 
  ql/src/test/results/clientpositive/subquery_in.q.out a374dc0f84aa78dcf099d8733b42f94e6cea7863 
  ql/src/test/results/clientpositive/subquery_notin.q.out e157ff4d511cd7a4729f3c1d39800e80788ee48a 
  ql/src/test/results/clientpositive/subquery_notin_having.q.java1.7.out 8f17b6c33b7842d805fa8fa412fed8149d3c219d 
  ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out e34a401ca41faae0f25e7f398ac5c078f8f34df8 
  ql/src/test/results/clientpositive/subquery_views.q.out 76e53d3be56f3f8c2422317585d441cd14665294 
  ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out 4703cec3fdcbb79bbc4b0365b97600e760ac2748 
  ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out d5530a579a011aefa2a7fea965d9617c45b86231 
  ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out 45c4e3f153bd7d55e2f09c83fc989fd12fbf9b80 
  ql/src/test/results/clientpositive/tez/explainuser_1.q.out 8c78fd9d7f23f5272d88e83378485c83605c5b5a 
  ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out 01686416d3fc66bcc6cfa02b29f99c554c918a1f 
  ql/src/test/results/clientpositive/tez/skewjoin.q.out fc084cc5b8c798ceb6bfc84ad1b29ca5d3c91f48 
  ql/src/test/results/clientpositive/tez/subquery_exists.q.out 5121a144c1d6c2c28890cd742e59d3c1bb868c9a 
  ql/src/test/results/clientpositive/tez/subquery_in.q.out a4887e4e69fd8d2734583586a67daf1bfeacf8ac 
  ql/src/test/results/clientpositive/tez/tez_dynpart_hashjoin_1.q.out e3131d5071c891b35340d040efb44ab3ea10a46c 
  ql/src/test/results/clientpositive/tez/tez_smb_empty.q.out 8c9ab2eda3b88362f38bf795e001dfc72ca52a73 
  ql/src/test/results/clientpositive/tez/tez_vector_dynpart_hashjoin_1.q.out 3711a10f425ba54153cf4fbca02ba86a09b401f6 
  ql/src/test/results/clientpositive/tez/vector_decimal_round.q.out 5bc04d7e02fa7b70050116ba8f1d062877691ae0 
  ql/src/test/results/clientpositive/tez/vector_groupby_mapjoin.q.out dedcec8aed37d2c03c4cd754d74112c474d5643a 
  ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out 7eb28f8e2a5af32075e2fa1a1ad89af092a36e90 
  ql/src/test/results/clientpositive/udf1.q.out b3b694b8794ac6eb3fe6d0bbc29e51e7602f16e8 
  ql/src/test/results/clientpositive/udf_10_trims.q.out 3a5303adfe8450adff1eeb7f32f83b1150979c09 
  ql/src/test/results/clientpositive/udf_folder_constants.q.out ef07420325dd2d99322f4fc150951798dcdeafaa 
  ql/src/test/results/clientpositive/union_remove_25.q.out 3869735f9f83a1c5538403f5563369eee7d77be9 
  ql/src/test/results/clientpositive/union_view.q.out 1d93159e2b2c1ede1c090fb82db1928872fd2c61 
  ql/src/test/results/clientpositive/vector_decimal_round.q.out ec6226ea74ece7b4129428dcf98d6f7af8f55e6e 
  ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out 367eb5983b2a57322d22a84c4afd39e4e2080345 
  ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out dd40f282c7392f4eb8ef674cb5f6629d41eacf01 

Diff: https://reviews.apache.org/r/42190/diff/


Testing
-------


Thanks,

Jesús Camacho Rodríguez

Re: Review Request 42190: HIVE-12478

Posted by Jesús Camacho Rodríguez <jc...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/42190/
-----------------------------------------------------------

(Updated Jan. 19, 2016, 2:07 p.m.)


Review request for hive and John Pullokkaran.


Bugs: HIVE-12478
    https://issues.apache.org/jira/browse/HIVE-12478


Repository: hive-git


Description
-------

Improve Hive/Calcite Trasitive Predicate inference


Diffs (updated)
-----

  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveCalciteUtil.java 4825a617876374085b6fac1192ba1531ec916bce 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/cost/HiveCostModel.java d15d885d2348d666df069228a93d6c5f914c79df 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveJoin.java 27b1e76a104dc961cb4bce554602d90b3aa867e0 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveSemiJoin.java 35586768c2c2b81e4213495632e4457dd3d70443 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveUnion.java 8b57b3504c407b8a1e73d48ea240c4ec7558b327 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinAddNotNullRule.java de880ce26f1e172288f700c8566fbe71f42af115 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinPushTransitivePredicatesRule.java 703c8c6dbdfa281443cbcf7b08de2266697da8a9 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HivePreFilteringRule.java d37fc0e08d5e41b29539a990e6638385c1135eec 
  ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java 1c44ade230681eab40222995ab3d9133b9097548 
  ql/src/test/results/clientpositive/annotate_stats_select.q.out b158d8567f6cc02d990d175e93996239aba0c5ed 
  ql/src/test/results/clientpositive/auto_join12.q.out 8ef3664764d04f53f3685d8f66dc4a353776a488 
  ql/src/test/results/clientpositive/auto_join16.q.out c1da6d2968697d304311044d358f1af267dc6e60 
  ql/src/test/results/clientpositive/bucketizedhiveinputformat.q.out cfb95be72b32a354faeddc79dc52bc29c7593a2b 
  ql/src/test/results/clientpositive/cast1.q.out 48a0c14031ef38dd5b4df7efa718a4d6ce04bc94 
  ql/src/test/results/clientpositive/cbo_const.q.out adc5232a67b2243dd5f09acaf1f7c49baea5daad 
  ql/src/test/results/clientpositive/cbo_rp_cross_product_check_2.q.out f1707eb4146c55338500c1fcaf4ff7199750250f 
  ql/src/test/results/clientpositive/cbo_rp_lineage2.q.out 1b2a2ab1af5992753c37d053942ecb2ebf775921 
  ql/src/test/results/clientpositive/constprog_partitioner.q.out 08c0aebafe1644a5adbec6a56879b39617bfbf69 
  ql/src/test/results/clientpositive/correlationoptimizer13.q.out 61b7bcb675a80dc3267365c65545e107ecbe12d2 
  ql/src/test/results/clientpositive/correlationoptimizer8.q.out 368a1147d404ae9aab18a64618abf8ed7b3f7189 
  ql/src/test/results/clientpositive/correlationoptimizer9.q.out 104a97afbb6657255a027ff6d51101f6963c2358 
  ql/src/test/results/clientpositive/cross_product_check_1.q.out 05eb270a292ecd9fe03db77511a7e2a08a28204c 
  ql/src/test/results/clientpositive/cross_product_check_2.q.out a36560f23c1801f0bf988fa4e08dcf49376d8577 
  ql/src/test/results/clientpositive/dynamic_rdd_cache.q.out 743865e073e1768f7f6234fde35ad2e56d8babe9 
  ql/src/test/results/clientpositive/filter_join_breaktask.q.out 53e9031d4219911f314bb31b74fe4931a32c65b0 
  ql/src/test/results/clientpositive/groupby_position.q.out c2566f2ad5d426db8814b7ca85207807f4a5afc7 
  ql/src/test/results/clientpositive/groupby_ppd.q.out d17c4b6d9e88d49d64b9725be1e51ca258ad1167 
  ql/src/test/results/clientpositive/index_auto_mult_tables.q.out 8c71925fbc5352f42abb280fc45a1d5a5713ebad 
  ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out b3e698927689dad5229165189779300cb8beca9b 
  ql/src/test/results/clientpositive/input_part1.q.out 501f7a9f87c66a1dd1d0fec0546597d810c0dbe9 
  ql/src/test/results/clientpositive/input_part5.q.out c6ae2fd58d7d41e4b4c0f764de3e28484917cd97 
  ql/src/test/results/clientpositive/input_part6.q.out c01d8afb6230440103ed8c1ecb38aea9eaabc832 
  ql/src/test/results/clientpositive/join12.q.out 8217c86d0e41c78b8bf4ed120b30a85204fa9915 
  ql/src/test/results/clientpositive/join16.q.out 244eb46dc0ae3b61ed932f043a98bb64295776a1 
  ql/src/test/results/clientpositive/join34.q.out e2c2b1a5ab742e26d953f11919e150f847a05157 
  ql/src/test/results/clientpositive/join35.q.out 663642c7d1c00a47993c497ac76d6f036221f06b 
  ql/src/test/results/clientpositive/join42.q.out 6e09e38102129edb7246b0a027c86ba1deed066c 
  ql/src/test/results/clientpositive/lineage2.q.out a189f82a3d29cd3b1e21a43afc85ef14fd74c79e 
  ql/src/test/results/clientpositive/lineage3.q.out f1162a213eea285a5d166731e0ce7e407f4106a7 
  ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out 3dea672a11b65e9040d0d794bf03408fd6e3a755 
  ql/src/test/results/clientpositive/llap/bucket_map_join_tez1.q.out 1fb76d8a8f32e0d63eba743d6007ffc7691b9b30 
  ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_1.q.out b459692b443a1686def6615e9e9bcce5922335c3 
  ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out 6a57f1fd82ef3e3cf681138383534e7fea1c07df 
  ql/src/test/results/clientpositive/louter_join_ppr.q.out 553def9bb50e7e9c7e80bc422dc7bad56c5b5998 
  ql/src/test/results/clientpositive/mergejoins.q.out 901041083f3182497361b8f27ed77c093e7ce237 
  ql/src/test/results/clientpositive/mergejoins_mixed.q.out 10f37f9fe34d79987333e3f8bb01166304fe5894 
  ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out 90032fe53d37163e09fbf2b1bf7dac0e55b80b18 
  ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out 7c5be6dbe636f6cfcf8f4a3563d2b204d3cb2b46 
  ql/src/test/results/clientpositive/partition_multilevels.q.out 699c1790314f0ea3bff2eae4aa6f3231eddead51 
  ql/src/test/results/clientpositive/perf/query31.q.out 909d64cef12a9492c5d24ef5876609a77423d2d5 
  ql/src/test/results/clientpositive/perf/query39.q.out 9f3e650943c1d7ab04fc521509ca9372e4105a25 
  ql/src/test/results/clientpositive/perf/query40.q.out b2d6262d96b7dc1c25748a758af61988b39d7c45 
  ql/src/test/results/clientpositive/perf/query42.q.out 9ede45d24587228328671a40e9b3f9ca43e2a550 
  ql/src/test/results/clientpositive/perf/query52.q.out 7e7224ba54b49a68040a536adca665a8f510bdd7 
  ql/src/test/results/clientpositive/perf/query64.q.out 9331673a663e9b31bfb00b443c4ae282ffe67e56 
  ql/src/test/results/clientpositive/perf/query66.q.out a25664e73afb1088e05ec3912dab253720bc4af4 
  ql/src/test/results/clientpositive/perf/query72.q.out bb56f0d695ede28d37b210fc1c6293444038154e 
  ql/src/test/results/clientpositive/perf/query75.q.out f3f9827a532b445e59642cbf9d169dc4147e03d2 
  ql/src/test/results/clientpositive/perf/query80.q.out 37cb542f008b21b26e2bdd03aac7144b7352893b 
  ql/src/test/results/clientpositive/perf/query85.q.out 54061ced073090cec35111081f21ac510d0bde92 
  ql/src/test/results/clientpositive/perf/query94.q.out 0357835f7f5e565f560e73506b10345c0fe089ff 
  ql/src/test/results/clientpositive/pointlookup2.q.out 1cfa4b6345ab48f6cac437a2dbefc657016a4b6d 
  ql/src/test/results/clientpositive/ppd_join2.q.out c5036525a685b5e76157dbf88a9e614727cb69ac 
  ql/src/test/results/clientpositive/ppd_join3.q.out 0000db129c9428e34935397ab5c51f010987eca3 
  ql/src/test/results/clientpositive/ppd_outer_join2.q.out 82e4ef5332e6d178ab19a544179f415ffd9efede 
  ql/src/test/results/clientpositive/ppd_outer_join3.q.out de82fe0ee9d7480c693b87f22e4f9a82b509e9a4 
  ql/src/test/results/clientpositive/ppd_outer_join4.q.out 289798c5bc0113ea4864e2c287001805a8fc1ea9 
  ql/src/test/results/clientpositive/ppd_outer_join5.q.out 35fec7a46606b0489d9c4e9c472a26607b17a177 
  ql/src/test/results/clientpositive/ppd_udf_case.q.out 2b407a63d8b51cfedc020459240150b97044ffc3 
  ql/src/test/results/clientpositive/ppd_union_view.q.out d33cbd6b7b024fc789e3477e35afaeb7a58f052b 
  ql/src/test/results/clientpositive/quotedid_basic.q.out 3c81e0bccce92d489d4f2eec874826a1d232c7be 
  ql/src/test/results/clientpositive/quotedid_partition.q.out a83c62b1826786f5213c8556bd275e4bd545fb6a 
  ql/src/test/results/clientpositive/router_join_ppr.q.out 7182f8deb6f74fc9250d6d55816c8a1debcb76ae 
  ql/src/test/results/clientpositive/skewjoin.q.out 4e98dfd9e7aedd8cffbe1aee64c03d62741763d7 
  ql/src/test/results/clientpositive/spark/auto_join12.q.out 158e53511f43bd12fc006bd595c4dab48dc1cf94 
  ql/src/test/results/clientpositive/spark/auto_join16.q.out ba6336aaa5213f0dcd292bd1fb07c9582fb1c6fd 
  ql/src/test/results/clientpositive/spark/bucket_map_join_tez1.q.out 57a89d67b56cc36dda8b42f21481e9363cff297a 
  ql/src/test/results/clientpositive/spark/bucketizedhiveinputformat.q.out c8fc4d3ac6aacb8e7ce59792ab4f74cabde238e3 
  ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_7.q.out 0b64a8735a6e9a668650db8907abce38c31ab70e 
  ql/src/test/results/clientpositive/spark/constprog_partitioner.q.out 8a6ab825c2be8e5a7d9715e93545421b7f16e1df 
  ql/src/test/results/clientpositive/spark/cross_product_check_1.q.out 5e67607241b1c029e40ec82edb09ddad394af67c 
  ql/src/test/results/clientpositive/spark/cross_product_check_2.q.out e8bcd7a6f346bfa02b4031abb6221bd65f7d15b4 
  ql/src/test/results/clientpositive/spark/dynamic_rdd_cache.q.out 6e595ff4b19d188b041394aff5df6d93614fe813 
  ql/src/test/results/clientpositive/spark/filter_join_breaktask.q.out 17a01c6860715fd4e30507b2ee02c97fe33c68ee 
  ql/src/test/results/clientpositive/spark/groupby_position.q.out 415703f638ede1e113fd3f7864f2f8688302c38d 
  ql/src/test/results/clientpositive/spark/join12.q.out 2ad0a43853e832fe7d16678d38e6b5b1f43f467f 
  ql/src/test/results/clientpositive/spark/join16.q.out 2496ec2904272923c346d746f6150a34ffee63be 
  ql/src/test/results/clientpositive/spark/join34.q.out a4cbc79b4755c0ab74177e7804bb4e16204345c2 
  ql/src/test/results/clientpositive/spark/join35.q.out 598143f021681214e5da79f87c76dd676281f6a1 
  ql/src/test/results/clientpositive/spark/louter_join_ppr.q.out 7f72b760929384c59d2e48827ff4ff652eb2b443 
  ql/src/test/results/clientpositive/spark/mergejoins.q.out e6872400b45cadc969ef897cf42c38dd23b9581f 
  ql/src/test/results/clientpositive/spark/mergejoins_mixed.q.out 42ffebfde50472f1aec060c33037fe851921e88c 
  ql/src/test/results/clientpositive/spark/ppd_join2.q.out 5848609e67bedffbffe7cb8028588017eaf327a6 
  ql/src/test/results/clientpositive/spark/ppd_join3.q.out c78d4cb4580d17946375f6ee5b6c447741d7c6f4 
  ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out 869596140ea9878c41eb3d44643f1f5c0e682dc3 
  ql/src/test/results/clientpositive/spark/ppd_outer_join3.q.out 4a8c58cfaa3257b69398457c43e16cbfe630bb15 
  ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out 8d0830892ab997e489306ec2698e1c6fdf61996f 
  ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out 8e398580ac526c0acbd642bc91579fcea0d9b428 
  ql/src/test/results/clientpositive/spark/router_join_ppr.q.out 319dc0ad836129d2e551e3414ab52a74b9f49b8b 
  ql/src/test/results/clientpositive/spark/skewjoin.q.out b2460460da36e856655ca12706678378b976f059 
  ql/src/test/results/clientpositive/spark/subquery_exists.q.out 5f41ac7aeaa5425004a4cd56638f0961a5a78a7e 
  ql/src/test/results/clientpositive/spark/subquery_in.q.out 1d813f8ae53e6cccde25e864d168380568e02e7a 
  ql/src/test/results/clientpositive/spark/union_remove_25.q.out eb95cadde3f8f3006df4a1093bebf00dd55514f8 
  ql/src/test/results/clientpositive/spark/union_view.q.out 492f71b10b9e98cd9235fad4b40850b2aa2d9730 
  ql/src/test/results/clientpositive/spark/vector_mapjoin_reduce.q.out 296c256d09703a073a41a36dc96b526e78afb715 
  ql/src/test/results/clientpositive/subquery_exists.q.out f3a270589b7b50dd7ef2ec53d1bac7ae88f7f245 
  ql/src/test/results/clientpositive/subquery_in.q.out a374dc0f84aa78dcf099d8733b42f94e6cea7863 
  ql/src/test/results/clientpositive/subquery_notin.q.out e157ff4d511cd7a4729f3c1d39800e80788ee48a 
  ql/src/test/results/clientpositive/subquery_notin_having.q.java1.7.out 8f17b6c33b7842d805fa8fa412fed8149d3c219d 
  ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out e34a401ca41faae0f25e7f398ac5c078f8f34df8 
  ql/src/test/results/clientpositive/subquery_views.q.out 76e53d3be56f3f8c2422317585d441cd14665294 
  ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out 4703cec3fdcbb79bbc4b0365b97600e760ac2748 
  ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out d5530a579a011aefa2a7fea965d9617c45b86231 
  ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out 45c4e3f153bd7d55e2f09c83fc989fd12fbf9b80 
  ql/src/test/results/clientpositive/tez/explainuser_1.q.out 8c78fd9d7f23f5272d88e83378485c83605c5b5a 
  ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out 01686416d3fc66bcc6cfa02b29f99c554c918a1f 
  ql/src/test/results/clientpositive/tez/skewjoin.q.out fc084cc5b8c798ceb6bfc84ad1b29ca5d3c91f48 
  ql/src/test/results/clientpositive/tez/subquery_exists.q.out 5121a144c1d6c2c28890cd742e59d3c1bb868c9a 
  ql/src/test/results/clientpositive/tez/subquery_in.q.out a4887e4e69fd8d2734583586a67daf1bfeacf8ac 
  ql/src/test/results/clientpositive/tez/tez_dynpart_hashjoin_1.q.out e3131d5071c891b35340d040efb44ab3ea10a46c 
  ql/src/test/results/clientpositive/tez/tez_smb_empty.q.out 8c9ab2eda3b88362f38bf795e001dfc72ca52a73 
  ql/src/test/results/clientpositive/tez/tez_vector_dynpart_hashjoin_1.q.out 3711a10f425ba54153cf4fbca02ba86a09b401f6 
  ql/src/test/results/clientpositive/tez/vector_decimal_round.q.out 5bc04d7e02fa7b70050116ba8f1d062877691ae0 
  ql/src/test/results/clientpositive/tez/vector_groupby_mapjoin.q.out dedcec8aed37d2c03c4cd754d74112c474d5643a 
  ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out 7eb28f8e2a5af32075e2fa1a1ad89af092a36e90 
  ql/src/test/results/clientpositive/udf1.q.out b3b694b8794ac6eb3fe6d0bbc29e51e7602f16e8 
  ql/src/test/results/clientpositive/udf_10_trims.q.out 3a5303adfe8450adff1eeb7f32f83b1150979c09 
  ql/src/test/results/clientpositive/udf_folder_constants.q.out ef07420325dd2d99322f4fc150951798dcdeafaa 
  ql/src/test/results/clientpositive/union_remove_25.q.out 3869735f9f83a1c5538403f5563369eee7d77be9 
  ql/src/test/results/clientpositive/union_view.q.out 1d93159e2b2c1ede1c090fb82db1928872fd2c61 
  ql/src/test/results/clientpositive/vector_decimal_round.q.out ec6226ea74ece7b4129428dcf98d6f7af8f55e6e 
  ql/src/test/results/clientpositive/vector_groupby_mapjoin.q.out 367eb5983b2a57322d22a84c4afd39e4e2080345 
  ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out dd40f282c7392f4eb8ef674cb5f6629d41eacf01 

Diff: https://reviews.apache.org/r/42190/diff/


Testing
-------


Thanks,

Jesús Camacho Rodríguez

Re: Review Request 42190: HIVE-12478

Posted by Jesús Camacho Rodríguez <jc...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/42190/
-----------------------------------------------------------

(Updated Jan. 12, 2016, 12:18 p.m.)


Review request for hive and John Pullokkaran.


Bugs: HIVE-12478
    https://issues.apache.org/jira/browse/HIVE-12478


Repository: hive-git


Description
-------

Improve Hive/Calcite Trasitive Predicate inference


Diffs (updated)
-----

  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveCalciteUtil.java 4825a617876374085b6fac1192ba1531ec916bce 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/HiveDefaultRelMetadataProvider.java c0609d7773a1e49cc85a1d542caa16d74ac76efe 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/cost/HiveCost.java 3c5cac2f5b98925e8840466fa9d83cd28125ee03 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/cost/HiveCostModel.java d15d885d2348d666df069228a93d6c5f914c79df 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/reloperators/HiveUnion.java 8b57b3504c407b8a1e73d48ea240c4ec7558b327 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveFilterMergeRule.java PRE-CREATION 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinAddNotNullRule.java de880ce26f1e172288f700c8566fbe71f42af115 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinPushTransitivePredicatesRule.java 703c8c6dbdfa281443cbcf7b08de2266697da8a9 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HivePreFilteringRule.java d37fc0e08d5e41b29539a990e6638385c1135eec 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveReduceExpressionsRule.java 50e139b4045ebac5a15bca05b1660dfeed4fe08c 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/stats/HiveRelMdSyntheticSelectivityCost.java PRE-CREATION 
  ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java f50f4d323220b1f90e33d5cf7daef9162998f5ec 
  ql/src/test/results/clientpositive/annotate_stats_select.q.out b158d8567f6cc02d990d175e93996239aba0c5ed 
  ql/src/test/results/clientpositive/auto_join12.q.out 8ef3664764d04f53f3685d8f66dc4a353776a488 
  ql/src/test/results/clientpositive/auto_join16.q.out c1da6d2968697d304311044d358f1af267dc6e60 
  ql/src/test/results/clientpositive/bucketizedhiveinputformat.q.out cfb95be72b32a354faeddc79dc52bc29c7593a2b 
  ql/src/test/results/clientpositive/cast1.q.out 48a0c14031ef38dd5b4df7efa718a4d6ce04bc94 
  ql/src/test/results/clientpositive/cbo_SortUnionTransposeRule.q.out eef23891f3a155fac60628ee47afa08d77fa3a2e 
  ql/src/test/results/clientpositive/cbo_const.q.out adc5232a67b2243dd5f09acaf1f7c49baea5daad 
  ql/src/test/results/clientpositive/cbo_rp_lineage2.q.out 1b2a2ab1af5992753c37d053942ecb2ebf775921 
  ql/src/test/results/clientpositive/constprog_partitioner.q.out 08c0aebafe1644a5adbec6a56879b39617bfbf69 
  ql/src/test/results/clientpositive/correlationoptimizer13.q.out 61b7bcb675a80dc3267365c65545e107ecbe12d2 
  ql/src/test/results/clientpositive/correlationoptimizer8.q.out 368a1147d404ae9aab18a64618abf8ed7b3f7189 
  ql/src/test/results/clientpositive/correlationoptimizer9.q.out 104a97afbb6657255a027ff6d51101f6963c2358 
  ql/src/test/results/clientpositive/dynamic_rdd_cache.q.out 743865e073e1768f7f6234fde35ad2e56d8babe9 
  ql/src/test/results/clientpositive/filter_cond_pushdown.q.out 5e0edbc9efb442467c4998021ac1ecfb9d07579d 
  ql/src/test/results/clientpositive/filter_join_breaktask.q.out 13d17aafa8fc15c980ffa7366a4ca8c7abe8fd50 
  ql/src/test/results/clientpositive/groupby_position.q.out c2566f2ad5d426db8814b7ca85207807f4a5afc7 
  ql/src/test/results/clientpositive/groupby_ppd.q.out d17c4b6d9e88d49d64b9725be1e51ca258ad1167 
  ql/src/test/results/clientpositive/groupby_sort_1_23.q.out 9c45602a3898cbef90ac13c8f65cca54cb9a7bd8 
  ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out ad263bc4cb9885e9d06c2ec4716a2cce56d11065 
  ql/src/test/results/clientpositive/index_auto_mult_tables.q.out 8c71925fbc5352f42abb280fc45a1d5a5713ebad 
  ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out b3e698927689dad5229165189779300cb8beca9b 
  ql/src/test/results/clientpositive/input_part1.q.out c5c46af6a69ffb8613fd7d3898ca32d3c6b802f4 
  ql/src/test/results/clientpositive/input_part5.q.out c6ae2fd58d7d41e4b4c0f764de3e28484917cd97 
  ql/src/test/results/clientpositive/input_part6.q.out c01d8afb6230440103ed8c1ecb38aea9eaabc832 
  ql/src/test/results/clientpositive/join12.q.out 8217c86d0e41c78b8bf4ed120b30a85204fa9915 
  ql/src/test/results/clientpositive/join16.q.out 244eb46dc0ae3b61ed932f043a98bb64295776a1 
  ql/src/test/results/clientpositive/join34.q.out 795dd3a39c989301efdb900f90a51d725e9dad6b 
  ql/src/test/results/clientpositive/join35.q.out c5231543e3e954c72274dc3fb9e3f0e83fce5516 
  ql/src/test/results/clientpositive/join42.q.out 6e09e38102129edb7246b0a027c86ba1deed066c 
  ql/src/test/results/clientpositive/lineage2.q.out a189f82a3d29cd3b1e21a43afc85ef14fd74c79e 
  ql/src/test/results/clientpositive/lineage3.q.out f1162a213eea285a5d166731e0ce7e407f4106a7 
  ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out 9c406a720398c14f7df09045a07f0cad5afa5437 
  ql/src/test/results/clientpositive/llap/bucket_map_join_tez1.q.out 1fb76d8a8f32e0d63eba743d6007ffc7691b9b30 
  ql/src/test/results/clientpositive/llap/dynamic_partition_pruning.q.out d2c11d7644570217532f9b366926d8cc94a03e6a 
  ql/src/test/results/clientpositive/llap/tez_dynpart_hashjoin_1.q.out b459692b443a1686def6615e9e9bcce5922335c3 
  ql/src/test/results/clientpositive/llap/tez_vector_dynpart_hashjoin_1.q.out 6a57f1fd82ef3e3cf681138383534e7fea1c07df 
  ql/src/test/results/clientpositive/llap/vectorized_dynamic_partition_pruning.q.out 63121a9e5b043e2c27fe08ee54e6fe01e2dd6cae 
  ql/src/test/results/clientpositive/louter_join_ppr.q.out 1f685ae7ae5989ab14f045fcafa99dabf54bc1e1 
  ql/src/test/results/clientpositive/mergejoin.q.out acf816ebc2db9df7f2878375dea3c403fb513c08 
  ql/src/test/results/clientpositive/mergejoins.q.out 901041083f3182497361b8f27ed77c093e7ce237 
  ql/src/test/results/clientpositive/mergejoins_mixed.q.out 10f37f9fe34d79987333e3f8bb01166304fe5894 
  ql/src/test/results/clientpositive/multiMapJoin1.q.out e2efec0295e2d15aa1497b848eb6eb8838617b7f 
  ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out 90032fe53d37163e09fbf2b1bf7dac0e55b80b18 
  ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out 7c5be6dbe636f6cfcf8f4a3563d2b204d3cb2b46 
  ql/src/test/results/clientpositive/partition_multilevels.q.out 699c1790314f0ea3bff2eae4aa6f3231eddead51 
  ql/src/test/results/clientpositive/perf/query31.q.out 909d64cef12a9492c5d24ef5876609a77423d2d5 
  ql/src/test/results/clientpositive/perf/query39.q.out 9f3e650943c1d7ab04fc521509ca9372e4105a25 
  ql/src/test/results/clientpositive/perf/query40.q.out b2d6262d96b7dc1c25748a758af61988b39d7c45 
  ql/src/test/results/clientpositive/perf/query42.q.out 9ede45d24587228328671a40e9b3f9ca43e2a550 
  ql/src/test/results/clientpositive/perf/query52.q.out 7e7224ba54b49a68040a536adca665a8f510bdd7 
  ql/src/test/results/clientpositive/perf/query58.q.out c2f71892ee7ceb68449c6c4f13754052041de106 
  ql/src/test/results/clientpositive/perf/query64.q.out 9331673a663e9b31bfb00b443c4ae282ffe67e56 
  ql/src/test/results/clientpositive/perf/query66.q.out a25664e73afb1088e05ec3912dab253720bc4af4 
  ql/src/test/results/clientpositive/perf/query72.q.out bb56f0d695ede28d37b210fc1c6293444038154e 
  ql/src/test/results/clientpositive/perf/query75.q.out f3f9827a532b445e59642cbf9d169dc4147e03d2 
  ql/src/test/results/clientpositive/perf/query80.q.out 37cb542f008b21b26e2bdd03aac7144b7352893b 
  ql/src/test/results/clientpositive/perf/query85.q.out 54061ced073090cec35111081f21ac510d0bde92 
  ql/src/test/results/clientpositive/perf/query94.q.out 0357835f7f5e565f560e73506b10345c0fe089ff 
  ql/src/test/results/clientpositive/pointlookup2.q.out 1d7efe8d86c067b2000be3a740658ba1d5e8b754 
  ql/src/test/results/clientpositive/ppd_join3.q.out 0000db129c9428e34935397ab5c51f010987eca3 
  ql/src/test/results/clientpositive/ppd_outer_join2.q.out 82e4ef5332e6d178ab19a544179f415ffd9efede 
  ql/src/test/results/clientpositive/ppd_outer_join3.q.out de82fe0ee9d7480c693b87f22e4f9a82b509e9a4 
  ql/src/test/results/clientpositive/ppd_outer_join4.q.out 289798c5bc0113ea4864e2c287001805a8fc1ea9 
  ql/src/test/results/clientpositive/ppd_outer_join5.q.out 35fec7a46606b0489d9c4e9c472a26607b17a177 
  ql/src/test/results/clientpositive/ppd_udf_case.q.out 2b407a63d8b51cfedc020459240150b97044ffc3 
  ql/src/test/results/clientpositive/ppd_union_view.q.out ba51cbd4db0021b30b3592f740b895b0e20aa59a 
  ql/src/test/results/clientpositive/quotedid_basic.q.out 3c81e0bccce92d489d4f2eec874826a1d232c7be 
  ql/src/test/results/clientpositive/quotedid_partition.q.out a83c62b1826786f5213c8556bd275e4bd545fb6a 
  ql/src/test/results/clientpositive/router_join_ppr.q.out b486f21385f45d12c15013c848d724202e97d014 
  ql/src/test/results/clientpositive/skewjoin.q.out 4e98dfd9e7aedd8cffbe1aee64c03d62741763d7 
  ql/src/test/results/clientpositive/spark/auto_join12.q.out 158e53511f43bd12fc006bd595c4dab48dc1cf94 
  ql/src/test/results/clientpositive/spark/auto_join16.q.out ba6336aaa5213f0dcd292bd1fb07c9582fb1c6fd 
  ql/src/test/results/clientpositive/spark/bucket_map_join_tez1.q.out 57a89d67b56cc36dda8b42f21481e9363cff297a 
  ql/src/test/results/clientpositive/spark/bucketsortoptimize_insert_7.q.out 0b64a8735a6e9a668650db8907abce38c31ab70e 
  ql/src/test/results/clientpositive/spark/dynamic_rdd_cache.q.out 6e595ff4b19d188b041394aff5df6d93614fe813 
  ql/src/test/results/clientpositive/spark/filter_join_breaktask.q.out 74742b2f8887baa23023a61a8b7497eafce0d967 
  ql/src/test/results/clientpositive/spark/groupby_position.q.out 415703f638ede1e113fd3f7864f2f8688302c38d 
  ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out 0b54b85ea01b464a931c1761583b4eed63558634 
  ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out 0b8ec5439d5d1e78b95dda349ddeaf58815e021f 
  ql/src/test/results/clientpositive/spark/join12.q.out 2ad0a43853e832fe7d16678d38e6b5b1f43f467f 
  ql/src/test/results/clientpositive/spark/join16.q.out 2496ec2904272923c346d746f6150a34ffee63be 
  ql/src/test/results/clientpositive/spark/join34.q.out 0f2c413dd59f8926bf0c37706d064a313d090d97 
  ql/src/test/results/clientpositive/spark/join35.q.out 0519689c9a78ef75aabfcf663d95a96033ab6ae0 
  ql/src/test/results/clientpositive/spark/louter_join_ppr.q.out c22158ca7130c3839ea0133fe84d92a3f04e791b 
  ql/src/test/results/clientpositive/spark/mergejoins.q.out e6872400b45cadc969ef897cf42c38dd23b9581f 
  ql/src/test/results/clientpositive/spark/mergejoins_mixed.q.out 42ffebfde50472f1aec060c33037fe851921e88c 
  ql/src/test/results/clientpositive/spark/ppd_join3.q.out c78d4cb4580d17946375f6ee5b6c447741d7c6f4 
  ql/src/test/results/clientpositive/spark/ppd_outer_join2.q.out 869596140ea9878c41eb3d44643f1f5c0e682dc3 
  ql/src/test/results/clientpositive/spark/ppd_outer_join3.q.out 4a8c58cfaa3257b69398457c43e16cbfe630bb15 
  ql/src/test/results/clientpositive/spark/ppd_outer_join4.q.out 8d0830892ab997e489306ec2698e1c6fdf61996f 
  ql/src/test/results/clientpositive/spark/ppd_outer_join5.q.out 8e398580ac526c0acbd642bc91579fcea0d9b428 
  ql/src/test/results/clientpositive/spark/router_join_ppr.q.out 620e5d200c05d1e9e884160170128d3f61fa231d 
  ql/src/test/results/clientpositive/spark/skewjoin.q.out b2460460da36e856655ca12706678378b976f059 
  ql/src/test/results/clientpositive/spark/subquery_exists.q.out 5f41ac7aeaa5425004a4cd56638f0961a5a78a7e 
  ql/src/test/results/clientpositive/spark/subquery_in.q.out 1d813f8ae53e6cccde25e864d168380568e02e7a 
  ql/src/test/results/clientpositive/spark/union_remove_25.q.out 91aa1f2758ef402ddc88f31936abbd0a09315333 
  ql/src/test/results/clientpositive/spark/union_view.q.out 492f71b10b9e98cd9235fad4b40850b2aa2d9730 
  ql/src/test/results/clientpositive/spark/vector_mapjoin_reduce.q.out 296c256d09703a073a41a36dc96b526e78afb715 
  ql/src/test/results/clientpositive/subquery_exists.q.out f3a270589b7b50dd7ef2ec53d1bac7ae88f7f245 
  ql/src/test/results/clientpositive/subquery_in.q.out a374dc0f84aa78dcf099d8733b42f94e6cea7863 
  ql/src/test/results/clientpositive/subquery_in_having.q.out 87c5a623dfa44e903710794634e459dc66bbd86a 
  ql/src/test/results/clientpositive/subquery_notexists.q.out 215d855f20d09b9e92da7a753cbce90760a73f0c 
  ql/src/test/results/clientpositive/subquery_notexists_having.q.out 637fc62941e6f8b4852c4b1a4d51d6b2517912a3 
  ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out e34a401ca41faae0f25e7f398ac5c078f8f34df8 
  ql/src/test/results/clientpositive/subquery_views.q.out 76e53d3be56f3f8c2422317585d441cd14665294 
  ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out 4703cec3fdcbb79bbc4b0365b97600e760ac2748 
  ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out 58ab2c08554f4b2b4d06e79de22845445fc3c0e5 
  ql/src/test/results/clientpositive/tez/explainuser_1.q.out 8c78fd9d7f23f5272d88e83378485c83605c5b5a 
  ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out bb0c6f1b2d3e09fea294457f609194505218dd6b 
  ql/src/test/results/clientpositive/tez/mergejoin.q.out 4b2d9635fe602fa6aa03d20d32bb57770a92ac39 
  ql/src/test/results/clientpositive/tez/skewjoin.q.out fc084cc5b8c798ceb6bfc84ad1b29ca5d3c91f48 
  ql/src/test/results/clientpositive/tez/subquery_exists.q.out 5121a144c1d6c2c28890cd742e59d3c1bb868c9a 
  ql/src/test/results/clientpositive/tez/subquery_in.q.out a4887e4e69fd8d2734583586a67daf1bfeacf8ac 
  ql/src/test/results/clientpositive/tez/tez_dynpart_hashjoin_1.q.out e3131d5071c891b35340d040efb44ab3ea10a46c 
  ql/src/test/results/clientpositive/tez/tez_smb_empty.q.out 8c9ab2eda3b88362f38bf795e001dfc72ca52a73 
  ql/src/test/results/clientpositive/tez/tez_vector_dynpart_hashjoin_1.q.out 3711a10f425ba54153cf4fbca02ba86a09b401f6 
  ql/src/test/results/clientpositive/tez/vector_decimal_round.q.out 5bc04d7e02fa7b70050116ba8f1d062877691ae0 
  ql/src/test/results/clientpositive/tez/vector_mapjoin_reduce.q.out 7eb28f8e2a5af32075e2fa1a1ad89af092a36e90 
  ql/src/test/results/clientpositive/tez/vectorized_dynamic_partition_pruning.q.out cda76db1f9966a0b1969381faa3ad035568edb84 
  ql/src/test/results/clientpositive/udf1.q.out b3b694b8794ac6eb3fe6d0bbc29e51e7602f16e8 
  ql/src/test/results/clientpositive/udf_10_trims.q.out 3a5303adfe8450adff1eeb7f32f83b1150979c09 
  ql/src/test/results/clientpositive/udf_folder_constants.q.out ef07420325dd2d99322f4fc150951798dcdeafaa 
  ql/src/test/results/clientpositive/udf_unix_timestamp.q.out c64379d3e501793620a0b3dd010a2ada4912a118 
  ql/src/test/results/clientpositive/union_remove_25.q.out d82fcfc726428347159d6186d9c7fdce6034980e 
  ql/src/test/results/clientpositive/union_view.q.out 1d93159e2b2c1ede1c090fb82db1928872fd2c61 
  ql/src/test/results/clientpositive/vector_decimal_round.q.out ec6226ea74ece7b4129428dcf98d6f7af8f55e6e 
  ql/src/test/results/clientpositive/vector_mapjoin_reduce.q.out dd40f282c7392f4eb8ef674cb5f6629d41eacf01 

Diff: https://reviews.apache.org/r/42190/diff/


Testing
-------


Thanks,

Jesús Camacho Rodríguez