Thanks, that of course makes sense. I think I see what the issue was, the download page actually had 2.5.5 at the top (so I mistakenly thought it was the latest). Now when I checked 2.5.5 is second from the last so it's obvious it's older. Perhaps it was a glitch with the download page that day, all fine now.
... View more
I installed Impala ODBC 2.5.5 (the latest version) on OS X. The driver does not load from unixodbc 2.3.6. The error says 'cannot find file' even though it is pointing to the correct file and all dependencies are present. I checked the timestamp on the lib files:
-rwxr-xr-x 1 root wheel 576 Sep 26 2013 SimbaImpalaODBC.did -rwxr-xr-x 1 root wheel 87203512 Sep 26 2013 libclouderaimpalaodbc.dylib -rwxr-xr-x 1 root wheel 3309240 Sep 26 2013 libcrypto.1.0.0.dylib -rwxr-xr-x 1 root wheel 3309240 Sep 26 2013 libcrypto.dylib -rwxr-xr-x 1 root wheel 769176 Sep 26 2013 libssl.1.0.0.dylib -rwxr-xr-x 1 root wheel 769176 Sep 26 2013 libssl.dylib
These are from 2013, much older than the prior release I had (2.5.22).
I then installed 2.5.41 and everything worked fine again.
If there are useful fixes in 2.5.5 it would be good to get the proper version uploaded.
... View more
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. ODBCInstLib=libiodbcinst.3.52.dylib 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. Thanks, Cory
... View more