Reply
Explorer
Posts: 6
Registered: ‎07-07-2015
Accepted Solution

How to kill Long running impala queries

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

Cloudera Employee
Posts: 8
Registered: ‎09-28-2013

Re: How to kill Long running impala queries

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

Explorer
Posts: 6
Registered: ‎07-07-2015

Re: How to kill Long running impala queries

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
Explorer
Posts: 14
Registered: ‎11-12-2015

Re: How to kill Long running impala queries

Hi,

Can you share how did you fixed that?

Highlighted
Explorer
Posts: 6
Registered: ‎07-06-2018

Re: How to kill Long running impala queries

You can try run the following your browser

 

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