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)
