[DRILL-2341] Type information is lost if list of fields is specified during create view

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.0
• Fix Version/s: 0.9.0
• Component/s: Metadata
• Assignee: Venki Korukanti
• Reporter: Victoria Markman
• Created: 27/Feb/15 22:31
• Updated: 15/Apr/15 18:21
• Resolved: 15/Apr/15 18:21

Description

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

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)

List of fields is specified, type information is lost

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)

View file:

{
  "name" : "v2",
  "sql" : "SELECT CAST(`a1` AS INTEGER), CAST(`b1` AS VARCHAR(10)), CAST(`c1` AS DATE)\nFROM `t1`",
  "fields" : [ {
    "name" : "x",
    "type" : "ANY",
    "isNullable" : true
  }, {
    "name" : "y",
    "type" : "ANY",
    "isNullable" : true
  }, {
    "name" : "z",
    "type" : "ANY",
    "isNullable" : true
  } ],
  "workspaceSchemaPath" : [ "dfs", "aggregation" ]
}

Issue Links

• breaks: DRILL-2797 Remove DrillRelOptUtil.createRename after Calcite rebase