Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Impala tuning

avatar
Contributor

Hello Team,

 

can you please advise how I can proceed to:


1. Limit the total # of concurrently executing Impala queries system wide
2. Limit the memory that an Impala query can use before swapping
3. Protect Impala from Yarn contention with Static Service Pools
4. Implement Admission Control Queues for different Impala User Groups
─ Limit concurrent queries for each queue/pool
─ Implement memory limits on the queue/pools and Running Queries
5. Put a disk limit on runaway queries specifying the maximum amount of disk
storage, in bytes, that any Impala query can consume on any host

 

on Cloudera?

 

Thanks,

 

Roshan

1 ACCEPTED SOLUTION

avatar
Master Collaborator

Hi Roshan,

 

This is a good starting guide on Impala admission control management. Please review it first and see if you still have questions after.

 

https://docs.cloudera.com/cdp-private-cloud-base/7.1.6/impala-manage/topics/impala-admission.html

 

 

Kind regards,

Alex

View solution in original post

3 REPLIES 3

avatar
Master Collaborator

Hi Roshan,

 

This is a good starting guide on Impala admission control management. Please review it first and see if you still have questions after.

 

https://docs.cloudera.com/cdp-private-cloud-base/7.1.6/impala-manage/topics/impala-admission.html

 

 

Kind regards,

Alex

avatar
Contributor

Hi Alex,

 

thanks for sharing.

 

I will review it.

 

Regards,

 

Roshan

avatar
Community Manager

@roshanbi, have you resolved 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. 

cjervis_0-1624451484101.png


Cy Jervis, Manager, Community Program
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.