Mandatory Hive configuration parameters for Hive ACID table replication policies

Before you create a Hive ACID table replication policy, you must configure the mandatory Hive service configuration parameters.

  1. Include the repl.source.for parameter in the source database dbproperties file.
  2. 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 1. The unit for the parameter is days.
  3. Configure the metastore.scheduled.queries.execution.timeout parameter to 600 seconds.
  4. Configure the metastore.housekeeping.threads.on parameter to true.
  5. Restart the services after you configure the parameters.