Closed
Description
Is your feature request related to a problem or challenge?
Hi all
I was going through SMJ implementation and suddenly stepped on the comments
// Sort-Merge join support currently is experimental
I think it would be nice to revisit it and understand if Sort Merge Join Exec is still experimental.
And if so is there any strategies to make it stable, or to run benchmarks to prove the join is stable?
- Adding TPCH benchmarks for Sort Merge Join #10092
- Trigger the Sort Merge Join benchmark using the GitHub action #10109
- fix Sort Merge Join to pass TPCH tests #10100
- Memory account not adding up in SortExec #10073
- Document Sort Merge Join algorithm #10357
- Sort Merge Join. LeftSemi issues #10379
- Sort Merge Join. LeftAnti issues #10380
- Add spilling in SortMergeJoin #9359
- SortMergeJoin: Add RightSemi join support #13471
- SortMergeJoin: Add RightAnti join support #13472
- SortMergeJoin: Add fuzz tests for SMJ when the JoinFilter is set #10659
- SortMergeJoin: The query stuck when join filter is set and more matched rows than batch size #10491
- SMJ LeftAnti filtered join fuzz test cannot pass #10872
- SMJ: incorrect result for filtered right outer join #10882
- SMJ producing different results than HashJoin when doing a semi join #10886
- Add fuzz tests for SortMergeJoin spilling #11541
- Intermittent failures in
fuzz_cases::join_fuzz::test_anti_join_1k_filtered#11555 - Flaky fuzz tests for filtered outer SortMergeJoin #12359
- Test TPCH with sort merge join #13573
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response