-
Notifications
You must be signed in to change notification settings - Fork 24.6k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Support spatial distance search in ES|QL (ST_DISTANCE) #108212
Labels
:Analytics/ES|QL
AKA ESQL
:Analytics/Geo
Indexing, search aggregations of geo points and shapes
>enhancement
Team:Analytics
Meta label for analytical engine team (ESQL/Aggs/Geo)
Comments
Pinging @elastic/es-analytical-engine (Team:Analytics) |
We should also keep in mind use cases involving speed, as discussed at #108332 (comment) |
This was referenced Jun 20, 2024
Since the lucene pushdown for spatial sort has it's own issue, now moved to 8.16, we'll mark this main issue as DONE for 8.15. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Labels
:Analytics/ES|QL
AKA ESQL
:Analytics/Geo
Indexing, search aggregations of geo points and shapes
>enhancement
Team:Analytics
Meta label for analytical engine team (ESQL/Aggs/Geo)
Description
The Elasticsearch
_search
API supports distance filtering and sorting:In PostGIS there are two related functions:
ST_DWITHIN
for filtering by distanceST_DISTANCE
for calculating a distance, also usable for sortingThese features can be implemented in ES|QL, but we believe we do not need to implement both functions, as we can perform Lucene-pushdown optimization identically in both cases, so we'll implement the more generic function only:
double ST_DISTANCE(geomA, geomB)
.This can be used for calculating a distance, filter and sorting based on the context in the query:
Distance calculations
Filtering results
Sorting results
Tasks
ST_DISTANCE
#109972The text was updated successfully, but these errors were encountered: