get Impala running queries from cli

[#1]

Hi guys,

I'm looking for a way to kill impala queries that runs more than X hours in our cluster. 

Because there is no built in way, we thought of several ways: 

we want to get all queries in flight (or from every coordinator or from all of them together - doesn't matter).

is there a way to do it and get the duration of each query? via the impala-shell/api?

we can easily write a python/ bash script that uses the way but we don't know a way to get all running queries duration. 

Thank you! 

[#2]

Hello @michalm_ 

Thanks for using Cloudera Community. While I haven't performed such Task, I wish to check if you have reviewed the 3rd Party Script via [1], which uses a Use-Defined Time to find Impala Queries & optionally, Kill them as well. Let us know if it helps. 

- Smarak

[1] https://github.com/onefoursix/kill-long-running-impala-queries

[#3]

Hi,

You may refer below doc, describing about Cloudera Manager API: Impala QueriesResources

https://archive.cloudera.com/cm7/7.1.3/generic/jar/cm_api/apidocs/resource_ImpalaQueriesResource.htm...

[#4]

@michalm_ Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.