question Re: get Impala running queries from cli in Support Questions

get Impala running queries from cli

michalm_ — Mon, 19 Jul 2021 11:33:18 GMT

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!

Re: get Impala running queries from cli

smdas — Mon, 26 Jul 2021 08:15:50 GMT

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

jAnshula — Mon, 26 Jul 2021 12:44:03 GMT

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

Re: get Impala running queries from cli

VidyaSargur — Fri, 30 Jul 2021 12:50:27 GMT

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