----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/40897/ -----------------------------------------------------------
Review request for hive. Bugs: HIVE-12566 https://issues.apache.org/jira/browse/HIVE-12566 Repository: hive-git Description ------- The pushing down of where clause to join condition should not be used in outer join. Otherwise, the initially matched rows from two joined tables might no longer match with more join conditions, and an extra row will result in some outer join cases. This patch is to disable the wher clasue pushdown in outer join. Diffs ----- ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java 69bb9d7 ql/src/test/queries/clientpositive/join_cond_pushdown_unqual5.q PRE-CREATION ql/src/test/results/clientpositive/join_cond_pushdown_unqual5.q.out PRE-CREATION Diff: https://reviews.apache.org/r/40897/diff/ Testing ------- 1. Manaual test cases passed and compared with other DBs like Oracle, MySQL 2. Precommit tests Thanks, Chaoyu Tang