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.

HiveAccessControlException Permission Denied: user does not have [ALL] privilege

HiveAccessControlException Permission Denied: user does not have [ALL] privilege

New Contributor

Hi.

I am very new to hive and the hadoop ecosystem.

I am trying to create an external table in hive but I am encountering this error:

108345-1556627563106.png

Upon reading, the suggestions points the Ranger policy to be the root cause but upon checking, all policies have already been given permission to "All"

108327-1556627618966.png


Did I miss something?

Thank you for the assist.

3 REPLIES 3

Re: HiveAccessControlException Permission Denied: user does not have [ALL] privilege

Mentor

@Matthew Alcala

Have you tried setting the policy [all - database, table, column] instead of all-hiveservice which enables a user who has Service Admin permission in Ranger to run the kill query API

Reference_Ranger_hive_policy

Please that and revert



Re: HiveAccessControlException Permission Denied: user does not have [ALL] privilege

New Contributor

Hi Geoffrey.


Actually, all other policies already have the same permissions with the all-hiveservice.


108364-1556776814301.png


108315-1556776901577.png


Which makes it more weird because all of them have the "All" permissions but still having that error.

Re: HiveAccessControlException Permission Denied: user does not have [ALL] privilege

Mentor

@Matthew Alcala

Can you share some info about your cluster HDP version, AD/LAP integration, Kerberos, nodes, etc?

So I can check if I have a sandbox of the same version