Problem

Executing sql in ambari’s hive view reports an error Unauthorized connection for super-user: root from IP

Solution

On the Ambari Web UI, select Services > HDFS > Configs.

Advanced option in the core-site section.

Add the following two lines and change the corresponding values if they already exist

hadoop.proxyuser.root.groups=*
hadoop.proxyuser.root.hosts=*

Restart corresponding services