Connecting to Apache Phoenix
Syntax used for connecting to Hbase using sqlline through phoenix is as listed below.
./sqlline.py 10.10.20.60:2181:/hbase-unsecure
10.10.20.60 – My Zookeeper
2181 – Zookeeper client port
hbase-unsecure – value configured as zookeeper.znode.parent in hbase-site.xml
Sample query
/usr/hdp/current/phoenix-client/bin/psql.py zookeeperserver:2181:/hbase-unsecure /usr/hdp/current/phoenix-client/doc/examples/WEB_STAT.sql /usr/hdp/current/phoenix-client/doc/examples/WEB_STAT.csv /usr/hdp/current/phoenix-client/doc/examples/WEB_STAT_QUERIES.sql