Jianshi Huang created SPARK-4199:
------------------------------------
Summary: Drop table if exists raises "table not found" exception
Key: SPARK-4199
URL: https://issues.apache.org/jira/browse/SPARK-4199
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 1.2.0
Reporter: Jianshi Huang
Try this:
sql("DROP TABLE IF EXISTS some_table")
The exception looks like this:
14/11/02 19:55:29 INFO ParseDriver: Parsing command: DROP TABLE IF EXISTS
some_table
14/11/02 19:55:29 INFO ParseDriver: Parse Completed
14/11/02 19:55:29 INFO Driver: </PERFLOG method=parse start=1414986929678
end=1414986929678 duration=0>
14/11/02 19:55:29 INFO Driver: <PERFLOG method=semanticAnalyze>
14/11/02 19:55:29 INFO HiveMetaStore: 0: Opening raw store with implemenation
class:org.apache.hadoop.hive.metastore.ObjectStore
14/11/02 19:55:29 INFO ObjectStore: ObjectStore, initialize called
14/11/02 19:55:29 ERROR Driver: FAILED: SemanticException [Error 10001]: Table
not found some_table
org.apache.hadoop.hive.ql.parse.SemanticException: Table not found some_table
at
org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.getTable(DDLSemanticAnalyzer.java:3294)
at
org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.getTable(DDLSemanticAnalyzer.java:3281)
at
org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.analyzeDropTable(DDLSemanticAnalyzer.java:824)
at
org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.analyzeInternal(DDLSemanticAnalyzer.java:249)
at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:284)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:441)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:342)
at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:977)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:888)
at org.apache.spark.sql.hive.HiveContext.runHive(HiveContext.scala:294)
at
org.apache.spark.sql.hive.HiveContext.runSqlHive(HiveContext.scala:273)
at
org.apache.spark.sql.hive.execution.DropTable.sideEffectResult$lzycompute(commands.scala:58)
at
org.apache.spark.sql.hive.execution.DropTable.sideEffectResult(commands.scala:56)
at
org.apache.spark.sql.execution.Command$class.execute(commands.scala:44)
at
org.apache.spark.sql.hive.execution.DropTable.execute(commands.scala:51)
at
org.apache.spark.sql.hive.HiveContext$QueryExecution.toRdd$lzycompute(HiveContext.scala:353)
at
org.apache.spark.sql.hive.HiveContext$QueryExecution.toRdd(HiveContext.scala:353)
at
org.apache.spark.sql.SchemaRDDLike$class.$init$(SchemaRDDLike.scala:58)
at org.apache.spark.sql.SchemaRDD.<init>(SchemaRDD.scala:104)
at org.apache.spark.sql.hive.HiveContext.sql(HiveContext.scala:98)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
