[ 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