question Re: How to kill Long running impala queries in Support Questions

How to kill Long running impala queries

Srini — Fri, 16 Sep 2022 09:38:24 GMT

Hi,

Am trying to kill long running query from CM. But the opraion failed with internal error. I got admin privileges from the CM. Is there anyway to do that from impala-shell?

Thanks

Re: How to kill Long running impala queries

cleroy — Thu, 20 Aug 2015 16:23:05 GMT

You can kill the query from the Impala Daemon web UI of the Impala
Daemon coordinating the query. You can see that from CM if you don't
know it already.

Any chance you can send me the CM server log so we can identify the
error being hit when trying to cancel from the CM UI?

Thanks,
chris

Re: How to kill Long running impala queries

Srini — Fri, 04 Sep 2015 06:47:10 GMT

Hi Chris,

thanks for the guidance, Our cluster is security enabled and impala user failed to authenticate properly while connecting the host where imapalad is running.

Thanks
Srini

Re: How to kill Long running impala queries

Antoni — Thu, 15 Sep 2016 10:42:12 GMT

Hi,

Can you share how did you fixed that?

Re: How to kill Long running impala queries

ramarov — Fri, 19 Oct 2018 09:10:25 GMT

You can try run the following your browser

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