apache / apache/pinot

First aggregate function support

Open
#7,647 4 comments 1 reaction 0 assignees View on GitHub
Dominant language
Java
Stars
6.1k
Forks
1.5k
Avg merge
1d 21h
Merged PRs (30d)
189

Description

It would be nice to have FIRST() aggregate function that returns the first value in a bucket (similar to [LASTWITHTIME](https://github.com/apache/pinot/commit/da3bce50eb79656d967da7636a741653735abd63) function).

cc @Jackie-Jiang @weixiangsun

Contributor guide

Open the contributing guide

Research direction

Start by reading the linked LASTWITHTIME commit, which is the stated model for this feature, and trace how its behavior is represented in Apache Pinot. Done means FIRST() is available as an aggregate function and returns the first value in each bucket, with behavior consistent with the request.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
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.