[
https://issues.apache.org/jira/browse/DRILL-2423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14533271#comment-14533271
]
Abhishek Girish commented on DRILL-2423:
----------------------------------------
Verified on Git.Commit.ID d12bee0 (May 7 build)
{code:sql}
> drop view thisviewneverexistedhowamiabletodropitcanbeveryconfusing;
+------------+------------+
| ok | summary |
+------------+------------+
| false | Unknown view
[thisviewneverexistedhowamiabletodropitcanbeveryconfusing] in schema [dfs.tmp].
|
+------------+------------+
1 row selected (0.171 seconds)
> create view a as select * from file_json1;
+------------+------------+
| ok | summary |
+------------+------------+
| true | View 'a' created successfully in 'dfs.tmp' schema |
+------------+------------+
1 row selected (0.205 seconds)
> drop view a;
+------------+------------+
| ok | summary |
+------------+------------+
| true | View [a] deleted successfully from schema [dfs.tmp]. |
+------------+------------+
1 row selected (0.164 seconds)
> drop view a;
+------------+------------+
| ok | summary |
+------------+------------+
| false | Unknown view [a] in schema [dfs.tmp]. |
+------------+------------+
1 row selected (0.152 seconds)
{code}
The issue is now resolved.
> DROP VIEW against non-existent views fails with ZK error
> --------------------------------------------------------
>
> Key: DRILL-2423
> URL: https://issues.apache.org/jira/browse/DRILL-2423
> Project: Apache Drill
> Issue Type: Bug
> Components: Metadata
> Affects Versions: 0.8.0
> Reporter: Abhishek Girish
> Assignee: Venki Korukanti
> Priority: Minor
> Fix For: 1.0.0
>
> Attachments: DRILL-2423-1.patch
>
>
> If a DROP VIEW command is issued against a non-existent view, it fails with
> an error indicating issue with ZK connection:
> {code:sql}
> > drop view customer_address ;
> +------------+------------+
> | ok | summary |
> +------------+------------+
> | false | Error: Failure while accessing Zookeeper. KeeperErrorCode =
> NoNode for /drill/storage.views.dfs.tpcds_text_sf1/customer_address |
> +------------+------------+
> 1 row selected (0.058 seconds)
> {code}
> The error message must clearly indicate that the view does not exist.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
