Community Articles

Find and share helpful community-sourced technical articles.
Celebrating as our community reaches 100,000 members! Thank you!
Labels (1)
Master Guru

HDP 2.5 GA'd phoenix query server. This makes connecting to phoenix much easier. Article will walk through steps on how to connect to phoenix Phoenix Query Server via DBVisualizer.

Grab the phoenix thin jdbc driver onto your desktop. On the HDP 2.5 here is the location of the jdbc driver


Start up DBVisualizer. From the top menu bar select Tools->Driver Manager


Popoluate the fields:

Name:Apache Phoenix Thin Client

I used phoenixthin.

URL Format: jdbc:phoenix:thin:url=<scheme>://<server-hostname>:<port>[...]

Client on the folder icon


Locate your phoenix thin jdbc driver you downloaded to your desktop. Once selected click on ok and and now you have the driver loaded.

Lets connect to phoenix. Click on the icon shown below which creates a new db connection. Then select "Use Wizard".


Enter a connection name. I used phoenix-QPS


Now select the driver you loaded in the previous steps. I named my driver phoenixthin


Next enter your userid & password. For this example I use the root user ID


Now a data connection has been created. Lets connect to phoenix using that connection alias. Go to your connection alias shown on the left pane. Right click and select "Connect"


You are now connected! Start having fun and open up some name spaces. Select * from tables


It is clear connecting to Phoenix is much easier now thanks to the community building Phoenix Query Server. Happy Phoenix-ing

Expert Contributor

@Sunile Manjee

Followed the above and getting:

An error occurred while establishing the connection: Long Message: Remote driver error: RuntimeException: java.sql.SQLFeatureNotSupportedException -> SQLFeatureNotSupportedException: (null exception message) Details: Type: org.apache.calcite.avatica.AvaticaClientRuntimeException Stack Trace: AvaticaClientRuntimeException: Remote driver error: RuntimeException: java.sql.SQLFeatureNotSupportedException -> SQLFeatureNotSupportedException: (null exception message). Error -1 (00000) null java.lang.RuntimeException: java.sql.SQLFeatureNotSupportedException at org.apache.calcite.avatica.jdbc.JdbcMeta.propagate( at org.apache.calcite.avatica.jdbc.JdbcMeta.connectionSync( at org.apache.calcite.avatica.remote.LocalService.apply( at org.apache.calcite.avatica.remote.Service$ConnectionSyncRequest.accept( at org.apache.calcite.avatica.remote.Service$ConnectionSyncRequest.accept( at org.apache.calcite.avatica.remote.AbstractHandler.apply( at org.apache.calcite.avatica.remote.ProtobufHandler.apply( at org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle( at at at at at at$ at at$ at Caused by: java.sql.SQLFeatureNotSupportedException at org.apache.phoenix.jdbc.PhoenixConnection.setCatalog( at org.apache.calcite.avatica.jdbc.JdbcMeta.apply( at org.apache.calcite.avatica.jdbc.JdbcMeta.connectionSync( ... 15 more at org.apache.calcite.avatica.remote.Service$ErrorResponse.toException( at org.apache.calcite.avatica.remote.RemoteProtobufService._apply( at org.apache.calcite.avatica.remote.ProtobufService.apply( at org.apache.calcite.avatica.remote.RemoteMeta$ at org.apache.calcite.avatica.remote.RemoteMeta$ at org.apache.calcite.avatica.AvaticaConnection.invokeWithRetries( at org.apache.calcite.avatica.remote.RemoteMeta.connectionSync( at org.apache.calcite.avatica.AvaticaConnection.sync( at org.apache.calcite.avatica.AvaticaConnection.getAutoCommit( at com.onseven.dbvis.g.B.C.ā(Z:1315) at com.onseven.dbvis.g.B.F$ at at java.util.concurrent.ThreadPoolExecutor.runWorker( at java.util.concurrent.ThreadPoolExecutor$ at

Through CLI, i am able to connect :

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo} p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #5330e1} span.s1 {font-variant-ligatures: no-common-ligatures}

[cloudbreak@ip-172-40-1-169 bin]$ ./

Setting property: [incremental, false]

Setting property: [isolation, TRANSACTION_READ_COMMITTED]

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

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

Triple checked I am loading the correct driver. Anything else I could be missing?

Version history
Last update:
‎08-17-2019 08:45 AM
Updated by: