[ https://issues.apache.org/jira/browse/PHOENIX-1580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14387687#comment-14387687 ]
James Taylor commented on PHOENIX-1580: --------------------------------------- Also, as Maryann pointed out, you'll need to compile the ORDER BY against the temporary schema you use to compile projection. If you have difficulty with this, [~maryannxue] can likely provide you a code snippet or pointer to help you with this. The reason you can't use the same ORDER BY expression from the inner statements is that those are executed on the server side against the PTable for the inner statement, while yours will be evaluated on the client side based on the results returned from the server. Rather than leave these in the memory bloated KeyValue structure, we compact these results to reduce client memory usage. > 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)