apache / apache/pinot

Extend Geospatial support to include additional functions like st_envelope, st_buffer etc.

Open
#8,050 0 comments 0 reactions 0 assignees View on GitHub
feature geo
Dominant language
Java
Stars
6.1k
Forks
1.5k
Avg merge
2d 3h
Merged PRs (30d)
195

Description

We have a geospatial usecase where we need to find the points in a polygon which Pinot can do really well with ST_Contains but what we need to do is fetch the Polygon by creating a Bounding box around a Point. Other tools for e.g postgis offers function like `ST_Envelope` to create this bounding box and `St_Buffer` to take a buffer for the radius.

Request is to add similar geometry capabilities to Pinot as well vs. having to manually define it.

cc @mayankshriv

Contributor guide

Open the contributing guide

Research direction

Start by tracing Pinot's existing ST_Contains geospatial function and how geometry functions are exposed. Define the scope for ST_Envelope and ST_Buffer, including bounding-box and radius behavior, then verify the supported functions with focused geospatial tests.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.