You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org> on 2015/01/11 06:08:34 UTC
[jira] [Created] (DRILL-1979) select multiple *, column as alias,
with limit operator, produces extra column
Sean Hsuan-Yi Chu created DRILL-1979:
----------------------------------------
Summary: 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)