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 <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 >
