FAQ
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.

Search Discussions

  • 김영우 at Nov 3, 2010 at 9:56 am
    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 <liulei412@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.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categorieshive, hadoop
postedNov 3, '10 at 9:04a
activeNov 3, '10 at 9:56a
posts2
users2
websitehive.apache.org

2 users in discussion

Lei liu: 1 post 김영우: 1 post

People

Translate

site design / logo © 2022 Grokbase