> 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 > >