Skip to main content

Enable Join Spill

  • January 17, 2019
  • 2 replies
  • 5 views
Imran_Shabbir
Forum|alt.badge.img

Hi anyone can tell me how to enable a join spill for a specific query in vertica with example.

Thanks in advance

    2 replies

    scottpedersoli
    Forum|alt.badge.img+1
    • scottpedersoli
    • Participating Frequently
    • January 18, 2019

    Place this directly after the statement (DELETE/MERGE/UPDATE/INSERT) ...
    /+ set_vertica_options(EE, ENABLE_JOIN_SPILL)/

    Dave_Stewart
    • Dave_Stewart
    • New Participant
    • October 19, 2021

    Don't forget asterisks ! :

    /*+set_vertica_options(EE, ENABLE_JOIN_SPILL)*/

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement