As more and more customers use CrateDB to power their Internet of Things (IoT) and machine data applications, the need for window functions grows.From the PostgreSQL docs:

"A window function performs a calculation across a set of table rows that are somehow related to the current row. This is comparable to the type of calculation that can be done with an aggregate function. But unlike regular aggregate functions, use of a window function does not cause rows to become grouped into a single output row — the rows retain their separate identities."

In CrateDB 3.2, aggregation functions can now be used in combination with time windows. This is an important step forward for our window function support.

We will continue to work on this feature.