Support Questions
Find answers, ask questions, and share your expertise

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

@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"

.

View solution in original post

3 REPLIES 3

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

@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"

.

View solution in original post