Configuring compaction

You configure some configure compaction properties from the Database Catalog and some from the Virtual Warehouse.

In this task, you configure the compactor worker threads in the Virtual Warehouse.

Required role: DWAdmin

  1. Click Virtual Warehouses, and select a Hive Virtual Warehouse.
  2. Click Actions > Edit > Metastore > HiveServer2.
  3. Select hive-site from the dropdown.
  4. View, increase, or decrease the number the hive.compactor.work.threads.
  5. Save changes, and restart the Virtual Warehouse.