I set up PAM authentication for Hive and I configured PAM to read OS users. So, from beeline I am able to connect using valid credentials.
The problem is when I try to connect to Hive View from Ambari. It asks me for Hive passwords and I enter the correct password, but it doesn't work.
In order to give you a brief overview of my config, I have:
hive.server2.authentication = PAM
And, when I try to open Hive View from Ambari, I get the following error:
Service Hive check failed: org.apache.ambari.view.hive2.internal.ConnectionException: Cannot open a hive connection with connect string jdbc:hive2://<host1>:2181,<host2>:2181,<host3>:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-hive2;hive.server2.proxy.user=test_user . . . Caused by: java.sql.SQLException: Could not open client transport for any of the Server URI's in ZooKeeper: Peer indicated failure: Error validating the login
Could you help me?
Thanks in advance!!!
Hi @Ivan Diaz
Unfortunately, as of Ambari 220.127.116.11 / HDP 18.104.22.168, whilst both Ambari and Hive support PAM authentication the Ambari Hive View does not support this authentication scheme. It is a feature that is being looked at for a future release but there is no timescale at present.