Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-10483

insert overwrite partition deadlocks on itself with DbTxnManager

    Details

      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

        Attachments

        1. HIVE-10483.2.patch
          9 kB
          Eugene Koifman
        2. HIVE-10483.patch
          9 kB
          Eugene Koifman

          Issue Links

            Activity

              People

              • Assignee:
                ekoifman Eugene Koifman
                Reporter:
                ekoifman Eugene Koifman
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: