HiveQL Table not found 에러

오늘은 일요일

아래와 같은 HiveQL 실행에러가 발생했다.

2015-02-08 07:17:36,494 ERROR metadata.Hive (Hive.java:getTable(931)) - NoSuchObjectException(message:xxxx table not found)

        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:1351)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:606)

        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105)

        at com.sun.proxy.$Proxy10.get_table(Unknown Source)

        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:780)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:606)

        at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:89)

        at com.sun.proxy.$Proxy11.getTable(Unknown Source)

        at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:928)

        at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:870)

        at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:968)

        at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:936)

        at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1046)

        at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:944)

        at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:8217)

        at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:258)

        at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:459)

        at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:349)

        at org.apache.hadoop.hive.ql.Driver.run(Driver.java:938)

        at org.apache.hadoop.hive.ql.Driver.run(Driver.java:902)

        at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)

        at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)

        at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:412)

        at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:347)

        at org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:445)

        at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:455)

        at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:713)

        at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:606)

        at org.apache.hadoop.util.RunJar.main(RunJar.java:208)

없다고하는 테이블 확인해 보니 있다. 그리고 재실행하니 문제 없이 돌아간다.

이건 어떤 경우에 발생하는 에러일까?

내일 출근해서 조사해봐야겠다.