Cloudera Docs

Configuring the only coordinators request pool

Learn how to configure a coordinator-only request pool to optimize system table queries.

Configuring a coordinator-only request pool allows you to run queries that do not require executors, reducing resource constraints and improving performance

Ensure you have administrator access to modify Impala configurations.

  1. Log in to Cloudera Manageras an Administrator
  2. In Cloudera Manager, go to Impala > Configurations > Impala Daemon Fair Scheduler Advanced Configuration Snippet (Safety Valve).
  3. Add <onlyCoordinators>true</onlyCoordinators>
  4. Click Apply Changes button and restart Impala.