jiayuasu commented on PR #2561:
URL: https://github.com/apache/sedona/pull/2561#issuecomment-3658070153
@alexeyegorov The pre-commit still failed.
In addition, I think the full outer join and COALESCE is not needed, if the
target is a left join from dfa.geom to dfb.geom?
I think below it is what you need
```
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]
