You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by Abe Weinograd <ab...@flonet.com> on 2014/08/20 15:52:11 UTC

Re: Error connecting through SQuirrel

Were you able to get this to work?  I just upgraded HBase to 0.98.1
(CDH5.1) and also to Phoenix 4.0 from 3.0 using the incubating release.
Sqlline seems to work fine.

I tried using the client jar in the downloadable binaries which as you
said, doesn't work.  Rebuilding from scratch didn't help either.  I
included my hbase-site.xml which also didn't help.  Looking at the Squirrel
log4j logs, when i included the larger 4.0 incubating client, i am getting
a lot of ClassDefNotFound errors around junit and mockito.

I did try using the client-without-hbase and then individually deploy the
hbase and other necessary jars to the Squirrel lib and that was able to
connect.  I need to package this easily, so doing it that way will be
difficult.

Oddly it seems that the hadoop1 jar works by itself, but that doesn't make
sense as we are using hadoop 2.3.

Is there anything i am missing here?

Thanks,
Abe


On Fri, Jul 25, 2014 at 8:55 AM, Gabriel Reid <ga...@gmail.com>
wrote:

> Hi Sid,
>
> The location of the jar file looks correct. However, there seems to be
> an issue with the build of hadoop2 phoenix-client jar -- the
> hbase-default.xml in that jar refers to hadoop1 for some reason. I'm
> not sure how that would have happened, but I'll follow it up on the
> dev list.
>
> For now, I can think of two options (either of the following should work):
> * Add an hbase-site.xml file in the lib directory of SQuirreL that
> sets the hbase.defaults.for.version.skip [1] setting to true
> * Rebuild the 4.0 release (git tag v4.0.0-incubating-release) from
> https://git-wip-us.apache.org/repos/asf/phoenix.git using the
> -Dhadoop.profile=2 flag (i.e. git checkout v4.0.0-incubating-release;
> mvn clean package -Dhadoop.profile=2 -DskipTests)
>
> There is a chance that the first option won't work if there really is
> something fundamentally wrong with the build of the hadoop2 version,
> but the second option should work no matter what. Can you let me know
> if either of these does or doesn't work for you?
>
>
> 1.
> http://hbase.apache.org/book/config.files.html#hbase.defaults.for.version.skip
>
>
> On Thu, Jul 24, 2014 at 10:11 PM, Siddharth Wagle
> <sw...@hortonworks.com> wrote:
> > Hi,
> >
> > I am connecting from my Mac to remote HBase running with the core phoenix
> > jar. I have put the client jar file at,
> >
> /Applications/SQuirreLSQL.app/Contents/Resources/Java/lib/phoenix-4.0.0-incubating-client.jar
> >
> > ]# rpm -qa | grep hbase
> > hbase-0.98.0.2.1.3.0-563.el6.noarch
> >
> > Exception:
> >
> > java.util.concurrent.ExecutionException: java.lang.RuntimeException:
> > java.lang.RuntimeException: hbase-default.xml file seems to be for and
> old
> > version of HBase (0.98.1-hadoop1), this version is 0.98.1-hadoop2
> >     at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:262)
> >
> > I read on another thread that the location of the client jar is wrong and
> > that it should be in the internal squirrel lib, without any hint of where
> > that is. Is there a property to provide a hbase-site to the client?
> >
> > Best Regards,
> > Sid
> >
> >
> >
> > CONFIDENTIALITY NOTICE
> > NOTICE: This message is intended for the use of the individual or entity
> to
> > which it is addressed and may contain information that is confidential,
> > privileged and exempt from disclosure under applicable law. If the
> reader of
> > this message is not the intended recipient, you are hereby notified that
> any
> > printing, copying, dissemination, distribution, disclosure or forwarding
> of
> > this communication is strictly prohibited. If you have received this
> > communication in error, please contact the sender immediately and delete
> it
> > from your system. Thank You.
>