Hi Jeff, The unixODBC implementation supports ODBC 3.0 standard (see http://en.wikipedia.org/wiki/Open_Database_Connectivity#UnixODBC ), although the version number of unixODBC on which we had a patch is 2.x.
However, patches in Hive-187 only implemented a subset of ODBC 3.0 interface (see the end of the page http://wiki.apache.org/hadoop/Hive/HiveODBC ). If the software requires some some API that are not supported currently, it won't work. Could you let us know which ODBC functions are required by the software? Also note that even though the all required functions in the API are supported, it does not mean the software can integrate with Hive seamlessly. For example, the SQLExecute() function is supported by Hive's ODBC driver, but it doesn't mean any SQL queries passed by SQLExecute() can be executed by Hive. We are working on extending HiveQL to support 3rd party applications access Hive through ODBC drivers. In this respect, it would be helpful to know which SQL features the software are using so that we can put them in the roadmap. Thanks, Ning On Oct 14, 2009, at 1:31 PM, Jeff Hammerbacher wrote: > Hey, > > I started working with the ODBC patch today ( > https://issues.apache.org/jira/browse/HIVE-187) and noticed that the > ODBC > driver off of which the work is based (unixODBC) is 2.x, not 3.0. > One of the > database GUIs we're working with here requires ODBC 3.0. What was > the reason > for using unixODBC, and how much work would moving to a new ODBC > driver > require? I'm pretty out of my depth in this domain, so any help is > appreciated. > > Regards, > Jeff
