Vertica Interrupt Session

In the use of Vertica often encountered in the execution of a time-consuming query when you want to forcibly end or interrupt this operation, at this time can be provided by the Vertica interrupt_statement () function to solve such problems, interrupt_ Statement requires two parameters, the first parameter is session_id, and the second parameter is statement_id, both of which can be obtained from the sessions table.

First, find out the session_id and statement_id that need to end from the sessions.

1	SELECT * from sessions;

And then execute

1	SELECT interrupt_statement (' <session_id> ', ' <statement_id> ');

You can also use the following command to close a reply

1 2	SELECT close_all_sessions (); SELECT close_session (' session_id ');