get Impala running query with duration with curl /cm API

[#1]

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

[#2 · Accepted solution]

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"