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

["Jinfeng Ni (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-2346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14556372#comment-14556372 ] 

Jinfeng Ni commented on DRILL-2346:
-----------------------------------

For now, I think this is the expected behavior.

For select * against a schema-less table, the expanding to a list of regular columns happens at execution time, not at planning time. However, when Drill creates a view, the view creation does not involve query execution (execution happens only when you query against the created view). In stead, it simply goes through query parsing / semantics checking.  It doesn't seem  possible to expand * into a list of regular columns when execute a view DDL statement, at this moment.

Also, if you explicitly list the column names in the view's definition, one would argue that you may put those columns explicitly in the Select statement in stead.

{code}
create view v2 as select a2, b2, c2 from t2;
{code}

or if you want to rename the column into different names

{code}
create view v2 (a3, b3, c3) as select a2, b2, c2 from t2;

or

create view v2 as select a2 a3, b2 b3, c2 c3 from t2;
{code}


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