Join spill doesn't seem to work

Naresh_Sankapel

Hi,

I have enable join spill in a query which contains multiple join operations. /*+set_vertica_options(EE, ENABLE_JOIN_SPILL)*/ is added to the query. But, I still get inner partition did not fit into memory error. Any clues on why it is happening is appreciated. 

Thanks
Naresh  

Prasanta_Pal

You may refer to  Adam's post
https://community.vertica.com/vertica/topics/enable_join_spill_usage