How to kill Long running impala queries

[#1]

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

[#2 · Accepted solution]

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

[#3]

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

[#4]

Hi,

Can you share how did you fixed that?

[#5]

You can try run the following your browser

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