Considerations for using compaction on Cloudera Data Warehouse Public Cloud

The first Hive Virtual Warehouse you create in Cloudera Data Warehouse (CDW) Public Cloud for a Database Catalog is automatically set as the compactor and performs all compaction work for subsequent Virtual Warehouses (Hive or Impala) that are created under that Data Catalog.

Consequently, you must take into account the query workload for compaction when you create the first Hive Virtual Warehouse. You must make sure that the warehouse has adequate resources to handle the compaction workload in addition to any other workloads you might run in that warehouse.