[
https://issues.apache.org/jira/browse/SPARK-17122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15425908#comment-15425908
]
Dongjoon Hyun commented on SPARK-17122:
---------------------------------------
Hi, [~jameszhouyi]
It's intentionally implemented in SPARK-16459. Please refer the comment in PR
https://github.com/apache/spark/pull/14115 .
> Failed to drop database when use the database in Spark 2.0
> ----------------------------------------------------------
>
> Key: SPARK-17122
> URL: https://issues.apache.org/jira/browse/SPARK-17122
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.0.0
> Reporter: Yi Zhou
>
> Found below case was broken in Spark 2.0, but it can run successfully in
> Spark 1.6. BTW, the case can also run successfully in Hive. Please see below
> reproduces for details.
> Spark-SQL CLI:
> /usr/lib/spark/bin/spark-sql
> spark-sql> use test_db;
> spark-sql> DROP DATABASE IF EXISTS test_db CASCADE;
> 16/08/10 15:13:35 INFO execution.SparkSqlParser: Parsing command: DROP
> DATABASE IF EXISTS test_db CASCADE
> Error in query: Can not drop current database `test_db`;
> Hive CLI:
> /usr/bin/hive
> hive> use test_db;
> OK
> hive> DROP DATABASE IF EXISTS test_db CASCADE;
> OK
> Time taken: 0.116 seconds
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
