This message was deleted.

I believe the SQL Window functions currently being worked on should handle this, e.g.:

select *,
  avg(Price) OVER(ORDER BY Date
     ROWS BETWEEN 2 PRECEDING AND CURRENT ROW )
     as moving_average
from stock_price;

Thanks @John Kowtko. If I understand it right, by

currently being worked on

, you mean it is in the making but not yet released/available. Could you confirm that? I don't see this available on our Druid instance (and we are on 0.23.0)

Hi @NKorade , yes they are under development. Though I don’t know which Druid release they will be in.

You can test them out if you build from the master branch. @Hellmar Becker wrote a great blog on this: https://blog.hellmar-becker.de/2023/03/26/druid-26-sneak-peek-window-functions/

Thanks @John Kowtko and thanks @Sergio Ferragut for the blog. This helps our planning a lot!