drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-1189) Return 0 row, when there is select * from view join another table, and there are duplicate column names.
Date Thu, 31 Jul 2014 05:53:48 GMT

     [ https://issues.apache.org/jira/browse/DRILL-1189?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau updated DRILL-1189:
----------------------------------

    Fix Version/s:     (was: 0.4.0)
                   0.5.0

> Return 0 row, when there is select * from view join another table,  and there are duplicate
column names.
> ---------------------------------------------------------------------------------------------------------
>
>                 Key: DRILL-1189
>                 URL: https://issues.apache.org/jira/browse/DRILL-1189
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Jinfeng Ni
>            Assignee: Jinfeng Ni
>             Fix For: 0.5.0
>
>
> If we create a view, and do a select * from view join another table T on columns with
identical names from the base table of view and from table T, then Drill will incorrectly
return 0 rows.
> create view myview as select n_nationkey, n_name, n_regionkey, n_comment from cp.`tpch/nation.parquet`;
> // return 0 rows!   Because of column re-naming
> select * from myview v join cp.`tpch/nation.parquet` n on v.n_nationkey = n.n_nationkey;
  
>  



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message