Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

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


+
Anandha L Ranganathan 2012-12-11, 03:28
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)
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB