Thanks for pointing out the direction, it works like a charm after switch to PQS + thin-driver.
This is a UTF-8 formatted mail ----------------------------------------------- James C.-C.Yu +886988713275 2018-03-03 6:44 GMT+08:00 Josh Elser <els...@apache.org>: > The issue is commonly that sqlline.py is adding the HBase configuration to > the classpath on your behalf. This obviously would not happen in Squirrel > (which Phoenix doesn't control or know about). > > * If Squirrel has the ability to add additional classpath entries, you can > try adding $HBASE_CONF_DIR to it > * If not, you can manually add hbase-site.xml to your phoenix-client.jar > * Else, you can try starting up PQS and using the thin-driver instead of > the thick-driver and that doesn't have any other required configuration. > > > On 3/2/18 5:00 AM, James Yu wrote: > >> I can run sqlline.py without a problem, but I am unable to connect to >> Phoenix with Squirrel. >> In Squirrel's log, we can see the hostname "hadoop-01" is successfully >> translated into IP and the connection is established. The zookeeper's log >> also shows the establishment, however, Squirrel still timeout the >> connection. >> >> Any idea what can cause such behavior? >> >> For more details & screenshot, please refer to this post: >> http://memyselfandtaco.blogspot.tw/2018/03/unable-to-connect >> -to-apache-phoenix.html >> >> Thank you. >> >> >> This is a UTF-8 formatted mail >> ----------------------------------------------- >> James C.-C.Yu >> >