Uploading patch HIVE-1101.patch. Since unixODBC is not compatible to Apache license, you need to apply this patch to unixODBC 2.2.14 and build yourself. This patch is based on the patch in
HIVE-187 and can be applied directly to unixODBC 2.2.14. The major change is to implement a simple SQLGetInfo to support MSTR v.9. Other changes are to the connection and disconnection code (SQLDriverConnect.c, SQLConnect.c, SQLFreeConnect.c etc.) to get the configuration info from odbc.ini.
1) unixODBC and MSTR both have DriverManager (libodbc.so, libodbcinst.so). You need to set LD_LIBRARY_PATH correspondingly when you run configuration and make this driver.
2) Since MSTR v9 support 32-bit driver only, you need to compile all dynamic libraries to 32-bit binaries. These include unixODBC, hiveclient, and thrift. Please refer to
HIVE-187 and http://wiki.apache.org/hadoop/Hive/HiveODBC for more information.