Skip to content
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.

Sign up for GitHub

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

Jump to bottom

Support Lucene push-down for sorting by distance with ST_DISTANCE #109973

Open
Tracked by #108212
craigtaverner opened this issue Jun 20, 2024 · 1 comment
Open
Tracked by #108212

Support Lucene push-down for sorting by distance with ST_DISTANCE #109973

craigtaverner opened this issue Jun 20, 2024 · 1 comment
Assignees
@craigtaverner
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

@craigtaverner
Copy link
Contributor

craigtaverner commented Jun 20, 2024 •
edited
Loading

Based on the specification at #108212, we have implemented the ST_DISTANCE function in the PR at #108764.

However, this does not perform any Lucene pushdown when sorting by distance and so will run slow for larger datasets. We need to implement a high-performance sort, presumably by pushing down to _geo_distance sorting.
@craigtaverner craigtaverner mentioned this issue Jun 20, 2024
Open
@elasticsearchmachine elasticsearchmachine added the needs:triage Requires assignment of a team area label label Jun 20, 2024
@craigtaverner craigtaverner changed the title Support Lucene push-down for sorting by distance Support Lucene push-down for sorting by distance with ST_DISTANCE Jun 20, 2024
@craigtaverner craigtaverner added >enhancement :Analytics/Geo Indexing, search aggregations of geo points and shapes Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo) :Analytics/ES|QL AKA ESQL and removed needs:triage Requires assignment of a team area label labels Jun 20, 2024
@craigtaverner craigtaverner self-assigned this Jun 20, 2024
@elasticsearchmachine
Copy link
Collaborator

Pinging @elastic/es-analytical-engine (Team:Analytics)

@craigtaverner craigtaverner mentioned this issue Jun 20, 2024
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@craigtaverner craigtaverner

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)
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@craigtaverner @elasticsearchmachine