----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/67800/ -----------------------------------------------------------
(Updated July 3, 2018, 6:49 a.m.) Review request for hive and Gopal V. Changes ------- Implemented recommended changes. Added order by in queries for predictable results. Bugs: HIVE-20039 https://issues.apache.org/jira/browse/HIVE-20039 Repository: hive-git Description ------- Bucket pruning: Left Outer Join on bucketed table gives wrong result. The context was reused by all the predicates. Instead use TS op directly. Diffs (updated) ----- data/files/bucket_pruning/l3_clarity__l3_monthly_dw_factplan_datajoin_1_s2_2018022300104_1/000000_0 PRE-CREATION data/files/bucket_pruning/l3_clarity__l3_monthly_dw_factplan_dw_stg_2018022300104_1/000000_0 PRE-CREATION data/files/bucket_pruning/l3_clarity__l3_snap_number_2018022300104/000000_0 PRE-CREATION data/files/bucket_pruning/l3_monthly_dw_dimplan/000056_0 PRE-CREATION ql/src/java/org/apache/hadoop/hive/ql/optimizer/FixedBucketPruningOptimizer.java 2debacacb5 ql/src/test/queries/clientpositive/tez_fixed_bucket_pruning.q PRE-CREATION ql/src/test/results/clientpositive/llap/tez_fixed_bucket_pruning.q.out PRE-CREATION Diff: https://reviews.apache.org/r/67800/diff/2/ Changes: https://reviews.apache.org/r/67800/diff/1-2/ Testing ------- Thanks, Deepak Jaiswal