apache / apache/pinot

Add distance range's lower bound support to Geoindex

Open
#6,417 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.