hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carl Steinbach <c...@cloudera.com>
Subject Re: FW: Connect to Hive from Windows via ODBC?
Date Tue, 08 Dec 2009 22:10:34 GMT
I filed a JIRA for this issue: http://issues.apache.org/jira/browse/HIVE-975

On Tue, Dec 8, 2009 at 1:28 PM, Carl Steinbach <carl@cloudera.com> wrote:

> I did some digging and found this thread on the unixODBC support list:
> http://mailman.unixodbc.org/pipermail/unixodbc-support/2008-June/001779.html
>
> The important part comes at the end:
>
> If you are happy to code to the ODBC API (and there is no reason why
> not, thats what its for), then if you just include the odbc headers
> sql.h, sqlext.h and so on, you can just use ODBC on windows linking to
>
> the native driver manager (odbc32.dll), then you can write code that
> builds and works just the same on Windows and *nix platforms. That was
> one of the initial goals of unixODBC.
>
> So it sounds like it is possible to write an ODBC driver that is compatible
> with both unixODBC and the windows ODBC manager, and potentially the current
> driver fits that bill. If so, the other problem that currently blocks
> getting this to run on Windows is the lack of a Thrift C++ runtime. There is
> a JIRA for that issue (http://issues.apache.org/jira/browse/THRIFT-591) as
> well as a patch, but it has not yet been committed.
>
> Carl
>
> me digging and found this th
>
> On Tue, Dec 8, 2009 at 11:41 AM, ben.cotton@lehman.com <
> benjamin.cotton@lehman.com> wrote:
>
>>  >  [...]  we should file a new ticket for a windows compatible Hive ODBC
>> driver.
>>
>> Indeed!
>>
>> Hive's appeal is that it provides an SQL-familiar view of Hadoop data
>> operators and operands.  Familair desktop  tools for interacting w/ these
>> data views (Excel, Acess, SqlDbx, etc.) cannot yet treat Hive as an ODBC
>> data source.   For us, this is  a significant capability gap.
>>
>>
>>
>>
>>
>> *From:* Carl Steinbach [mailto:carl@cloudera.com <carl@cloudera.com>]
>> *Sent:* Tuesday, December 08, 2009 12:35 PM
>> *To:* hive-user@hadoop.apache.org; hive-dev@hadoop.apache.org
>> *Subject:* Re: Connect to Hive from Windows via ODBC?
>>
>>
>>
>> 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)?
>>
>>
>>
>>
>>  - - - - - - - - - - - - - - - - - - - - - - - - - -
>> This message is intended only for the personal and confidential use of the
>> designated recipient(s) named. If you are not the intended recipient of this
>> message, you are hereby notified that any review, dissemination,
>> distribution or copying of this message is strictly prohibited. This
>> communication is for information purposes only and should not be regarded as
>> an offer to sell or as a solicitation of an offer to buy any financial
>> product, an official confirmation of any transaction, or as an official
>> statement of Aurora Bank FSB. Email transmission cannot be guaranteed to be
>> secure or error-free. Therefore, we do not represent that this information
>> is complete or accurate and it should not be relied upon as such. All
>> information is subject to change without notice.
>>
>>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message