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

Reply via email to