Clever Geek Handbook

HDP: Unable to run Phoenix sqlline.py

I am using Sandbox HDP 2.2

I have installed phoenix yum install (version 4.2)

But when I run them:

./sqlline.py localhost:2181
./sqlline.py localhost
./sqlline.py sandbox.hortonworks.com:2181
./sqlline.py sandbox.hortonworks.com

I got the error:

15/07/03 08:26:31 ERROR client.ConnectionManager$HConnectionImplementation: 
The node /hbase is not in ZooKeeper. It should have been written by the master. 
Check the value configured in 'zookeeper.znode.parent'. There could be a mismatch 
with the one configured in the master.

I tried to run:

./sqlline.py sandbox.hortonworks.com:2181:/hbase-unsecure

But it "freezes" - after 20 minutes there is still no answer

I have this in my / etc / hbase / conf / hbase -site.xml:

<property>
  <name>hbase.zookeeper.quorum</name>
  <value>sandbox.hortonworks.com</value>
</property>
<property>
  <name>zookeeper.znode.parent</name>
  <value>/hbase-unsecure</value>
</property>
+3


source to share


2 answers


You need to create links in the directory where sqlline.py

up to the 2.xml files provided by HBase / Hadoop live.

$ pwd
/usr/hdp/2.2.8.0-3150/phoenix/bin

$ ll | grep xml
lrwxrwxrwx 1 root root   29 Dec 16 13:34 core-site.xml -> /etc/hbase/conf/core-site.xml
lrwxrwxrwx 1 root root   30 Dec 16 13:34 hbase-site.xml -> /etc/hbase/conf/hbase-site.xml


With the buttons $JAVA_HOME

and java

on yours, $PATH

you can run sqlline.py

:

$ ./sqlline.py localhost:2181/hbase-unsecure
+1


source


You need to specify the root dir "/hbase-unsecure"

in the connection string, because by default Phoenix tries to connect to / hbase. Try the following:



./sqlline.py localhost: 2181: / hbase-unsecure

0


source






More articles:


All Articles