You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@sedona.apache.org by "zhangfengcdt (via GitHub)" <gi...@apache.org> on 2025/01/22 22:50:47 UTC
Re: [I] Two table join via predicate St_knn , exclusive the others predicates? [sedona]
zhangfengcdt commented on issue #1766:
URL: https://github.com/apache/sedona/issues/1766#issuecomment-2608428329
This query is not yet supported. The reason is that the ST_KNN cannot be used as a predicate because predicates in SQL are used to filter rows based on conditions that evaluate to true or false, while ST_KNN is a ranking function. That being said, a knn join cannot be used as a predicate with a regular join condition.
However, we do support KNN join with equality and inequality operators that are pushed to the source datasource loader, for example:
```
select * from tbl_a
join tbl_b on st_knn(point,point,1) and tbl_a.groupid = 1
```
is supported with the groupid = 1 pushed to the reader.
--
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: issues-unsubscribe@sedona.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org