My name is Kyle, and I work for Simba Technologies which develops the underlying ODBC driver that you are using. I may be able to help you resolve the issue you’re facing, as we’ve seen a few similar issues.
Would you be able to do the following:
1) Set the following environment variables
a. ODBCINI = /usr/lib/hive/lib/native/hiveodbc/Setup/odbc.ini
b. ODBCINSTINI = /usr/lib/hive/lib/native/hiveodbc/Setup/odbcinst.ini
c. SIMBAINI = /usr/lib/hive/lib/native/hiveodbc/Setup/hortonworks.hiveodbc.ini
This is because, in our testing, we noticed that the ini files were not being picked up by the iodbctest program even though they were in the home directory
2) Starting up Excel:
You can do either of the following options to launch Excel:
a. Launch Excel from command line
i. Set the environment variable DYLD_LIBRARY_PATH =/usr/lib/hive/lib/native/universal/
ii. Go to “/Applications/Microsoft Office 2011/Microsoft Excel.app/Contents/MacOS” and launch Excel in command line
b. Set launchctl from the command line
i. launchctl setenv DYLD_LIBRARY_PATH /usr/lib/hive/lib/native/universal/
ii. Open Excel as usual from the launcher.