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.