Hey Ning, Thanks for the quick reply. I'll do some more investigation on my end to see which APIs the GUI is using and which are not supported. The GUI, btw, is http://www.sqldbx.com.
Regards, Jeff On Wed, Oct 14, 2009 at 2:03 PM, Ning Zhang <nzh...@facebook.com> wrote: > 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 > >
