Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-2341

Type information is lost if list of fields is specified during create view

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.8.0
    • Fix Version/s: 0.9.0
    • Component/s: Metadata
    • Labels:
      None

      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" ]
      }
      

        Attachments

        1. DRILL-2341-1.patch
          7 kB
          Venki Korukanti

          Issue Links

            Activity

              People

              • Assignee:
                vkorukanti Venki Korukanti
                Reporter:
                vicky Victoria Markman
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: