[HIVE-1398] Support union all without an outer select *

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.13.0
• Component/s: Query Processor
• Labels: SQL
• Assignee: Gunther Hagleitner
• Reporter: Ashish Thusoo
• Created: 09/Jun/10 22:12
• Updated: 10/Dec/14 00:09
• Resolved: 02/Dec/14 19:46

Description

In hive for union alls the query has to be wrapped in an sub query as shown below:

select * from
(select c1 from t1
union all
select c2 from t2);

This JIRA proposes to fix that to support

select c1 from t1
union all
select c2 from t2;

Issue Links

• blocks: HIVE-1386 HiveQL SQL Compliance (Umbrella)
• is superceded by: HIVE-6189 Support top level union all statements
• relates to: HIVE-9002 union all does not generate correct result for order by and limit