[ https://issues.apache.org/jira/browse/HIVE-10483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eugene Koifman resolved HIVE-10483. ----------------------------------- Resolution: Fixed Fix Version/s: 1.3.0 1.2.0 committed to branch-1.2 and master. Thanks [~alangates] for the review > insert overwrite partition deadlocks on itself with DbTxnManager > ---------------------------------------------------------------- > > Key: HIVE-10483 > URL: https://issues.apache.org/jira/browse/HIVE-10483 > Project: Hive > Issue Type: Bug > Components: Query Planning, Query Processor, Transactions > Affects Versions: 1.0.0 > Reporter: Eugene Koifman > Assignee: Eugene Koifman > Fix For: 1.2.0, 1.3.0 > > Attachments: HIVE-10483.2.patch, HIVE-10483.patch > > > insert overwrite ta partition(part=xxxx) select xxx from tb join ta where > part=xxxx > It seems like the Shared conflicts with the Exclusive lock for Insert > Overwrite even though both are part of the same txn. > More precisely insert overwrite requires X lock on partition and the read > side needs an S lock on the query. > A simpler case is > insert overwrite ta partition(part=xxxx) select * from ta -- This message was sent by Atlassian JIRA (v6.3.4#6332)