Usage Note 57439: Cannot open lib 'Cloudera ODBC Driver for Impala 64-bit' errors when using SAS/ACCESS® Interface to Impala
 |  |  |  |
When you use SAS/ACCESS Interface to Impala, the following error might occur:
ERROR: CLI error trying to establish connection: [unixODBC][Driver Manager]Can't open lib 'Cloudera ODBC Driver for Impala 64-bit' : file not found
The error occurs when you use code similar to this:
libname mylib sasioimp database=database-name SERVER='server-name' PORT=port-number;
If you use the same connection with a data source name such as the one shown below, the connection works correctly.
libname mylib sasioimp dsn="Sample Cloudera Impala DSN 64";
The problem occurs when the odbcinst.ini file contains incorrect header information. The Impala driver requires that the odbcinst.ini file contain the following header:
[Cloudera ODBC Driver for Impala 64-bit]
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Impala | 64-bit Enabled AIX | ||
| Linux for x64 | ||||
Cannot open lib 'Cloudera ODBC Driver for Impala 64-bit' when using SAS/ACCESS to Impala. The problem occurs when using the Impala driver without a DSN. To resolve the problem change $stking379
| Type: | Usage Note |
| Priority: |
| Date Modified: | 2016-03-07 10:26:02 |
| Date Created: | 2016-01-15 11:31:32 |