01-31-2018 07:26 AM
I am trying to configure the Cloudera ODBC Driver for Impala on a Mac. The instructions state that you need to set the DYLD_LIBRARY_PATH to the location of the iODBC libraries. The issue is that with the later OS X versions, setting DYLD_LIBRARY_PATH or LD_LIBRARY_PATH is prohibited by System Integrity Protection.
The trace error we get is:
Jan 31 11:11:09 INFO 1 ConnectionAttributes::SetAttribute: Invalid attribute: 1051
Jan 31 11:11:09 ERROR 1 Connection::SQLSetConnectAttr: [Cloudera][ODBC] (10210) Attribute identifier invalid or not supported: 1051
Jan 31 11:11:09 TRACE 1 CInterface::SQLDriverConnectW: +++++ enter +++++
Jan 31 11:11:09 TRACE 1 Connection::SQLDriverConnectW: +++++ enter +++++
Jan 31 11:11:09 TRACE 1 ConnectionState2::SQLDriverConnectW: +++++ enter +++++
Jan 31 11:11:09 ERROR 1 Connection::SQLDriverConnectW: [Cloudera][ODBC] (10360) Invalid connection string.
I found this in an earlier issue, and it said the solution was to set the DYLD_LIBRARY_PATH (but now this is no longer possible).
Is the driver searching for that specific variable?
I have the required libraries in: /usr/local/lib
That should be at the front of the runtime search path for libraries. I also tried modifying the clouder.impala.odbc.ini file with the library name, a specific name that has the version in it, and still no luck. We tried including the path to the file as well.
Please let me know if there is a fix for this, or possibly a later version of the driver.
FYI, we have been able to make UnixODBC work on a Mac, just not iODBC, and we need iODBC to support Microsoft Excel.