Sudo vi /Library/ODBC/hortonworks/hiveodbc/lib/universal/Įh, no, it didn’t work for me with just those two files. Responsible: /Applications/Microsoft Excel.app/Contents/MacOS/Microsoft Excel įinally ended up moving my data sudo cp -R /opt/hortonworks /Library/ODBC/Īnd setting up odbc.ini and odbcinst.ini files to reference the new driver location. Path: /Applications/Microsoft Excel.app/Contents/MacOS/Microsoft Excel Violation: deny file-read-data /opt/hortonworks/hiveodbc/lib/universal/libhortonworkshiveodbc.dylib I could see those “deny file-data-read” violations! 🙄 SandboxViolation: Microsoft Excel(12403) deny file-read-data /opt/hortonworks/hiveodbc/lib/universal/libhortonworkshiveodbc.dylib Some of my research lead to this, and turns out it indeed was a problem of mac sandbox security. Are you running El Capitan on Sierra? Well I was running Sierra and tried connecting before while running on El Capitan. So you done everything right and can’t connect Excel to Hive using ODBC driver on your macOS? I try to install 'Hive ODBC Driver for HDP 2.3 (v2.0.5)' on Mac OS 10.11.2, I have successful installed iODBC version 3.52.10 but the installation of the Hive ODBC driver fails.

Hortonworks jdbc driver for mac