Filter HMS results
HMS can perform server-side filtering of data returned by a read operation. Enabling the filter can show results of statements, such as SHOW TABLES or SHOW DATABASES, based on who the user is. You enable filtering by setting a boolean flag and hook. The hook identifies the class name that implements the filtering.
You add the following properties and values in hive-site.xml for HMS
API-Ranger integration:
- metastore.server.filter.enabled
- Value: true (to do filtering) or false (no filtering)
- metastore.filter.hook
- Value: org.apache.hadoop.hive.ql.security.authorization.plugin.metastore.HiveMetaStoreAuthorizer
Add properties as described in the previous section.