hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carl Steinbach <c...@cloudera.com>
Subject Re: Create table as select fails with error "Error in metadata: org.apache.thrift.TApplicationException"
Date Fri, 01 Oct 2010 04:46:24 GMT
Hi Amareshwari,

Which version of Hive are you using to run the Hive metastore server?

Thanks.

Carl

On Thu, Sep 30, 2010 at 9:25 PM, Amareshwari Sri Ramadasu <
amarsri@yahoo-inc.com> wrote:

>  Hi,
>
> Create table as select queries fail with
> org.apache.thrift.TApplicationException in our clusters for some queries.
>
> Following is the stack trace for the exception :
> Error in metadata: org.apache.thrift.TApplicationException: Internal error
> processing create_table
> org.apache.hadoop.hive.ql.metadata.HiveException:
> org.apache.thrift.TApplicationException: Internal error processing
> create_table
>         at
> org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:405)
>         at
> org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:2465)
>         at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:180)
>         at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:108)
>         at
> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:55)
>         at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:895)
>         at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:764)
>         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:640)
>         at
> org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:140)
>         at
> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:199)
>         at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:353)
>         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: org.apache.thrift.TApplicationException: Internal error
> processing create_table
>         at
> org.apache.thrift.TApplicationException.read(TApplicationException.java:107)
>         at
>
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_create_table(ThriftHiveMetastore.java:566)
>         at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.create_table(ThriftHiveMetastore.java:549)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:281)
>         at
> org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:399)
>
> When we tried with hive.metastore.connect.retries=10, it fails though it
> succeeds occasionally.
>
> The metastore logs have the following exception
> Internal error processing create_table
> java.lang.RuntimeException: Commit is called, but transaction is not
> active. Either there are mismatching open and
> close calls or rollback was called in the same trasaction
>         at
> org.apache.hadoop.hive.metastore.ObjectStore.commitTransaction(ObjectStore.java:250)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_core(HiveMetaStore.java:795)
>         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:816)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler$13.run(HiveMetaStore.java:813)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.executeWithRetry(HiveMetaStore.java:234)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table(HiveMetaStore.java:813)
>         at
>
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$create_table.process(ThriftHiveMetastore.java:1992)
>         at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor.process(ThriftHiveMetastore.java:1644)
>         at
> org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:252)
>         at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>         at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
>         at java.lang.Thread.run(Thread.java:619)
>
> Can somebody help us find the root cause of the problem?
>
> Thanks
> Amareshwari
>
>

Mime
View raw message