Using "CLOSE_SESSION" Or "INTERUPT_STATEMENT" commands, we can close/kill current running sessions.
Detailed Description:
If we need to close a session, follow the below steps
Step1: Identify the session
- Find the Session Id which we need to close. Connect to Vertica DB Using super user and run the below query, it gives the list of current running sessions along with Session_Id.
Step2: Close the session
- Using "Close_Session" or "Interupt_Statement" commands we can colse/kill the current running sessions.
Syntax:
SELECT CLOSE_SESSION('<Session ID>')OR
SELECT INTERUPT_STATEMENT('<Session ID>')