Zheng
My apologies for the length of time to reply. We were out the last week or so for the holidays.
Below is the contents of the /tmp/nrasch/hive.log file. It appears I need to obtain org.eclipse.jdt.core and place it in the $HIVE_HOME/lib dir?
Nathan
2010-01-04 11:30:36,408 ERROR DataNucleus.Plugin (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires "org.eclipse.core.resources" but it cannot be resolved.
2010-01-04 11:30:36,408 ERROR DataNucleus.Plugin (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires "org.eclipse.core.resources" but it cannot be resolved.
2010-01-04 11:30:36,415 ERROR DataNucleus.Plugin (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires "org.eclipse.core.runtime" but it cannot be resolved.
2010-01-04 11:30:36,415 ERROR DataNucleus.Plugin (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires "org.eclipse.core.runtime" but it cannot be resolved.
2010-01-04 11:30:36,416 ERROR DataNucleus.Plugin (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires "org.eclipse.text" but it cannot be resolved.
2010-01-04 11:30:36,416 ERROR DataNucleus.Plugin (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires "org.eclipse.text" but it cannot be resolved.
2010-01-04 11:30:40,166 ERROR exec.DDLTask (SessionState.java:printError(248)) - FAILED: Error in metadata: javax.jdo.JDODataStoreException: Exception thrown performing schema operation : Add classes to Catalog "", Schema "APP"
NestedThrowables:
java.sql.SQLNonTransientConnectionException: A network protocol error was encountered and the connection has been terminated: the requested command encountered an unarchitected and implementation-specific condition for which there was no architected message
org.apache.hadoop.hive.ql.metadata.HiveException: javax.jdo.JDODataStoreException: Exception thrown performing schema operation : Add classes to Catalog "", Schema "APP"
NestedThrowables:
java.sql.SQLNonTransientConnectionException: A network protocol error was encountered and the connection has been terminated: the requested command encountered an unarchitected and implementation-specific condition for which there was no architected message
at org.apache.hadoop.hive.ql.metadata.Hive.getTablesForDb(Hive.java:441)
at org.apache.hadoop.hive.ql.metadata.Hive.getTablesByPattern(Hive.java:423)
at org.apache.hadoop.hive.ql.metadata.Hive.getAllTables(Hive.java:410)
at org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:399)
at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:161)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:99)
at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:64)
at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:577)
at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:457)
at org.apache.hadoop.hive.ql.Driver.runCommand(Driver.java:319)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:307)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:123)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:181)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:287)
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)
Caused by: javax.jdo.JDODataStoreException: Exception thrown performing schema operation : Add classes to Catalog "", Schema "APP"
NestedThrowables:
java.sql.SQLNonTransientConnectionException: A network protocol error was encountered and the connection has been terminated: the requested command encountered an unarchitected and implementation-specific condition for which there was no architected message
at org.datanucleus.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:289)
at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3741)
at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411)
at org.datanucleus.store.rdbms.query.QueryCompiler.executionCompile(QueryCompiler.java:312)
at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225)
at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:174)
at org.datanucleus.store.query.Query.executeQuery(Query.java:1443)
at org.datanucleus.store.rdbms.query.JDOQLQuery.executeQuery(JDOQLQuery.java:244)
at org.datanucleus.store.query.Query.executeWithArray(Query.java:1357)
at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:242)
at org.apache.hadoop.hive.metastore.ObjectStore.getMDatabase(ObjectStore.java:283)
at org.apache.hadoop.hive.metastore.ObjectStore.getDatabase(ObjectStore.java:301)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:147)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:119)
at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.(HiveMetaStoreClient.java:74)
at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:828)
at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:838)
at org.apache.hadoop.hive.ql.metadata.Hive.getTablesForDb(Hive.java:439)
... 18 more
Caused by: java.sql.SQLNonTransientConnectionException: A network protocol error was encountered and the connection has been terminated: the requested command encountered an unarchitected and implementation-specific condition for which there was no architected message
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.Connection.getAutoCommit(Unknown Source)
at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:122)
at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994)
at org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960)
at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691)
at org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358)
at org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344)
at org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736)
... 35 more
Caused by: org.apache.derby.client.am.SqlException: A network protocol error was encountered and the connection has been terminated: the requested command encountered an unarchitected and implementation-specific condition for which there was no architected message
at org.apache.derby.client.am.SqlException.copyAsUnchainedSQLException(Unknown Source)
at org.apache.derby.client.am.Sqlca.chainDeferredExceptionsToAgentOrAsConnectionWarnings(Unknown Source)
at org.apache.derby.client.am.Sqlca.getJDBCMessage(Unknown Source)
at org.apache.derby.client.am.SqlException.getMessage(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.DatabaseMetaData.getIndexInfo(Unknown Source)
at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getRDBMSTableIndexInfoForTable(RDBMSSchemaHandler.java:616)
at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getRDBMSTableIndexInfoForTable(RDBMSSchemaHandler.java:585)
at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getSchemaData(RDBMSSchemaHandler.java:202)
at org.datanucleus.store.rdbms.table.TableImpl.getExistingCandidateKeys(TableImpl.java:1093)
at org.datanucleus.store.rdbms.table.TableImpl.validateCandidateKeys(TableImpl.java:696)
at org.datanucleus.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:398)
at org.datanucleus.store.rdbms.table.ClassTable.validateConstraints(ClassTable.java:3214)
at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2865)
at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595)
at org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241)
at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
... 41 more
2010-01-04 11:30:40,169 ERROR ql.Driver (SessionState.java:printError(248)) - FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
________________________________________
From: Zheng Shao [zshao9@gmail.com]
Sent: Thursday, December 24, 2009 2:11 AM
To: hive-user@hadoop.apache.org
Subject: Re: javax.jdo.JDODataStoreException
Can you open /tmp/<user>/hive.log? It should have the full stack trace.
Zheng
On Wed, Dec 23, 2009 at 12:17 PM, Nathan Rasch
wrote:
All:
I've been setting up Hive using Derby in Server Mode as per the instructions here:
http://wiki.apache.org/hadoop/HiveDerbyServerModeAfter I've got everything finished I attempt to start Hive and run a 'show tables;' query.
I get the following output:
hive> show tables;
FAILED: Error in metadata: javax.jdo.JDODataStoreException: Exception thrown performing schema operation : Add classes to Catalog "", Schema "APP"
NestedThrowables:
java.sql.SQLNonTransientConnectionException: A network protocol error was encountered and the connection has been terminated: the requested command encountered an unarchitected and implementation-specific condition for which there was no architected message
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
It appears that something is missing from my classpath?
I've set the follow environment variables:
HADOOP_HOME
HIVE_HOME
DERBY_HOME
DERBY_INSTALL
Is there something else I need set and/or do?
Nathan
--
Yours,
Zheng
