question Re: Hive not running after HDP 2.5 ambari installment in Archives of Support Questions (Read Only)

Hive not running after HDP 2.5 ambari installment

doug_mengistu — Wed, 30 Nov 2016 01:11:14 GMT

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

Re: Hive not running after HDP 2.5 ambari installment

SQLShaw — Wed, 30 Nov 2016 01:16:24 GMT

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_user.html

Re: Hive not running after HDP 2.5 ambari installment

doug_mengistu — Mon, 19 Aug 2019 09:49:31 GMT

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

Re: Hive not running after HDP 2.5 ambari installment

Former Member — Wed, 30 Nov 2016 04:06:50 GMT

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