Hive not running after HDP 2.5 ambari installment

[#1]

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

[#2]

Hi @Dagmawi Mengistu. Make sure you setup Hive proxy as described here http://docs.hortonworks.com/HDPDocuments/Ambari-2.4.2.0/bk_ambari-views/content/setup_HDFS_proxy_use...

[#3]

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

[#4 · Accepted solution]

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

.