[DRILL-2346] Star is not expanded correctly in create view if view fields are specified

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 0.8.0
• Fix Version/s: 1.1.0
• Component/s: Query Planning & Optimization
• Assignee: Jinfeng Ni
• Reporter: Victoria Markman
• Created: 28/Feb/15 01:38
• Updated: 15/Jun/15 18:50
• Resolved: 22/May/15 16:09

Description

0: jdbc:drill:schema=dfs> select * from t2 limit 1;
+------------+------------+------------+
|     a2     |     b2     |     c2     |
+------------+------------+------------+
| 0          | zzz        | 2014-12-31 |
+------------+------------+------------+
1 row selected (0.065 seconds)

We get an error, even though table t2 has 3 columns:

0: jdbc:drill:schema=dfs> create view v2(a2, b2, c2) as select * from t2;
+------------+------------+
|     ok     |  summary   |
+------------+------------+
| false      | View's field list and View's query field list have different counts. |
+------------+------------+
1 row selected (0.038 seconds)