Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Enable Join Spill

Imran_ShabbirImran_Shabbir
in General Discussion

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

Thanks in advance

Comments

  • scottpedersoliscottpedersoli ✭

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

  • Dave_StewartDave_Stewart

    Don't forget asterisks ! :

    /*+set_vertica_options(EE, ENABLE_JOIN_SPILL)*/

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
Heading 1Heading 2
QuoteCodeSpoiler
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.