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

Question

I am very new to hive and the hadoop ecosystem.

I am trying to create a new table in hive but I am encountering this error:

According to some suggestions, I have to set the Ranger policies but upon checking, policies already had permissions to "All"

Same permissions were also given to other policies.

Did I miss something? Thank you.

Answer 1

You might need HDFS user directory which can be created by the administrator using sudo -u hdfs hdfs dfs -mkdir /user/<user_id>

In case you want to check if there is one exists:

hdfs dfs -ls /user | grep <user_id>

Answer 2

I had a similar issue. You may want to check Ranger > Audit > Plugin Status to see if the policy is being applied. If it's not it may be that you have a jersey-client classpath conflict. More details here: https://jonmorisissqlblog.blogspot.com/2021/06/ranger-hive-policy-activation-time.html