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:42:54 GMT
Sorry you're having so much trouble, Russell. The hbase-sites.xml overrides
values from the hbase-default.xml, so I wouldn't worry about not finding
that file. Just set what you need in the hbase-sites.xml and make sure it's
on the classpath.

Thanks,
James


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
>

Mime
View raw message