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

Dongjoon Hyun commented on SPARK-17053:
---------------------------------------

Oh, I see what you mean. Yes, indeed. Currently, Spark ignores the option.
{code}
scala> sql("set hive.exec.drop.ignorenonexistent=true")
res1: org.apache.spark.sql.DataFrame = [key: string, value: string]

scala> sql("drop table a")
org.apache.spark.sql.AnalysisException: Table to drop '`a`' does not exist;
{code}
I'll make a PR soon. Could you update the title more specifically?

> 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: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to