question Re: Impala Queries in Support Questions

Impala Queries

Amn_468 — Tue, 21 Apr 2026 08:56:48 GMT

Hello,

We are seeing a few Impala queries running for more than 3 hours in Impala. Upon checking we found that the query is in exception state however on the Cloudera Impala GUI it still showing it as running. Would like to know if there is a way to kill such type of queries at Impala level.

We have implemented Impala ACL and set the Queue Timeout to 5 minutes yet some queries keep running. Our applications connect to Impala via JDBC and we also have some users who use Hue to run queries.

Any assistance/guidance is much appreciated.

Re: Impala Queries

ShankerSharma — Tue, 12 Oct 2021 05:29:28 GMT

Hello,

You can kill the query from the Impala Daemon web UI of the Impala
Daemon coordinating the query.

you can try killing from the browser.

https://<query_coordinator_server_name>:25000/close_session?session_id=<session_id>

Please let us know if it helps

Re: Impala Queries

Amn_468 — Tue, 12 Oct 2021 07:47:20 GMT

Hi @ShankerSharma

I am currently killing the query from Impala GUI, however, this becomes overkill when there are many queries in a state of exception. Was wondering if there could be a faster way to select all of such queries and kill them in one go.

Re: Impala Queries

ShankerSharma — Tue, 12 Oct 2021 14:13:45 GMT

Hello,

There is no such way to kill the query in one go.

You need to either do it by one of the following methods:-

You can kill the query from the Impala Daemon web UI of the Impala
Daemon coordinating the query.

you can try killing from the browser.

https://<query_coordinator_server_name>:25000/close_session?session_id=<session_id>