Pengcheng Xiong created HIVE-9002:
-------------------------------------
Summary: union all does not generate correct result for order by
and limit
Key: HIVE-9002
URL: https://issues.apache.org/jira/browse/HIVE-9002
Project: Hive
Issue Type: Bug
Reporter: Pengcheng Xiong
Assignee: Pengcheng Xiong
Right now if we have
select col from A
union all
select col from B [Operator]
it is treated as
(select col from A)
union all
(select col from B [Operator])
Although it is correct for where, group by (having) join operators, it is not
correct for order by and limit operators. They should be
(select col from A
union all
select col from B) [order by, limit]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
