Advanced Hive configuration parameters for Hive ACID table replication policies

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

  1. 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.cm.retain parameter, and the value as 7d. 7d indicates seven days.
  2. 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.cm.retain parameter, and the value as 7d. 7d indicates seven 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.