[jira] [Resolved] (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 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)