cstrap
10/6/2014 - 9:46 AM

HP Vertica - Server with low memory - Enable Spill

HP Vertica - Server with low memory - Enable Spill

enable_spill_vertica
content_copyfile_download
When: ERROR: Join inner did not fit in memory ...

$ vsql

dbadmin=> select set_vertica_options('EE','ENABLE_JOIN_SPILL');
                    set_vertica_options
--------------------------------------------------------------

 EE Vertica Options
 --------------------
 ENABLE_JOIN_SPILL
 
 (1 row)
 
 Thanks StackOverflow - http://stackoverflow.com/questions/12485524/how-to-enable-join-spill-in-vertica-database