[ 
https://issues.apache.org/jira/browse/PHOENIX-1580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14382099#comment-14382099
 ] 

Maryann Xue commented on PHOENIX-1580:
--------------------------------------

[~ayingshu] Not sure about the UNION grammar about column names, does it 
require columns have exactly the same names or aliases from each subquery? If 
yes, pushing down ORDER BY would be just as fine.
It is important that we need to push down ORDER BY and LIMIT, because that way 
we can leverage server sorting and return as few rows as possible from the 
server.


> 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-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)

Reply via email to