perf(streaming): non-blocking join matching

[BugenZhao]

...to further reduce the memory usage and also the latency, I guess we can even make hash_eq_match return a Stream instead of collecting the rows into an entry before we can yield them.

Originally posted by @BugenZhao in #10979 (comment)

[lmatz]

This is supposed to prevent the OOM case where a single row from the dimension table produces a huge number of joined results, e.g. 1M+, with the fact table, isn't it? (it occurred to me when looking at today's user OOM feedback

[BugenZhao]

This is supposed to prevent the OOM case where a single row from the dimension table produces a huge number of joined results, e.g. 1M+, with the fact table, isn't it? (it occurred to me when looking at today's user OOM feedback

I believe so. Work together with #10979.

[github-actions]

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.