[HIVE-24135] Drop database doesn't delete directory in managed location

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Labels: pull-request-available
• Assignee: Naveen Gangam
• Reporter: Karen Coppage
• Created: 09/Sep/20 09:52
• Updated: 17/Nov/22 08:48
• Resolved: 08/Jun/21 15:42

Description

Repro:
say the default managed location is managed/hive and the default external location is external/hive.

create database db1; -- creates: external/hive/db1.db
create table db1.table1 (i int); -- creates: managed/hive/db1.db and  managed/hive/db1.db/table1
drop database db1 cascade; -- removes : external/hive/db1.db and managed/hive/db1.db/table1

Problem: Directory managed/hive/db1.db remains.

Since HIVE-22995, dbs have a managed (managedLocationUri) and an external location (locationUri). I think the issue is that HiveMetaStore.HMSHandler#drop_database_core deletes only the db directory in the external location.

Issue Links

• links to: GitHub Pull Request #1506
• links to: GitHub Pull Request #2354