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

Global Limit optimization on ACID table without base directory may throw exception

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.2.1
    • 1.3.0, 2.0.0
    • Hive, Transactions
    • None

    Description

      Steps to reproduce:

      set hive.fetch.task.conversion=minimal;
      set hive.limit.optimize.enable=true;

      create table acidtest1(
      c_custkey int,
      c_name string,
      c_nationkey int,
      c_acctbal double)
      clustered by (c_nationkey) into 3 buckets
      stored as orc
      tblproperties("transactional"="true");

      insert into table acidtest1
      select c_custkey, c_name, c_nationkey, c_acctbal from tpch_text_10.customer;

      select cast (c_nationkey as string) from acidtest.acidtest1 limit 10;

      DAG did not succeed due to VERTEX_FAILURE. failedVertices:1 killedVertices:0
      FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Map 1, vertexId=vertex_1447362491939_0020_1_00, diagnostics=[Vertex vertex_1447362491939_0020_1_00 [Map 1] killed/failed due to:ROOT_INPUT_INIT_FAILURE, Vertex Input: acidtest1 initializer failed, vertex=vertex_1447362491939_0020_1_00 [Map 1], java.lang.RuntimeException: serious problem
      	at org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.generateSplitsInfo(OrcInputFormat.java:1035)
      	at org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.getSplits(OrcInputFormat.java:1062)
      	at org.apache.hadoop.hive.ql.io.HiveInputFormat.addSplitsForGroup(HiveInputFormat.java:308)
      	at org.apache.hadoop.hive.ql.io.HiveInputFormat.getSplits(HiveInputFormat.java:410)
      	at org.apache.hadoop.hive.ql.exec.tez.HiveSplitGenerator.initialize(HiveSplitGenerator.java:155)
      	at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable$1.run(RootInputInitializerManager.java:246)
      	at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable$1.run(RootInputInitializerManager.java:240)
      	at java.security.AccessController.doPrivileged(Native Method)
      	at javax.security.auth.Subject.doAs(Subject.java:422)
      	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657)
      	at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable.call(RootInputInitializerManager.java:240)
      	at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable.call(RootInputInitializerManager.java:227)
      	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      	at java.lang.Thread.run(Thread.java:745)
      Caused by: java.util.concurrent.ExecutionException: java.lang.IllegalArgumentException: delta_0000017_0000017 does not start with base_
      	at java.util.concurrent.FutureTask.report(FutureTask.java:122)
      	at java.util.concurrent.FutureTask.get(FutureTask.java:192)
      	at org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.generateSplitsInfo(OrcInputFormat.java:1012)
      	... 15 more
      Caused by: java.lang.IllegalArgumentException: delta_0000017_0000017 does not start with base_
      	at org.apache.hadoop.hive.ql.io.AcidUtils.parseBase(AcidUtils.java:144)
      	at org.apache.hadoop.hive.ql.io.AcidUtils.parseBaseBucketFilename(AcidUtils.java:172)
      	at org.apache.hadoop.hive.ql.io.orc.OrcInputFormat$FileGenerator.call(OrcInputFormat.java:667)
      	at org.apache.hadoop.hive.ql.io.orc.OrcInputFormat$FileGenerator.call(OrcInputFormat.java:625)
      	... 4 more
      ]DAG did not succeed due to VERTEX_FAILURE. failedVertices:1 killedVertices:0
      

      Attachments

        1. HIVE-12444.branch-1.ADDENDUM.patch
          2 kB
          Wei Zheng
        2. HIVE-12444.ADDENDUM.patch
          2 kB
          Wei Zheng
        3. HIVE-12444.branch-1.patch
          14 kB
          Wei Zheng
        4. HIVE-12444.5.patch
          12 kB
          Wei Zheng
        5. HIVE-12444.4.patch
          12 kB
          Wei Zheng
        6. HIVE-12444.3.patch
          9 kB
          Wei Zheng
        7. HIVE-12444.2.patch
          9 kB
          Wei Zheng
        8. HIVE-12444.1.patch
          4 kB
          Wei Zheng

        Activity

          People

            wzheng Wei Zheng
            wzheng Wei Zheng
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: