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 ST_EXTENT_AGG in ESQL #104659

Closed
craigtaverner opened this issue Jan 23, 2024 · 1 comment · Fixed by #117451
Closed

Support ST_EXTENT_AGG in ESQL #104659

craigtaverner opened this issue Jan 23, 2024 · 1 comment · Fixed by #117451
Assignees
@GalLalouche
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) v9.0.0

Comments

@craigtaverner
Copy link
Contributor

craigtaverner commented Jan 23, 2024 •
edited
Loading

Description

The simplest spatial aggregation once both points and shapes are supported is ST_EXTENT. This is also the only aggregation being considered for non-licensing due to its potential usage in Kibana. The function is similar to ST_ENVELOPE, but instead of generating the bounds for a geometry argument, it aggregates over all geometries for that field, and produces a combined bounding box.

For reference, the PostGIS documentation is https://postgis.net/docs/ST_Extent.html
@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 v8.13.0 labels Jan 23, 2024
@craigtaverner craigtaverner mentioned this issue Jan 23, 2024
Open
@elasticsearchmachine
Copy link
Collaborator

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

@craigtaverner craigtaverner self-assigned this Jan 29, 2024
@craigtaverner craigtaverner changed the title Support ST_BOUNDS in ESQL Support ST_EXTENT in ESQL Jan 29, 2024
@craigtaverner craigtaverner changed the title Support ST_EXTENT in ESQL Support ST_EXTENT_AGG in ESQL Apr 17, 2024
@craigtaverner craigtaverner mentioned this issue Nov 19, 2024
Closed
@GalLalouche GalLalouche mentioned this issue Dec 2, 2024
Merged
@GalLalouche GalLalouche linked a pull request Dec 2, 2024 that will close this issue
ST_EXTENT aggregation (#104659) #117451
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@GalLalouche GalLalouche

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

Successfully merging a pull request may close this issue.

ST_EXTENT aggregation (#104659) GalLalouche/elasticsearch
4 participants
@craigtaverner @mark-vieira @GalLalouche @elasticsearchmachine