You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by "Riesland, Zack" <Za...@sensus.com> on 2015/09/30 13:37:03 UTC
Connecting to Phoenix from AquaDataStudio?
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)
RE: Connecting to Phoenix from AquaDataStudio?
Posted by "Riesland, Zack" <Za...@sensus.com>.
Thanks Gabriel,
I finally got it.
Had to replace several apache-related jars and added a jar for HTrace as well as one for 'netty'.
-----Original Message-----
From: Gabriel Reid [mailto:gabriel.reid@gmail.com]
Sent: Wednesday, September 30, 2015 8:23 AM
To: user@phoenix.apache.org
Subject: Re: Connecting to Phoenix from AquaDataStudio?
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 <Za...@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 <Za...@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(PTableI
>> m
>> pl.java:624)
>>
>> at
>> org.apache.phoenix.schema.PTableImpl$PRowImpl.setValue(PTableImpl.jav
>> a
>> :655)
>>
>> at
>> org.apache.phoenix.execute.MutationState.addRowMutations(MutationStat
>> e
>> .java:201)
>>
>> at
>> org.apache.phoenix.execute.MutationState.access$200(MutationState.jav
>> a
>> :75)
>>
>> at
>> org.apache.phoenix.execute.MutationState$2.init(MutationState.java:26
>> 3
>> )
>>
>> at
>> org.apache.phoenix.execute.MutationState$2.<init>(MutationState.java:
>> 2
>> 60)
>>
>> at
>> org.apache.phoenix.execute.MutationState.toMutations(MutationState.ja
>> v
>> a:258)
>>
>> at
>> org.apache.phoenix.execute.MutationState.toMutations(MutationState.ja
>> v
>> a:248)
>>
>> at
>> org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaData
>> C
>> lient.java:1466)
>>
>> at
>> org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.j
>> a
>> va:535)
>>
>> at
>> org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableC
>> o
>> 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(PhoenixState
>> m
>> ent.java:250)
>>
>> at
>> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStateme
>> n
>> t.java:1026)
>>
>> at
>> org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(Connectio
>> n
>> QueryServicesImpl.java:1529)
>>
>> at
>> org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(Connectio
>> n
>> QueryServicesImpl.java:1498)
>>
>> at
>> org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExe
>> c
>> utor.java:77)
>>
>> at
>> org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQ
>> u
>> eryServicesImpl.java:1498)
>>
>> at
>> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(Phoe
>> n
>> ixDriver.java:162)
>>
>> at
>> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbedded
>> D
>> 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.PingD
>> i
>> alog$3.runTest(Unknown
>> Source)
>>
>> at
>> com.aquafold.datastudio.mainframe.dialog.connection.diagnostics.PingD
>> i
>> alog$2.run(Unknown
>> Source)
>>
>>
>>
>>
>>
>>
Re: Connecting to Phoenix from AquaDataStudio?
Posted by Gabriel Reid <ga...@gmail.com>.
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
<Za...@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 <Za...@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)
>>
>>
>>
>>
>>
>>
RE: Connecting to Phoenix from AquaDataStudio?
Posted by "Riesland, Zack" <Za...@sensus.com>.
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 <Za...@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)
>
>
>
>
>
>
Re: Connecting to Phoenix from AquaDataStudio?
Posted by Gabriel Reid <ga...@gmail.com>.
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
<Za...@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/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)
>
>
>
>
>
>