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 ODBC with Sentry

Solved Go to solution

Impala ODBC with Sentry

Rising Star

Hi All,

I've got a user who is trying to use Power BI to connect to impala via the odbc and kerberos.  This will work fine, however the only database he see's is the default, despite having permissions within sentry to select from every database.

If that user logs into Hue and uses impala query editior he can access all db's and tables.  However if he trying to connect to any database / table within power bi (by writing sql to pass through, as he can't see the db's in Power BI drop down), he gets the error message "AuthorizationException: User xyz does not have privildges to view table xyz.xyz

Username and xyz obvisouly would be different.

I'm at a complete loss, the user is within all the correct groups within hue, those groups maps to roles within sentry which has permissions assinged.

Any advice?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Impala ODBC with Sentry

Rising Star

Incase anyone ever comes across this thread.  We found that the problem was that the user had an upper case letter in his windows AD account.

To fix this issue we set:

HDFS Config: Map Kerberos Principals to Short Names
RULE:[1:$1]/L
DEFAULT

Impala Config: load_auth_to_local_rules
TRUE

1 REPLY 1
Highlighted

Re: Impala ODBC with Sentry

Rising Star

Incase anyone ever comes across this thread.  We found that the problem was that the user had an upper case letter in his windows AD account.

To fix this issue we set:

HDFS Config: Map Kerberos Principals to Short Names
RULE:[1:$1]/L
DEFAULT

Impala Config: load_auth_to_local_rules
TRUE

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