question Re: Not able to start Hive on HDP sandbox in Archives of Support Questions (Read Only)

Not able to start Hive on HDP sandbox

SatishS — Mon, 14 Dec 2015 08:24:02 GMT

Hello Friends,

I am new to HDP and was trying to access the Hive on Beeswax. when I run a command "Show databases;" it's throwing following error,

Error: Error occurred executing hive query: Error while processing statement: FAILED: Hive Internal Error: com.sun.jersey.api.client.ClientHandlerException(java.io.IOException: org.apache.hadoop.security.authentication.client.AuthenticationException: Authentication failed, status: 503, message: Service Unavailable).

and

when I try to run the hive command on command prompt, it's giving some java exceptions.

Please help me to resolve this issue.

Thanks,

Satish.

Re: Not able to start Hive on HDP sandbox

nsabharwal — Mon, 14 Dec 2015 08:26:37 GMT

@Satish S Can you share a screen shot?

Please provide the java exception messages. This looks like authenication issue.

Re: Not able to start Hive on HDP sandbox

bsaini — Mon, 14 Dec 2015 11:57:56 GMT

Also, are you using HDP Sandbox? Which version of HDP are you on?

Have you made sure via Ambari that Hive is up and running?

Re: Not able to start Hive on HDP sandbox

bsaini — Mon, 14 Dec 2015 11:59:28 GMT

Also, moved the question to Data Processing category as "Community Help" is for help regarding navigation and other such aspects of this community forum. It is confusing and we are looking to change that title soon.

Re: Not able to start Hive on HDP sandbox

SatishS — Wed, 16 Dec 2015 02:09:49 GMT

Here are the attachments.

Re: Not able to start Hive on HDP sandbox

SatishS — Wed, 16 Dec 2015 02:11:56 GMT

It's 2.3.2

Re: Not able to start Hive on HDP sandbox

SatishS — Wed, 16 Dec 2015 02:12:35 GMT

Pls refer the screenshots in below comment. Thx.

Re: Not able to start Hive on HDP sandbox

deepesh1 — Wed, 16 Dec 2015 03:03:30 GMT

Looking at your attachments, it looks like you are trying to launch hive cli as root user. Make sure /user/root exists on HDFS and is owned by root user. If it's not so, login/sudo as hdfs user and run the following commands:

hadoop fs -mkdir /user/root
hadoop fs -chmod -R 755 /user/root
hadoop fs -chown -R root:root /user/root

Launch the hive cli after that.

Re: Not able to start Hive on HDP sandbox

SatishS — Wed, 16 Dec 2015 03:45:56 GMT

Thanks Deepesh. Its working fine now. Does this mean, we should have root user both on the local file system and hdfs? I didn't get why we need root user on HDFS. Please help me to understand this.

Re: Not able to start Hive on HDP sandbox

deepesh1 — Wed, 16 Dec 2015 07:42:59 GMT

Any local user that wants to start YARN application also needs a home directory (/user/<user>) on the HDFS as well. I am guessing Tez is enabled in your environment and part of initializing hive cli is bringing up a YARN application which might be failing.

Re: Not able to start Hive on HDP sandbox

SatishS — Thu, 17 Dec 2015 02:56:57 GMT

ok, thanks. I was looking into Cloudera sandbox and I don't see any root user under users folder on HDFS. Any idea why it's different. even it's using the YARN.

Re: Not able to start Hive on HDP sandbox

harsh85_amc — Tue, 05 Jan 2016 19:46:43 GMT

@Deepesh how to run sudo on sandbox..I typed sudo -i then also it is giving root@sandbox.

If i type hadoop fs -mkdir /user/root it is giving error message

mkdir permission denied : user :root, access : WRITE, inode="user/root": hdfs:hdfs:drwxr-xr-x

Re: Not able to start Hive on HDP sandbox

deepesh1 — Wed, 06 Jan 2016 03:04:04 GMT

Try "su - hdfs" and then run the above hadoop commands.

Re: Not able to start Hive on HDP sandbox

seenivasansindh — Wed, 06 Jan 2016 03:49:58 GMT

Deepesh,

In HDFS environment is the hdfs user superuser. As in a typical UNIX env root is the superuser and without root user password we can't perform any of the stuff.

Re: Not able to start Hive on HDP sandbox

deepesh1 — Wed, 06 Jan 2016 03:58:28 GMT

Yes, hdfs is typically the superuser on HDFS.