Support Questions
Find answers, ask questions, and share your expertise

unable to connect dbvisualizer with phoenix

able to connect with pheonix with /usr/hdp/current/phoenix-client/bin/sqlline.py zookeeper_host:2181:/hbase-unsecure

but when i tried zookeeper_host:2181:/hbase-unsecure am unable to connect.

for that i have to add some classpath get though this link. but didnt get the exact ans.

3 REPLIES 3

Re: unable to connect dbvisualizer with phoenix

Super Collaborator

If you are running dbvisualizer on the ambari managed node, you need to add /etc/hbase/conf to the classpath of the connection. If you are running it from not managed node, copy /etc/hbase/conf to some local directory and add it to the classpath.

Re: unable to connect dbvisualizer with phoenix

@Sergey Soldatov i tired that still am getting this error: bash: zookeeper_host:2181:/hbase-unsecure: No such file or directory

Re: unable to connect dbvisualizer with phoenix

Super Collaborator

Please be more specific about the changes you have done. The error states that you did something in the command line and that's not that you need to do. Those changes should be done in the properties for phoenix driver. The place where you specify phoenix-client.jar you also should look for additional properties like 'extra classpath' and that's the place where you should provide the path to /etc/hbase/conf