Apply new configuration properties for hive0.14 in hive-site.xml file then drop or delete table
On Monday, February 23, 2015, Jie Zhang <jiezh2...@gmail.com> wrote: > Hi, > > I have an application using hive, and just upgraded from 0.13.1 to 0.14.0. > However, a bunch of unit testcases, which are using embedded derby > metastore, failing to drop table. Here are the exception stack trace. Does > anyone have clue what the problem can be and how to resolve it? Feedback is > really appreciated. Thanks! > > ERROR 2015-02-22 22:38:26,757 [main] [StmtCacheTest] [line 308] > SQLException when creating hive data in test table: [stmtcache_test] > > java.sql.SQLException: Error while processing statement: FAILED: Execution > Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. > MetaException(message:javax.jdo.JDOException: Exception thrown when > executing query > > at > org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:596) > > at org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:275) > > at > org.apache.hadoop.hive.metastore.ObjectStore.listMIndexes(ObjectStore.java:3133) > > at > org.apache.hadoop.hive.metastore.ObjectStore.getIndexes(ObjectStore.java:3107) > > at sun.reflect.GeneratedMethodAccessor86.invoke(Unknown Source) > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:606) > > at > org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:98) > > at com.sun.proxy.$Proxy8.getIndexes(Unknown Source) > > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_table_core(HiveMetaStore.java:1465) > > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_table_with_environment_context(HiveMetaStore.java:1657) > > at sun.reflect.GeneratedMethodAccessor85.invoke(Unknown Source) > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:606) > > at > org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:102) > > at com.sun.proxy.$Proxy9.drop_table_with_environment_context(Unknown > Source) > > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.drop_table_with_environment_context(HiveMetaStoreClient.java:1890) > > at > org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.drop_table_with_environment_context(SessionHiveMetaStoreClient.java:117) > > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.dropTable(HiveMetaStoreClient.java:855) > > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.dropTable(HiveMetaStoreClient.java:791) > > at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source) > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:606) > > at > org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:90) > > at com.sun.proxy.$Proxy10.dropTable(Unknown Source) > > at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:980) > > at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.java:917) > > at org.apache.hadoop.hive.ql.exec.DDLTask.dropTable(DDLTask.java:3673) > > at > org.apache.hadoop.hive.ql.exec.DDLTask.dropTableOrPartitions(DDLTask.java:3608) > > at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:320) > > at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:160) > > at > org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:85) > > at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1604) > > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1364) > > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1177) > > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1004) > > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:999) > > at > org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:144) > > at > org.apache.hive.service.cli.operation.SQLOperation.access$100(SQLOperation.java:69) > > at > org.apache.hive.service.cli.operation.SQLOperation$1$1.run(SQLOperation.java:196) > > at java.security.AccessController.doPrivileged(Native Method) > > at javax.security.auth.Subject.doAs(Subject.java:415) > > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1491) > > at > org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:536) > > at > org.apache.hive.service.cli.operation.SQLOperation$1.run(SQLOperation.java:208) > > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > > - Jessica > -- Sent from Gmail Mobile
