Set Hive Configuration Overrides

The upgrade process does not preserve all overrides (customizations) you made to your old Hive configurations. After upgrading, you refer to your records about your old configuration and use this information to set at least six critical property values.

By design, the six critical properties that you need to customize are not visible in Cloudera Manager, as you can see from the Visible in CM column of Configurations Requirements and Recommendations (see link below). You use the Safety Valve to add these properties to hive-site.xml as shown in this task.
  1. In Cloudera Manager > Clusters select the Hive on Tez service. Click Configuration, and search for hive-site.xml.
  2. In Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml, click +.
  3. In Name, add the hive.conf.hidden.list property.
  4. In Value, add your custom list.
  5. Customize the other critical properties: hive.conf.restricted.list, hive.exec.post.hooks, hive.script.operator.env.blacklist, hive.security.authorization.sqlstd.confwhitelist, hive.security.command.whitelist
  6. Save the changes and restart the Hive service.
  7. Look at the Configurations Requirements and Recommendations to understand which overrides were preserved or not.