hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adam Silberstein <>
Subject Re: org.apache.hadoop.hive.metastore.HiveMetaStoreClient with webhcat REST
Date Mon, 17 Mar 2014 22:12:57 GMT
Didn't get any answers on this, trying one more time.


On Mar 14, 2014, at 9:50 AM, Adam Silberstein <> wrote:

> Hi,
> I'm testing out the REST interface to webhcat and stuck doing basic DDL operations.
> Background on installation:
> --I installed packages with apt-get
> --I'm on CDH4.5
> I successfully have created and loaded tables with chat command line.  E.g.: hcat -e
'create table testtable (a string, b string, c int);'
> I did some loading by hand and via Pig.  So I think the HCatalog service is running correctly.
> Here's what I am seeing via curl:
> $ curl http://localhost:50111/templeton/v1/ddl/database/testtable?<myname>
> {"errorDetail":"\norg.apache.hadoop.hive.ql.metadata.HiveException: org.apache.hadoop.hive.ql.metadata.HiveException:
java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient\n\tat
org.apache.hadoop.hive.ql.exec.DDLTask.descDatabase(\n\tat org.apache.hadoop.hive.ql.exec.DDLTask.execute(\n\tat
org.apache.hadoop.hive.ql.exec.Task.executeTask(\n\tat org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(\n\tat
org.apache.hadoop.hive.ql.Driver.launchTask(\n\tat org.apache.hadoop.hive.ql.Driver.execute(\n\tat\n\tat\n\tat\n\tat org.apache.hcatalog.cli.HCatCli.processCmd(\n\tat
org.apache.hcatalog.cli.HCatCli.processLine(\n\tat org.apache.hcatalog.cli.HCatCli.main(\n\tat
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(\n\tat
java.lang.reflect.Method.invoke(\n\tat org.apache.hadoop.util.RunJar.main(\n","error":"FAILED:
Error in metadata: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException:
Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient","errorCode":500}
> I found a bunch of help online so I tried adding some things in webhcat-site.xml
> -templeton.libjars: I added paths to a bunch of libraries, including '/usr/lib/hive/lib/hive-metastore-0.10.0-cdh4.5.0.jar'
which has the missing HiveMetaStoreClient class.  Then restarted webhcat, can't tell if it
picked up this property.
> -Less promising, I uploaded the hive tar.gz file to HDFS and updated their paths in templeton.hive.archive
and templeton.hive.path.  Skeptical the server would be looking in HDFS for libraries, and
this didn't help either.
> -There is older material from ~2011 as well, but ignoring that.
> If you have any suggestions please share.  Thanks in advance!
> -Adam

We've moved! Please update your address book:

Trifacta Inc
575 Market St, 11th Floor
San Francisco, CA 94105

View raw message