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>