apache / apache/druid

Zero-Filling not working for non available buckets.

Open
#13,327 4 comments 0 reactions 0 assignees View on GitHub
Bug
Dominant language
Java
Stars
14.1k
Forks
3.8k
Avg merge
2d 58m
Merged PRs (30d)
233

Description

Affected Version : 24.0

### Description

While trying to query in a interval (example: "intervals": [ "2021-01-01T00:00:00.000/2022-01-04T00:00:00.000" ])

The buckets which are empty (which do not have data matching intervals with the data of timestamp in the database) does not populate zero filling even though keeping skipEmptyBuckets = false.

Query using:

{
"queryType": "timeseries",
"dataSource": "sample2",
"granularity": "day",
"aggregations": [
{ "type": "longSum", "name": "sample_name1", "fieldName": "content.VOLUME" }
],
"intervals": [ "2021-01-01T00:00:00.000/2022-01-04T00:00:00.000" ],
"context" : {
"skipEmptyBuckets": "false"
}
}

Not sure if this is not possible or if its an error?

Contributor guide

Open the contributing guide

Research direction

Start with Druid's timeseries query handling and the skipEmptyBuckets context option, using the supplied interval and query as the reproduction. Confirm whether empty day buckets are omitted despite skipEmptyBuckets=false, then identify the relevant behavior or test and define done as returning zero-filled buckets for the requested interval, or documenting that this is unsupported.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
database
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
32/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.