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: https://issues.apache.org/jira/browse/HIVE-576 HTH. thanks, BIll On Wed, Sep 16, 2009 at 8:36 PM, Vijay <[email protected]> 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" <[email protected]> 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 <[email protected]> > *Reply-To: *<[email protected]>, <[email protected]> > *Date: *Tue, 15 Sep 2009 22:54:50 -0700 > *To: *Vijay <[email protected]> > *Cc: *<[email protected]> > *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... > >
