drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sean Hsuan-Yi Chu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1979) select multiple *, column as alias, with limit operator, produces extra column
Date Sun, 11 Jan 2015 05:08:34 GMT
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)

Mime
View raw message