You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by James Yu <cy...@gmail.com> on 2018/03/02 10:00:57 UTC
Unable to connect to Apache Phoenix with Squirrel
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
Re: Unable to connect to Apache Phoenix with Squirrel
Posted by James Yu <cy...@gmail.com>.
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 <el...@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
>>
>
Re: Unable to connect to Apache Phoenix with Squirrel
Posted by Josh Elser <el...@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