Support Questions

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

get Impala running queries from cli

New Contributor

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! 



Super Collaborator

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




Expert Contributor



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

Community Manager

@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.  


Vidya Sargur,
Community Manager

Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community: