Hi anyone can tell me how to enable a join spill for a specific query in vertica with example.
Thanks in advance
Place this directly after the statement (DELETE/MERGE/UPDATE/INSERT) ...
/+ set_vertica_options(EE, ENABLE_JOIN_SPILL)/
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.