[
https://issues.apache.org/jira/browse/DRILL-675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13993929#comment-13993929
]
Venki Korukanti commented on DRILL-675:
---------------------------------------
With DRILL-679 change, in order to create new tables/views in dfs schema, we
need to add the following to storage-plugins.json to change the default
properties of the "default" workspace.
{code}
workspaces: {
"default" : {
location: "/",
writable: true
}
{code}
> 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)
