The parent article discusses how to access the ams-hbase instance using Phoenix client when it is a standalone environment.
This article is an extension to that as I list the steps to access ams-hbase instance using Phoenix client when Zookeeper is installed on the cluster.
As described in the parent article, login to AMS Collector host machine:
1. Check the /etc/ams-hbase/conf/hbase-site.xml
2. From the above file we pick hbase.zookeeper.quorum , hbase.zookeeper.property.clientPort and zookeeper.znode.parent values
3. Goto cd /usr/lib/ambari-metrics-collector/bin
4. Invoke the client with the connection url as shown below by substituting the values:
./sqlline.py hbase.zookeeper.quorum : hbase.zookeeper.property.clientPort 😕 zookeeper.znode.parent
Example ./sqlline.py myzkqrm.com:61181:/ams-hbase-secure