Window functions

Window functions
Link blog.tinybird.co/2021/03/16/c…
Date Mar 26, 2021

Windows Function Slides

blog.tinybird.co/2021/03/16/c…

An exploration on what’s possible to do with the most recent experimental feature on ClickHouse - window functions, and an overview of other interesting feat…

Windows Functions Blog Link

How Do I Simulate Window Functions Using Arrays on older versions of clickhouse?

  1. Group with groupArray.
  2. Calculate the needed metrics.
  3. Ungroup back using arrayJoin.
Last modified 2021.08.12 : General corrections and updates. (5969b688)