Tracking: enhance hash join spilling

[xudong963]

Summary

• join_spilling_threshold to ratio #14771
• make partition number configurable: part of fix: fix hash join spilling hang and add more tests #14794
• support left-related join spilling: feat: support left-related join spilling #14828
• make hash join spilling stable and add enough tests: part of fix: fix hash join spilling hang and add more tests #14794
• support right-related join spilling: feat: support right-related join spilling #14853
• open hash join spilling by default: chore: open join spilling by default #14843
• support cross join spilling: feat: support cross join spilling #14887
• feat: add a buffer to Spiller #14963
• support recursive spilling when the restored partition still can't fit into memory.

[xudong963]

Bug fixes:

• fix: check if global memory is negative #14733
• fix: fix hash join spilling hang and add more tests #14794
• fix: fix wrong results for left join spilling #14860
• fix: make block data type be consistent with hash method #15089

[xudong963]

Refactor:

• refactor: refactor hash join spill probe side #14743
• refactor: hash join build spilling #14768
• refactor: reduce hash join build spilling files #14919
• refactor: reduce hash join probe spilled files #14942

[xudong963]

Others:

• A repo to test databend's join spilling: https://github.com/xudong963/NOOOM

[BohuTANG]

Others:

• A repo to test databend's join spilling: https://github.com/xudong963/NOOOM

Great, I didn't know have this one. Can you port this into wizard? https://github.com/datafuselabs/wizard

[xudong963]

Others:

• A repo to test databend's join spilling: https://github.com/xudong963/NOOOM

Great, I didn't know have this one. Can you port this into wizard? https://github.com/datafuselabs/wizard

Will do it