Whitelisting Configurations at the Session Level
Condition
Users encounter errors in Hive on Tez when attempting to modify properties at runtime
using tools like Beeline or SQL Workbench. Beeline error
include:
Error while processing statement: Cannot modify hive.input.format at runtime. It is not in the list of params that are allowed to be modified at runtime (state=42000, code=1).
Cause
The errors occur due to misconfigured or missing properties in the
hive.security.authorization.sqlstd.confwhitelist or
hive.security.authorization.sqlstd.confwhitelist.append
parameters. Specifically:
- The required property is not included in the whitelist.
- Misconfigurations in the whitelist, such as:
- Using
|
at the beginning of entries. - Improper use of
.
in property names, such as failing to escape it or incorrectly adding it to configurations.
- Using