[HIVE-5321] Join filters do not work correctly with outer joins again

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 0.9.0, 0.11.0
• Component/s: Query Processor
• Assignee: Unassigned
• Reporter: Alexander Pivovarov
• Created: 19/Sep/13 19:21
• Updated: 20/Sep/13 02:37
• Resolved: 20/Sep/13 00:15

Description

select * from tt1 left outer join tt2 on (tt1.c1 = tt2.c1 and tt1.c1 <= 2);
does not give correct results.

to reproduce:
hive> create table tt1 (c1 int);
hive> create table tt2 (c1 int);
$ vi tt1
1
2
3
4

$ vi tt2
1
2
8
9

$ hadoop fs -put tt1 /user/hive/warehouse/tt1/
$ hadoop fs -put tt2 /user/hive/warehouse/tt2/

wrong result:
hive> select * from tt1 left outer join tt2 on (tt1.c1 = tt2.c1 and tt1.c1 <= 2);
1 1
2 2
3 NULL
4 NULL

correct result:
select * from tt1 left outer join tt2 on (tt1.c1 = tt2.c1) where tt1.c1 <= 2;
1 1
2 2

hive-0.11.0-bin$ head -1 RELEASE_NOTES.txt
Release Notes - Hive - Version 0.11.0

Issue Links

• blocks: HIVE-1534 Join filters do not work correctly with outer joins