Problem Note 60652: When using SAS/ACCESS® Interface to Impala with in-database procedures, you receive "ERROR...Required setting 'UID' is not present..."
When you use in-database procedures, the user ID and password are ignored and you receive an error as illustrated by the example shown below:
libname myimp impala dsn=dsn-name database=database-name user=user-ID
password=password;
NOTE: Libref MYIMP was successfully assigned as follows:
Engine: IMPALA
Physical Name: impala_prod
proc means data=myimp.sas_class;
var weight;
run;
ERROR: Error during in-database processing.
ERROR: ERROR: [unixODBC][Cloudera][DSI] (20032) Required setting 'UID' is not
present in the connection settings.
To circumvent the problem, use the CONOPTS= option to provide the full connection along with the UID and PWD as shown below:
libname myimp impala database=database-name host=host-name port=21050 UID="user-id"
PWD="password"
conopts='Driver={Impala};AuthMech=3;UseSASL=1;SSL=1;TrustedCerts=your.pem; StringColumnLength=2000';
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Impala | Microsoft® Windows® for x64 | 9.4 TS1M3 | |
| 64-bit Enabled AIX | 9.4 TS1M3 | |
| Linux for x64 | 9.4 TS1M3 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
In SAS/ACCESS Interface to Impala, when you use the in-database procedures and specify a DSN= value in the LIBNAME connection, the user= and password= values are ignored. To circumvent this issue, use the CONOPTS parameter in your LIBNAME statement.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-06-28 12:33:55 |
| Date Created: | 2017-06-16 08:47:05 |