question Re: Cloudera Manager -> Impala Queries -> "Waiting for client" in Support Questions

Cloudera Manager -> Impala Queries -> "Waiting for client"

MarkBoyd05 — Mon, 24 Jun 2024 18:40:18 GMT

We want to setup some Impala monitoring and look specifically for queries that have a "Waiting for client" state. I am pretty familiar with the Cloudera Manager API calls to get Impala query information, but can't seem to figure out how to get this particular state. Can someone shed light on how Cloudera Manager itself does it, since I see that status in the Cloudera Manager UI when looking at Impala queries? Thanks, I appreciate any help in advance.

Mark

Re: Cloudera Manager -> Impala Queries -> "Waiting for client"

DianaTorres — Tue, 25 Jun 2024 01:24:06 GMT

@MarkBoyd05 Welcome to the Cloudera Community!

To help you get the best possible solution, I have tagged our Cloudera Manager experts @upadhyayk04 @Zrahman who may be able to assist you further.

Please keep us updated on your post, and we hope you find a satisfactory solution to your query.

Re: Cloudera Manager -> Impala Queries -> "Waiting for client"

MarkBoyd05 — Mon, 29 Jul 2024 20:22:05 GMT

Diana -

Thank you for including other experts. I haven't seen any other responses, though. @upadhyayk04 @Zrahman do either of you have any thoughts on this? Thanks!

Mark

Re: Cloudera Manager -> Impala Queries -> "Waiting for client"

DianaTorres — Wed, 07 Aug 2024 19:08:01 GMT

@bbreak Hi! Do you have any insights here? Thanks!

Re: Cloudera Manager -> Impala Queries -> "Waiting for client"

MarkBoyd05 — Fri, 16 Aug 2024 17:46:52 GMT

I think I've figured out the solution. In looking at queries in CM using the Impala Queries page and comparing that to what I see in REST API output, it looks like CM shows "Waiting for client" when a query has a finished status but does not have an end time associated with it yet. In all the queries that I saw in CM, the one's that showed "Waiting for client" had a finished status and a start time in the REST API JSON, but did not have an end time. I'm going to "assume" that I have this figured out now, but if anyone has any more insight into this, I would appreciate it.