How to Force Kill Session in Vertica 9.0

josefp

Hi,
I have a session performing SELECT S3Export(), but when I performed CLOSE_SESSION() and INTERRUPT_SESSION() command the session is still persistent.

I checked the PID of the session from the OS side using the information from the V_MONITOR.SESSIONS client_pid column, but I cannot find the OS PID running on the node.

How to force kill the session?

Bryan_H

There was a recent blog post about this, I think this answer was posted in another question:
https://forum.vertica.com/discussion/240886/stop-a-stubborn-query-that-won-t-cancel

josefp

Thank you Bryan, I'll check this option. Cheers.