[
https://issues.apache.org/jira/browse/DRILL-2207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sean Hsuan-Yi Chu updated DRILL-2207:
-------------------------------------
Description:
The current specification/behavior of UNION ALL is not well defined.
This issue attempts to reach agreement on the expected behavior of UNION ALL.
Please Provide your comments here:
https://docs.google.com/a/maprtech.com/document/d/1OQFQ6IvdeBJkDLKHFBlwP3tle2WuzpBgZf6R_6Vh0mw
If you cannot see the document in the link, you still can find it in the
attachment with this jira issue.
..............................................................................................................................
An example of the current implementation:
(select n_name from cp.`tpch/nation.parquet` limit 1)" +
"UNION ALL " +
"(select r_name from cp.`tpch/region.parquet` limit 1);
returns:
n_name
ALGERIA
r_name
AFRICA
was:
For instance,
(select n_name from cp.`tpch/nation.parquet` limit 1)" +
"UNION ALL " +
"(select r_name from cp.`tpch/region.parquet` limit 1);
returns:
n_name
ALGERIA
r_name
AFRICA
> Union All Design Proposal
> -------------------------
>
> Key: DRILL-2207
> URL: https://issues.apache.org/jira/browse/DRILL-2207
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Relational Operators
> Reporter: Sean Hsuan-Yi Chu
> Assignee: Sean Hsuan-Yi Chu
> Priority: Critical
>
> The current specification/behavior of UNION ALL is not well defined.
> This issue attempts to reach agreement on the expected behavior of UNION ALL.
> Please Provide your comments here:
> https://docs.google.com/a/maprtech.com/document/d/1OQFQ6IvdeBJkDLKHFBlwP3tle2WuzpBgZf6R_6Vh0mw
> If you cannot see the document in the link, you still can find it in the
> attachment with this jira issue.
> ..............................................................................................................................
> An example of the current implementation:
> (select n_name from cp.`tpch/nation.parquet` limit 1)" +
> "UNION ALL " +
> "(select r_name from cp.`tpch/region.parquet` limit 1);
> returns:
> n_name
> ALGERIA
> r_name
> AFRICA
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
