Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

unable to connect dbvisualizer with phoenix

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
Highlighted

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.

Highlighted

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

Highlighted

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

Don't have an account?
Coming from Hortonworks? Activate your account here