Hive backup fails with error: Error while processing statement: Cannot modify dfs.replication at runtime. It is not in list of params that are allowed to be modified at runtime (state=42000,code=1) 6923 Closing: 0:

Hive backup fails.

Symptoms

Hive backup fails with the following error in the log file: Error while processing statement: Cannot modify dfs.replication at runtime. It is not in list of params that are allowed to be modified at runtime (state=42000,code=1) 6923 Closing: 0:

Causes

The Hive security authorization property has not been set in "HiveServer2 Advanced Configuration Snippet (Safety Valve) for hive-site.xml" under Hive on Tez configuration.

Resolution

1. From the Cloudera Manager console, click Clusters, and then select the Hive on Tez service.
2. On the Configuration tab, search for hive-site.xml.
3. In Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml, click +.
4. In Name, add hive.security.authorization.sqlstd.confwhitelist.append.
5. In Value, add mapred\..*|hive\..*|mapreduce\..*|spark\..*|dfs\..*.
6. Save the changes and restart the Hive service.