Configuring fe_service_threads in Cloudera Data Warehouse on premises

The “fe_service_threads” configuration is used to specify the maximum number of concurrent client connections or threads allowed to serve client requests in an Impala Virtual Warehouse. The default value of the “fe_service_threads” configuration is 96. You can change the value of this configuration from the Impala Coordinator flagfile configurations in the Cloudera Data Warehouse UI.

The recommended value of the “fe_service_threads” configuration is 96. Setting the value of this configuration lower than 96 can degrade performance.

1. Log in to the Cloudera Data Warehouse service as DWAdmin.
2. Go to the Virtual Warehouses tab and locate the Impala Virtual Warehouse on which you want to set this configuration.
3. Click > Edit.
4. Go to CONFIGURATIONS > Impala coordinator and select flagfile from the Configuration files drop-down menu.
5. Specify the value of the “fe_service_threads” configuration in the VALUE field.
6. Click Apply Changes.