Reply
New Contributor
Posts: 1
Registered: ‎08-19-2018

Hive and Impala showing different roles for user with Sentry installed

[ Edited ]

I am running Cloudera 5.15, with Kerboros enabled on the cluster. Sentry is installed to configure user access to various tables/databases ...etc.

 

Everything is installed and working fine for Hive, but not for Impala.

 

I'm using Hue web UI for issuing hive/impala queries. (I'm getting same results using beeline and impala-shell though)

 

From Hue/Hive:

show current roles;

return --> "professors_role"

 

From Hue/Impala

show current roles;

return --> no results

 

When I issue "select current_user()" from hive and impala query editors I'm getting different results.

 

From hive "select current_user()" returns "hive"

 

from impala "select current_user()" returns "professor1"

 

I'm thinking perhaps this is the kulprit, but i'm not sure how to fix? Maybe I've missed a configuration setting in impala somewhere?

 

Everything works fine in hive - logging in as different users shows me different databases and tables as I would expect based on their assigned roles. Users logged into Impala can't see anything.

 

Any help is greatly appreciated.

 

Thanks

Announcements