I have checked out the latest HIVE Trunk and built it. I am now trying to
configure a mysql metastore. I ran the script hive-schema-0.7.0.mysql.sql
which was the latest one in the list after creating the metastore database.
So why is it complaining about this CDS table?
2011-09-16 17:45:25,132 ERROR exec.Task (SessionState.java:printError(365)) -
FAILED: Error in metadata: MetaException(message:Got exception:
javax.jdo.JDODataStoreException Required table missing : "`CDS`" in Catalog ""
Schema "". DataNucleus requires this table to perform its persistence
operations. Either your MetaData is incorrect, or you need to enable "datan
ucleus.autoCreateTables")
org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Got
exception: javax.jdo.JDODataStoreException Req
uired table missing : "`CDS`" in Catalog "" Schema "". DataNucleus requires
this table to perform its persistence operatio
ns. Either your MetaData is incorrect, or you need to enable
"datanucleus.autoCreateTables")
at
org.apache.hadoop.hive.ql.metadata.Hive.getTablesByPattern(Hive.java:936)
at org.apache.hadoop.hive.ql.metadata.Hive.getAllTables(Hive.java:908)
at org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:1834)
at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:299)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:132)
at
org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1346)
at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1137)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:946)
at
org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:253)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:210)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:401)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:664)
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)
Caused by: MetaException(message:Got exception: javax.jdo.JDODataStoreException
Required table missing : "`CDS`" in Catalo
g "" 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.metastore.MetaStoreUtils.logAndThrowMetaException(MetaStoreUtils.java:779)
at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTables(HiveMetaStoreClient.java:736)
at
org.apache.hadoop.hive.ql.metadata.Hive.getTablesByPattern(Hive.java:934)
... 17 more
