https://community.cloudera.com/t5/Support-Questions/get-Impala-running-query-with-duration-with-curl-cm-API/m-p/315854#M226594 <P>Hi ,</P><P>&nbsp;</P><P>I am trying to pull impala running query with status&nbsp;</P><P>/services/Impala/impalaQueries#'?filter=(query_state=RUNNING) but it also displaying all Finished query detials.</P><P>&nbsp;</P><P>I need to pull information of Only RUNNING query which duration exceed with certain time period.</P><P>&nbsp;</P><P>Can some one help me.</P><P>&nbsp;</P><P>Thanks</P><P>At</P> Tue, 04 May 2021 04:07:20 GMT amitshanker 2021-05-04T04:07:20Z https://community.cloudera.com/t5/Support-Questions/get-Impala-running-query-with-duration-with-curl-cm-API/m-p/315854#M226594 <P>Hi ,</P><P>&nbsp;</P><P>I am trying to pull impala running query with status&nbsp;</P><P>/services/Impala/impalaQueries#'?filter=(query_state=RUNNING) but it also displaying all Finished query detials.</P><P>&nbsp;</P><P>I need to pull information of Only RUNNING query which duration exceed with certain time period.</P><P>&nbsp;</P><P>Can some one help me.</P><P>&nbsp;</P><P>Thanks</P><P>At</P> Tue, 04 May 2021 04:07:20 GMT https://community.cloudera.com/t5/Support-Questions/get-Impala-running-query-with-duration-with-curl-cm-API/m-p/315854#M226594 amitshanker 2021-05-04T04:07:20Z https://community.cloudera.com/t5/Support-Questions/get-Impala-running-query-with-duration-with-curl-cm-API/m-p/315873#M226605 <P>Try something like&nbsp;</P><LI-CODE lang="markup"># curl -u admin "http://$cmhost:7180/api/v33/clusters/Cluster%201/services/IMPALA-1/impalaQueries?filter=(query_state=RUNNING%20and%20query_duration&gt;=1000)&amp;from=2021-05-04T00:00:00.00Z"</LI-CODE><P>&nbsp;</P> Tue, 04 May 2021 09:38:30 GMT https://community.cloudera.com/t5/Support-Questions/get-Impala-running-query-with-duration-with-curl-cm-API/m-p/315873#M226605 gzigldrum 2021-05-04T09:38:30Z