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.
-
Log in to the Cloudera web interface and
navigate to the Cloudera Data Warehouse service.
-
Click Virtual Warehouses in the left navigation
panel.
-
Select the Impala Virtual Warehouse, click options for the warehouse
-
Click Edit and navigate to Impala
Coordinator under the Configurations
tab
-
Select the
fair-scheduler.xml under
Configuration files.
-
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>
-
Save the file.
-
Restart the Impala coordinator to apply the changes.
