Connecting to Phoenix from AquaDataStudio?

[Riesland, Zack]

Has anyone been able to use Aqua Data Studio w/ Phoenix?

I had success w/ DBVisualizer, but am not able to connect from ADS.

I tried to create a “generic JDBC connection” using the connection wizard. I 
pointed at the appropriate driver jar: 4.2.0.2.2.0.0-2041-client.jar in our 
case.

But when I attempt to test the connection, I get the error below.

Any ideas?


java.lang.NoSuchMethodError: 
org.apache.hadoop.hbase.client.Mutation.getFamilyCellMap()Ljava/util/NavigableMap;
                at 
org.apache.phoenix.schema.PTableImpl$PRowImpl.removeIfPresent(PTableImpl.java:624)
                at 
org.apache.phoenix.schema.PTableImpl$PRowImpl.setValue(PTableImpl.java:655)
                at 
org.apache.phoenix.execute.MutationState.addRowMutations(MutationState.java:201)
                at 
org.apache.phoenix.execute.MutationState.access$200(MutationState.java:75)
                at 
org.apache.phoenix.execute.MutationState$2.init(MutationState.java:263)
                at 
org.apache.phoenix.execute.MutationState$2.<init>(MutationState.java:260)
                at 
org.apache.phoenix.execute.MutationState.toMutations(MutationState.java:258)
                at 
org.apache.phoenix.execute.MutationState.toMutations(MutationState.java:248)
                at 
org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1466)
                at 
org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:535)
                at 
org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:184)
                at 
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:260)
                at 
org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:252)
                at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
                at 
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:250)
                at 
org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1026)
                at 
org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1529)
                at 
org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1498)
                at 
org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77)
                at 
org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1498)
                at 
org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:162)
                at 
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:126)
                at 
org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:133)
                at \\...\\ .\\हिñçêČάй語简�?한\\.Jᠻꐎꎂᢋ 9.KX(Unknown Source)
                at \\...\\ .\\हिñçêČάй語简�?한\\.Jᠻꐎꎂᢋ 9.au(Unknown Source)
                at \\...\\ .\\हिñçêČάй語简�?한\\.Jᠻꐎꎂᢋ 9.getConnection(Unknown 
Source)
                at \\...\\ .\\हिñçêČάй語简�?한\\.Jᠻꐎꎂᢋ 9.getConnection(Unknown 
Source)
                at 
com.aquafold.datastudio.mainframe.dialog.connection.diagnostics.yꑅꀱꏓᜪ 
import.dv(Unknown Source)
                at 
com.aquafold.datastudio.mainframe.dialog.connection.diagnostics.yꑅꀱꏓᜪ 
import.b(Unknown Source)
                at \\...\\ .\\हिñçêČάй語简�?한\\.bᡲꐢꐟꄦ 5 5.d(Unknown Source)
                at \\...\\ .\\हिñçêČάй語简�?한\\.bᡲꐢꐟꄦ 5 5.b(Unknown Source)
                at 
com.aquafold.datastudio.mainframe.dialog.connection.diagnostics.PingDialog$3.runTest(Unknown
 Source)
                at 
com.aquafold.datastudio.mainframe.dialog.connection.diagnostics.PingDialog$2.run(Unknown
 Source)