Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
New Contributor

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? 

5 REPLIES 5

avatar
Master Guru

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


Cheers!
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

avatar
New Contributor

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.

 

 

avatar
Master Guru

@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. 


Cheers!
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

avatar
New Contributor

@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.

avatar
Master Guru

@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


Cheers!
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.