question Re: Impala memory limit for group in Support Questions

Impala memory limit for group

Hambaliou14 — Tue, 23 Sep 2025 12:40:13 GMT

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!

Re: Impala memory limit for group

Boris G — Wed, 24 Sep 2025 20:43:26 GMT

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.

Re: Impala memory limit for group

DianaTorres — Mon, 29 Sep 2025 20:18:54 GMT

@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.

Re: Impala memory limit for group

Hambaliou14 — Tue, 30 Sep 2025 11:18:04 GMT

Hello @Boris G,

Thanks for this response. It works for me.