[
https://issues.apache.org/jira/browse/SPARK-25464?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16623644#comment-16623644
]
Sean Owen commented on SPARK-25464:
-----------------------------------
I don't think this is a problem. If I can delete /usr/hive/warehouse, then,
well I can delete it in many ways. If I can write to a location, I can do
whatever I want to its contents.
If I create a DB, and someone else creates one with the same location, that is
a bigger problem – this doesn't change the fact that both now write over the
same data. Also, imagine that this prevents the 'real' owner from deleting the
database, if you like.
If anything I'd prohibit creating two DBs in the metastore with the same path,
but if Hive doesn't prevent it, I don't know if Spark should.
> Dropping database can remove the hive warehouse directory contents
> ------------------------------------------------------------------
>
> Key: SPARK-25464
> URL: https://issues.apache.org/jira/browse/SPARK-25464
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.3.1
> Reporter: Sushanta Sen
> Priority: Major
>
> Create Database.
> CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] db_name [COMMENT comment_text]
> [*LOCATION*path] [WITH DBPROPERTIES (key1=val1, key2=val2, ...)]
> \{{LOCATION }}If the specified path does not already exist in the underlying
> file system, this command tries to create a directory with the path. *When
> the database is dropped later, this directory is not deleted,
> {color:#d04437}but currently it is deleting the directory as well.{color}
> {color:#333333}please refer the below link{color}
> {color:#d04437}[databricks documentation|{color}
>
> [https://docs.databricks.com/spark/latest/spark-sql/language-manual/create-database.html]
> {color:#d04437}]{color}
> if i create the database as below
> create database db1 location '/user/hive/warehouse'; //this is hive warehouse
> directory
> *{color:#333333}on dropping this db it will also delete the warehouse
> directory which contains the other db information.{color}*
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
