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

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! 

 

3 REPLIES 3

Re: get Impala running queries from cli

Expert Contributor

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

 

Re: get Impala running queries from cli

Cloudera Employee

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

Re: get Impala running queries from cli

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.  


Regards,

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: