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 <jamestay...@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 <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 >> > >
