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