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.

  1. Go to the Virtual Warehouses tab and select a Hive Virtual Warehouse.
  2. Click > Edit > Configurations > Hiveserver2.
  3. Select hive-site from the Configuration files drop-down menu.
  4. View, increase, or decrease the number the hive.compactor.work.threads.
  5. Click Apply Changes.