KILL Statements

    Attempts to forcibly terminate the currently running queries.
    The queries to terminate are selected from the system.processes table using the criteria defined in the clause of the KILL query.

    Examples:

    Read-only users can only stop their own queries.

    The synchronous version (SYNC) waits for all queries to stop and displays information about each process as it stops.
    The response contains the column, which can take the following values:

    1. finished – The query was terminated successfully.
    2. The other values ​​explain why the query can’t be stopped.

    A test query (TEST) only checks the user’s rights and displays a list of queries to stop.

    KILL MUTATION

    Tries to cancel and remove that are currently executing. Mutations to cancel are selected from the table using the filter specified by the WHERE clause of the KILL query.

    Examples:

    The query is useful when a mutation is stuck and cannot finish (e.g. if some function in the mutation query throws an exception when applied to the data contained in the table).

    Changes already made by the mutation are not rolled back.