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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
