You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org> on 2015/01/17 02:43:34 UTC
[jira] [Resolved] (DRILL-1979) select multiple *, column as alias,
with limit operator, produces extra column
[ https://issues.apache.org/jira/browse/DRILL-1979?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Hsuan-Yi Chu resolved DRILL-1979.
--------------------------------------
Resolution: Duplicate
> select multiple *, column as alias, with limit operator, produces extra column
> ------------------------------------------------------------------------------
>
> Key: DRILL-1979
> URL: https://issues.apache.org/jira/browse/DRILL-1979
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Operators
> Reporter: Sean Hsuan-Yi Chu
> Assignee: Sean Hsuan-Yi Chu
> Priority: Critical
> Fix For: 0.8.0
>
>
> For example,
> select *, r_name as extra, * from cp.`tpch/region.parquet` limit 2;
> -----------------------------------------------------------------------------------------------------------------------------------------
> | r_regionkey<IN | r_name<VARCHAR | r_comment<VARC | extra<VARCHAR( | r_regionkey0<I | r_name0<VARCHA | r_comment0<VAR | extra0<VARCHAR |
> -----------------------------------------------------------------------------------------------------------------------------------------
> | 0 | AFRICA | lar deposits. | AFRICA | 0 | AFRICA | lar deposits. | AFRICA |
> | 1 | AMERICA | hs use ironic, | AMERICA | 1 | AMERICA | hs use ironic, | AMERICA |
> -----------------------------------------------------------------------------------------------------------------------------------------
> Total rows returned : 2
> Notice the last column "extra0", which is redundant!
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)