[ https://issues.apache.org/jira/browse/PHOENIX-1580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14387560#comment-14387560 ]
Alicia Ying Shu commented on PHOENIX-1580: ------------------------------------------ [~maryannxue] Thanks a lot for the response. If I understand right we should not use MergeSortTopNResultIterator if there is order by for Union all because the first N results coming back are not the final results. We should have all the results back and have a final Order by on them. Currently Order By and Limit have been pushed down to each subSelect. > Support UNION ALL > ----------------- > > Key: PHOENIX-1580 > URL: https://issues.apache.org/jira/browse/PHOENIX-1580 > Project: Phoenix > Issue Type: Bug > Reporter: Alicia Ying Shu > Assignee: Alicia Ying Shu > Attachments: PHOENIX-1580-grammar.patch, Phoenix-1580-v1.patch, > phoenix-1580-v1-wipe.patch, phoenix-1580.patch, unionall-wipe.patch > > > Select * from T1 > UNION ALL > Select * from T2 -- This message was sent by Atlassian JIRA (v6.3.4#6332)