You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Russell Jurney <ru...@gmail.com> on 2014/08/22 02:51:39 UTC
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
ᐧ
Re: Unable to Connect Squirrel to Phoenix 4
Posted by James Taylor <ja...@apache.org>.
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 <an...@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 <ru...@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 <an...@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 <qi...@certusnet.com.cn>
>>>>>
>>>>> Website: www.certusnet.com.cn
>>>>>
>>>>>
>>>>> *From:* Russell Jurney <ru...@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
>
Re: Unable to Connect Squirrel to Phoenix 4
Posted by Abe Weinograd <ab...@flonet.com>.
I have a similar issue. We are using CDH5.1 and subsequently Hadoop2. For
Squirrel, I have to use the Hadoop1 JAR (makes no sense to me). That works.
Additionally, I have taking the phoenix-client without hbase jars and added
the subsequent cloudera jars that are needed to the squirrel lib and that
works too. Since we need to easily package this for some folks, I just
stuck with the Hadoop1 JAR. I had to do the same thing for Phoenix 3
before we upgraded Hbase.
Abe
On Fri, Aug 22, 2014 at 12:54 AM, James Taylor <ja...@apache.org>
wrote:
> 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 <an...@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 <an...@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 <an...@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 <qi...@certusnet.com.cn>
>>>>>>>
>>>>>>> Website: www.certusnet.com.cn
>>>>>>>
>>>>>>>
>>>>>>> *From:* Russell Jurney <ru...@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
>>
>
>
Re: Unable to Connect Squirrel to Phoenix 4
Posted by James Taylor <ja...@apache.org>.
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 <an...@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 <an...@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 <an...@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 <qi...@certusnet.com.cn>
>>>>>>
>>>>>> Website: www.certusnet.com.cn
>>>>>>
>>>>>>
>>>>>> *From:* Russell Jurney <ru...@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
>
Re: Unable to Connect Squirrel to Phoenix 4
Posted by anil gupta <an...@gmail.com>.
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 <an...@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 <ru...@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 <an...@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 <qi...@certusnet.com.cn>
>>>>>
>>>>> Website: www.certusnet.com.cn
>>>>>
>>>>>
>>>>> *From:* Russell Jurney <ru...@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
Re: Unable to Connect Squirrel to Phoenix 4
Posted by anil gupta <an...@gmail.com>.
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 <ru...@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 <an...@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 <qi...@certusnet.com.cn>
>>>>
>>>> Website: www.certusnet.com.cn
>>>>
>>>>
>>>> *From:* Russell Jurney <ru...@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
Re: Unable to Connect Squirrel to Phoenix 4
Posted by Russell Jurney <ru...@gmail.com>.
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 <an...@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 <ru...@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 <qi...@certusnet.com.cn>
>>>
>>> Website: www.certusnet.com.cn
>>>
>>>
>>> *From:* Russell Jurney <ru...@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
Re: Unable to Connect Squirrel to Phoenix 4
Posted by anil gupta <an...@gmail.com>.
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 <ru...@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 <qi...@certusnet.com.cn>
>>
>> Website: www.certusnet.com.cn
>>
>>
>> *From:* Russell Jurney <ru...@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
Re: Unable to Connect Squirrel to Phoenix 4
Posted by Russell Jurney <ru...@gmail.com>.
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 <qi...@certusnet.com.cn>
>
> Website: www.certusnet.com.cn
>
>
> *From:* Russell Jurney <ru...@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
Re: Unable to Connect Squirrel to Phoenix 4
Posted by "sunfl@certusnet.com.cn" <su...@certusnet.com.cn>.
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
Website: www.certusnet.com.cn
From: Russell Jurney
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
ᐧ