HiveAccessControlException Permission denied: user [integration_user] does not have [RWSTORAGE] privilege on [deltastoragehandler://true/]
arijit999 opened this issue · 1 comments
Getting error when trying to create a delta table using beeline. How to resolve privilege issue on deltastoragehandler?
Added following jars to beeline:
delta-hive-assembly_2.12-0.6.0.jar;
delta-standalone_2.12-0.6.0.jar;
As per admin max privileges has been granted.
Ranger is integrated.
Error encountered:
Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [integration_user] does not have [RWSTORAGE] privilege on [deltastoragehandler://true/] (state=42000,code=40000)
This link helped resolve the Ranger Policy issue.
https://docs.cloudera.com/cdp-private-cloud-base/latest/security-ranger-authorization/topics/security-ranger-resource-policy-storage-handler.html?
