You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Zoltan Chovan (Jira)" <ji...@apache.org> on 2020/05/07 11:00:00 UTC

[jira] [Updated] (HIVE-23391) Change requested lock for ALTER TABLE ADD COLUMN to DDL_SHARED

     [ https://issues.apache.org/jira/browse/HIVE-23391?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zoltan Chovan updated HIVE-23391:
---------------------------------
    Attachment: HIVE-23391.patch

> Change requested lock for ALTER TABLE ADD COLUMN to DDL_SHARED
> --------------------------------------------------------------
>
>                 Key: HIVE-23391
>                 URL: https://issues.apache.org/jira/browse/HIVE-23391
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Zoltan Chovan
>            Assignee: Zoltan Chovan
>            Priority: Major
>         Attachments: HIVE-23391.patch
>
>
> A long running query can block a simple add column query, as the add column will require a DDL_EXCLUSIVE lock currently. By changing this to a shared lock, this metadata only query can be executed without having to wait for the previous query to finish.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)