[jira] [Commented] (HIVE-12594) X lock on partition should not conflict with S lock on DB

["Eugene Koifman (JIRA)" <ji...@apache.org>]

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

Eugene Koifman commented on HIVE-12594:
---------------------------------------

another example is "show tables" which takes an S lock on DB for the same reason
it should not conflict with X lock when doing "insert overwrite table/partition" on acid table or "insert into table/partition" of non-acid table.

> X lock on partition should not conflict with S lock on DB
> ---------------------------------------------------------
>
>                 Key: HIVE-12594
>                 URL: https://issues.apache.org/jira/browse/HIVE-12594
>             Project: Hive
>          Issue Type: Improvement
>          Components: Transactions
>    Affects Versions: 1.0.0
>            Reporter: Eugene Koifman
>            Assignee: Eugene Koifman
>
> S lock on DB is acquired when creating a new table in that DB to make sure the DB is not dropped at the same time
> This should not conflict with operations such as rebuild index which takes an Exclusive lock on a partition.  See also HIVE-10242



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)