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 <[email protected]> > wrote: > >> Currently Hive only have an ODBC driver for Linux. >> >> Ning >> >> On Dec 8, 2009, at 8:44 AM, [email protected] wrote: >> >> Does there exist a driver that can be used to define a DSN that >> connects >> Windows desktop apps to Hive (via ODBC DataSource)? >> >> >>
