I am getting this error "Unauthorized connection for super-user: root from IP" while querying hive data through Ambari Hive View. How to overcome this error ??

[#1]

Hey Guys,

I am able to query data through admin hive view of ambari, it is displaying output properly. but whenever I am running query ,Console displays this error "Unauthorized connection for super-user: root from IP ***.***.***.*" also in output for data nodes IP addresses ."Unauthorized connection for super-user: root from IP".Please let me know which configuration property needs to be changed to resolve this issue.

Thanks in advance,

Subash

[#2]

@subash sharmacould you plese set hadoop.proxyuser.hive.groups,hadoop.proxyuser.hive.hosts to * using ambari and restart hdfs and see if it help.

[#3]

@Rajkumar Singh

yes i did and have restarted the hdfs and related services, but i am still facing the issue.

[#4]

hiveproxyhost.png snapshot attached.

[#5]

@subash sharma

Please add the proxy property for root user as hadoop.proxyuser.root.groups=* and hadoop.proxyuser.root.hosts=*.

[#6]

@Sindhu

Hey Sindhu, Can you please let me know the path of configuration file where I need to make these changes and let me know the services which need to be restarted after committing the changes.

Thank you,

Subash

[#7]

@subash sharma

You need to add below properties to core-site.xml(custom core-site section of Ambari)

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

[#8]

Please refer this -

http://docs.hortonworks.com/HDPDocuments/Ambari-2.1.2.0/bk_ambari_views_guide/content/_setup_HDFS_pr...

Regards

Pranay Vyas

[#9]

This solved for me:

hadoop.proxyuser.root.hosts=*

Rgds,

Luiz

[#10]

1. In Ambari Web, browse to Services > HDFS > Configs.
2. Under the Advanced tab, navigate to the Custom core-site section.
3. Click Add Property… to add the following custom properties:

hadoop.proxyuser.root.groups=*

hadoop.proxyuser.root.hosts=*