That's correct, the missing HTrace libs looks to be the problem now. It will probably take a bit of trial and error to get things working, but with the correct combination of dependencies it should all work.
- Gabriel On Wed, Sep 30, 2015 at 2:10 PM, Riesland, Zack <[email protected]> wrote: > 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:[email protected]] > Sent: Wednesday, September 30, 2015 7:48 AM > To: [email protected] > 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 <[email protected]> > 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) >> >> >> >> >> >>
