java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Map 1, vertexId=vertex_1474097800415_0311_2_00, diagnostics=[Vertex vertex_1474097800415_0311_2_00 [Map 1] killed/failed due to:ROOT_INPUT_INIT_FAILURE, Vertex Input: commerce_feed_redshift_dedup initializer failed, vertex=vertex_1474097800415_0311_2_00 [Map 1], java.io.FileNotFoundException: File s3://xxx/yyy/internal_test_automation/2016/09/17/17156/data/feed/commerce_feed_redshift_dedup/.hive-staging_hive_2016-09-17_10-24-20_998_2833938482542362802-639 does not exist.

Stack Overflow | devsda | 3 months ago
  1. 0

    Why hive_staging file is missing in AWS EMR

    Stack Overflow | 3 months ago | devsda
    java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Map 1, vertexId=vertex_1474097800415_0311_2_00, diagnostics=[Vertex vertex_1474097800415_0311_2_00 [Map 1] killed/failed due to:ROOT_INPUT_INIT_FAILURE, Vertex Input: commerce_feed_redshift_dedup initializer failed, vertex=vertex_1474097800415_0311_2_00 [Map 1], java.io.FileNotFoundException: File s3://xxx/yyy/internal_test_automation/2016/09/17/17156/data/feed/commerce_feed_redshift_dedup/.hive-staging_hive_2016-09-17_10-24-20_998_2833938482542362802-639 does not exist.
  2. 0

    general - [jira] [Created] (HIVE-12599) Unexpected refCount error from the LLAP IO layer - msg#06750 - Recent Discussion OSDir.com

    osdir.com | 11 months ago
    java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex fa <responseData class="java.lang.String">Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Map 5, vertexId=vertex_1449122740455_0665_7_00, d
  3. 0

    [HIVE-12599] Add logging to debug rare unexpected refCount error from the LLAP IO layer - ASF JIRA

    apache.org | 11 months ago
    java.sql.SQLException: Error processing statement: FAILED: Execution Error, code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex fa <responseData class= >Error processing statement: FAILED: Execution Error, code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Map 5, vertexId=vertex_1449122740455_0665_7_00, d
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hive over Tez via Hive JDBC - Error

    Stack Overflow | 1 year ago | Narayana Basetty
    java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask
  6. 0

    GitHub comment 346#119138872

    GitHub | 1 year ago | srikanth0863
    java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Map 1, vertexId=vertex_1474097800415_0311_2_00, diagnostics=[Vertex vertex_1474097800415_0311_2_00 [Map 1] killed/failed due to:ROOT_INPUT_INIT_FAILURE, Vertex Input: commerce_feed_redshift_dedup initializer failed, vertex=vertex_1474097800415_0311_2_00 [Map 1], java.io.FileNotFoundException: File s3://xxx/yyy/internal_test_automation/2016/09/17/17156/data/feed/commerce_feed_redshift_dedup/.hive-staging_hive_2016-09-17_10-24-20_998_2833938482542362802-639 does not exist.

      at com.amazon.ws.emr.hadoop.fs.s3n.S3NativeFileSystem.listStatus()
    2. com.amazon.ws
      EmrFileSystem.listStatus
      1. com.amazon.ws.emr.hadoop.fs.s3n.S3NativeFileSystem.listStatus(S3NativeFileSystem.java:987)
      2. com.amazon.ws.emr.hadoop.fs.s3n.S3NativeFileSystem.listStatus(S3NativeFileSystem.java:929)
      3. com.amazon.ws.emr.hadoop.fs.EmrFileSystem.listStatus(EmrFileSystem.java:339)
      3 frames
    3. Hadoop
      FileSystem.listLocatedStatus
      1. org.apache.hadoop.fs.FileSystem.listStatus(FileSystem.java:1530)
      2. org.apache.hadoop.fs.FileSystem.listStatus(FileSystem.java:1537)
      3. org.apache.hadoop.fs.FileSystem.listStatus(FileSystem.java:1556)
      4. org.apache.hadoop.fs.FileSystem.listStatus(FileSystem.java:1601)
      5. org.apache.hadoop.fs.FileSystem$4.<init>(FileSystem.java:1778)
      6. org.apache.hadoop.fs.FileSystem.listLocatedStatus(FileSystem.java:1777)
      7. org.apache.hadoop.fs.FileSystem.listLocatedStatus(FileSystem.java:1755)
      7 frames
    4. Hadoop
      FileInputFormat.getSplits
      1. org.apache.hadoop.mapred.FileInputFormat.singleThreadedListStatus(FileInputFormat.java:239)
      2. org.apache.hadoop.mapred.FileInputFormat.listStatus(FileInputFormat.java:201)
      3. org.apache.hadoop.mapred.FileInputFormat.getSplits(FileInputFormat.java:281)
      3 frames
    5. Hive Query Language
      HiveSplitGenerator.initialize
      1. org.apache.hadoop.hive.ql.io.HiveInputFormat.addSplitsForGroup(HiveInputFormat.java:363)
      2. org.apache.hadoop.hive.ql.io.HiveInputFormat.getSplits(HiveInputFormat.java:486)
      3. org.apache.hadoop.hive.ql.exec.tez.HiveSplitGenerator.initialize(HiveSplitGenerator.java:200)
      3 frames
    6. org.apache.tez
      RootInputInitializerManager$InputInitializerCallable$1.run
      1. org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable$1.run(RootInputInitializerManager.java:278)
      2. org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable$1.run(RootInputInitializerManager.java:269)
      2 frames
    7. Java RT
      Subject.doAs
      1. java.security.AccessController.doPrivileged(Native Method)
      2. javax.security.auth.Subject.doAs(Subject.java:422)
      2 frames
    8. Hadoop
      UserGroupInformation.doAs
      1. org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657)
      1 frame
    9. org.apache.tez
      RootInputInitializerManager$InputInitializerCallable.call
      1. org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable.call(RootInputInitializerManager.java:269)
      2. org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable.call(RootInputInitializerManager.java:253)
      2 frames
    10. Java RT
      Thread.run
      1. java.util.concurrent.FutureTask.run(FutureTask.java:266)
      2. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      3. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      4. java.lang.Thread.run(Thread.java:745)
      4 frames