oracle配置元数据失败,hive配置独立METADATA ORACLE库出错

之前不用独立的METADATA库，SHOW TABLES是没问题的。

之后想用独立的库，我的做法如下，结果报错，想问下哪位大哥知道原因？谢谢。

1，ORACLE库建用户PJY，赋DBA权限

2，配置hive-site.xml，主要配置如下：

javax.jdo.option.ConnectionURL

jdbc

racle:thin:@172.16.3.13:1522/mydb   

JDBC connect string for a JDBC metastore

javax.jdo.option.ConnectionDriverName

oracle.jdbc.driver.OracleDriver

Driver class name for a JDBC metastore

javax.jdo.option.ConnectionUserName

pjy

username to use against metastore database

javax.jdo.option.ConnectionPassword

huafei331

password to use against metastore database

3，COPY $ORACLE_HOME/jdbc/lib/ojdbc14.jar到$HIVE_HOME/lib下

4，hive

WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties files.

Logging initialized using configuration in jar:file:/home/hadoop-user/hive-0.9.0-bin/lib/hive-common-0.9.0.jar!/hive-log4j.properties

Hive history file=/tmp/hadoop-user/hive_job_log_hadoop-user_201208211036_1889602575.txt

5，hive>show tables;结果如下：

FAILED: Error in metadata: MetaException(message:Got exception: javax.jdo.JDODataStoreException An exception was thrown while adding/validating class(es) : ORA-01754: a table may contain only one column of type LONG

java.sql.SQLException: ORA-01754: a table may contain only one column of type LONG

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)

at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)

at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1726)

at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1696)

at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)

at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)

at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:730)

at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:681)

at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:402)

at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:458)

at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2689)

at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2503)

at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2148)

at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)

at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:986)

at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:952)

at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:919)

at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:356)

at org.datanucleus.store.rdbms.query.legacy.ExtentHelper.getExtent(ExtentHelper.java:48)

at org.datanucleus.store.rdbms.RDBMSStoreManager.getExtent(RDBMSStoreManager.java:1332)

at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:4149)

at org.datanucleus.store.rdbms.query.legacy.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411)

at org.datanucleus.store.rdbms.query.legacy.QueryCompiler.executionCompile(QueryCompiler.java:312)

at org.datanucleus.store.rdbms.query.legacy.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225)

at org.datanucleus.store.rdbms.query.legacy.JDOQLQuery.compileInternal(JDOQLQuery.java:175)

at org.datanucleus.store.query.Query.executeQuery(Query.java:1628)

at org.datanucleus.store.rdbms.query.legacy.JDOQLQuery.executeQuery(JDOQLQuery.java:245)

at org.datanucleus.store.query.Query.executeWithArray(Query.java:1499)

at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:243)

at org.apache.hadoop.hive.metastore.ObjectStore.getTables(ObjectStore.java:771)

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.hive.metastore.RetryingRawStore.invoke(RetryingRawStore.java:111)

at $Proxy5.getTables(Unknown Source)

at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_tables(HiveMetaStore.java:1629)

at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTables(HiveMetaStoreClient.java:772)

at org.apache.hadoop.hive.ql.metadata.Hive.getTablesByPattern(Hive.java:975)

at org.apache.hadoop.hive.ql.metadata.Hive.getAllTables(Hive.java:949)

at org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:2001)

at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:323)

at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:134)

at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)

at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1326)

at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1118)

at org.apache.hadoop.hive.ql.Driver.run(Driver.java:951)

at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:258)

at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:215)

at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:406)

at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:689)

at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:557)

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:156)

)

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask