hadoop - hive 错误:metastore.RetryingRawStore:JDO数据存储错误。 1000毫秒后重试metastore命令(尝试1之1)

Question

我正在将Sybase作为Hive的元存储库运行。
我已对数据库给予适当的许可。
但是在执行基本命令时遇到问题。(显示表)

这是 Debug模式下job的输出:

14/05/27 08:00:59 DEBUG metastore.ObjectStore: javax.jdo.option.ConnectionDriverName = com.sybase.jdbc4.jdbc.SybDriver
14/05/27 08:00:59 DEBUG metastore.ObjectStore: javax.jdo.option.ConnectionUserName = XXX
14/05/27 08:00:59 DEBUG metastore.ObjectStore: datanucleus.validateColumns = false
14/05/27 08:00:59 DEBUG metastore.ObjectStore: datanucleus.cache.level2 = false
14/05/27 08:00:59 DEBUG metastore.ObjectStore: datanucleus.plugin.pluginRegistryBundleCheck = LOG
14/05/27 08:00:59 DEBUG metastore.ObjectStore: datanucleus.cache.level2.type = none
14/05/27 08:00:59 DEBUG metastore.ObjectStore: javax.jdo.PersistenceManagerFactoryClass = org.datanucleus.api.jdo.JDOPersistenceManagerFactory
14/05/27 08:00:59 DEBUG metastore.ObjectStore: datanucleus.autoCreateSchema = false
14/05/27 08:00:59 DEBUG metastore.ObjectStore: datanucleus.storeManagerType = rdbms
14/05/27 08:00:59 DEBUG metastore.ObjectStore: datanucleus.connectionPoolingType = BONECP
14/05/27 08:00:59 INFO metastore.ObjectStore: ObjectStore, initialize called
14/05/27 08:00:59 INFO metastore.ObjectStore: Initialized ObjectStore
14/05/27 08:00:59 WARN metastore.ObjectStore: Version information not found in metastore.     hive.metastore.schema.verification is not enabled so recording the schema version 0.12.0
 14/05/27 08:00:59 ERROR metastore.RetryingRawStore: JDO datastore error. Retrying metastore command after 1000 ms (attempt 1 of 1)
 14/05/27 08:01:02 WARN metastore.ObjectStore: Version information not found in metastore. hive.metastore.schema.verification is not enabled so recording the schema version 0.12.0
 14/05/27 08:01:04 ERROR exec.DDLTask: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate o    rg.apache.hadoop.hive.metastore.HiveMetaStoreClient
    at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:602)
    at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3677)
    at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:252)
    at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:151)
    at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:65)
    at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1437)
    at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1215)
    at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1043)
    at org.apache.hadoop.hive.ql.Driver.run(Driver.java:911)
    at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
    at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
    at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:413)
    at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:781)
    at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:675)
    at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)
    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:212)`

Caused by: javax.jdo.JDODataStoreException: Exception thrown obtaining schema column information from datastore
NestedThrowables:
java.sql.SQLException: The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database.

    at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:451)

Answer 1

您可能有以下一个或多个问题:

1.)请检查是否将正确的连接器jar放在SyBase的配置单元库中？

2.)您的SyBase服务器正在运行？

3.)您是否在hive-site.xml中输入了正确的用户名/密码/连接URL？

希望这可以帮助..!!