DATA Step, Macro, Functions and more

error while connecting through impala

Reply
Super Contributor
Super Contributor
Posts: 359

error while connecting through impala

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?

PROC Star
Posts: 1,760

Re: error while connecting through impala

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;

Super Contributor
Super Contributor
Posts: 359

Re: error while connecting through impala

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

 

 

Super Contributor
Super Contributor
Posts: 359

Re: error while connecting through impala

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

PROC Star
Posts: 1,760

Re: error while connecting through impala

 

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.

Ask a Question
Discussion stats
  • 4 replies
  • 173 views
  • 0 likes
  • 2 in conversation