org.apache.hadoop.hive.metastore.RetryingHMSHandler: InvalidObjectException(message:d0_edw1_ato)

tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    TDCH with oozie is failing while connecting to Hive

    Stack Overflow | 5 months ago | Deepak Janyavula
    org.apache.hadoop.hive.metastore.RetryingHMSHandler: InvalidObjectException(message:d0_edw1_ato)

    Root Cause Analysis

    1. org.apache.hadoop.hive.metastore.RetryingHMSHandler

      InvalidObjectException(message:d0_edw1_ato)

      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_with_environment_context()
    2. Hive Metastore
      HiveMetaStore$HMSHandler.create_table_with_environment_context
      1. org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_with_environment_context(HiveMetaStore.java:1451)
      1 frame
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:498)
      4 frames
    4. Hive Metastore
      RetryingHMSHandler.invoke
      1. org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:107)
      1 frame
    5. com.sun.proxy
      $Proxy22.create_table_with_environment_context
      1. com.sun.proxy.$Proxy22.create_table_with_environment_context(Unknown Source)
      1 frame
    6. Hive Metastore
      HiveMetaStoreClient.createTable
      1. org.apache.hadoop.hive.metastore.HiveMetaStoreClient.create_table_with_environment_context(HiveMetaStoreClient.java:2056)
      2. org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:675)
      3. org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:663)
      3 frames
    7. com.teradata.connector
      ConnectorImportTool.run
      1. com.teradata.connector.hive.utils.HiveUtils.createHiveTable(HiveUtils.java:979)
      2. com.teradata.connector.hive.processor.HiveOutputProcessor.outputPostProcessor(HiveOutputProcessor.java:258)
      3. com.teradata.connector.common.tool.ConnectorJobRunner.runJob(ConnectorJobRunner.java:162)
      4. com.teradata.connector.common.tool.ConnectorImportTool.run(ConnectorImportTool.java:74)
      4 frames
    8. Hadoop
      ToolRunner.run
      1. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
      2. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:90)
      2 frames
    9. com.teradata.connector
      ConnectorImportTool.main
      1. com.teradata.connector.common.tool.ConnectorImportTool.main(ConnectorImportTool.java:813)
      1 frame
    10. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:498)
      4 frames
    11. org.apache.oozie
      JavaMain.main
      1. org.apache.oozie.action.hadoop.JavaMain.run(JavaMain.java:56)
      2. org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:47)
      3. org.apache.oozie.action.hadoop.JavaMain.main(JavaMain.java:35)
      3 frames
    12. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:498)
      4 frames
    13. org.apache.oozie
      LauncherMapper.map
      1. org.apache.oozie.action.hadoop.LauncherMapper.map(LauncherMapper.java:241)
      1 frame
    14. Hadoop
      YarnChild$2.run
      1. org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54)
      2. org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:453)
      3. org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
      4. org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168)
      4 frames
    15. Java RT
      Subject.doAs
      1. java.security.AccessController.doPrivileged(Native Method)
      2. javax.security.auth.Subject.doAs(Subject.java:422)
      2 frames
    16. Hadoop
      UserGroupInformation.doAs
      1. org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657)
      1 frame
    17. Hadoop
      YarnChild.main
      1. org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:162)
      1 frame