Support Questions

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

Empty Impala queries in Cloudera Manager

avatar
Expert Contributor

Hi,

 I have a brand new installation of CDH 5.15, where all services (MNG,Impala) are in green. I executed ~10 queries on Impala, and was checking the queries in Cloudera Manager -> Impala Queries. I noticed two issues:

- Some of the queries were in the list when there were in "running" state

- After the statements were finished, no query were reported in Impala Queries.

 

The obvious reason could be time filter: I checked 30m, 1h, 2h, 1d, still NO results. 

Also another obvious reason can be a search filter. The filter is empty, NO results.

 

I checked the Service Monitor of CM, it is in green, so I suppose it collects data.

I checked the Impala storage (firehose_impala_storage_bytes) it is 1GB.

The only "warning" is about the memory of Service Monitor what is much less, but this is a new cluster, no workload running, and the CM reports that the heap usage is under 1G

The recommended non-Java memory size is 12.0 GiB, 10.5 GiB more than is configure

 

What could be the problem of the empty list? Why Cloudera Manager is not collecting the Impala queries? Or maybe it is, but then why it is not reporting, showing me them?

 

Thanks 

1 ACCEPTED SOLUTION

avatar
Master Guru
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
4 REPLIES 4

avatar
Expert Contributor

Hi @TomasTF,

 

One question:

   - How do you executhe that queries? With wich client?

 

Have you try to ctrl+R in your cloudera manager (tab impala --> queries) in your browser.

 

Regards,

Manu.

avatar
Expert Contributor
Queries via jdbc client.
Yes tried refresh, but after ~ 30 min all the queries appeared.

avatar
Expert Contributor

Hi, @TomasTF

 

Have your system the same timezone that your CDH?

 

Regards,

Manu.

avatar
Master Guru
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login