Join spill doesn't seem to work

Naresh_SankapelNaresh_Sankapel
in General Discussion
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  

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...