If you're trying to run locally on a Mac, see this thread: http://search-hadoop.com/m/9UY0h2s6mxw4Opgf2/%252Fetc%252Fhosts&subj=Re+testing+problem

On Saturday, October 31, 2015, Naor David <tron47@gmail.com> wrote:
run netstat -a 1 | grep "SYN_SENT" and check if port 2181 is blocked in your network..

On Sat, Oct 31, 2015 at 8:00 PM, Steve Terrell <sterrell@oculus360.us> wrote:
OK, did some more troubleshooting.  Still can't run sqlline.py from my macbook laptop.  Still hangs.

My HBase cluster is an Amazon EMR, and I can run sqlline.py from any of nodes in the cluster, be they master, core, or task nodes.

So maybe it's not so much a remote host issue but a problem with my Mac or some kind of Amazon EMR security issue.  But, I've tried opening up all ports just in case something other than 2181 is required, and no luck.

Has anyone run this version of Phoenix on EMR and been able to use sqlline.py or SQuirreL client remotely from outside of AWS's private network?

(My ultimate goal was to get SQuirreL working, but though sqlline.py would be an easier problem to tackle.  SQuirreL is getting timeouts which I suspect are due to the same hanging that I see with sqlline.py.)


On Wed, Oct 28, 2015 at 5:04 PM, Steve Terrell <sterrell@oculus360.us> wrote:
Yes, I can:

$ telnet <my master ip> 2181
Connected to <my master host name>.
Escape character is '^]'.


On Wed, Oct 28, 2015 at 4:48 PM, Alok Singh <alok@cloudability.com> wrote:
It looks like a zookeeper node is also on the master. Can you connect to <master ip> on port 2181 from the machine that you are running sqlline.py on?


On Wed, Oct 28, 2015 at 2:23 PM, Steve Terrell <sterrell@oculus360.us> wrote:
I can get "sqlline.py localhost" to work fine from the master node.

However, when I try to run it remotely, all I get is this:

java -cp "<my path>/phoenix-4.6.0-HBase-0.98-client.jar" -Dlog4j.configuration=file:<my path>/log4j.properties sqlline.SqlLine -d org.apache.phoenix.jdbc.PhoenixDriver -u jdbc:phoenix:<my master ip>:2181:/hbase -n none -p none --color=true --fastConnect=false --verbose=true --isolation=TRANSACTION_READ_COMMITTED

Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:<my master ip>:2181:/hbase none none org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:<my master ip>:2181:/hbase
15/10/28 15:29:44 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable

And then it just hangs.  Has anyone else come across this?