[
https://issues.apache.org/jira/browse/SPARK-17053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15420392#comment-15420392
]
Sean Owen commented on SPARK-17053:
-----------------------------------
That would imply that "IF EXISTS" is redundant, that the behavior is always "IF
EXISTS".
The Hive docs also disagree:
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL
In Hive 0.7.0 or later, DROP returns an error if the table doesn't exist,
unless IF EXISTS is specified or the configuration variable
hive.exec.drop.ignorenonexistent is set to true.
> DROP statement should not require IF EXISTS
> -------------------------------------------
>
> Key: SPARK-17053
> URL: https://issues.apache.org/jira/browse/SPARK-17053
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.0.0
> Reporter: Gokhan Civan
>
> In version 1.6.1, the following does not throw an exception:
> create table a as select 1; drop table a; drop table a;
> In version 2.0.0, the second drop fails; this is not compatible with Hive.
> The same problem exists for views.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
