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