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 <anilgupt...@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 <anilgupt...@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.jur...@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 <anilgupt...@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.jur...@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, su...@certusnet.com.cn < >>>>> su...@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: su...@certusnet.com.cn <qi...@certusnet.com.cn> >>>>>> >>>>>> Website: www.certusnet.com.cn >>>>>> >>>>>> >>>>>> *From:* Russell Jurney <russell.jur...@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.jur...@gmail.com >>>>>> datasyndrome.com >>>>>> ᐧ >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Russell Jurney twitter.com/rjurney russell.jur...@gmail.com >>>>> datasyndrome.com >>>>> >>>> >>>> >>>> >>>> -- >>>> Thanks & Regards, >>>> Anil Gupta >>>> >>> >>> >>> >>> -- >>> Russell Jurney twitter.com/rjurney russell.jur...@gmail.com datasyndrome >>> .com >>> >> >> >> >> -- >> Thanks & Regards, >> Anil Gupta >> > > > > -- > Thanks & Regards, > Anil Gupta >
