Mac M1 computers and impala driver on top of python: driver file not found (file exists on the expected location)

[#1]

Developer in my team are running into a problem setting up their development environment with M1 mac computers. We use the impala driver to access CDP. After installing all dependencies they are getting this error: 

'message': 'Error in database connection', 'error': '(\'01000\', "[01000] [unixODBC][Driver Manager]Can\'t open lib \'/opt/cloudera/impalaodbc/lib/universal/libclouderaimpalaodbc.dylib\' : file not found (0) (SQLDriverConnect)") - Driver=/opt/cloudera/impalaodbc/lib/universal/libclouderaimpalaodbc.dylib;

Still, the file existis in the expected location, which means that the message is misleading. Any ideas what we could do? Anyone having the same problem? 

[#2]

@lu_araujo How you are setting up the Env? What document you are following? 

[#3]

Hi @GangWar ! We didn't follow any specific documents. Is there any? We do have three other developers that succeeded setting up the environment but this was 8 months ago and we were some how unable to replicate what we did. 

Step 1 python install (python 3.9.10)

Setp 2 unixodbc install:

Unix odbc was installed using brew and we set the following flags: 

$ export LDFLAGS="-L/opt/homebrew/Cellar/unixodbc/2.3.9_1/lib"
$ export CPPFLAGS="-I/opt/homebrew/Cellar/unixodbc/2.3.9_1/include"

Step 3:  pip install pyodbc (4.0.32)

Step 4: pip install psycopg2-binary (2.9.1)

Step 5: install cloudera impala driver 2.6.8 using the dmg file. 

Try to connect to cloudera from the python flask app and we get the file not found error above, although the file exists in the expected location.

[#4]

@lu_araujo Yes there is. Check page 29 in below below document.

https://downloads.cloudera.com/connectors/impala_odbc_2.6.14.1016/Cloudera-ODBC-Connector-for-Impala...

Then check page 40 and so on to export variables correctly. 

I still suggest you to check /opt/cloudera/impalaodbc/lib/universal/libclouderaimpalaodbc.dylib\ exist with correct ownership and permission. 

Secondly reinstall the driver again on the target location and MacOS using above doc. Make sure to follow the instructions regarding odbc.ini in th doc. 

If it still fails you can open a support case with Cloudera. Hope this helps. 

[#5]

@GangWar What exactly are the steps for opening a support case with Cloudera? We know the manual for installing the driver and we followed all its steps. Still, no success. Thanks for all your help.

[#6]

@lu_araujo If you are a Cloudera Customer Or having Cloudera Enterprise License/Subscription You can open a support case on Cloudera Portal. You must be a registered user on Cloudera to do the same. 

https://my.cloudera.com/faq/support.html#create-case