hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Sichi <jsi...@facebook.com>
Subject Re: Connect to Hive from Windows via ODBC?
Date Tue, 08 Dec 2009 19:20:36 GMT
If there's interest in going beyond ODBC to any calling environment  
where a PostgreSQL client is already supported, someone recently came  
up with this:

http://code.google.com/p/pg2luciddb/

It is targeted at LucidDB, but it could be generalized into a pg2jdbc  
bridge for use with systems such as Hive which have JDBC as their  
primary API.  The nice part is that nothing special is needed on the  
client side, and the server side is pure Java; the listening server  
translates PostgreSQL requests from the client into JDBC calls, so you  
just use standard pgsql stuff (e.g. ODBC driver or DBI) on the client  
side.

It does rely on view support for faking the PostgreSQL metadata views,  
so some Hive work would be needed there.

However, from a performance perspective, and probably most other  
aspects, the native Hive ODBC driver is a better option, so this would  
mostly be useful as duct tape for the environments where native  
support isn't available yet.

JVS

On Dec 8, 2009, at 9:35 AM, Carl Steinbach wrote:

> Has anyone tried to getting the windows ODBC driver manager to  
> recognize
> Hive's unixODBC ODBC driver? I was able to build unixODBC on cygwin
> following these directions (
> http://embeddedtimes.wordpress.com/2009/05/10/installing-unixodbc-on-cygwin-windows-xp/

> ),
> but it's unclear to me if it is possible to make the windows ODBC  
> driver
> manager recognize a driver written using the unixODBC library. Does  
> anyone
> on the list know if this should definitely not work?
>
> If unixODBC is a non-starter on windows, we should file a new ticket  
> for a
> windows compatible Hive ODBC driver. I imagine that most of the  
> people who
> want to use ODBC to connect to Hive are running windows.
>
> Carl
>
> On Tue, Dec 8, 2009 at 8:50 AM, Ning Zhang <nzhang@facebook.com>  
> wrote:
>
>> Currently Hive only have an ODBC driver for Linux.
>>
>> Ning
>>
>> On Dec 8, 2009, at 8:44 AM, bcotton3@bloomberg.net wrote:
>>
>> Does there exist a driver that can be used to define  a  DSN that  
>> connects
>> Windows desktop apps to Hive (via ODBC DataSource)?
>>
>>
>>


Mime
View raw message