You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2014/07/26 01:38:38 UTC

[jira] [Updated] (DRILL-1189) Return 0 row, when there is select * from view join another table, and there are duplicate column names.

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

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

    Assignee: Jinfeng Ni

> 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.4.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)