@dmharshit    Check your Ambari UI--->HDFS-->Config-- look for the parameter hadoop.proxyuser.hive.hosts make sure it's the HS2 host is listed here. In my case bern.swiss.ch   Then restart the stale services and revert if you see any errors share the logs Happy Hadooping ... View more