Does Drill impersonation work with Hive SQL based authorization?
See all drill best practice FAQs.
This is a question that the MapR Drill team is often asked.
Yes, user identity in Drill via impersonation will be applied to Hive tables secured via SQL based authorization. This will apply if you are querying Hive tables from Drill using the Hive storage plugin. Note however that SQL based authorization is not intended for metadata security on the Hive metastore. This means that SHOW SCHEMAS and SHOW TABLES will return all databases and tables from the Hive metastore irrespective of permissions. Actual queries on Hive tables however will only work if the user has the appropriate permissions on those tables.
Retrieving data ...