我正在运行Sybase作为我Hive的metastore。我已经允许使用数据库了。但在执行基本命令时遇到问题(show tables)
下面是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)
您可能有以下一个(多个)问题:
1)。请检查您是否在SyBase的hive库中放置了正确的连接器jar ?
2)。您的SyBase服务器正在运行吗?
3)。您是否在hive-site.xml中输入了正确的用户名/密码/连接URL ?
希望这有帮助…!!
我有一个类似的错误。这可能是由于Hive Metastore (HMS)无法出现。你可能需要重新启动对我有效的HMS服务。希望这对你有帮助!!