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

[#1]

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

[#2]

@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.

[#3]

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

[#4]

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

[#5 · Accepted solution]

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.