[
https://issues.apache.org/jira/browse/DRILL-438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13993077#comment-13993077
]
George Chow commented on DRILL-438:
-----------------------------------
I pulled and did a build and observed this in sqlline:
===
0: jdbc:drill:schema=hivestg> create view dfs.myView as select * from
dfs.`/opt/drill/raw-files/testTypes.json`;
+------------+------------+
| ok | summary |
+------------+------------+
| true | View 'dfs' created successfully in 'dfs' schema |
+------------+------------+
1 row selected (0.105 seconds)
0: jdbc:drill:schema=hivestg> select * from dfs.myView;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
running query.[error_id: "eaa86f75-0bfb-4d6e-bd25-43a0b5d60718"
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 24 ] < EigenbaseContextException:[ From line 1, column 15 to line 1,
column 24 ] < SqlValidatorException:[ Table \'dfs.myView\' not found ]"
]
Error: exception while executing query (state=,code=0)
0: jdbc:drill:schema=hivestg> drop view dfs.myView;
+------------+------------+
| ok | summary |
+------------+------------+
| false | Error: Schema 'dfs' has no view named 'dfs.myView' |
+------------+------------+
1 row selected (0.115 seconds)
> Add support for Views (CREATE, DROP and select)
> -----------------------------------------------
>
> Key: DRILL-438
> URL: https://issues.apache.org/jira/browse/DRILL-438
> Project: Apache Drill
> Issue Type: New Feature
> Reporter: Jacques Nadeau
> Assignee: Venki Korukanti
> Attachments: DRILL-438-1.patch, DRILL-438-2.patch
>
>
--
This message was sent by Atlassian JIRA
(v6.2#6252)
