sedona icon indicating copy to clipboard operation
sedona copied to clipboard

Document spatial Left Join

Open alexeyegorov opened this issue 3 weeks ago • 1 comments

Based on this discussion about spatial joins, I have tried various options to perform a spatial left join.

Currently, we were using the S2 or H3 strategy as we need to perform LEFT JOINs in our setup (not inner joins). However, we figured out a combination of INNER JOIN and a FULL OUTER JOIN to produce a result of a LEFT JOIN by keeping high performance of Sedona spatial join.

A documentation will be updated in the PR.

alexeyegorov avatar Dec 14 '25 13:12 alexeyegorov

Added a PR here: https://github.com/apache/sedona/pull/2561

alexeyegorov avatar Dec 14 '25 13:12 alexeyegorov

this is live here: https://sedona.apache.org/latest/api/sql/Optimizer/#spatial-left-join

jiayuasu avatar Dec 17 '25 07:12 jiayuasu