apache / apache/sedona-db

c/sedona-s2geography: Complete function parity with BigQuery geography

Open
#821 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Rust
Stars
503
Forks
61
Avg merge
2d 4h
Merged PRs (30d)
90

Description

A few functions are missing and need low-level implementation in s2geography to complete parity with the list of functions at https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions .

- [ST_LINESUBSTRING](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_linesubstring)
- [ST_COVEREDBY](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_coveredby)
- [ST_COVERS](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_covers)
- [ST_HAUSDORFFDWITHIN](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_hausdorffdwithin)
- [ST_INTERSECTSBOX](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_intersectsbox)
- [ST_TOUCHES](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_touches)
- [ST_ANGLE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_angle)
- [ST_AZIMUTH](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_azimuth)
- [ST_HAUSDORFFDISTANCE](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_hausdorffdistance)

Contributor guide

Open the contributing guide

Research direction

Start in the s2geography component and compare its available functions with the linked BigQuery geography-functions reference. Implement the nine listed functions at the low level, then verify that s2geography provides parity with that function list.

Written by the indexing model from the issue text.

Assessment

Tech stack
rust
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.