Hive ODBC Driver on OSX 10.11 (El Capitan)

[#1]

The Hortonworks Hive ODBC Driver for OSX 10.11 (El Capitan) fails to install.

"This package is incompatible with this version of OS X and may fail to install"

This issue is being tracked on (with full installer log) here:

https://hortonworks.jira.com/browse/BUG-47990

Support/Engineering will be reaching out to Simba Tech for a new Hive ODBC Driver.

[#2]

Temp workaround:

https://apple.stackexchange.com/questions/208478/how-do-i-disable-system-integrity-protection-sip-ak...

Thanks to @Yi Zhang for the suggestion.

[#3]

Simba have released an updated ODBC driver called 2.1.0.

Link: https://simba.box.com/s/sq9zyyogft7ee42i18geiyevx371txrd

This fix addresses critical Windows problems as well as the inability to install properly on OSX El Capitain.

This does not address CentOS 7 compatibility unfortunately.

[#4]

This post should not be categorized as an "article". An article should show in a structured manner why, what, how, benefits, conclusions, etc. about a topic. This is a support issue, at most a question "what to do when ODBC driver fails to install on OSZX 10.11"? @dtraver please reclassify it as a question, for clarity-sake and fairness for what an article should be.

[#5]

The referenced JIRA above is now resolved. I have successfully tested the new version of the Hive ODBC Driver on Mac OSX version 10.11 (El Capitan). However, please note that you must install the new Hive ODBC driver version 2.1.2 as shown through the iODBC Administration tool

Please also note that the location of the driver file has changed. Here is the new odbcinst.ini file (stored in ~/.odbcinst.ini), showing the old driver location commented out and the new driver location below it:

[ODBC Drivers]
Hortonworks Hive ODBC Driver=Installed

[Hortonworks Hive ODBC Driver]
Description=Hortonworks Hive ODBC Driver

; old driver location
; Driver=/usr/lib/hive/lib/native/universal/libhortonworkshiveodbc.dylib
;  new driver location below
Driver=/opt/hortonworks/hiveodbc/lib/universal/libhortonworkshiveodbc.dylib