[
https://issues.apache.org/jira/browse/HIVE-10483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Eugene Koifman updated HIVE-10483:
----------------------------------
Summary: insert overwrite partition deadlocks on itself with DbTxnManager
(was: ACID: insert overwrite with self join deadlocks on itself with
DbTxnManager)
> 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
> Attachments: 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)
