Support Questions

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

get Impala running query with duration with curl /cm API

avatar
Explorer

Hi ,

 

I am trying to pull impala running query with status 

/services/Impala/impalaQueries#'?filter=(query_state=RUNNING) but it also displaying all Finished query detials.

 

I need to pull information of Only RUNNING query which duration exceed with certain time period.

 

Can some one help me.

 

Thanks

At

1 ACCEPTED SOLUTION

avatar
Super Collaborator

Try something like 

# curl -u admin "http://$cmhost:7180/api/v33/clusters/Cluster%201/services/IMPALA-1/impalaQueries?filter=(query_state=RUNNING%20and%20query_duration>=1000)&from=2021-05-04T00:00:00.00Z"

 

View solution in original post

1 REPLY 1

avatar
Super Collaborator

Try something like 

# curl -u admin "http://$cmhost:7180/api/v33/clusters/Cluster%201/services/IMPALA-1/impalaQueries?filter=(query_state=RUNNING%20and%20query_duration>=1000)&from=2021-05-04T00:00:00.00Z"