[HIVE-9009] order by (limit) meaning for the last subquery of union in Hive is different from other main stream RDBMS

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2.0
• Assignee: Pengcheng Xiong Assign to me
• Reporter: Pengcheng Xiong
• Created: 02/Dec/14 18:51
• Updated: 18/May/15 19:55
• Resolved: 09/Feb/15 21:43

Description

Currently Hive will treat
select id from A
union all
select id from B
order by id
as
select id from A
union all
(select id from B
order by id)

However, it should be treated as

(select id from A
union all
select id from B)
order by id

Issue Links

• links to: RB