Impala Queries

Question

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.

ShankerSharma · Accepted Answer

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.

or

you can try killing from the browser.

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

ShankerSharma · Answer

Hello,

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

or

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

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.