Skip to main content
Hambaliou14
Silver ⭐️
September 23, 2025
Solved

Impala memory limit for group

Hello everyone,

Is it possible to limit the memory for executing queries for an LDAP group in CDP 7.1.7? This would allow creating a memory pool for each group so that if a user in that group launches a memory-intensive query, it does not impact other users in the cluster.

BR!

Boris G
Boris GAnswer
Gold ⭐️
September 24, 2025

I think you would need to set up the Submission Access Control per pool, as mentioned here: https://docs.cloudera.com/cdp-private-cloud-base/7.1.7/impala-manage/topics/impala-dynamic-pool-configure.html

This is in addition to the memory-based admission control per pool as explained here: https://docs.cloudera.com/cdp-private-cloud-base/7.1.7/impala-manage/topics/impala-admission.html and other links under https://docs.cloudera.com/cdp-private-cloud-base/7.1.7/impala-manage/topics/impala-resource-management.html.

As the result you should get Impala memory 'divided' (virtually, not physically!) between the pools, and each pool accessible only by the groups as configured.

3 replies

Boris G
Gold ⭐️
Boris GAnswer
Gold ⭐️
September 24, 2025

I think you would need to set up the Submission Access Control per pool, as mentioned here: https://docs.cloudera.com/cdp-private-cloud-base/7.1.7/impala-manage/topics/impala-dynamic-pool-configure.html

This is in addition to the memory-based admission control per pool as explained here: https://docs.cloudera.com/cdp-private-cloud-base/7.1.7/impala-manage/topics/impala-admission.html and other links under https://docs.cloudera.com/cdp-private-cloud-base/7.1.7/impala-manage/topics/impala-resource-management.html.

As the result you should get Impala memory 'divided' (virtually, not physically!) between the pools, and each pool accessible only by the groups as configured.

Translate
Hambaliou14
Silver ⭐️
September 30, 2025

Hello @Boris G,

Thanks for this response. It works for me.

Translate
DianaTorres
Community Manager
Community Manager
September 29, 2025

@Hambaliou14 Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  Thanks.

Translate
Regards, Diana Torres, Senior Community Moderator