Troubleshooting Apache HivePDF version

Whitelisting Configurations at the Session Level

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).
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:
  1. The required property is not included in the whitelist.
  2. 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.
  1. In Cloudera Manager, navigate to Clusters > Hive on Tez > Configurations
  2. Search for hive-site.xml and locate the 'Hive Service Advanced Configuration Snippet (Safety Valve)'
  3. Add or update the required properties in the hive.security.authorization.sqlstd.confwhitelist.append parameter.
    For Example:
    <property>
    <name>hive.security.authorization.sqlstd.confwhitelist.append</name>
    <value>hive\.input\.format\..*|tez\.queue\.name|my\.third\.property|principal|sslTrustStore</value>
    </property>
    
  4. Restart the Hive on Tez service for the changes to take effect.