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 <[email protected]> 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, [email protected] < > [email protected]> 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:[email protected] <[email protected]>] >> *Sent:* Tuesday, December 08, 2009 12:35 PM >> *To:* [email protected]; [email protected] >> *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 <[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)? >> >> >> >> >> - - - - - - - - - - - - - - - - - - - - - - - - - - >> 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. >> >> >
