When I run this it would stay and no response:
$ /usr/bin/phoenix-sqlline.py zk.prod.myserver.com:2181:/hbase
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:zk.prod.myserver.com:2181:/hbase none none org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:zk.prod.myserver.com:2181:/hbase
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
15/06/21 20:48:11 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
15/06/21 20:48:11 WARN impl.MetricsConfig: Cannot locate configuration: tried hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties
Can you try to run just /usr/bin/phoenix-sqlline.py wit the host name without any port or path?
Im not saying it's the solution, but wondering it that helps.
Also, have you exported this before?
$ export JAVA_HOME=/usr/java/jdk1.7.0_67-cloudera
$ export PATH=$PATH:$JAVA_HOME/bin
Same problem. I had tried the above way. But with no luck of running well. Please help on this.
The regionservers are killed when I first run phoenix-sqlline but I cannot find any error messages from regionserver log. That is super weird.
From Apache Phoenix mailing list, I finnally got a workaroud for this.