hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bill Graham <>
Subject Re: Problems using hive JDBC driver on Windows (with Squirrel SQL Client)
Date Thu, 17 Sep 2009 05:47:41 GMT
Additional help could certainly be used on the JDBC driver. I agree that
getting the JDBC support full-featured is a good place to focus your energy.
Guys correct me if I'm wrong, but the approach has generally been to pick a
SQL client desktop app and implement the JDBC methods need to support it.
Raghu did that with Pentaho and I did the same for Squirrel.

I don't normally use Squirrel, but I implemented to it since it's open
source and it gives great visibility in the logs/admin window into which
JDBC methods are being called that are not yet implemented and it's fairly
forgiving. (I'm a fan of DBVisualizer, but it doesn't give very much useful
info when something in the driver isn't implemented, plus it tends to
fail-fast when an optional metadata methods fails.)

Regarding what's currently being worked on in the driver, I'm working on
HIVE-795 to get better error messaing and SQLStates passed from the Hive
server to the JDBC driver. Others can comment on what else is active, but
I'd recommend searching for open JIRAs where Component/s is 'Client'. This
issue has also become somewhat of an umbrella bug for JDBC, and contains a
number of TODOs:



On Wed, Sep 16, 2009 at 8:36 PM, Vijay <> wrote:

> This may be something i'd be interested in working on. My idea in general
> would be to make the jdbc driver as thin and full featured as reasonable.
> I'm convinced this is the best way to integrate hive with many of the
> excellent tools available out thee.
> Although I could get the jdbc driver to work with a couple of these tools
> I'm having trouble to get it working with many others. Especially on windows
> it is slightly more painful. Is there some work in progress along these
> lines? Any thoughts or pointers?
> Thanks in advance,
> Vijay
> On Sep 15, 2009 10:59 PM, "Prasad Chakka" <> wrote:
>  SerDe may be needed to deserialize the result from Hive server. But I
> also thought the results are in delimited form (LazySimpleSerDe or
> MetadataTypedColumnSetSerDe or something like that) so it is possible to
> decouple hadoop jar but will take some work.
> ------------------------------
> *From: *Bill Graham <>
> *Reply-To: *<>, <>
> *Date: *Tue, 15 Sep 2009 22:54:50 -0700
> *To: *Vijay <>
> *Cc: *<>
> *Subject: *Re: Problems using hive JDBC driver on Windows (with Squirrel
> SQL  Client)
> Good question. The JDBC package relies on the hive serde2 package, which
> has at least the followin...
> > > Thanks a lot Bill! That was my problem. I thought my code base was
> pretty recent. Apparently not...

View raw message