Hive has different authorization possibilities, and one of them is the StorageBasedAuthorizationProvider. But unfortunatly, it's bugged since 0.14. With this policy, the rights on the metastore are 'copying' the rights on the filesystem where the tables are stored (if you don't have the write rights on the filesystem, you can't drop the table). It's super easy to set up and use, compared to Sentry that need to set up a new service, plus create roles, privileges etc...
Is there any way this patch could be backported ?
Thanks in advanced,
Many thanks for your reply !
Got it for the StorageBasedAuthorizationProvider. We already started to use Sentry and has some issues for sharing rights without "Synchronizing HDFS ACLs and Sentry Permissions". The fact we couldn't use impersonation anymore was blocking. I'm going to try the syncronizing feature and everything should go smoothly now. I hope :)