[jira] [Updated] (HIVE-10483) insert overwrite partition deadlocks on itself with DbTxnManager

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

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