You should look at the Moving Average Query contributed extension ( https://druid.apache.org/docs/latest/development/extensions-contrib/moving-average-query.html). That provides window and analytic functions, and allows for user extensions. It isn't integrated into the SQL layer yet, but you can do a lot with it using native JSON queries.
Will <http://www.verizonmedia.com> Will Lauer Senior Principal Architect, Audience & Advertising Reporting Data Platforms & Systems Engineering M 508 561 6427 1908 S. First St Champaign, IL 61822 <http://www.facebook.com/verizonmedia> <http://twitter.com/verizonmedia> <https://www.linkedin.com/company/verizon-media/> <http://www.instagram.com/verizonmedia> On Fri, Oct 2, 2020 at 3:17 AM Dave Watson <blockeinst...@gmail.com> wrote: > Hello > Is there a published Roadmap? I am particularly interested in support for > window functions, analytical functions and user defined aggregate > functions. Similar to support in Hive and SparkSQL. > Thank you >