Cannot modify ..** at runtime. It is not in list of params that are allowed to be modified at runtime

hive 与 ranger 开启权限验证后：使用自定义参数 set xxx 时会报错，

org.apache.hive.service.cli.HiveSQLException: Error while processing statement: Cannot modify ..** at runtime. It is not in list of params that are allowed to be modified at runtime

解决办法：在hiveserver2.xml中加入以下参数，通配以|隔开

<property>
    <name>hive.security.authorization.sqlstd.confwhitelist.append</name>
    <value>mapred.*|hive.*|mapreduce.*|spark.*</value>
</property>
<property>
    <name>hive.security.authorization.sqlstd.confwhitelist</name>
    <value>mapred.*|hive.*|mapreduce.*|spark.*</value>
</property>