Victoria Markman created DRILL-2341:
---------------------------------------

             Summary: Type information is lost if list of fields is specified 
during create view
                 Key: DRILL-2341
                 URL: https://issues.apache.org/jira/browse/DRILL-2341
             Project: Apache Drill
          Issue Type: Bug
          Components: Metadata
    Affects Versions: 0.8.0
            Reporter: Victoria Markman
            Assignee: Steven Phillips


List of fields is not provided, type information is correct.

{code}
0: jdbc:drill:schema=dfs> create view v1 as select cast(a1 as int), cast(b1 as 
varchar(10)), cast(c1 as date) from t1;
+------------+------------+
|     ok     |  summary   |
+------------+------------+
| true       | View 'v1' created successfully in 'dfs.aggregation' schema |
+------------+------------+
1 row selected (0.063 seconds)

0: jdbc:drill:schema=dfs> describe v1;
+-------------+------------+-------------+
| COLUMN_NAME | DATA_TYPE  | IS_NULLABLE |
+-------------+------------+-------------+
| EXPR$0      | INTEGER    | NO          |
| EXPR$1      | VARCHAR    | NO          |
| EXPR$2      | DATE       | NO          |
+-------------+------------+-------------+
3 rows selected (0.102 seconds)
{code}

List of fields is specified, type information is lost
{code}
0: jdbc:drill:schema=dfs> create view v2(x,y,z) as select cast(a1 as int), 
cast(b1 as varchar(10)), cast(c1 as date) from t1;
+------------+------------+
|     ok     |  summary   |
+------------+------------+
| true       | View 'v2' created successfully in 'dfs.aggregation' schema |
+------------+------------+
1 row selected (0.049 seconds)
0: jdbc:drill:schema=dfs> describe v2;
+-------------+------------+-------------+
| COLUMN_NAME | DATA_TYPE  | IS_NULLABLE |
+-------------+------------+-------------+
| x           | ANY        | NO          |
| y           | ANY        | NO          |
| z           | ANY        | NO          |
+-------------+------------+-------------+
3 rows selected (0.084 seconds)
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to