The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.

Enable Join Spill

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

Thanks in advance

Comments

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

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