Close Session in Vertic

       If one of the session is running long time. If you want to close the session, then we can use below syntax.

Syntax:

• Find the Session Id for long running session. Connect to Vertica DB Using super user and run the below query.

          SELECT * FROM  SESSIONS

•  Then we will get list of current running sessions information, find the required session and copy the 'Session_Id'
• In below two statements Run any one of the statement to kill the long running sessions.

          SELECT CLOSE_SESSION('<Session ID>')
          OR
          SELECT INTERUPT_STATEMENT('<Session ID>')