hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harish Butani (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-6114) NoSuchObjectException(message:bdm.tableName table not found)
Date Thu, 27 Mar 2014 23:51:19 GMT

    [ https://issues.apache.org/jira/browse/HIVE-6114?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13950164#comment-13950164
] 

Harish Butani commented on HIVE-6114:
-------------------------------------

[~shiw019] can you provide details on how to reproduce?
Also can this be downgraded from Blocker priority

> NoSuchObjectException(message:bdm.tableName table not found)
> ------------------------------------------------------------
>
>                 Key: HIVE-6114
>                 URL: https://issues.apache.org/jira/browse/HIVE-6114
>             Project: Hive
>          Issue Type: Bug
>          Components: Database/Schema
>    Affects Versions: 0.12.0
>         Environment: hadoop-0.20.2-cdh3u3, hive-0.12.0
>            Reporter: William Stone
>            Priority: Blocker
>              Labels: gettable, metastore, table_not_found
>
> 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



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message