Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Impala Connectivity issue

Impala Connectivity issue

New Contributor

Hi Team 

 

We have configured SAS/ACCESS Interface to Impala Database to run SAS Macros against data that is accessible by Impala,

 

Hive Configuration details,

ODBC Driver Version: 2.5.5

Bitwise: 64Bit

 

Impala Configuration details,

ODBC Driver Version: 2.5.24

Bitwise: 64Bit

 

User created a macro to run four queries and the year is passed(2008,2018) as argument , so for each year it will run four queries. While running it fails for random year with below error.

 

%macro zz_plit_as_patients(startyear, endyear);   # This Macro runs for all the years in between them.

%do year = &startyear %to &endyear;

 

 

Error Log :

 

MLOGIC(DISCONNDBPASSTHROUGH):  Beginning execution.

MLOGIC(DISCONNDBPASSTHROUGH):  Stored compiled macro in libref ASSIGN compiled 13JAN20:17:59:32 with V9.4.

MLOGIC(DISCONNDBPASSTHROUGH):  Parameter LIBNAME1 has value imp

SYMBOLGEN:  Macro variable LIBNAME1 resolves to imp

MPRINT(ZZ_PLIT_AS_PATIENTS.DISCONNDBPASSTHROUGH):   disconnect from imp;

MLOGIC(DISCONNDBPASSTHROUGH):  Ending execution.

MPRINT(ZZ_PLIT_AS_PATIENTS):  ;

MLOGIC(ZZ_PLIT_AS_PATIENTS):  %DO loop index variable YEAR is now 2018; loop will iterate again.

MLOGIC(CONNDBPASSTHROUGH):  Beginning execution.

MLOGIC(CONNDBPASSTHROUGH):  Stored compiled macro in libref ASSIGN compiled 13JAN20:17:59:32 with V9.4.

SYMBOLGEN:  Macro variable STUDY_NO resolves to RWE_2020_02921

MLOGIC(CONNDBPASSTHROUGH):  Parameter DBNAME has value RWE_2020_02921

MLOGIC(CONNDBPASSTHROUGH):  Parameter LIBNAME1 has value imp

MPRINT(ZZ_PLIT_AS_PATIENTS.CONNDBPASSTHROUGH):   OPTIONS NONOTES NOSTIMER NOSOURCE NOSOURCE2 NOSYNTAXCHECK NOMAUTOSOURCE nomprint

 nomlogic

ERROR: CLI error trying to establish connection: [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] :

        AuthorizationException: User 'zhengzhg' does not have privileges to access: RWE_2020_02921.*

MPRINT(CONNDBPASSTHROUGH):   SYMBOLGEN MPRINTNEST;

MLOGIC(CONNDBPASSTHROUGH):  Ending execution.

MPRINT(ZZ_PLIT_AS_PATIENTS):  ;

SYMBOLGEN:  Macro variable USR resolves to zz

SYMBOLGEN:  Macro variable YEAR resolves to 2018

MPRINT(ZZ_PLIT_AS_PATIENTS):   execute ( drop table if exists zz_3_ptid_as_2018 purge;

MPRINT(ZZ_PLIT_AS_PATIENTS):   ) by imp;

ERROR: The IMP engine cannot be found.

ERROR: A Connection to the imp DBMS is not currently supported, or is not installed at your site.

SYMBOLGEN:  Macro variable USR resolves to zz

SYMBOLGEN:  Macro variable YEAR resolves to 2018

SYMBOLGEN:  Macro variable YEAR resolves to 2018

 

 

User able to access the Database by creating and dropping tables, but if we ran again it fails for some other “year”. Is this cause because of continuous query fired via SAS.

I have verified HDFS /tmp access for the user


he is having access for /tmp folder still facing issue

 

here around 15 impala nodes  and also Sentry, LDAP authentication enabled.

 

 

Kindly Help me as soon as possible.

2 REPLIES 2
Highlighted

Re: Impala Connectivity issue

Cloudera Employee

Does the user have access to the database RWE_2020_02921?

 

The exception below seems to indicate he/she does not: "AuthorizationException: User 'zhengzhg' does not have privileges to access: RWE_2020_02921.*"

 

What is the exact query that is being run against the RWE_2020_02921 database?

Highlighted

Re: Impala Connectivity issue

New Contributor

User having privileges but still facing connectivity issues with impala database.

Don't have an account?
Coming from Hortonworks? Activate your account here