Skip to main content

How to end an endlessly running query in Vertica?

  • June 28, 2013
  • 3 replies
  • 13 views
Akshay_Anand
I put a query to create a table in Vertica. But it seems that the query is taking more time to execute when compared to the average run time. It tried to stop the query using the cross button available in the background processes tab, but unfortunately it didn't stop the query. Can you please help in stopping it?

    3 replies

    Prasanta_Pal
    Forum|alt.badge.img
    • Prasanta_Pal
    • Participating Frequently
    • June 28, 2013
    Hi, Closing the session may help to stop the query, you may try. dbadmin=> select session_id from sessions; session_id ---------------------------------- localhost.localdoma-6910:0x44294 select close_session('localhost.localdoma-13354:0xbeab');
    id10t
    Forum|alt.badge.img
    • id10t
    • Participating Frequently
    • February 19, 2015
    INTERRUPT_STATEMENT

    Syntax
    INTERRUPT_STATEMENT( 'session_id ', statement_id )
    Navin_C
    Forum|alt.badge.img+2
    • Navin_C
    • Participating Frequently
    • March 5, 2015

    INTERRUPT_STATEMENT is the best option, you can select which queries you want to stop.

    Did, you try to find out why your queries are blocked.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement