phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Unable to Connect Squirrel to Phoenix 4
Date Fri, 22 Aug 2014 04:54:53 GMT
Good point, Anil. That's been a cause of issues in the past as well. Thanks,

James


On Thu, Aug 21, 2014 at 9:42 PM, anil gupta <anilgupta84@gmail.com> wrote:

> Another naive suggestion:
> Is it possible that maybe you have many/conflicting phoenix-client or
> hbase jar files in squirrel classpath?
>
>
> On Thu, Aug 21, 2014 at 9:40 PM, anil gupta <anilgupta84@gmail.com> wrote:
>
>> Hi Russel,
>>
>> AFAIK, hbase-default.xml is present in hbase jar files. But, it sounds
>> really weird that even after copying your cluster conf files squirrel is
>> complaining about this.
>>
>> Thanks,
>> Anil Gupta
>>
>>
>> On Thu, Aug 21, 2014 at 9:20 PM, Russell Jurney <russell.jurney@gmail.com
>> > wrote:
>>
>>> I added my cluster's hbase-site.xml and core-site.xml and I get the
>>> error below. This is bad, as I can't find hbase-default.xml for CDH5.1
>>> anywhere on the machine.
>>>
>>> java.util.concurrent.ExecutionException: java.lang.RuntimeException:
>>> java.lang.RuntimeException: hbase-default.xml file seems to be for and old
>>> version of HBase (null), this version is 0.98.1-cdh5.1.0
>>>  at java.util.concurrent.FutureTask.report(FutureTask.java:122)
>>> at java.util.concurrent.FutureTask.get(FutureTask.java:202)
>>>  at
>>> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
>>> at
>>> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
>>>  at
>>> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
>>> at
>>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>>>  at java.util.concurrent.FutureTask.run(FutureTask.java:262)
>>> at
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>>>  at
>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>>> at java.lang.Thread.run(Thread.java:724)
>>> Caused by: java.lang.RuntimeException: java.lang.RuntimeException:
>>> hbase-default.xml file seems to be for and old version of HBase (null),
>>> this version is 0.98.1-cdh5.1.0
>>> at
>>> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:175)
>>>  at
>>> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
>>> at
>>> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
>>>  ... 5 more
>>> Caused by: java.lang.RuntimeException: hbase-default.xml file seems to
>>> be for and old version of HBase (null), this version is 0.98.1-cdh5.1.0
>>>  at
>>> org.apache.hadoop.hbase.HBaseConfiguration.checkDefaultsVersion(HBaseConfiguration.java:70)
>>> at
>>> org.apache.hadoop.hbase.HBaseConfiguration.addHbaseResources(HBaseConfiguration.java:102)
>>>  at
>>> org.apache.hadoop.hbase.HBaseConfiguration.create(HBaseConfiguration.java:113)
>>> at
>>> org.apache.phoenix.query.ConfigurationFactory$ConfigurationFactoryImpl.getConfiguration(ConfigurationFactory.java:41)
>>>  at
>>> org.apache.phoenix.query.QueryServicesOptions.withDefaults(QueryServicesOptions.java:146)
>>> at
>>> org.apache.phoenix.query.QueryServicesImpl.<init>(QueryServicesImpl.java:34)
>>>  at
>>> org.apache.phoenix.jdbc.PhoenixDriver.getQueryServices(PhoenixDriver.java:96)
>>> at
>>> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:114)
>>>  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)
>>> ... 7 more
>>>
>>> ᐧ
>>>
>>>
>>> On Thu, Aug 21, 2014 at 8:02 PM, anil gupta <anilgupta84@gmail.com>
>>> wrote:
>>>
>>>> Hi Russell,
>>>>
>>>> Is you cluster conf files(hbase-site.xml, core-site.xml, etc) present
>>>> in classpath of Squirrel? Typically, i copy them in lib folder of squilrrel.
>>>>
>>>> Thanks,
>>>> Anil Gupta
>>>>
>>>>
>>>> On Thu, Aug 21, 2014 at 7:54 PM, Russell Jurney <
>>>> russell.jurney@gmail.com> wrote:
>>>>
>>>>> Thats the thing - I am using the appropriate phoenix client jar for my
>>>>> hbase cluster. SQLine works smoothly, but I'd like to use Squirrel.
>>>>> ᐧ
>>>>>
>>>>>
>>>>> On Thu, Aug 21, 2014 at 6:01 PM, sunfl@certusnet.com.cn <
>>>>> sunfl@certusnet.com.cn> wrote:
>>>>>
>>>>>> Try to utilize appropriate phoenix-[version]-client.jar for your
>>>>>> hbase cluster.
>>>>>> If sqlline works smoothly, try to rebuild phoenix and get the client
>>>>>> jar.
>>>>>>
>>>>>> ------------------------------
>>>>>> ------------------------------
>>>>>>
>>>>>> CertusNet
>>>>>>
>>>>>> 赛特斯信息科技股份有限公司
>>>>>>
>>>>>>
>>>>>>
>>>>>> 孙福林
>>>>>>
>>>>>> Add:  江苏省南京市玄武区玄武大道699-22号18幢 赛特斯大楼
>>>>>>
>>>>>> Mobile: 15850710386
>>>>>> Mail: sunfl@certusnet.com.cn <qiuyj@certusnet.com.cn>
>>>>>>
>>>>>> Website: www.certusnet.com.cn
>>>>>>
>>>>>>
>>>>>> *From:* Russell Jurney <russell.jurney@gmail.com>
>>>>>> *Date:* 2014-08-22 08:51
>>>>>> *To:* user@phoenix.apache.org
>>>>>> *Subject:* Unable to Connect Squirrel to Phoenix 4
>>>>>> I follow instructions but get this error:
>>>>>>
>>>>>> java.util.concurrent.ExecutionException: java.lang.RuntimeException:
>>>>>> java.lang.RuntimeException: hbase-default.xml file seems to be for
and old
>>>>>> version of HBase (null), this version is 0.98.1-cdh5.1.0
>>>>>>  at java.util.concurrent.FutureTask.report(FutureTask.java:122)
>>>>>> at java.util.concurrent.FutureTask.get(FutureTask.java:202)
>>>>>>  at
>>>>>> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
>>>>>> at
>>>>>> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
>>>>>>  at
>>>>>> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
>>>>>> at
>>>>>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>>>>>>  at java.util.concurrent.FutureTask.run(FutureTask.java:262)
>>>>>> at
>>>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>>>>>>  at
>>>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>>>>>> at java.lang.Thread.run(Thread.java:724)
>>>>>> Caused by: java.lang.RuntimeException: java.lang.RuntimeException:
>>>>>> hbase-default.xml file seems to be for and old version of HBase (null),
>>>>>> this version is 0.98.1-cdh5.1.0
>>>>>> at
>>>>>> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:175)
>>>>>>  at
>>>>>> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
>>>>>> at
>>>>>> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
>>>>>>  ... 5 more
>>>>>> Caused by: java.lang.RuntimeException: hbase-default.xml file seems
>>>>>> to be for and old version of HBase (null), this version is 0.98.1-cdh5.1.0
>>>>>>  at
>>>>>> org.apache.hadoop.hbase.HBaseConfiguration.checkDefaultsVersion(HBaseConfiguration.java:70)
>>>>>> at
>>>>>> org.apache.hadoop.hbase.HBaseConfiguration.addHbaseResources(HBaseConfiguration.java:102)
>>>>>>  at
>>>>>> org.apache.hadoop.hbase.HBaseConfiguration.create(HBaseConfiguration.java:113)
>>>>>> at
>>>>>> org.apache.phoenix.query.ConfigurationFactory$ConfigurationFactoryImpl.getConfiguration(ConfigurationFactory.java:41)
>>>>>>  at
>>>>>> org.apache.phoenix.query.QueryServicesOptions.withDefaults(QueryServicesOptions.java:146)
>>>>>> at
>>>>>> org.apache.phoenix.query.QueryServicesImpl.<init>(QueryServicesImpl.java:34)
>>>>>>  at
>>>>>> org.apache.phoenix.jdbc.PhoenixDriver.getQueryServices(PhoenixDriver.java:96)
>>>>>> at
>>>>>> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:114)
>>>>>>  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)
>>>>>> ... 7 more
>>>>>>
>>>>>> --
>>>>>> Russell Jurney twitter.com/rjurney russell.jurney@gmail.com
>>>>>> datasyndrome.com
>>>>>> ᐧ
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Russell Jurney twitter.com/rjurney russell.jurney@gmail.com
>>>>> datasyndrome.com
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Thanks & Regards,
>>>> Anil Gupta
>>>>
>>>
>>>
>>>
>>> --
>>> Russell Jurney twitter.com/rjurney russell.jurney@gmail.com datasyndrome
>>> .com
>>>
>>
>>
>>
>> --
>> Thanks & Regards,
>> Anil Gupta
>>
>
>
>
> --
> Thanks & Regards,
> Anil Gupta
>

Mime
View raw message