Support Questions

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

No available Impalad to send queries to

avatar
Rising Star

We are running CDH 5.3.3 with Hue 3.7.0, and just added impala via Cloudera Manager. Whenever we log on to Hue, the "No available Impalad to send queries to." appears. Cloudera Manager doesn't report anything wrong with either impala or Hue. The impala and Hue logs don't show any errors. 

Any help would be greatly appreciated.

Thanks!

 

For completeness, I also want to add that the impala-shell works without a problem. The issue seems to be restricted to Hue.

1 ACCEPTED SOLUTION

avatar
Rising Star

Problem solved. Rebooting the cluster servers didn’t fix the issue. The problem was due to Hue being configured with LDAP. Even though I didn’t find anything that says otherwise, I didn’t think that Having LDAP implemented for Hue required Impala too to be configured for LDAP. After doing that the misconfiguration message disappears, and everything works fine.

Thanks again for your help!

View solution in original post

29 REPLIES 29

avatar
Super Guru
Are all the impalads up in the Impala service? (in the "instances" tab)

Romain


avatar
Rising Star
Yes, they are. Cloudera Manager doesn't report any anomaly, and nothing is shown in the logs that might indicate a problem of any nature. Impala-shell works fine. Hue is the only thing that seems to have issues. Server name and port number for impala in hue.ini are correct. The deamon on the target host is indeed listening to the right port number.

avatar
Super Guru
Is the Hue Impala App working or do you just get the warning on the
start-up page?

Did you also check the impalad address on the Hue page /desktop/dump_config
[impala] tab?

Romain

avatar
Rising Star
I get the message right after I log on to Hue, right at the time Hue checks the configuration. As for the app, if I click on it, the browser hangs for a while before finally showing the Impala editor page. However, no list of databases is shown as the app seems unable to retrieve any.

avatar
Super Guru
Did you check the /desktop/check_config page?

avatar
Rising Star
I'm sorry, bear with me. On the configuration page for Hue, if I click on "desktop" in the "Configuration Sections and Variables" section I don't see check_config. Am I looking in the wrong place?

avatar
Rising Star

Unless you are talking about the Hue main page. Here is a snapshot that shows what I see after logging on to Hue:

aa.png

 

avatar
Super Guru
For some reason I don't see the picture 😉

But if you go http://hue-host:8888/desktop/dump_config --> "Configuration
Sections and Variables" --> [impala]

Check server_host and server_port

Romain

avatar
Rising Star
Thanks. Server_name is one of the servers where the impalad deamon is running. The port number is the default one (21050).