Support Questions

Find answers, ask questions, and share your expertise

How to kill Long running impala queries

avatar
Explorer

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

1 ACCEPTED SOLUTION

avatar
Cloudera Employee
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

View solution in original post

4 REPLIES 4

avatar
Cloudera Employee
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

avatar
Explorer
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

avatar
Contributor

Hi,

Can you share how did you fixed that?

avatar
Contributor

You can try run the following your browser

 

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