[
https://issues.apache.org/jira/browse/HIVE-4434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13643621#comment-13643621
]
gongguan.zhang commented on HIVE-4434:
--------------------------------------
tTable.getSd() is null, and there is files in
hdfs://***/warehouse/tmp_visitor_vip_access_distinct_2_20130401
> some tables was created but no SDS, and can't drop these tables
> ---------------------------------------------------------------
>
> Key: HIVE-4434
> URL: https://issues.apache.org/jira/browse/HIVE-4434
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.8.0, 0.8.1
> Environment: OS:Linux x86_64
> hive 0.8.0
> hadoop-0.21
> Reporter: gongguan.zhang
>
> all these tables are invalid,when selecting,get the following exception:
> hive> select *from tmp_visitor_vip_access_distinct_2_20130401 limit 1;
> FAILED: Hive Internal Error: java.lang.NullPointerException(null)
> java.lang.NullPointerException
> at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:859)
> at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:787)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:875)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:7120)
> at
> org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:238)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:376)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:334)
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:843)
> at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:224)
> at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:358)
> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:593)
> 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:192)
> when dropping table,get the next following exceptions:
> hive> drop table tmp_visitor_vip_access_distinct_2_20130401;
> FAILED: Hive Internal Error: java.lang.NullPointerException(null)
> java.lang.NullPointerException
> at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:859)
> at
> org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.analyzeDropTable(DDLSemanticAnalyzer.java:693)
> at
> org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.analyzeInternal(DDLSemanticAnalyzer.java:203)
> at
> org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:238)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:376)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:334)
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:843)
> at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:224)
> at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:358)
> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:593)
> 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:192)
> and the metadata info in mysql is:
> TBL_ID: 43832
> CREATE_TIME: 1367017748
> DB_ID: 1
> LAST_ACCESS_TIME: 0
> OWNER: acorn
> RETENTION: 0
> SD_ID: NULL
> TBL_NAME: tmp_visitor_vip_access_distinct_2_20130401
> TBL_TYPE: MANAGED_TABLE
> VIEW_EXPANDED_TEXT: NULL
> VIEW_ORIGINAL_TEXT: NULL
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
