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

NoSuchObjectException(message:bdm.tableName table not found)

    XMLWordPrintableJSON

Details

    Description

      When executing an Query "USE bdm;DESC FORMATTED bdm_las_waybill_revoke_run_car_task;"
      But when I try it again, It will success.
      This is a random phenomenon.

      Throw Exceptions like this

      2013-12-26 04:20:38,849 ERROR metadata.Hive (Hive.java:getTable(953)) - NoSuchObjectException(message:bdm.bdm_las_waybill_revoke_run_car_task table not found)
      at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:1373)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:103)
      at $Proxy10.get_table(Unknown Source)
      at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:854)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:89)
      at $Proxy11.getTable(Unknown Source)
      at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:950)
      at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:892)
      at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer$tableSpec.<init>(BaseSemanticAnalyzer.java:730)
      at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer$tableSpec.<init>(BaseSemanticAnalyzer.java:707)
      at org.apache.hadoop.hive.ql.parse.LoadSemanticAnalyzer.analyzeInternal(LoadSemanticAnalyzer.java:196)
      at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:284)
      at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:441)
      at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:342)
      at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:977)
      at org.apache.hadoop.hive.ql.Driver.run(Driver.java:888)
      at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:260)
      at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:217)
      at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:507)
      at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:442)
      at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:825)
      at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:769)
      at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:708)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.apache.hadoop.util.RunJar.main(RunJar.java:197)

      2013-12-26 04:20:38,904 ERROR ql.Driver (SessionState.java:printError(419)) - FAILED: SemanticException [Error 10001]: Line 1:114 Table not found 'bdm_las_waybill_revoke_run_car_task'
      org.apache.hadoop.hive.ql.parse.SemanticException: Line 1:114 Table not found 'bdm_las_waybill_revoke_run_car_task'
      at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer$tableSpec.<init>(BaseSemanticAnalyzer.java:733)
      at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer$tableSpec.<init>(BaseSemanticAnalyzer.java:707)
      at org.apache.hadoop.hive.ql.parse.LoadSemanticAnalyzer.analyzeInternal(LoadSemanticAnalyzer.java:196)
      at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:284)
      at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:441)
      at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:342)
      at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:977)
      at org.apache.hadoop.hive.ql.Driver.run(Driver.java:888)
      at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:260)
      at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:217)
      at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:507)
      at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:442)
      at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:825)
      at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:769)
      at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:708)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.apache.hadoop.util.RunJar.main(RunJar.java:197)
      Caused by: org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found bdm_las_waybill_revoke_run_car_task
      at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:954)
      at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:892)
      at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer$tableSpec.<init>(BaseSemanticAnalyzer.java:730)
      ... 19 more

      Attachments

        Activity

          People

            Unassigned Unassigned
            shiw019 William Stone
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated: