- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
get Impala running queries from cli
- Labels:
-
Apache Impala
-
HDFS
Created 07-19-2021 04:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
Created 07-26-2021 01:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 07-26-2021 05:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You may refer below doc, describing about Cloudera Manager API: Impala QueriesResources
Created 07-30-2021 05:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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:
