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.