Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to kill Long running impala queries

Solved Go to solution

How to kill Long running impala queries

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

Accepted Solutions

Re: How to kill Long running impala queries

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

4 REPLIES 4

Re: How to kill Long running impala queries

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

Re: How to kill Long running impala queries

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

Re: How to kill Long running impala queries

Explorer

Hi,

Can you share how did you fixed that?

Re: How to kill Long running impala queries

Explorer

You can try run the following your browser

 

https://<query_coordinator_server_name>:25000/close_session?session_id=<session_id>
Don't have an account?
Coming from Hortonworks? Activate your account here