Add distance range's lower bound support to Geoindex
Open
- Dominant language
- Java
- Stars
- 6.1k
- Forks
- 1.5k
- Avg merge
- 1d 21h
- Merged PRs (30d)
- 189
Description
The Geoindex introduced in this [PR](https://github.com/apache/incubator-pinot/pull/6409) supports only the upper bound of the distance range. It would be nice to add the lower bound support for queries like this
```
select count(*) from starbucksStores where 2000 < ST_DISTANCE(location_st_point , ST_POINT(-122, 37)) < 10000
```
Contributor guide
Research direction
Start by reading the linked PR 6409 and tracing the existing Geoindex support for the upper distance bound. Extend the same area to handle the lower bound in queries like the example, then verify that the shown distance-range query works correctly.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100