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.
1. Go to the Cloudera Manager > Clusters > Hive to 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 1. The unit for the parameter is days.
4. Enter the hive.repl.cm.retain parameter and value as 1d. The unit for the parameter is 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 1 day 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 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 Hive 1 (Hive Metastore) / Instances > Configuration page and then set the instance specific configuration.
Restart the services after you configure the parameters.