Support Questions

Find answers, ask questions, and share your expertise

Who agreed with this topic

Failure to connect to Impala via unixODBC on Mac - cannot locate driver

avatar
Contributor

I'm trying to connect to Impala on a new mac (M2 Chip). I followed all the steps here for unixODBC. I confirmed that my unixODBC install is working and that the Cloudera driver installed properly.

When I run `odbcinst -j` I get:

unixODBC 2.3.12
DRIVERS............: /opt/homebrew/etc/odbcinst.ini
SYSTEM DATA SOURCES: /opt/homebrew/etc/odbc.ini
FILE DATA SOURCES..: /opt/homebrew/etc/ODBCDataSources
USER DATA SOURCES..: /Users/willhipson/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

Here's my odbcinst.ini

 

[ODBC Drivers]
Cloudera ODBC Driver for Impala=Installed

[Impala]
Description=Cloudera ODBC Driver for Impala
Driver=/opt/cloudera/impalaodbc/lib/universal/libclouderaimpalaodbc.dylib

 

 And here's the first few lines of my odbc.ini

 

[ODBC]

[ODBC Data Sources]
Impala=Cloudera ODBC Driver for Impala

[Impala]

Description=Cloudera Impala ODBC Driver DSN

Driver=Impala

 

I have confirmed that the driver exists in `/opt/cloudera/impalaodbc/lib/universal/libclouderaimpalaodbc.dylib`

When I try to run `isql -v Impala` in the terminal I get the error:

 

[01000][unixODBC][Driver Manager]Can't open lib '/opt/cloudera/impalaodbc/lib/universal/libclouderaimpalaodbc.dylib' : file not found
[ISQL]ERROR: Could not SQLConnect

 

I have been struggling to resolve this for several days and have scoured SO, blog posts, and this forum for help but nothing seems to work. Hoping to resolve soon.

Who agreed with this topic