Hi LiuLei, I believe you should check out HIVE-1760 ( https://issues.apache.org/jira/browse/HIVE-1760)
Hope this helps. - Youngwoo 2010/11/3 lei liu <liulei...@gmail.com> > When I create one table, hive throw below Exception: > > 2010-11-03 09:42:02,939 ERROR exec.DDLTask > (SessionState.java:printError(277)) - FAILED: Error in metadata: > java.lang.RuntimeExcepti > on: commitTransaction was called but openTransactionCalls = 0. This > probably indicates that there are unbalanced calls to openTransa > ction/commitTransaction > org.apache.hadoop.hive.ql.metadata.HiveException: > java.lang.RuntimeException: commitTransaction was called but > openTransactionCalls > = 0. This probably indicates that there are unbalanced calls to > openTransaction/commitTransaction > at > org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:400) > at > org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:2126) > at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:166) > at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:107) > at > org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:55) > at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:633) > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:506) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:384) > at > org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:115) > at > org.apache.hadoop.hive.service.ThriftHive$Processor$execute.process(ThriftHive.java:378) > at > org.apache.hadoop.hive.service.ThriftHive$Processor.process(ThriftHive.java:366) > at > org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:252) > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) > at java.lang.Thread.run(Thread.java:619) > Caused by: java.lang.RuntimeException: commitTransaction was called but > openTransactionCalls = 0. This probably indicates that there > are unbalanced calls to openTransaction/commitTransaction > at > org.apache.hadoop.hive.metastore.ObjectStore.commitTransaction(ObjectStore.java:250) > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_core(HiveMetaStore.java:794) > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.access$600(HiveMetaStore.java:79) > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler$13.run(HiveMetaStore.java:815) > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler$13.run(HiveMetaStore.java:812) > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.executeWithRetry(HiveMetaStore.java:234) > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table(HiveMetaStore.java:812) > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:279) > at > org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:394) > ... 14 more > > What is reason result to the Exception? > > LiuLei > > Thanks. > >