Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive not running after HDP 2.5 ambari installment

Solved Go to solution

Hive not running after HDP 2.5 ambari installment

Contributor

hive-error.txt

I installed HDP 2.5 and tried to run hive but i'm getting the error attached. Then after that I did run the following command to give it permission but still not working... what should I do?

sudo -u hdfs hdfs dfs -mkdir /user/ec2-user

sudo -u hdfs hdfs dfs -chown -R ec2-user:hdfs /user/ec2-user

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Hive not running after HDP 2.5 ambari installment

@Dagmawi Mengistu

Is "ambari-server.hostname" is actually your ambari server hostname ?

Can you try changing it to "*" and then retest the same?

something like this:

hadoop.proxyuser.ec2-user.groups = *
hadoop.proxyuser.ec2-user.hosts = *
hadoop.proxyuser.admin.groups = *
hadoop.proxyuser.admin.groups = *

NOTE: If you are running ambari-server daemon under an account name of root then you should add

hadoop.proxyuser.root.groups = *
hadoop.proxyuser.root.hosts = *

.

Also your error indicates that it is not able to write inside the "/user/admin/hive/job/...." directory, which indicates that you have logged in to ambari hive view as "admin" user, so you must do the following:

su -l hdfs -c "hdfs dfs -mkdir /user/admin" 
su -l hdfs -c "hdfs dfs -chown admin:hdfs /user/admin"

.

3 REPLIES 3

Re: Hive not running after HDP 2.5 ambari installment

Re: Hive not running after HDP 2.5 ambari installment

Contributor

@Scott Shaw It's still not working...

9893-screen-shot-2016-11-29-at-23915-pm.png

9894-screen-shot-2016-11-29-at-24013-pm.png

9891-screen-shot-2016-11-29-at-23308-pm.png

9892-screen-shot-2016-11-29-at-23457-pm.png

Re: Hive not running after HDP 2.5 ambari installment

@Dagmawi Mengistu

Is "ambari-server.hostname" is actually your ambari server hostname ?

Can you try changing it to "*" and then retest the same?

something like this:

hadoop.proxyuser.ec2-user.groups = *
hadoop.proxyuser.ec2-user.hosts = *
hadoop.proxyuser.admin.groups = *
hadoop.proxyuser.admin.groups = *

NOTE: If you are running ambari-server daemon under an account name of root then you should add

hadoop.proxyuser.root.groups = *
hadoop.proxyuser.root.hosts = *

.

Also your error indicates that it is not able to write inside the "/user/admin/hive/job/...." directory, which indicates that you have logged in to ambari hive view as "admin" user, so you must do the following:

su -l hdfs -c "hdfs dfs -mkdir /user/admin" 
su -l hdfs -c "hdfs dfs -chown admin:hdfs /user/admin"

.