The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
How to Force Kill Session in Vertica 9.0

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?
Tagged:
0
Answers
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
Thank you Bryan, I'll check this option. Cheers.