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

[Jinfeng Ni (JIRA)]

Jinfeng Ni created DRILL-1189:
---------------------------------

             Summary: 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


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)