Skip to main content
Hambaliou14
Silver ⭐️
Sep 23, 2025 12:40 PM UTC
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 ⭐️
Sep 24, 2025 8:43 PM UTC

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 ⭐️
Sep 24, 2025 8:43 PM UTC

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 ⭐️
Sep 30, 2025 11:18 AM UTC

Hello @Boris G,

Thanks for this response. It works for me.

Translate
DianaTorres
Community Manager
Community Manager
Sep 29, 2025 8:18 PM UTC

@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