[ https://issues.apache.org/jira/browse/DRILL-2346?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jinfeng Ni updated DRILL-2346: ------------------------------ Fix Version/s: (was: 0.9.0) 1.1.0 > Star is not expanded correctly in create view if view fields are specified > -------------------------------------------------------------------------- > > Key: DRILL-2346 > URL: https://issues.apache.org/jira/browse/DRILL-2346 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Affects Versions: 0.8.0 > Reporter: Victoria Markman > Assignee: Jinfeng Ni > Priority: Minor > Fix For: 1.1.0 > > > {code} > 0: jdbc:drill:schema=dfs> select * from t2 limit 1; > +------------+------------+------------+ > | a2 | b2 | c2 | > +------------+------------+------------+ > | 0 | zzz | 2014-12-31 | > +------------+------------+------------+ > 1 row selected (0.065 seconds) > {code} > We get an error, even though table t2 has 3 columns: > {code} > 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) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)