KILL QUERY command

The KILL QUERY command terminates a query that is running in the current Graph service and then returns the ID of the terminated query.

Limitations

The following types of queries cannot be terminated using the KILL QUERY command:

• DDL statements
• DML statements
• Synchronous procedural calls

Syntax

diagramsource

kill_query_command

kill_query_command ::=
    'KILL' 'QUERY' '"' query_id '"'

Parameters

query_id

The ID of the query to be terminated. Only a single query ID can be specified at a time. You can use SHOW QUERIES to obtain the query ID.

Examples

Kill a query

KILL QUERY "20231128_06303700005z3tjb"

20231128_06303700005z3tjb is the ID of the query to be terminated.

Return:

+------------------------------+
| query_id                     |
+------------------------------+
| "20231128_06303700005z3tjb"  |
+------------------------------+