Advanced Hive configuration parameters for Hive ACID table replication policies

You can configure the additional Hive service configuration parameters as necessary.

Configure the event time to live (TTL) parameter to 7 days in the Hive-on-Tez service.
1. Go to the Cloudera Manager > Clusters > Hive-on-Tez service > Configuration page.
2. Search for the Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml property.
3. Enter the hive.metastore.event.db.listener.timetolive parameter, and value as 7. The unit for the parameter is days.
4. Enter the hive.repl.event.db.listener.timetolive parameter, and value as 7. The unit for the parameter is days.
5. Enter the hive.repl.cm.retain parameter, and the value as 7d. 7d indicates seven days.
  
  note
  The hive.metastore.event.db.listener.timetolive parameter value must match the hive.repl.cm.retain parameter. Therefore, you need to configure the hive.repl.cm.retain parameter to 7 days as well. When you change one of the two properties, make sure that you update the other parameter with the same value.
tip
When an event’s TTL expires, the event is removed from the metastore and the replication policy job shows a FAILED_ADMIN state with the error Notification events are missing in the meta store. To recover from this state, re-bootstrap the database.
Configure the event time to live (TTL) parameter to 7 days in the Hive service.
1. Go to the Cloudera Manager > Clusters > Hive service > Configuration page.
2. Search for the Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml property.
3. Enter the hive.metastore.event.db.listener.timetolive parameter, and value as 7. The unit for the parameter is days.
4. Enter the hive.repl.event.db.listener.timetolive parameter, and value as 7. The unit for the parameter is days.
5. Enter the hive.repl.cm.retain parameter, and the value as 7d. 7d indicates seven days.
  
  note
  The hive.metastore.event.db.listener.timetolive parameter value must match the hive.repl.cm.retain parameter. Therefore, you need to configure the hive.repl.cm.retain parameter to 7 days as well. When you change one of the two properties, make sure that you update the other parameter with the same value.
Configure the metastore.scheduled.queries.execution.timeout parameter to 600 seconds.
Configure the metastore.housekeeping.threads.on parameter to true.

caution
Ensure that you set this parameter on only ONE instance of Hive Metastore. You can set this by navigating to the Hive 1 (Hive Metastore) / Instances > Configuration page and then set the instance specific configuration.
Restart the services after you configure the parameters.