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.

Not able to connect phoenix unsecure

Re: Not able to connect phoenix unsecure

Expert Contributor

@Neeraj Sabharwal

No luck, Facing the same issue

Re: Not able to connect phoenix unsecure

New Contributor

Please try to set the following environmental variables pointing to your HBase conf directory: export HBASE_CONF_DIR=<conf dir> export HBASE_CONF_PATH=<conf dir>

Re: Not able to connect phoenix unsecure

0down vote

You will need to specify root dir "hbase-unsecure" in the connection string because by default Phoenix is trying to connect to /hbase. Try this:

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

Re: Not able to connect phoenix unsecure

can you please attach the content of SYSTEM.CATALOG table for debugging by running a below command in hbase shell

> scan 'SYSTEM.CATALOG', {RAW => true}

Re: Not able to connect phoenix unsecure

New Contributor

Sometimes it's a user permission issue. The first time you access phoenix through sqlline, system tables get created for that user, and if later you try to access with root user, you don't have permissions to read from those tables ('root' user is does not have 'root' permissions in hbase). Try accessing phoenix with hbase root user (I belive by default is user "hbase"). If you can access phoenix, then all you have to do is change permissions of the system tables through hbase shell. You can do that with hbase 'grant' command.

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