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
Unfortunately, as of Ambari 18.104.22.168 / HDP 22.214.171.124, 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.