Can you run below two commands on your server where hs2 and metastore are running and paste the output? ps -ef | grep hiveserver2 ps -ef | grep metastore
... View more
@suresh krish Which version of Ambari are you using? it seems your issue is fixed in Ambari 2.4 details are here: https://issues.apache.org/jira/browse/AMBARI-15953
... View more
@sankar rao Go to /apps/hive/warehouse/ directrory on HDFS and change the user/group permissions as per your requirement. drwxr-x--- - root hdfs 0 2015-11-19 17:30 /apps/hive/warehouse/default.db
... View more
yes, we can't submit/run shell scripts directly from local. we need tp set up NFS mount and give a try. link for setting up NFS mount https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4/bk_hdfs_nfs_gateway/content/user-guide-hdfs-nfs-instructions.html
... View more
@sameer lail it seems password less ssh is having problem for connecting all the nodes from Oozie server. I think you have to set password less ssh for Oozie user as well.
... View more
yes, we have to make changes through Ambari only if your cluster managed by Ambari. Ambari will overwrite the changes if we make any changes at command level. nothing to do with hive-site.xml , we have to check in hive-env.sh
... View more
your GUI is showing around 12 GB but it's not showing in your ps -ef script. it means your 12 GB doesn't take an effect.. May be ambari issue or some hard coded value is not allowing to update. I would recommend to increase 6 GB or 8 GB instead of 12GB, 12 GB is very high number.
... View more
Xmx1024m means it's just 1 GB, please increase it to 4 or 6 or 8 GB based on available Memory. Go to Ambari -Hive-search for heap (hive.heapsize) and update the value to 8192 and then re-start affected services.
... View more
