Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Drop table in hive throws metastore excetion.


Copy link to this message
-
RE: Drop table in hive throws metastore excetion.
Hi Anandha
         Because you set datanucleus.autoCreateTables=false. So hive would not create table automatic.
         When Hive drop table , index table will also be droped. So it will used INDEX_PARAMS table.
         I think you can try this.:

1、  set datanucleus.autoCreateTables=true

2、  create a index for one table ,so hive will create index_params table.

3、  Try to drop table.

Regards
Ransom

From: Anandha L Ranganathan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2012 11:29 AM
To: [EMAIL PROTECTED]
Subject: Drop table in hive throws metastore excetion.

I am trying to drop a table in Hive and it throws metastore exception.

2012-12-11 01:19:59,225 ERROR exec.DDLTask (SessionState.java:printError(365)) - FAILED: Error in metadata: javax.jdo.JDODataStoreException: Required table missing : ""INDEX_PARAMS"" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables"
NestedThrowables:
org.datanucleus.store.rdbms.exceptions.MissingTableException: Required table missing : ""INDEX_PARAMS"" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables"
org.apache.hadoop.hive.ql.metadata.HiveException: javax.jdo.JDODataStoreException: Required table missing : ""INDEX_PARAMS"" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables"
NestedThrowables:
org.datanucleus.store.rdbms.exceptions.MissingTableException: Required table missing : ""INDEX_PARAMS"" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables"
        at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:755)
        at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:712)
        at org.apache.hadoop.hive.ql.exec.DDLTask.dropTable(DDLTask.java:2860)
        at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:238)
        at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:130)
        at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
        at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1063)
        at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:900)
        at org.apache.hadoop.hive.ql.Driver.run(Driver.java:748)
        at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:209)
        at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:286)
        at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:516)
        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:186)