[jira] [Commented] (DRILL-2423) DROP VIEW against non-existent views fails with ZK error

["Victoria Markman (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-2423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14481356#comment-14481356 ] 

Victoria Markman commented on DRILL-2423:
-----------------------------------------

With dill version:

{code}
#Fri Apr 03 23:03:15 EDT 2015
git.commit.id.abbrev=4f21357
{code}

Non existent views are reported to be dropped:
{code}
0: jdbc:drill:schema=dfs> drop view thisviewneverexistedhowamiabletodropitcanbeveryconfusing;
+------------+------------+
|     ok     |  summary   |
+------------+------------+
| true       | View 'thisviewneverexistedhowamiabletodropitcanbeveryconfusing' deleted successfully from 'dfs.joins' schema |
+------------+------------+
1 row selected (0.083 seconds)
{code}

> 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: Steven Phillips
>            Priority: Minor
>             Fix For: 1.1.0
>
>
> 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)