[HIVE-3343] Hive: Query misaligned result for Group by followed by Join with filter and skip a group-by result

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.10.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Assignee: Gang Tim Liu
• Reporter: Gang Tim Liu
• Created: 08/Aug/12 00:02
• Updated: 10/Jan/13 19:53
• Resolved: 14/Aug/12 04:58

Description

This simple Hive query would generate wrong result:

select a.key, b.k2, b.k3
from src a
join (
select key,
min(key) as k,
min(key)+1 as k1,
min(key)+2 as k2,
min(key)+3 as k3
from src
group by key
) b
on a.key=b.key and b.k1 < 5;

0 3.0 1.0
0 3.0 1.0
0 3.0 1.0
2 5.0 3.0

The right result is:
0 2.0 3.0
0 2.0 3.0
0 2.0 3.0
2 4.0 5.0