SQL RAND function
Open
Area - SQL
Feature/Change Description
- Dominant language
- Java
- Stars
- 14.1k
- Forks
- 3.8k
- Avg merge
- 2d 58m
- Merged PRs (30d)
- 233
Description
### Description
Add a `RAND()` function to Druid SQL.
### Motivation
It could be used for random sampling (e.g. `WHERE RAND() < 0.2`).
See also https://github.com/apache/incubator-druid/issues/8661.
Contributor guide
Research direction
The issue names Druid SQL and the RAND() function but no file or test. Start by locating existing Druid SQL function implementations and their tests, then verify that RAND() supports the shown WHERE RAND() < 0.2 sampling use case and add matching coverage.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 38/100