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

Spatial ES|QL MVP with OGC functions #103590

Open
craigtaverner opened this issue Dec 19, 2023 · 3 comments
Open

Spatial ES|QL MVP with OGC functions #103590

craigtaverner opened this issue Dec 19, 2023 · 3 comments
Labels
:Analytics/ES|QL AKA ESQL >enhancement Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo)

Comments

@craigtaverner
Copy link
Contributor

craigtaverner commented Dec 19, 2023 •
edited
Loading

Description

Based on the initial Spatial ES|QL feature set described in #103587, we would like to see a modest subset of OGC compliant functions. These can be grouped into the following categories:

  • Predicates
    • To be used in the WHERE clause as filters, for example FROM index | WHERE ST_WITHIN(location, "POLYGON(...)")
  • Scalar functions
    • For performing calculations or transformations on spatial types, for example FROM index | EVAL area = ST_AREA(geometry)
  • Statistics (Aggregations)
    • For aggregating spatial types, for example: FROM index | STATS centroid=ST_CENTROID(location) BY category)
@craigtaverner craigtaverner added >enhancement Team:QL (Deprecated) Meta label for query languages team :Analytics/ES|QL AKA ESQL labels Dec 19, 2023
@elasticsearchmachine
Copy link
Collaborator

Pinging @elastic/es-ql (Team:QL)

@elasticsearchmachine
Copy link
Collaborator

Pinging @elastic/elasticsearch-esql (:Query Languages/ES|QL)

@wchaparro wchaparro added the Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo) label Jan 2, 2024
@elasticsearchmachine
Copy link
Collaborator

Pinging @elastic/es-analytics-geo (Team:Analytics)

@elasticsearchmachine elasticsearchmachine removed the Team:QL (Deprecated) Meta label for query languages team label Jan 2, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
:Analytics/ES|QL AKA ESQL >enhancement Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo)
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@craigtaverner @wchaparro @elasticsearchmachine