Support Questions
Find answers, ask questions, and share your expertise

Impala tuning

Solved Go to solution

Impala tuning

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

Accepted Solutions

Re: Impala tuning

Expert Contributor

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

Re: Impala tuning

Expert Contributor

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

Re: Impala tuning

Contributor

Hi Alex,

 

thanks for sharing.

 

I will review it.

 

Regards,

 

Roshan

Re: Impala tuning

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.

Learn more about the Cloudera Community:
Community Guidelines
How to use the forum