You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2021/03/09 13:58:00 UTC

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

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

ASF GitHub Bot logged work on HIVE-23391:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 09/Mar/21 13:57
            Start Date: 09/Mar/21 13:57
    Worklog Time Spent: 10m 
      Work Description: zchovan commented on pull request #2054:
URL: https://github.com/apache/hive/pull/2054#issuecomment-793932193


   cc @deniskuzZ 


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Issue Time Tracking
-------------------

    Worklog Id:     (was: 563074)
    Time Spent: 20m  (was: 10m)

> 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
>              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: 20m
>  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.3.4#803005)