Skip to main content
MarkBoyd05
MarkBoyd05
Gold ⭐️
June 24, 2024
Solved

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

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

MarkBoyd05
MarkBoyd05Answer
Gold ⭐️
August 16, 2024

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.

View in thread

4 replies

DianaTorres
Community Manager
DianaTorres
Community Manager
June 25, 2024

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

Translate
Regards, Diana Torres, Senior Community Moderator
MarkBoyd05
MarkBoyd05Author
Gold ⭐️
July 29, 2024

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

Translate
    DianaTorres
    Community Manager
    DianaTorres
    Community Manager
    August 7, 2024

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

    Translate
    Regards, Diana Torres, Senior Community Moderator
    MarkBoyd05
    MarkBoyd05AuthorAnswer
    Gold ⭐️
    August 16, 2024

    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.

    Translate
    Terms & ConditionsAccessibility statement