Need Help : Druid

Hi
Community, We had few requirements for which I needed some of your inputs if
possible. I am putting the same on druid user group as well.

Point-1

  1. . Need
    rolling aggregation of 3 hours, for every hour I need to find out metric
    aggregation (Avg, Min, Max) based on 3 hours of data . Is it possible by any
    chance or any how with druid ? (Image Attached)

    Point-2
    

Reset
Few values in case of some conditions

Suppose
I am calculating SUM of a day for particular metrics it will sum up all the
data of complete day. In case of some conditions coming from network suppose at
5AM in morning, it should find out SUM of values came after 5AM for that day.

Point-3

We
have requirement of providing daily aggregation based on customized timing
(like we have 1 feed where we need to send daily aggregation for the time
period 20:00 to 20:00)

Point-4

Current
druid is filling the metric value with 0 if it does not get anything, is there
any way I can default the same to some other value ? Some of the metrics would
be having 0 as some proper value and having 0 as default does not looks to suit
us. Would be good if we are able to keep it NULL. Please suggest.

Point-5

For
some of the feeds, we are required to give last polled value of all the metrics
[ suppose if we haven’t got value of any specific metric for the last poll then
we need to provide the value of earlier poll accordingly ]. Please suggest
accordingly.

Regards,

Arpan Khagram

Mobile: +91
8308993200

rolling_window.png