petern48 opened a new issue, #2570: URL: https://github.com/apache/sedona/issues/2570
In https://github.com/apache/sedona/pull/2561, a contributor added docs for a workaround for how they achieved using Sedona's `RangeJoinExec` for a LEFT JOIN. It involved rewriting the query with a CTE. While it works, we should support this behavior natively, so users don't have to do this workaround or *worse* move forward with the unoptimized behavior. Here's the workaround in the docs. We should also remove this from the docs once this is achieved. ```sql WITH inner_join AS ( SELECT dfA.a_id , dfB.b_id FROM dfA, dfB WHERE ST_INTERSECTS(dfA.geometry, dfB.geometry) ) SELECT dfA.*, inner_join.b_id FROM dfA LEFT JOIN inner_join ON dfA.a_id = inner_join.a_id; ``` -- 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]
