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:analog.s...@gmail.com]
Sent: Tuesday, December 11, 2012 11:29 AM
To: user@hive.apache.org
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)
