Support for `any_value` aggregation function
Open
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
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