Add a "Distinct" implementation that leverages index for low cardinality columns
Open
- Dominant language
- Java
- Stars
- 6.1k
- Forks
- 1.5k
- Avg merge
- 1d 21h
- Merged PRs (30d)
- 189
Description
For queries of the type: `select distinct() from `, we can create an implementation that enhances the query performance
Contributor guide
Research direction
No files, tests, or entry points are named. Start by tracing Pinot's handling of SELECT DISTINCT queries and how indexes are used for low-cardinality columns. Define the execution approach and validation criteria, then add tests or benchmarks showing that the stated query shape uses the index and improves performance.
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
- 25/100