[
https://issues.apache.org/jira/browse/HIVE-10483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yechao Chen updated HIVE-10483:
-------------------------------
Description:
insert overwrite table 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 table ta partition(part=xxxx) select * from ta
was:
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
> 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.3.0, 2.0.0
>
> Attachments: HIVE-10483.2.patch, HIVE-10483.patch
>
>
> insert overwrite table 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 table ta partition(part=xxxx) select * from ta
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
