Kontinuation commented on code in PR #514:
URL: https://github.com/apache/sedona-db/pull/514#discussion_r2691000104
##########
rust/sedona-spatial-join/src/exec.rs:
##########
@@ -1075,10 +1085,10 @@ mod tests {
JoinType::Left => "SELECT L.id l_id, R.id r_id FROM L LEFT JOIN R
ON ST_Intersects(L.geometry, R.geometry) ORDER BY l_id, r_id",
JoinType::Right => "SELECT L.id l_id, R.id r_id FROM L RIGHT JOIN
R ON ST_Intersects(L.geometry, R.geometry) ORDER BY l_id, r_id",
JoinType::Full => "SELECT L.id l_id, R.id r_id FROM L FULL OUTER
JOIN R ON ST_Intersects(L.geometry, R.geometry) ORDER BY l_id, r_id",
- JoinType::LeftSemi => "SELECT L.id l_id FROM L WHERE EXISTS
(SELECT 1 FROM R WHERE ST_Intersects(L.geometry, R.geometry)) ORDER BY l_id",
- JoinType::RightSemi => "SELECT R.id r_id FROM R WHERE EXISTS
(SELECT 1 FROM L WHERE ST_Intersects(L.geometry, R.geometry)) ORDER BY r_id",
- JoinType::LeftAnti => "SELECT L.id l_id FROM L WHERE NOT EXISTS
(SELECT 1 FROM R WHERE ST_Intersects(L.geometry, R.geometry)) ORDER BY l_id",
- JoinType::RightAnti => "SELECT R.id r_id FROM R WHERE NOT EXISTS
(SELECT 1 FROM L WHERE ST_Intersects(L.geometry, R.geometry)) ORDER BY r_id",
+ JoinType::LeftSemi => "SELECT L.id l_id FROM L LEFT SEMI JOIN R ON
ST_Intersects(L.geometry, R.geometry) ORDER BY l_id",
+ JoinType::RightSemi => "SELECT R.id r_id FROM L RIGHT SEMI JOIN R
ON ST_Intersects(L.geometry, R.geometry) ORDER BY r_id",
+ JoinType::LeftAnti => "SELECT L.id l_id FROM L LEFT ANTI JOIN R ON
ST_Intersects(L.geometry, R.geometry) ORDER BY l_id",
+ JoinType::RightAnti => "SELECT R.id r_id FROM L RIGHT ANTI JOIN R
ON ST_Intersects(L.geometry, R.geometry) ORDER BY r_id",
Review Comment:
Yes, these are supported by DataFusion SQL parser.
--
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]
