question Re: Hive : Unauthorized connection for super-user: root in Archives of Support Questions (Read Only)

Hive : Unauthorized connection for super-user: root

mmazerolle — Sat, 08 Oct 2016 02:41:30 GMT

Hi everyone,

I am new to the community and trying to work with HDP 2.5. Setup a small lab at the office with 4 servers. Installation went good and everything seems to work fine, at least the dashboard is all green now (took three complete install but get it to work).

Servers (Xeon 8 cores with 16 GB of RAM each):

manager001 : 192.168.2.50, slave001 : 192.168.2.51, slave002 : 192.168.2.52 and slave003 : 192.168.2.53

I distributed the services in the servers to balance the memory usage and the load. My problem is that when I try to create a table in the Hive view I get the message :

"Unauthorized connection for super-user: root from IP 192.168.2.53"

Re: Hive : Unauthorized connection for super-user: root

chennuri_gouris — Sat, 08 Oct 2016 03:10:01 GMT

https://community.hortonworks.com/questions/9384/unauthorized-connection-for-super-user.html

Re: Hive : Unauthorized connection for super-user: root

mmazerolle — Sun, 09 Oct 2016 04:42:06 GMT

Despite the link (refering to oozie), the configuration changes must be done for :

hadoop.proxyuser.root.groups

hadoop.proxyuser.root.hosts

Figured it out just after the post. All work fine now.