Skip to main content

Enable Join Spill

  • Jan 17, 2019 10:18 AM UTC
  • 2 replies
  • 19 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
    • Jan 18, 2019 6:59 PM UTC

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

    Dave_Stewart
    • Dave_Stewart
    • New Participant
    • Oct 19, 2021 1:17 PM UTC

    Don't forget asterisks ! :

    /*+set_vertica_options(EE, ENABLE_JOIN_SPILL)*/

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement