Initiating automatic compaction

To start automatic compaction in Cloudera Data Warehouse, you set a property in the Database Catalog.

Required role: DWAdmin
  1. Log into the CDP web interface and in Cloudera Home, click Data Warehouse.
    Cloudera Home looks something like this:
  2. In Cloudera Data Warehouse, select a Database Catalog.
  3. Click options > Edit > Configurations > Metastore.
  4. From the drop-down, select hive-site for the configuration category.
  5. Set hive.compactor.initiator.on to true.
  6. Save and restart the Database Catalog.