apache / apache/pinot

Support for `any_value` aggregation function

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

Description

Many databases provide an `any_value` aggregation function, which is useful in queries like this:

```sql
select colA, any_value(colB)
from T
group by colA
```

Contributor guide

Open the contributing guide

Research direction

Start with the SQL example and inspect Pinot's existing aggregation-function support and related tests. Done means a query using any_value(colB) with GROUP BY colA executes successfully and returns an appropriate value for each group.

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
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.