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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.5.0
• Assignee: Jinfeng Ni
• Reporter: Jinfeng Ni
• Created: 24/Jul/14 18:36
• Updated: 04/Aug/14 20:33
• Resolved: 04/Aug/14 20:33

Description

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;

Issue Links

• Is contained by: DRILL-931 Wildcard queries cause problems in certain schemaless situations