Impala Admission Control Configuration

@Abhijith_Nayak 
To achieve the desired behavior where Impala queries automatically run in the respective resource pools based on the user, you can configure Impala Admission Control to handle this routing seamlessly. Here's how you can implement it.
1. Enable Resource Pools in Cloudera Manager

1. Ensure that Dynamic Resource Pools are enabled in Cloudera Manager:
2. Go to Cloudera Manager > Impala > Configuration > Admission Control.
3. Enable Admission Control if it isn’t already.

2. Create Resource Pools

• You already have two resource pools (resource_pool_1 and resource_pool_2). Ensure these pools are properly configured:
  • resource_pool_1: For users A, B, and C.
  • resource_pool_2: For users D and E.

Verify the following settings for each pool:

• Memory and CPU resources are allocated appropriately for the expected workloads.

Query concurrency limits are set based on your cluster’s capacity.

3. Configure Submission Access Control

• Map the users to their respective resource pools:
  1. Navigate to Cloudera Manager > Impala > Configuration > Admission Control > Resource Pools.
  2. For resource_pool_1, under Submission Access Control, add:

3. For resource_pool_2, under Submission Access Control, add

This ensures that only the specified users can submit queries to their designated pools.

1. Configure Default Resource Pool Selection

   • Use the pool_mapping configuration to automatically route queries based on the user. This eliminates the need for users to specify the pool explicitly when submitting queries.

   Steps:

   1. Navigate to Cloudera Manager > Impala > Configuration > Admission Control > Pool Mapping Rules.
   2. Add rules to map users to their pools

5. Validate the Configuration

• Restart the Impala services to apply the changes.
• Run test queries as each user to confirm the routing works as expected:
  • Log in as user A, B, C, D, and E and execute queries without specifying the resource pool.
  • Use the following command in the Impala shell to check the assigned resource pool for a query:

Look for the Admission result section to verify the query ran in the correct pool.

Expected Outcome

• Users A, B, and C will have their queries automatically routed to resource_pool_1.
• Users D and E will have their queries automatically routed to resource_pool_2.
• No manual pool specification will be required during query submission.

This configuration ensures proper workload isolation and efficient resource utilization in your cluster. Let me know if further clarification is needed Happy hadooping !!!

1. Enable Resource Pools in Cloudera Manager
2. Create Resource Pools
3. Configure Submission Access Control 

We have done above configuration successfully
But we are not able to do this section Configure Default Resource Pool Selection  
we don't have Pool Mapping Rules this option in  Cloudera Manager > Impala > Configuration > Admission Control > Pool Mapping Rules. path 

We are using CDP 7.1.9 and CM 7.11.3

Do we need to change any thing in Placement Rules section of Impala Admission Control Configuration page

@Abhijith_Nayak @Sofiane-CH 

Try below steps for Default Resource Pool Selection.

1. In your Cloudera Manager page, navigate to Clusters (Left side blue pane) > Impala Admission Control Configuration.

2. Click "Default Settings". Select "Allow these users and groups to submit to this pool". Add users or groups separated by comma with no extra spaces. For e.g: A,B,C,D,E

3. Now, click "Edit" in your respective resource pools. In tab "Submission Access Control". Select "Allow these users and groups to submit to this pool". Now, again add users or groups separated by comma with no extra spaces.
Below is an example for your mentioned pools resource_pool_1 and resource_pool_2:
resource_pool_1 --> A,B,C
resource_pool_2 --> D,E

4. Once, the above is done, click "Refresh Dynamic Resource Pools" and restart Impala.

References:

• https://docs.cloudera.com/runtime/7.3.1/impala-manage/topics/impala-dynamic-pool-configure.html 
• https://docs.cloudera.com/runtime/7.3.1/impala-manage/topics/impala-dynamic-pool-settings.html