You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by "sunfl@certusnet.com.cn" <su...@certusnet.com.cn> on 2014/08/13 07:21:37 UTC
Squirrel Sql Client to phoenix
Hi,
After successfully getting phoenix driver through expanding JVM pergen space for Squirrel Sql Client, I got another problem when connecting my alias. MY connection URL are as this form: jdbc:phoenix: hadoop-2.certus.com,hadoop-7.certus.com,hadoop-6.certus.com. Then I got the following information error in the log. Anybody had encountered this problem before? hadoop-1.certus.com this node work as HMaster and Spark Master.
Caused by: java.lang.IllegalArgumentException: Not a host:port pair: PBUF
hadoop-1.certus.com ?? ?????
at org.apache.hadoop.hbase.util.Addressing.parseHostname(Addressing.java:60)
at org.apache.hadoop.hbase.ServerName.<init>(ServerName.java:101)
at org.apache.hadoop.hbase.ServerName.parseVersionedServerName(ServerName.java:283)
at org.apache.hadoop.hbase.MasterAddressTracker.bytesToServerName(MasterAddressTracker.java:77)
at org.apache.hadoop.hbase.MasterAddressTracker.getMasterAddress(MasterAddressTracker.java:61)
at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.getMaster(HConnectionManager.java:805)
at org.apache.hadoop.hbase.client.HBaseAdmin.<init>(HBaseAdmin.java:127)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:739)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1021)
at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1156)
at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:422)
at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183)
at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:226)
at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:908)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1351)
at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:131)
at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:112)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
... 8 more
CertusNet
赛特斯信息科技股份有限公司
孙福林
Add: 江苏省南京市玄武区玄武大道699-22号18幢 赛特斯大楼
Mobile: 15850710386
Mail: sunfl@certusnet.com.cn
Website: www.certusnet.com.cn
Re: Re: Squirrel Sql Client to phoenix
Posted by "sunfl@certusnet.com.cn" <su...@certusnet.com.cn>.
Hi,
Thanks so much for your reply. The phoenix version used is phoenix-4.0.0-incubating-src. And the Hbase version is Version 0.98.3-hadoop2.
I had no idea what the problem is. Looking forward for your reply.
CertusNet
赛特斯信息科技股份有限公司
孙福林
Add: 江苏省南京市玄武区玄武大道699-22号18幢 赛特斯大楼
Mobile: 15850710386
Mail: sunfl@certusnet.com.cn
Website: www.certusnet.com.cn
From: Gabriel Reid
Date: 2014-08-13 16:36
To: user
Subject: Re: Squirrel Sql Client to phoenix
Could you post the version of phoenix that you're using, as well as
the version of HBase that you're using on the server? This looks like
a mismatch between the version of HBase that Phoenix is built for and
the version of HBase running on the server.
On Wed, Aug 13, 2014 at 7:21 AM, sunfl@certusnet.com.cn
<su...@certusnet.com.cn> wrote:
> Hi,
> After successfully getting phoenix driver through expanding JVM pergen space
> for Squirrel Sql Client, I got another problem when connecting my alias. MY
> connection URL are as this form: jdbc:phoenix:
> hadoop-2.certus.com,hadoop-7.certus.com,hadoop-6.certus.com. Then I got the
> following information error in the log. Anybody had encountered this problem
> before? hadoop-1.certus.com this node work as HMaster and Spark Master.
>
>
> Caused by: java.lang.IllegalArgumentException: Not a host:port pair: PBUF
>
> hadoop-1.certus.com ?? ?????
> at org.apache.hadoop.hbase.util.Addressing.parseHostname(Addressing.java:60)
> at org.apache.hadoop.hbase.ServerName.<init>(ServerName.java:101)
> at
> org.apache.hadoop.hbase.ServerName.parseVersionedServerName(ServerName.java:283)
> at
> org.apache.hadoop.hbase.MasterAddressTracker.bytesToServerName(MasterAddressTracker.java:77)
> at
> org.apache.hadoop.hbase.MasterAddressTracker.getMasterAddress(MasterAddressTracker.java:61)
> at
> org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.getMaster(HConnectionManager.java:805)
> at org.apache.hadoop.hbase.client.HBaseAdmin.<init>(HBaseAdmin.java:127)
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:739)
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1021)
> at
> org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1156)
> at
> org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:422)
> at
> org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:226)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:908)
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1351)
> at
> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:131)
> at
> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:112)
> at
> net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
> at
> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
> ... 8 more
>
> ________________________________
> ________________________________
>
> CertusNet
>
> 赛特斯信息科技股份有限公司
>
>
>
> 孙福林
>
> Add: 江苏省南京市玄武区玄武大道699-22号18幢 赛特斯大楼
>
> Mobile: 15850710386
> Mail: sunfl@certusnet.com.cn
>
> Website: www.certusnet.com.cn
Re: Squirrel Sql Client to phoenix
Posted by Gabriel Reid <ga...@gmail.com>.
Could you post the version of phoenix that you're using, as well as
the version of HBase that you're using on the server? This looks like
a mismatch between the version of HBase that Phoenix is built for and
the version of HBase running on the server.
On Wed, Aug 13, 2014 at 7:21 AM, sunfl@certusnet.com.cn
<su...@certusnet.com.cn> wrote:
> Hi,
> After successfully getting phoenix driver through expanding JVM pergen space
> for Squirrel Sql Client, I got another problem when connecting my alias. MY
> connection URL are as this form: jdbc:phoenix:
> hadoop-2.certus.com,hadoop-7.certus.com,hadoop-6.certus.com. Then I got the
> following information error in the log. Anybody had encountered this problem
> before? hadoop-1.certus.com this node work as HMaster and Spark Master.
>
>
> Caused by: java.lang.IllegalArgumentException: Not a host:port pair: PBUF
>
> hadoop-1.certus.com ?? ?????
> at org.apache.hadoop.hbase.util.Addressing.parseHostname(Addressing.java:60)
> at org.apache.hadoop.hbase.ServerName.<init>(ServerName.java:101)
> at
> org.apache.hadoop.hbase.ServerName.parseVersionedServerName(ServerName.java:283)
> at
> org.apache.hadoop.hbase.MasterAddressTracker.bytesToServerName(MasterAddressTracker.java:77)
> at
> org.apache.hadoop.hbase.MasterAddressTracker.getMasterAddress(MasterAddressTracker.java:61)
> at
> org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.getMaster(HConnectionManager.java:805)
> at org.apache.hadoop.hbase.client.HBaseAdmin.<init>(HBaseAdmin.java:127)
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:739)
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1021)
> at
> org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1156)
> at
> org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:422)
> at
> org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:226)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:908)
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1351)
> at
> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:131)
> at
> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:112)
> at
> net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
> at
> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
> ... 8 more
>
> ________________________________
> ________________________________
>
> CertusNet
>
> 赛特斯信息科技股份有限公司
>
>
>
> 孙福林
>
> Add: 江苏省南京市玄武区玄武大道699-22号18幢 赛特斯大楼
>
> Mobile: 15850710386
> Mail: sunfl@certusnet.com.cn
>
> Website: www.certusnet.com.cn