[
https://issues.apache.org/jira/browse/PHOENIX-1580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14369978#comment-14369978
]
James Taylor commented on PHOENIX-1580:
---------------------------------------
I don't think it'd be difficult to adjust the grammar, as it only affects the
structure of the ParseNode tree. Take a look here:
https://msdn.microsoft.com/en-us/library/ms189499.aspx at the Syntax block. I
think we'd want to restrict subqueries as shown too (to also not contain ORDER
BY or LIMIT). In this way, the grammar wouldn't allow you to union together sql
statements that have separate ORDER BY statements, since the grammar would only
allow an ORDER BY and LIMIT at the end of the SELECT statement.
> 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.patch, unionall-wipe.patch
>
>
> Select * from T1
> UNION ALL
> Select * from T2
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
