phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Riesland, Zack" <Zack.Riesl...@sensus.com>
Subject RE: Connecting to Phoenix from AquaDataStudio?
Date Wed, 30 Sep 2015 12:10:17 GMT
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.reid@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.Riesland@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)
>
>
>
>
>
>
Mime
View raw message