comphead commented on issue #9846: URL: https://github.com/apache/arrow-datafusion/issues/9846#issuecomment-2027426584
it is used if next conditions met https://github.com/apache/arrow-datafusion/blob/81c96fc3db0ea35638278f32df066be63b745a51/datafusion/core/src/physical_planner.rs#L1136 There is also a small set of tests introduced in `sort_merge_join.slt`. And the plans there shows SMJ To enforce SMJ its needed to set ``` set datafusion.optimizer.prefer_hash_join = false; ``` Probably we can revisit tests and run some benchmarks with SMJ enforced to make a decision? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
