Support Questions
Find answers, ask questions, and share your expertise

get Impala running query with duration with curl /cm API

Solved Go to solution

get Impala running query with duration with curl /cm API

New Contributor

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

Accepted Solutions

Re: get Impala running query with duration with curl /cm API

Expert Contributor

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

Re: get Impala running query with duration with curl /cm API

Expert Contributor

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