Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

Not able to start Hive on HDP sandbox

avatar
Expert Contributor

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.

1 ACCEPTED SOLUTION

avatar

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.

View solution in original post

14 REPLIES 14

avatar
Expert Contributor

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.

avatar
New Member

@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

avatar

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

avatar

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.

avatar

Yes, hdfs is typically the superuser on HDFS.