[
https://issues.apache.org/jira/browse/PHOENIX-1580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14395264#comment-14395264
]
Alicia Ying Shu edited comment on PHOENIX-1580 at 4/3/15 11:33 PM:
-------------------------------------------------------------------
[~jamestaylor] I made the changes. But the output looked different. We need run
existing tests and fix any problem if raised. It is a separate issue.
Does the output look right to you? It is what we get now.
>explain select a_string, col1 from test_table union all select a_string, col1
>from b_table order by col1 limit 1
UNION ALL OVER 2 QUERIES
CLIENT PARALLEL 1-WAY FULL SCAN OVER TEST_TABLE
CLIENT MERGE SORT
CLIENT PARALLEL 1-WAY FULL SCAN OVER B_TABLE
CLIENT MERGE SORT
SERVER TOP 1 ROW SORTED BY [COL1]
CLIENT MERGE SORT
was (Author: aliciashu):
[~jamestaylor] I made the changes. But the output looked different. We need run
existing tests and fix any problem if raised. It is a separate issue.
Does the output looks right to you? It is what we get now.
>explain select a_string, col1 from test_table union all select a_string, col1
>from b_table order by col1 limit 1
UNION ALL OVER 2 QUERIES
CLIENT PARALLEL 1-WAY FULL SCAN OVER TEST_TABLE
CLIENT MERGE SORT
CLIENT PARALLEL 1-WAY FULL SCAN OVER B_TABLE
CLIENT MERGE SORT
SERVER TOP 1 ROW SORTED BY [COL1]
CLIENT MERGE SORT
> Support UNION ALL
> -----------------
>
> Key: PHOENIX-1580
> URL: https://issues.apache.org/jira/browse/PHOENIX-1580
> Project: Phoenix
> Issue Type: Improvement
> Reporter: Alicia Ying Shu
> Assignee: Alicia Ying Shu
> Attachments: PHOENIX-1580-grammar.patch, Phoenix-1580-v1.patch,
> Phoenix-1580-v2.patch, Phoenix-1580-v3.patch, Phoenix-1580-v4.patch,
> Phoenix-1580-v5.patch, Phoenix-1580-v6.patch, Phoenix-1580-v7.patch,
> Phoenix-1580-v8.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)
