[jira] [Created] (DRILL-675) Views created in dfs (with no workspace subschema) schema are not be found when queried

["Venki Korukanti (JIRA)" <ji...@apache.org>]

Venki Korukanti created DRILL-675:
-------------------------------------

             Summary: Views created in dfs (with no workspace subschema) schema are not be found when queried
                 Key: DRILL-675
                 URL: https://issues.apache.org/jira/browse/DRILL-675
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Venki Korukanti
            Assignee: Venki Korukanti
         Attachments: DRILL-675-1.patch

{code}
USE dfs;
+------------+------------+
|     ok     |  summary   |
+------------+------------+
| true       | Default schema changed to 'dfs' |
+------------+------------+
1 row selected (0.098 seconds)

0: jdbc:drill:schema=hivestg> create view myView as select * from dfs.`/opt/drill/raw-files/testTypes.json`;
+------------+------------+
|     ok     |  summary   |
+------------+------------+
| true       | View 'myView' created successfully in 'dfs' schema |
+------------+------------+
1 row selected (0.128 seconds)
0: jdbc:drill:schema=hivestg> select * from myView;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "45b96c5d-5e37-4d9d-96bf-4a7c88be859b"
endpoint {
  address: "localhost"
  user_port: 31010
  control_port: 31011
  data_port: 31012
}
error_type: 0
message: "Failure while parsing sql. < ValidationException:[ org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to line 1, column 20 ] < EigenbaseContextException:[ From line 1, column 15 to line 1, column 20 ] < SqlValidatorException:[ Table \'myView\' not found ]"
]
{code}

The problem is when you are using the 'dfs' as the current schema, view table is created as part of the "dfs" schema in ViewStore. But when searching for a table (or view) in "dfs" schema it looks at the tables in "default" schema which has the schema path "dfs.default". As there is no view table with "dfs.default" in ViewStore, it throws table not found error. 



--
This message was sent by Atlassian JIRA
(v6.2#6252)