Cloudera Docs

Resizing the Impala or Trino Virtual Warehouse size

After creating an Impala or Trino Virtual Warehouse, you can tune, or correct, the T-shirt size of executor groups that drive the Virtual Warehouse. The size of the executor groups is critical for achieving cost and performance goals.

You do not have to recreate the Virtual Warehouse if you want to try a different size. For example, you can easily change the size of executor groups from 'xsmall' to 'small' after creating a the Virtual Warehouse by following the procedure below to edit the Virtual Warehouse.
  1. Log in to the Cloudera web interface and navigate to the Cloudera Data Warehouse service.
  2. In the Cloudera Data Warehouse service, click Overview in the left navigation pane.
  3. In Overview page, find your Virtual Warehouses, click , and select Details.
  4. In the Virtual Warehouse details page, click the Sizing And Scaling tab and select a different size from the Size drop-down menu.
  5. Click Apply Changes.