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

hive insert overwrite table select from self dead lock

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 0.13.1
    • Fix Version/s: None
    • Component/s: Locking
    • Labels:
      None

      Description

      CREATE TABLE test(
      id int,
      msg string)
      PARTITIONED BY (
      continent string,
      country string)
      CLUSTERED BY (id)
      INTO 10 BUCKETS
      STORED AS ORC;

      alter table test add partition(continent='Asia',country='India');

      in hive-site.xml:
      hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
      hive.support.concurrency=true;

      in hive shell:
      set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;

      insert into test table some records first.

      then execute sql:
      insert overwrite table test partition(continent='Asia',country='India') select id,msg from test;

      the log stop at :
      INFO log.PerfLogger: <PERFLOG method=acquireReadWriteLocks from=org.apache.hadoop.hive.ql.Driver>

      i think it has dead lock when insert overwrite table from it self.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                ekoifman Eugene Koifman
                Reporter:
                wangxiaoyu Xiaoyu Wang
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: