[
https://issues.apache.org/jira/browse/HIVE-26721?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17633703#comment-17633703
]
Denys Kuzmenko edited comment on HIVE-26721 at 11/14/22 11:13 AM:
------------------------------------------------------------------
hi [~yeachan153],
was the table used at the time of a drop/was there any locks on it before the
drop was executed?
was (Author: dkuzmenko):
hi [~yeachan153],
> Dropping external tables with high partition count in hive-metastore takes
> very long
> ------------------------------------------------------------------------------------
>
> Key: HIVE-26721
> URL: https://issues.apache.org/jira/browse/HIVE-26721
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Affects Versions: 3.1.2
> Reporter: Yeachan Park
> Priority: Minor
>
> 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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
