get Impala running queries from cli

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!