join spill and internal tables

Daniel_Leybovic

join spill - seems doesn't work on internal tables ??? daniel=> select version(); version ------------------------------------ Vertica Analytic Database v6.1.2-0 (1 row) daniel=> \! free -m total used free shared buffers cached Mem: 7845 3107 4737 0 72 1591 -/+ buffers/cache: 1444 6401 Swap: 3904 0 3904 daniel=> \p -- query with hint select /*+set_vertica_options(ee, enable_join_spill)*/ * from query_requests a inner join dc_errors b on a.session_id = b.session_id and a.transaction_id = b.transaction_id and a.statement_id = b.statement_id; daniel=> \g -- execution ERROR 3815: Join inner did not fit in memory [(v_internal.dc_errors x v_internal.dc_requests_issued) using dc_errors_p and subquery (PATH ID: 1)] -- enable globally daniel=> select set_vertica_options('EE','ENABLE_JOIN_SPILL'); set_vertica_options -------------------------------------------------------------- EE Vertica Options -------------------- ENABLE_JOIN_SPILL (1 row) -- execute daniel=> select /*+set_vertica_options(ee, enable_join_spill)*/ ^J * -- all^J from query_requests a ^J inner join ^J dc_errors b ^J on a.session_id = b.session_id ^J and ^J a.transaction_id = b.transaction_id ^J and ^J a.statement_id = b.statement_id; ERROR 3815: Join inner did not fit in memory [(v_internal.dc_errors x v_internal.dc_requests_issued) using dc_errors_p and subquery (PATH ID: 1)]