Attempting to modify Hive configuration parameters might result in a "Cannot modify 'parameter' at run time" error


The following SQL exception might occur if you try to change Hive configuration parameters that have been restricted:

Cannot modify <parameter> at runtime. It is not in list of params that are allowed to be modified at run time.

This is due to a change in Hive 13 when SQL standard-based Hive authorization is enabled. For details, see “Restrictions on Hive Commands and Statements.”

If you receive this error when setting a restricted parameter, circumvent the issue by setting the parameter in the hive-site.xml file on the Hadoop server. Setting the property in the client-side hive-site.xml file does not work.

Note: Disabling SQL standard-base Hive authorization is not recommended.