[ https://issues.apache.org/jira/browse/SPARK-25464?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sushanta Sen closed SPARK-25464. -------------------------------- > 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 (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org