You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by "bcotton3@bloomberg.net" <bc...@bloomberg.net> on 2009/12/08 17:44:31 UTC
Connect to Hive from Windows via ODBC?
Does there exist a driver that can be used to define a DSN that
connects Windows desktop apps to Hive (via ODBC DataSource)?
Re: Connect to Hive from Windows via ODBC?
Posted by John Sichi <js...@facebook.com>.
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 <nz...@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)?
>>
>>
>>
Re: Connect to Hive from Windows via ODBC?
Posted by John Sichi <js...@facebook.com>.
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 <nz...@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)?
>>
>>
>>
Re: Connect to Hive from Windows via ODBC?
Posted by Carl Steinbach <ca...@cloudera.com>.
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 <nz...@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)?
>
>
>
Re: Connect to Hive from Windows via ODBC?
Posted by Carl Steinbach <ca...@cloudera.com>.
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 <nz...@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)?
>
>
>
Re: Connect to Hive from Windows via ODBC?
Posted by Ning Zhang <nz...@facebook.com>.
Currently Hive only have an ODBC driver for Linux.
Ning
On Dec 8, 2009, at 8:44 AM, bcotton3@bloomberg.net<ma...@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)?