[ 
https://issues.apache.org/jira/browse/IMPALA-12648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17843042#comment-17843042
 ] 

Michael Smith commented on IMPALA-12648:
----------------------------------------

This makes it possible to run into a similar issue we've seen in the UI - 
IMPALA-915 - where we're unable to cancel a query while still being analyzed. 
Currently the client can't encounter that problem because the request to start 
a query doesn't return with a query ID until query planning is complete.

> Support killing queries and sessions programatically
> ----------------------------------------------------
>
>                 Key: IMPALA-12648
>                 URL: https://issues.apache.org/jira/browse/IMPALA-12648
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Frontend
>    Affects Versions: Impala 4.3.0
>            Reporter: Manish Maheshwari
>            Assignee: Michael Smith
>            Priority: Major
>
> Support killing queries and sessions programatically via kill commands to be 
> able to manage impala running workloads.
> 1. Killing Queries that are currently running
> {code:java}
> -- Forcibly terminates query with the specified query_id:
> KILL QUERY WHERE query_id='634bf9fcf55278eb:ac0ef05300000000' {code}
> For queries that are the finished and waiting to be closed, this command 
> should close them
> 2. Killing sessions that are open
> {code:java}
> -- Forcibly terminates session and closes all queries: 
> KILL SESSION WHERE session_id='2644d52c79c4c1e4:e974538f2189ed82'  {code}
> this command should terminate the session and kill all active queries and 
> close all queries that are finished  and are waiting to be closed.
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to