hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pengcheng Xiong (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-9002) union all does not generate correct result for order by and limit
Date Tue, 02 Dec 2014 00:02:13 GMT
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)

Mime
View raw message