hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carl Steinbach <c...@cloudera.com>
Subject Re: Caused by: javax.jdo.JDODataStoreException: Exception thrown while querying indices for table=DBS: HELP need
Date Mon, 06 Dec 2010 01:42:30 GMT
>From the README.txt file that ships with hive-0.6.0:

Upgrading from older versions of Hive
=====================================

- Hive 0.6.0 includes changes to the MetaStore schema. If
  you are upgrading from an earlier version of Hive it is
  imperative that you upgrade the MetaStore schema by
  running the appropriate schema upgrade script located in
  the scripts/metastore/upgrade directory.

  We have provided upgrade scripts for Derby, MySQL, and PostgreSQL
  databases. If you are using a different database for your MetaStore
  you will need to provide your own upgrade script.

- Hive 0.6.0 includes new configuration properties. If you
  are upgrading from an earlier version of Hive it is imperative
  that you replace all of the old copies of the hive-default.xml
  configuration file with the new version located in the conf/
  directory.


On Fri, Dec 3, 2010 at 4:30 PM, Tali K <ncherryus@hotmail.com> wrote:

>  No, where I can find this script?
>
> ------------------------------
> Date: Fri, 3 Dec 2010 15:53:52 -0800
> Subject: Re: Caused by: javax.jdo.JDODataStoreException: Exception thrown
> while querying indices for table=DBS: HELP need
> From: carl@cloudera.com
> To: user@hive.apache.org
>
>
> Hi Tali,
>
> Did you run the metastore schema upgrade script? This is a requirement if
> you are upgrading from an older version of Hive to version 0.6.
>
> Thanks.
>
> Carl
>
> On Fri, Dec 3, 2010 at 1:31 PM, Tali K <ncherryus@hotmail.com> wrote:
>
> Hi All,
>
> We installed a new hive distribution - 0.6.
> We copied  this 2 jars to the hive/lib directory.
> postgresql-9.0-801.jdbc4.jar
> jdo2-core-2.0.jar
>
> We are getting this exception Caused by: javax.jdo.JDODataStoreException:
> Exception thrown while querying indices for table=DBS
> NestedThrowables:
> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
> commands ignored until end of transaction block
>         at
> org.datanucleus.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:313)
>
>
> Please help!!!
>
>
>  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:186)
> Caused by: javax.jdo.JDODataStoreException: Exception thrown while querying
> indices for table=DBS
> NestedThrowables:
> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
> commands ignored until end of transaction block
>         at
> org.datanucleus.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:313)
>         at
> org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:4154)
>         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.getMDatabase(ObjectStore.java:322)
>         at
> org.apache.hadoop.hive.metastore.ObjectStore.getDatabase(ObjectStore.java:341)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB_core(HiveMetaStore.java:359)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.access$200(HiveMetaStore.java:79)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler$4.run(HiveMetaStore.java:381)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler$4.run(HiveMetaStore.java:378)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.executeWithRetry(HiveMetaStore.java:234)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:378)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:171)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:136)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:87)
>         at
> org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:1269)
>         at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:1279)
>         at
> org.apache.hadoop.hive.ql.metadata.Hive.getTablesByPattern(Hive.java:603)
>         ... 17 more
> Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is
> aborted, commands ignored until end of transaction block
>         at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
>         at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
>         at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
>         at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
>         at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
>         at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
>         at
> org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getIndexInfo(AbstractJdbc2DatabaseMetaData.java:4023)
>         at
> org.apache.commons.dbcp.DelegatingDatabaseMetaData.getIndexInfo(DelegatingDatabaseMetaData.java:327)
>         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:1099)
>         at
> org.datanucleus.store.rdbms.table.TableImpl.validateCandidateKeys(TableImpl.java:698)
>         at
> org.datanucleus.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:400)
>         at
> org.datanucleus.store.rdbms.table.ClassTable.validateConstraints(ClassTable.java:3267)
>         at
> org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2773)
>         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)
>         ... 39 more
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask
> 10/12/03 13:26:40 ERROR ql.Driver: FAILED: Execution Error, return code 1
> from org.apache.hadoop.hive.ql.exec.DDLTask
>
>
>

Mime
View raw message