Initiating automatic compaction

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

  1. Log into the Cloudera web interface and in Cloudera Home, click Cloudera Data Warehouse.
  2. In Cloudera Data Warehouse, select your Database Catalog and click > Edit.
  3. Click Configurations > Metastore.
  4. From the drop-down, select hive-site for the configuration category.
  5. Set hive.compactor.initiator.on to true.
  6. Click Apply Changes and restart the Database Catalog.