Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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

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.

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

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.