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

Niklaus Xiao commented on HIVE-15193:
-------------------------------------

set {{hive.exec.drop.ignorenonexistent}} to false and try again.

{code}
0: jdbc:hive2://189.39.151.74:21066/> drop view aaa;
No rows affected (0.113 seconds)
0: jdbc:hive2://189.39.151.74:21066/> set 
hive.exec.drop.ignorenonexistent=false;
No rows affected (0.009 seconds)
0: jdbc:hive2://189.39.151.74:21066/> drop view aaa;
Error: Error while compiling statement: FAILED: SemanticException [Error 
10001]: Table not found aaa (state=42S02,code=10001)
{code}

> Drop non-existing view executes successfully
> --------------------------------------------
>
>                 Key: HIVE-15193
>                 URL: https://issues.apache.org/jira/browse/HIVE-15193
>             Project: Hive
>          Issue Type: Bug
>          Components: Database/Schema
>            Reporter: Sangeeta Gulia
>
> When i try to drop a view which do not exist. Then the query result gives me 
> Output: Ok 
> Whereas it should give an error that "The view you are trying to drop does 
> not exist"



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to