phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gabriel Reid <gabriel.r...@gmail.com>
Subject Re: Connecting to Phoenix from AquaDataStudio?
Date Wed, 30 Sep 2015 12:22:30 GMT
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
<Zack.Riesland@sensus.com> 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: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