Cloudera Docs

Configuring user quotas in Admission Control

Configure user quotas in Impala’s Admission Control to limit concurrent queries for individual users or groups.

Ensure you have access to the fair-scheduler.xml file and necessary administrative privileges in Impala.

  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 or Update <userQueryLimit> and <groupQueryLimit> elements to define the quota rules. 
    <queue name="group-set-small">
 <userQueryLimit>
 <user>*</user>
 <totalCount>1</totalCount>
 </userQueryLimit>
 <groupQueryLimit>
 <group>it</group>
 <totalCount>2</totalCount>
 </groupQueryLimit>
 <userQueryLimit>
 <user>fiona</user>
 <totalCount>3</totalCount>
 </userQueryLimit>
</queue>
  4. Click Apply Changes button and restart Impala.