error while connecting through impala

[woo]

We have sas 9.4 on linux with sas/access to impala + sas/access to hadoop

+

we have cloudera impala odbc driver - 2.5.37 version installed

+

we have ODBCINI env. variable set up for all which is pointing to user based odbcini at individual user's home directory,

scenario1

when we run below libname statement in interactive mode (sas -nodms) job ran fine either with read only permission OR read+write permission for odbcini file for any user.

scenario2

when we run job in batch mode with read only permission for odbcini file - we receive below error

LIBNAME hdp impala dsn=xxx schema=xxx user=xxx pw="xxx" ;
ERROR: CLI error trying to establish connection: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
ERROR: Error in the LIBNAME statement.

however, when we run same test with read+write permission for odbcini file, job runs fine.

when we asked cloudera team, they said it should be matter matter what permission odbcini file has.

anyone came across same issue before?

[ChrisNZ]

1- Does the test with read only permission for odbcini file work from ODBC manager?

2- Does this work?

LIBNAME hdp impala dsn=xxx schema=xxx user=xxx pw="xxx" access=readonly;

[woo]

Thank you for your note Chris,

didn't understand your first question, have different scenarios so far,

odbcini file with read only mode + odbcini env. variable assigned centrally (/etc/profile -> pointing to user's home dir odbcini file) - interactive mode (./sas -nodms) -> job run fine

odbcini file with read only mode + odbcini env. variable assigned centrally + assign odbcini env. variable explicitely into user's home dir odbcini file - interactive mode (./sas -nodms) -> job failed

odbcini file with read only mode + odbcini env. variable assigned centrally + batch mode (sas job_name.sas) -> job failed

odbcini file with read only mode + odbcini env. variable assigned centrally + assign odbcini env. variable explicitely into user's home dir odbcini file - batch mode (sas job_name.sas) -> job run fine

[woo]

Also -> job failed with your option#2 (access=readonly) with cli error.

[ChrisNZ]

The important bit was at the end:

Does the test with read only permission for odbcini file work from ODBC manager?

Not from SAS. There is a "test" button in ODBC manager to test connections.