You cannot  use "hacluster" if that hostname is not resolved to a IP. Is what I tried to explain in my last mail.

Use the ip of te machine that is running query server or its hostname 


El 12 oct. 2017 6:19, "Mallieswari Dineshbabu" <> escribió:
Hi Rafa,

Still, faced “UnKnownHostException:hacluster” when started the query server with cluster name 'hacluster' and try to connect phoenix client like below.


bin>python http://hacluster:8765


Setting property: [incremental, false]

Setting property: [isolation, TRANSACTION_READ_COMMITTED]

issuing: !connect jdbc:phoenix:thin:url=http://hacluster:8765;serialization=PROTOBUF none none org.apache.phoenix.queryserver.client.Driver

Connecting to jdbc:phoenix:thin:url=http://hacluster:8765;serialization=PROTOBUF

java.lang.RuntimeException: hacluster

        at org.apache.calcite.avatica.remote.AvaticaCommonsHttpClientImpl.send(

        at org.apache.calcite.avatica.remote.RemoteProtobufService._apply(

        at org.apache.calcite.avatica.remote.ProtobufService.apply(

        at org.apache.calcite.avatica.remote.Driver.connect(

        at sqlline.DatabaseConnection.connect(

        at sqlline.DatabaseConnection.getConnection(

        at sqlline.Commands.connect(

        at sqlline.Commands.connect(

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(

        at java.lang.reflect.Method.invoke(

        at sqlline.ReflectiveCommandHandler.execute(

        at sqlline.SqlLine.dispatch(

        at sqlline.SqlLine.initArgs(

        at sqlline.SqlLine.begin(

        at sqlline.SqlLine.start(

        at sqlline.SqlLine.main(



Mallieswari D


On Wed, Oct 11, 2017 at 5:53 PM, rafa <> wrote:
Hi Mallieswari,

The hbase.rootdir is a filesystem resource. If you have a HA NAmenode and a created nameservice you can point to the active namenode automatically. As far as I know it is not related to the HBase Master HA.

The "hacluster" used in this command : python http://hacluster:8765   is a hostname resource. What do you obtain from nslookup hacluster ?

To have serveral Phoenix query servers to achieve HA in that layer you would need a balancer (sw or hw) defined to balance across all your available query servers.



On Wed, Oct 11, 2017 at 1:30 PM, Mallieswari Dineshbabu <> wrote:
Hi All,

I am trying to integrate Phoenix in a High availability enabled Hadoop-HBase cluster. I have used nameservice ID instead of HMaster's hostname in the following property. So that any of my active HMaster will be identified automatically in case of fail over,






Similarly, I tried connecting to QueryServer that is running in one of the HMaster node, from my thin client with the following URL . But I get the error, “No suitable driver found for http://hacluster:8765"


python http://hacluster:8765



Please tell what configuration need to be done to connect QueryServer with nameserviceID.


Note: The same works fine when I specify HMaster's ip address in both my HBase configuration and sqline connection string.


Thanks and regards 

Thanks and regards