Filter HMS results

HMS can perform server-side filtering of data returned by a read operation. Filtering is enabled by default, which shows the results of statements, such as SHOW TABLES or SHOW DATABASES, based on who the user is. You can disable 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.