[
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)
