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

Posted to issues@hive.apache.org by "Denys Kuzmenko (Jira)" <ji...@apache.org> on 2022/05/05 13:25:00 UTC

[jira] [Commented] (HIVE-23391) Non blocking ALTER TABLE add column

    [ https://issues.apache.org/jira/browse/HIVE-23391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17532242#comment-17532242 ] 

Denys Kuzmenko commented on HIVE-23391:
---------------------------------------

Merged to master.
[~asinkovits], [~lvegh], thank you for the review!

> Non blocking ALTER TABLE add column
> -----------------------------------
>
>                 Key: HIVE-23391
>                 URL: https://issues.apache.org/jira/browse/HIVE-23391
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Zoltan Chovan
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 4.0.0
>
>         Attachments: HIVE-23391.2.patch, HIVE-23391.3.patch, HIVE-23391.4.patch, HIVE-23391.patch
>
>          Time Spent: 1h 10m
>  Remaining Estimate: 0h
>
> 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.20.7#820007)