[jira] [Commented] (SPARK-17122) Failed to drop database when use the database in Spark 2.0

["Apache Spark (JIRA)" <ji...@apache.org>]

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

Apache Spark commented on SPARK-17122:
--------------------------------------

User 'adrian-wang' has created a pull request for this issue:
https://github.com/apache/spark/pull/15011

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