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)