Using a White List with Fallback Hive Authorizer

You can add an exception to Fallback Hive Authorizer restrictions using the hive.security.authorization.sqlstd.confwhitelist.append property.

About this task

The hive.security.authorization.sqlstd.confwhitelist property is list of comma-separated Java regexes that you can append to. Appending to this list instead of updating the original list means that you can append to the default set by SQL-standard authorization instead of replacing it entirely.

You can modify the configurations parameters that match these regexes when SQL-standard authorization is enabled.

To get the default value, use the set <param> command. The hive.conf.restricted.list checks are still enforced after the white-list check.

An example of a white-list configuration is as follows:
<property>
  <name>hive.security.authorization.sqlstd.confwhitelist.append</name>
  <value>hive.reloadable.aux.jars.path</value>
</property>

Procedure

After adding this configuration to the hive-site.xml file, execute the following command:
set hive.reloadable.aux.jars.path=/path/to/jar