[HIVE-9053] select constant in union all followed by group by gives wrong result

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.13.0, 0.14.0
• Fix Version/s: 1.0.0
• Assignee: Pengcheng Xiong
• Reporter: Pengcheng Xiong
• Created: 09/Dec/14 19:26
• Updated: 19/Feb/15 18:22
• Resolved: 15/Dec/14 01:18

Description

Here is the the way to reproduce with q test:

select key from (select '1' as key from src union all select key from src)tab group by key;

will give

OK
NULL
1

This is not correct as src contains many other keys.

Issue Links

• is related to: HIVE-9039 Support Union Distinct
• relates to: HIVE-9105 Hive-0.13 select constant in union all followed by group by gives wrong result
• relates to: HIVE-9106 improve the performance of null scan optimizer when several table scans share a physical path
• links to: RB