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

Not able to connect phoenix unsecure

Expert Contributor

phoenix-unsecure.pngI am getting following error while connecting to phoenix

14 REPLIES 14

Re: Not able to connect phoenix unsecure

@chennuri gouri shankar

See this jira https://issues.apache.org/jira/browse/PHOENIX-1762

Please read the details. What's your HDP and Phoenix version?

Re: Not able to connect phoenix unsecure

Expert Contributor

@Neeraj Sabharwal

Phoenix version - 4.4.0.2.3.2.0-2950

Hdp - HDP-2.3.2.0-2950

Highlighted

Re: Not able to connect phoenix unsecure

@chennuri gouri shankar

Are you able to see it through hbase shell?

su - hbase

hbase shell

list

Re: Not able to connect phoenix unsecure

Expert Contributor

@Neeraj Sabharwal

Yes i can see that

2653-hbase-list.png

Re: Not able to connect phoenix unsecure

@chennuri gouri shankar

If it's not production system then try this

hbase zkcli

ls /

[zk: sandbox.hortonworks.com:2181(CONNECTED) 0] ls /

[clusterstate.json, consumers, hiveserver2, storm, rmstore, controller_epoch, configs, isr_change_notification, admin, zookeeper, aliases.json, config, hbase-unsecure, registry, live_nodes, overseer, overseer_elect, collections, brokers]

[zk: sandbox.hortonworks.com:2181(CONNECTED) 1] rmr /hbase-unsecure

[zk: sandbox.hortonworks.com:2181(CONNECTED) 2]

Re: Not able to connect phoenix unsecure

@chennuri gouri shankar

Once you launch phoenix shell then it will recreate metadata

[zk: sandbox.hortonworks.com:2181(CONNECTED) 0] ls /hbase-unsecure

[meta-region-server, backup-masters, table, draining, region-in-transition, table-lock, running, master, namespace, hbaseid, online-snapshot, replication, splitWAL, recovering-regions, rs, flush-table-proc]

[zk: sandbox.hortonworks.com:2181(CONNECTED) 1] ls /hbase-unsecure/table

table table-lock

[zk: sandbox.hortonworks.com:2181(CONNECTED) 1] ls /hbase-unsecure/table

[SYSTEM.SEQUENCE, hbase:acl, SYSTEM.STATS, SYSTEM.CATALOG, iemployee, hbase:meta, hbase:namespace, SYSTEM.FUNCTION]

[zk: sandbox.hortonworks.com:2181(CONNECTED) 2]

Re: Not able to connect phoenix unsecure

Expert Contributor

@Neeraj Sabharwal

After Deleting /hbase-unsecure

my promt got struck

2657-phoenix.pngzk.png

Re: Not able to connect phoenix unsecure

@chennuri gouri shankar You can restart HBase but wait for the prompt to come back.

Re: Not able to connect phoenix unsecure

It seems you are not using correct znode in your url. (/ is missing)

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

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