Is your feature request related to a problem or challenge?

In SortMergeJoin, it is possibly run of memory when it requires extra memory to hold polled buffer batches. We can consider adding spilling support there to make the operator resilient to the memory issue.

Describe the solution you'd like

Add spilling support in SortMergeJoin.

Describe alternatives you've considered

No response

Additional context

No response