[HIVE-16950] Dropping hive database/table which was created explicitly in default database location, deletes all databases data from default database location

• Type: Bug
• Status: Patch Available
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.2.1
• Component/s: Hive
• Assignee: Oleksiy Sayankin
• Reporter: Rahul Kalgunde
• Created: 23/Jun/17 14:03
• Updated: 21/Oct/22 07:31

Description

When database/table is created explicitly pointing to the default location, dropping the database/table deletes all the data associated with the all databases/tables.

Steps to replicate:
in below e.g. dropping table test_db2 also deletes data of test_db1 where as metastore still contains test_db1

hive> create database test_db1;
OK
Time taken: 4.858 seconds

hive> describe database test_db1;
OK
test_db1 hdfs://sandbox.hortonworks.com:8020/apps/hive/warehouse/test_db1.db root USER
Time taken: 0.599 seconds, Fetched: 1 row(s)

hive> create database test_db2 location '/apps/hive/warehouse' ;
OK
Time taken: 1.457 seconds

hive> describe database test_db2;
OK
test_db2 hdfs://sandbox.hortonworks.com:8020/apps/hive/warehouse root USER
Time taken: 0.582 seconds, Fetched: 1 row(s)

hive> drop database test_db2;
OK
Time taken: 1.317 seconds

hive> dfs -ls /apps/hive/warehouse;
ls: `/apps/hive/warehouse': No such file or directory
Command failed with exit code = 1
Query returned non-zero code: 1, cause: null

hive> describe database test_db1;
OK
test_db1 hdfs://sandbox.hortonworks.com:8020/apps/hive/warehouse/test_db1.db root USER
Time taken: 0.629 seconds, Fetched: 1 row(s)

Issue Links

• links to: Review board