apache / apache/pinot

Multiple argument support for DISTINCTCOUNTHLL/DISTINCTCOUNTTHETASKETCH

Open
#8,225 2 comments 1 reaction 0 assignees View on GitHub
help wanted
Dominant language
Java
Stars
6.1k
Forks
1.5k
Avg merge
2d 3h
Merged PRs (30d)
195

Description

Currently pinot only supports a single argument for distinct count hll and thetasketch functions. For some use cases like ours where we needed distinct count by two columns and `id` and a `date` it is very useful.

https://docs.pinot.apache.org/users/user-guide-query/how-to-handle-unique-counting

Contributor guide

Open the contributing guide

Research direction

Start with the unique-counting documentation linked in the issue and trace the DISTINCTCOUNTHLL and DISTINCTCOUNTTHETASKETCH query-function entry points in Pinot. Done means both functions accept multiple column arguments and support distinct counting across combinations such as id and date, with the relevant behavior covered by the project's existing tests.

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.