Correct URL for connecting to hbase using phoenix in java

Question

I have set up Hbase on Pseudo-Distributed mode and have installed Phoenix on it.

I can connect to Phoenix using sqlline.py localhost and can use it without any errors. then I tried to connect to Phoenix through Java by using the following

Connection con = DriverManager.getConnection("jdbc:phoenix:[zookeeper]");

as give on the apache FAQs. then I replaced the [zookeeper] with the ip address of my VM on which hbase and Phoenix is set up, but its not connecting..

my zoo.cfg contains only the basic properties:

tickTime=2000
dataDir=/home/hduser/zookeeper/datadir
clientPort=2181

my regionservers file in hbase/conf has only localhost in it.

What should be the correct URL to connect to hbase?

score 1 · Accepted Answer · answered Sep 17 '14 at 08:33

1

I just needed to add the machine with zookeeper in etc/hostsas <ipaddress> machine_name and then use the machine name in the url for JDBC connection.

answered Sep 17 '14 at 08:33

Antariksha Yelkawar

381
1
12

Really took, 8 days !.. no support from community.. :( – peaceUser Oct 20 '16 at 11:50
I almost went crazy with it... Community knows jack... :) – Antariksha Yelkawar Oct 21 '16 at 06:39
do you know a way to get the schemas, and tables for existing Hbase? – peaceUser Oct 21 '16 at 07:11
It has been quite some time since I even touched it, but I thought you can just list the tables and stuff using a command when you run the CLI – Antariksha Yelkawar Oct 21 '16 at 09:35

Correct URL for connecting to hbase using phoenix in java

1 Answers1