Created on 06-14-2016 01:20 AM - edited 08-19-2019 01:49 AM
I've installed Phoenix Query Server (PQS) on one of the nodes on my cluster based on this answer.
At first, it's running, but when I restart the HBase, PQS wont start again. Here's the error log below:
On the node where PQS is installed, I also installed "clients".
Also, when installing PQS, do I need to enable Phoenix? or This will be automatic after PQS install?
Thank you in advance!
You should enable Phoenix - Josh please correct me if I am wrong.
Can you use jps command to see if the previous PQS server was stopped ?
How did you restart the cluster ?
Hi @Ted Yu, thanks for the respose.
1. Noted on enabling phoenix
6896 Main 7731 NiFi 32283 Kafka 22044 ConsoleConsumer 1740 jenkins.war 7709 RunNiFi 28271 Jps
3. I didn't restart the whole cluster. Just restarted hbase component. Restarted it via Ambari
Below steps might help you:
If you are running external applications, it is recommended that you test the connection to HBase using the following connection strings for the Phoenix JDBC driver:
set CLASSPATH=<path_to_hbase-site.xml>;<path_to_core-site.xml> i.e. export HBASE_CONF_PATH=/etc/hbase/conf:/etc/hadoop/conf
Zookeeper_host_name> can specify one host or several hosts. If you specify several Zookeeper hosts, insert commas between host names. For example, <ZK_host1, ZK_host2, ZK_host3>.
jdbc:phoenix:zk_quorum:2181:zk_parent (or) if you are logged in as your own user kinit /usr/hdp/current/phoenix-client/bin/sqlline.py hostname.domain.com:2181:/hbase-secure
secured_Zookeeper_node> is the path to the secured Zookeeper node, and <
HBase_headless_keytab_file> is the location of this keytab file.
jdbc:phoenix:zk_quorum:2181:/hbase-secure:hbase@EXAMPLE.COM:/hbase-secure/keytab/keytab_file (or) if using logged in as hbase user kinit -k -t /etc/security/keytabs/hbase.headless.keytab hbase /usr/hdp/current/phoenix-client/bin/sqlline.py hostname.domain.com:2181:/hbase-secure:firstname.lastname@example.org:/etc/security/keytabs/hbase.headless.keytab