Initiating automatic compaction To start automatic compaction in Cloudera Data Warehouse, you set a property in the Database Catalog. Log into the CDP web interface and in Cloudera Home, click Data Warehouse. Cloudera Home looks something like this: In Cloudera Data Warehouse, select your Database Catalog. Click Configurations > Metastore. From the drop-down, select hive-site for the configuration category. Set hive.compactor.initiator.on to true. Save and restart the Database Catalog. Parent topic: Compaction in Cloudera Data Warehouse