配置单元ERROR:metastore.RetryingRawStore: JDO数据存储错误。在1000毫秒后重试metastore命令(第1次尝试，共1次)

Question

我正在运行Sybase作为my Hive的转移核。我已经在数据库上授予了适当的权限。但在执行基本命令时会遇到问题。(显示表格)

以下是调试模式下作业的输出：

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.)请检查您是否在SyBase的hive库中放置了正确的连接器jar？

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

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

希望这能有所帮助！

Answer 2

我也有过类似的错误..这可能是由于Hive Metastore (HMS)无法出现。您可能想要重新启动HMS服务，该服务对我有效。希望这能有所帮助！