Timeseries queries are not being zero-filled

Hey guys,

Is it just me or timeseries queries are not being zero-filled http://druid.io/docs/0.8.2/querying/timeseriesquery.html? Ensured that the ingested data existing within provided interval w/ “gaps”. Also, playing with the context options wasn’t helpfull: “context” : { “skipEmptyBuckets”: “false” }

Any help would be much appreciated.

Regards,

Shinesun

Just to add that updating Druid to 0.8.2 didn’t help.

Regards,
Shinesun

Hi Shinesun, why do you think zero-filling is not working?

Can you provide an example result?

Hi Fangjin,

It simply doesn’t work as described in documentation:

Timeseries queries normally fill empty interior time buckets with zeroes. For example, if you issue a “day” granularity timeseries query for the interval 2012-01-01/2012-01-04, and no data exists for 2012-01-02, you will receive:
[

{
“timestamp”: “2012-01-01T00:00:00.000Z”,
“result”: { “sample_name1”: <some_value> }
},
{
“timestamp”: “2012-01-02T00:00:00.000Z”,
“result”: { “sample_name1”: 0 }
},
{
“timestamp”: “2012-01-03T00:00:00.000Z”,
“result”: { “sample_name1”: <some_value> }
}
]

So, I’m not getting results for 2012-01-02 at all thus wondering whether this feature’s still working.

Please let me know if I can provide any other info.

Can you please supply a unit test to reproduce the behaviour?