Configuring mandatory properties for Hive replication

Before you submit a Hive replication policy, you must have permissions to configure the Hive service configuration properties in Cloudera Manager. You need to set system level configurations only one time at the Hive Service level.

Minimum required role: Replication Administrator or Full Administrator

Setting the time to live property

  1. In Cloudera Manager, click Clusters > Hive, and search for Hive Service Advanced Configuration Snippet (Safety Valve) for hive.site.xml,
  2. Click Add, and enter the following property and value: In Name, hive.metastore.event.db.listener.timetolive ; in Value, 7.
  3. Click Add, and enter the following property and value: In Name, hive.repl.cm.retain ; in Value, 7.
  4. Restart Hive.
    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.

Setting the timeout parameter

  1. Configure the metastore.scheduled.queries.execution.timeout parameter to 600 seconds.
  2. Save, and restart Hive.

Setting the threads on property

  1. Configure the metastore.housekeeping.threads.on parameter to true.
  2. Save and restart Hive.