[HIVE-26721] Dropping external tables with high partition count in hive-metastore takes very long

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 3.1.2
• Component/s: Hive
• Assignee: Unassigned
• Reporter: Yeachan Park
• Created: 10/Nov/22 12:48
• Updated: 14/Nov/22 11:14

Description

Dropping external tables in hive-metastore with lots of partitions (~30K partitions) takes a very long time (~30 minutes)

This seems strange since external tables should just be a delete operation on the metastore database.

We're running an external hive-metastore with a backend database of Postgres 13.7.