Thanks Gabriel,
I replaced all the Hadoop and hbase related jars under Aqua Data
Studio/lib/apache with the appropriate ones from our cluster and I *think* I
made some progress.
Seems like I'm now missing the jar with org.cloudera.htrace.Trace ?
java.sql.SQLException: ERROR 103 (08004): Unable to establish connection.
at
org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:336)
at
org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:260)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.access$300(ConnectionQueryServicesImpl.java:157)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1519)
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)
Caused by: java.io.IOException: java.lang.reflect.InvocationTargetException
at
org.apache.hadoop.hbase.client.ConnectionManager.createConnection(ConnectionManager.java:426)
at
org.apache.hadoop.hbase.client.ConnectionManager.createConnectionInternal(ConnectionManager.java:319)
at
org.apache.hadoop.hbase.client.HConnectionManager.createConnection(HConnectionManager.java:292)
at
org.apache.phoenix.query.HConnectionFactory$HConnectionFactoryImpl.createConnection(HConnectionFactory.java:47)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:258)
... 18 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at
org.apache.hadoop.hbase.client.ConnectionManager.createConnection(ConnectionManager.java:424)
... 22 more
Caused by: java.lang.NoClassDefFoundError: org/cloudera/htrace/Trace
at
org.apache.hadoop.hbase.zookeeper.RecoverableZooKeeper.exists(RecoverableZooKeeper.java:195)
at org.apache.hadoop.hbase.zookeeper.ZKUtil.checkExists(ZKUtil.java:481)
at
org.apache.hadoop.hbase.zookeeper.ZKClusterId.readClusterIdZNode(ZKClusterId.java:65)
at
org.apache.hadoop.hbase.client.ZooKeeperRegistry.getClusterId(ZooKeeperRegistry.java:106)
at
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.retrieveClusterId(ConnectionManager.java:858)
at
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.<init>(ConnectionManager.java:662)
... 27 more
-----Original Message-----
From: Gabriel Reid [mailto:gabriel.r...@gmail.com]
Sent: Wednesday, September 30, 2015 7:48 AM
To: user@phoenix.apache.org
Subject: Re: Connecting to Phoenix from AquaDataStudio?
Hi Zack,
It looks like there is probably an older version of HBase somewhere
(earlier) in the classpath.
I don't know anything about Aqua Data Studio, but could it be that it somehow
bundles support for HBase 0.94 somewhere (or perhaps there is another JDBC
driver on the class path that workds with HBase 0.94?)
- Gabriel
On Wed, Sep 30, 2015 at 1:37 PM, Riesland, Zack <zack.riesl...@sensus.com>
wrote:
> 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/N
> avigableMap;
>
> at
> org.apache.phoenix.schema.PTableImpl$PRowImpl.removeIfPresent(PTableIm
> pl.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:2
> 60)
>
> at
> org.apache.phoenix.execute.MutationState.toMutations(MutationState.jav
> a:258)
>
> at
> org.apache.phoenix.execute.MutationState.toMutations(MutationState.jav
> a:248)
>
> at
> org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataC
> lient.java:1466)
>
> at
> org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.ja
> va:535)
>
> at
> org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCo
> mpiler.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(PhoenixStatem
> ent.java:250)
>
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatemen
> t.java:1026)
>
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(Connection
> QueryServicesImpl.java:1529)
>
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(Connection
> QueryServicesImpl.java:1498)
>
> at
> org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExec
> utor.java:77)
>
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQu
> eryServicesImpl.java:1498)
>
> at
> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(Phoen
> ixDriver.java:162)
>
> at
> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedD
> river.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.PingDi
> alog$3.runTest(Unknown
> Source)
>
> at
> com.aquafold.datastudio.mainframe.dialog.connection.diagnostics.PingDi
> alog$2.run(Unknown
> Source)
>
>
>
>
>
>
