This message was deleted.

Hi Pavithra, Is this what you are looking for? https://docs.imply.io/polaris/time-series-functions/ This is currently released only in Imply Polaris (SaaS Druid) since last week but may make its way into OSS Druid over time.

Hi @John Kowtko.thanks for quick reply.the above links you provided will help me.i have one more question? i have requrement on aggregate will first interpolate to find values at the beginning and end of each interval, sum all raw values in said interval (including the interpolated values), then divide the sum by the length of the interval.is there any way in druid we can achive this?

It sounds like you want to compute an integral under the curve ... ... the upcoming LAG() window function should handle that ... ... until then there is a DATE_EXPAND() function which is used in conjunction with UNNEST(), which can generate evenly spaced time values. This has just come out in Imply, not sure if it's readily available in OSS right now ... and there isn't much doc on it right now, maybe take a look at: https://imply.io/blog/whats-new-in-imply-polaris-our-real-time-analytics-dbaas/

There is doc on

unnest

and the

date_expand

docs are in the work. https://github.com/apache/druid/blob/master/docs/querying/sql.md#unnest . These docs will go out with Druid 26.

Thank you.i will go through these docs and check