Skip to main content

Join spill doesn't seem to work

  • September 30, 2014
  • 1 reply
  • 9 views

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

1 reply

Prasanta_Pal
Forum|alt.badge.img
  • Participating Frequently
  • October 1, 2014