On Tue, Mar 18, 2014 at 2:27 AM, Peter Marron <Peter.Marron@trilliumsoftware.com> wrote:

Hi,<= /p>

I’m reluctant to an= swer this as I am very far from knowledgeable about this.

However the error that yo= u’re getting looks the one that I always get when I

do not have a hive server= running. I think that your hcat commands can be

serviced without a hive s= erver, but that your failing command cannot.

In other words you need t= o execute something like this first:

$ nohup hive --service hi= veserver &

Also the URL that you are= using looks a little strange.

Normally you would have s= omething like

$ curl http://localhost:50111/templeton/v1/ddl/database/default?user.name=3D<my= name>

so your URL suggests that= you have a database called “testtable”?

I really hope that this h= elps.

Regards,

Peter Marron
Senior Developer
Trillium Software, A Harte Hanks Company

Theale RG7 5AH<= u>

+44 (0) 118 940 7609 office
+44 (0) 118 940 7699 f= ax

trilliumsoftw= are.com / linkedin / twitter / facebook<= span style=3D"font-size:11.0pt;font-family:"Calibri","sans-s= erif";color:#1f497d">

From: Adam Silberstein [mailto:adam@trifacta.com]
Sent: 17 March 2014 22:13
To: user@h= ive.apache.org
Subject: Re: org.apache.hadoop.hive.metastore.HiveMetaStoreClient wi= th webhcat REST

Hi,

Didn't get any answers on this, trying one more = time.

Thanks,

Adam

On Mar 14, 2014, at 9:50 AM, Adam Silberstein <adam@trifacta.com&= gt; wrote:

Hi,

I'm testing out the REST interface to webhcat an= d 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 c= hat command line. E.g.: h= cat -e 'create table testtable (a string, b string, c int);'

I did some loading by hand and via Pig. So I t= hink the HCatalog service is running correctly.

Here's what I am seeing via curl:<= /p>

$ curl http://localhost:50111/templeton/v1/ddl/database/testtable?user.name=3D<= myname>

{"errorDetail":"\norg.apache.hadoop.h= ive.ql.metadata.HiveException: org.apache.hadoop.hive.ql.metadata.HiveExcep= tion: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.h= ive.metastore.HiveMetaStoreClient\n\tat org.apache.hadoop.hive.ql.exec.DDLT= ask.descDatabase(DDLTask.java:2647)\n\tat org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:244)\n\tat org= .apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:138)\n\tat org.apach= e.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:66)\n\tat or= g.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1383)\n\tat org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1169)\n\tat org.apach= e.hadoop.hive.ql.Driver.run(Driver.java:982)\n\tat org.apache.hadoop.hive.q= l.Driver.run(Driver.java:902)\n\tat org.apache.hcatalog.cli.HCatDriver.run(= HCatDriver.java:43)\n\tat org.apache.hcatalog.cli.HCatCli.processCmd(HCatCl= i.java:251)\n\tat org.apache.hcatalog.cli.HCatCli.processLine(HCatCli.java:205)\n\tat org.ap= ache.hcatalog.cli.HCatCli.main(HCatCli.java:164)\n\tat sun.reflect.NativeMe= thodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAcces= sorImpl.invoke(NativeMethodAccessorImpl.java:57)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorIm= pl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:622)\n\tat or= g.apache.hadoop.util.RunJar.main(RunJar.java:208)\n","error"= :"FAILED: Error in metadata: org.apache.hadoop.hive.ql.metadata.HiveEx= ception: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.m= etastore.HiveMetaStoreClient","errorCode":500}=

I found a bunch of help online so I tried adding som= e things in webhcat-site.xml

-templeton.libjars: I added paths to a bunch of libr= aries, including '/usr/lib/hive/lib/hive-metastore-0.10.0-cdh4.5.0.jar&= #39; 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.p= ath. 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 ign= oring that.

If you have any suggestions please share. Than= ks in advance!

-Adam

We've moved! Please update your address book:

Trifacta Inc

575 Market St, 11th Floor

San Francisco, CA 94105