Cloudera Community

Support Questions

Find answers, ask questions, and share your expertise
cancel
Turn on suggestions
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Advanced Search
Solved Go to solution

Unable to connect Excel 2016 for MAC to Hive

Labels:
avatar
author-rank sunxueyong
New Contributor

Created ‎04-03-2016 11:10 PM

Now the hive ODBC driver can be installed in OS X 10.11, however, Excel 2016 for MAC still can not connect. My DSN was tested successfully with iodbctest, however, Excel failed to connect with error message "IM003 [iODBC][Driver Manager]Specified driver could not be loaded" and "00000 [iODBC][Driver Manager]dlopen(/opt/hortonworks/hiveodbc/lib/universal/libhortonworkshiveodbc.dylib, 6): no suitable image found. Did find /opt/hortonworks/hiveodbc/lib/universal/libhortonworkshiveodbc.dylib: open() failed with errno=1"

14,545 Views
0
1 ACCEPTED SOLUTION

avatar
author-rank bschofield
Contributor

Created ‎06-17-2016 08:54 PM

I ran into this same problem with Excel 2016 on El Capitan. Jiaxing Liang is right in that OS X's sandboxing is blocking access to libhortonworkshiveodbc.dylib. You can verify the same by launching /Applications/Utilities/Console and filtering on 'sandboxd'. The Activity Monitor can also display if sandboxing is enabled. View -> Columns -> Sandbox.

As a work around I copied the Hortonworks Hive ODBC driver from the default install location of /opt/hortonworks to /Library/ODBC/hortonworks. I then updated the odbc.ini and odbcinst.ini files to reference the new driver location.

# Driver: The location where the ODBC driver is installed to. Driver=/Library/ODBC/hortonworks/hiveodbc/lib/universal/libhortonworkshiveodbc.dylib

The ErrorMessagesPath in the hortonworks.hiveodbc.ini files was being blocked too so that needed updating as well.

ErrorMessagesPath=/Library/ODBC/hortonworks/hiveodbc/ErrorMessages/

View solution in original post

11,764 Views
0
22 REPLIES 22

avatar
author-rank devers1 author-rank
Rising Star

Created ‎10-05-2016 09:00 PM

I can confirm that the work around does enable applications/tools like Excel and Tableau to function normally.

3,626 Views
0 Kudos

avatar
author-rank dtraver
Rising Star

Created ‎02-08-2017 06:40 PM

Hive ODBC Driver 2.1.7 (located in Hortonworks Public Repo http://public-repo-1.hortonworks.com/HDP/hive-odbc/2.1.7.1010) should have fixed this issue as per the release notes:

New installation location for macOS

On macOS, the driver now installs to /Library/hortonworks/hive. Previously, the driver installed to /opt/hortonworks/hive.

@Darwin

1,525 Views

avatar
author-rank michiel
New Contributor

Created ‎02-27-2017 11:23 AM

Note that you're linking to the file for windows. URL for OS X: http://public-repo-1.hortonworks.com/HDP/hive-odbc/2.1.7.1010/Mac_OS_X/hive-odbc-native.dmg

1,525 Views
0 Kudos
Announcements
What's New @ Cloudera
[RELEASED] Cloudera Streaming Analytics - Kubernetes Operato...
What's New @ Cloudera
[RELEASED] Cloudera Streams Messaging - Kubernetes Operator ...
Community Announcements
February 2025 Community Highlights
What's New @ Cloudera
3 Benefits of External IDE Connectivity, Now Available in Cl...
What's New @ Cloudera
Performance comparison of Spark3 on YARN with S3 Standard VS...
View More Announcements