[jira] [Comment Edited] (HIVE-26721) Dropping external tables with high partition count in hive-metastore takes very long

["Denys Kuzmenko (Jira)" <ji...@apache.org>]

    [ 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)