KILL QUERY

Description

Each Doris connection runs in a separate thread. Use this statement to terminate the thread.

Syntax

KILL [CONNECTION] <processlist_id>

Varaint Syntax

KILL QUERY [ { <processlist_id> | <query_id> } ]

Required Parameters

1. <processlist_id>

Indicates the ID of the connection thread that needs to be killed

2. <query_id>

Indicates the ID of the query to be killed

Optional Parameters

1. CONNECTION

Indicates whether the thread is currently connected

Access Control Requirements

The user who executes this SQL command must have at least the following permissions:

Privilege	Object	Notes
GRANT_PRIV	DATABASE	GRANT permission is required for the KILL statement

Usage Notes

• The thread process list identifier can be queried from the Id column output by the SHOW PROCESSLIST

• The Connection ID can be queried from SELECT CONNECTION_ID()

Examples

select connection_id()

+-----------------+
| connection_id() |
+-----------------+
| 48              |
+-----------------+

SHOW PROCESSLIST

+------------------+------+------+--------------------+---------------------+----------+---------+---------+------+-------+-----------------------------------+---------------------------------------------------------------------------------------+
| CurrentConnected | Id   | User | Host               | LoginTime           | Catalog  | Db      | Command | Time | State | QueryId                           | Info                                                                                  |
+------------------+------+------+--------------------+---------------------+----------+---------+---------+------+-------+-----------------------------------+---------------------------------------------------------------------------------------+
| Yes              |   48 | root | 10.16.xx.xx:44834   | 2025-01-21 16:49:47 | internal | test | Query   |    0 | OK    | e6e4ce9567b04859-8eeab8d6b5513e38 | SHOW PROCESSLIST                                                                      |
|                  |   50 | root | 192.168.xx.xx:52837 | 2025-01-21 16:51:34 | internal |      | Sleep   | 1837 | EOF   | deaf13c52b3b4a3b-b25e8254b50ff8cb | SELECT @@session.transaction_isolation                                                |
|                  |   51 | root | 192.168.xx.xx:52843 | 2025-01-21 16:51:35 | internal |      | Sleep   |  907 | EOF   | 437f219addc0404f-9befe7f6acf9a700 | /* ApplicationName=DBeaver Ultimate 23.1.3 - Metadata */ SHOW STATUS                  |
|                  |   55 | root | 192.168.xx.xx:55533 | 2025-01-21 17:09:32 | internal | test | Sleep   |  271 | EOF   | f02603dc163a4da3-beebbb5d1ced760c | /* ApplicationName=DBeaver Ultimate 23.1.3 - SQLEditor <Console> */ SELECT DATABASE() |
|                  |   47 | root | 10.16.xx.xx:35678   | 2025-01-21 16:21:56 | internal | test | Sleep   | 3528 | EOF   | f4944c543dc34a99-b0d0f3986c8f1c98 | select * from test                                                                    |
+------------------+------+------+--------------------+---------------------+----------+---------+---------+------+-------+-----------------------------------+---------------------------------------------------------------------------------------+

kill 51