Not able to connect phoenix unsecure

[#1]

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

[#2]

@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?

[#3]

@Neeraj Sabharwal

Phoenix version - 4.4.0.2.3.2.0-2950

Hdp - HDP-2.3.2.0-2950

[#4]

@chennuri gouri shankar

Are you able to see it through hbase shell?

su - hbase

hbase shell

list

[#5]

@Neeraj Sabharwal

Yes i can see that

[#6]

@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]

[#7]

@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]

[#8]

@Neeraj Sabharwal

After Deleting /hbase-unsecure

my promt got struck

zk.png

[#9]

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

[#10]

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

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