You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sedona.apache.org by "chinagui (via GitHub)" <gi...@apache.org> on 2023/06/09 07:30:16 UTC

[GitHub] [sedona] chinagui opened a new issue, #855: Support spatialJoin when the join clause contains unequal conditions

chinagui opened a new issue, #855:
URL: https://github.com/apache/sedona/issues/855

   ## Expected behavior
   Support spatialJoin when the join clause contains unequal conditions
   
   ## Actual behavior
   When there are spatial relationship conditions and non equivalence conditions in the join clause, spatialjoin is not effective and BroadcastNestedLoopJoin is used
   
   ## Steps to reproduce the problem
   
   ## Settings
   
   Sedona version = 1.4.0
   
   Apache Spark version = 3.3.0
   
   Apache Flink version = ?
   
   API type = Scala
   
   Scala version = 2.12
   
   JRE version = 1.8
   
   Python version = ?
   
   Environment = Standalone


-- 
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: dev-unsubscribe@sedona.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [sedona] chinagui commented on issue #855: Support spatialJoin when the join clause contains unequal conditions

Posted by "chinagui (via GitHub)" <gi...@apache.org>.
chinagui commented on issue #855:
URL: https://github.com/apache/sedona/issues/855#issuecomment-1606545270

   Like this，
   ```sql
   SELECT a.*
   FROM a
   JOIN b ON st_contains(a.geometry, b.geometry)
   JOIN c ON st_contains(b.geometry, c.geometry)
   WHERE a.id !=b.id
     AND b.id != c.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: dev-unsubscribe@sedona.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [sedona] Kontinuation commented on issue #855: Support spatialJoin when the join clause contains unequal conditions

Posted by "Kontinuation (via GitHub)" <gi...@apache.org>.
Kontinuation commented on issue #855:
URL: https://github.com/apache/sedona/issues/855#issuecomment-1585671059

   Can you provide an example query to reproduce this problem? I've tried queries like this and it was planned as a RangeJoin.
   
   ```sql
   SELECT * FROM df1 JOIN df2 ON ST_Contains(df1.geom, df2.geom) AND df1.dist > df2.dist
   ```


-- 
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: dev-unsubscribe@sedona.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org