BELUGA BEHR created HIVE-18670:

             Summary: Prevent DROP DATABASE If Data Exists in HDFS
                 Key: HIVE-18670
             Project: Hive
          Issue Type: Improvement
          Components: HiveServer2
    Affects Versions: 2.3.2, 3.0.0
            Reporter: BELUGA BEHR

A user is not able to drop a database if it has tables under it unless they 
include the _CASCADE_ keyword to their DROP DATABASE statement.


I would like to propose that, if {{hive.mapred.mode}} is set to 'strict', Hive 
also checks for other data before dropping the database.

For example, if the database is stored within HDFS, then Hive should check if 
there exists other data, not even necessarily related to Hive, within the 
database's HDFS directory, before dropping.

The examples are:
{code:java|title=Example 1}

-- Does not succeed because 'my_table' exists
> DROP DATABASE my_database;

-- Succeeds and removes the root directory /hive/my_database
{code:java|title=Example 2}

-- Succeeds because no tables exist, but I just lost my "important" file
> DROP DATABASE my_database;

This message was sent by Atlassian JIRA

Reply via email to