Support Questions

Find answers, ask questions, and share your expertise

distribute Impala query load in Hue

Super Collaborator



I have created F5 VIP for the impala nodes in my cluster that helps me to distribute the query load on the nodes.


When i'm using the VIP in the impala-shell all is working fine and all the queries distibute on the different impala nodes.


When i tried to configure it in Hue by adding the following to the Hue snppest valve:






I got an error that the node is down or the metasore is down.


I tried also to add the vip in the impala loader balancer configuration and got the same error.


Maybe i need to open the port from the Hue server to vip?

Any idea how to configure this?


Are session sets as Sticky?


Consider enabling "sticky sessions". Cloudera recommends enabling this setting so that stateless client applications such as impalad and Hue are not disconnected from long-running queries. Evaluate whether this setting is appropriate for your combination of workload and client applications.


Note: in next CDH release, Hue should handle the Impala load balancing out of the box.

Super Collaborator
Enabling stickiness even I added the timeout to be 1 hour?

Should the port 21050 be open from the hue server to the VIP?

Should I use the setting in the valve or just add the VIP in impala setting
as a load balancing?

Super Collaborator

@Romainr The documntation you provided is for the HA proxy server while as i mentioned i'm using the F5 VIP and already read the documntation of using F5 for load balancing:

Super Collaborator

Managed to solve the issue by just adding the balancing configuration.


Using the VIP created a problem for users how drop and create tables where the impala-meta data was not syned cross all the nodes, i'm followed this link to get this work and currently testing it.


Wondering when this will be solved without using workarounds.



Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.