v.22.6Experimental Feature

Enables POPULATE for WINDOW VIEW

Enables POPULATE for WINDOW VIEW. #36945 (vxider).
Enables the POPULATE option for WINDOW VIEW in ClickHouse.

Why it matters

This feature allows users to pre-populate window views with existing data at the time of creation, ensuring that the view contains data immediately rather than waiting for incremental updates. It improves usability by simplifying data initialization for window views.

How to use it

When creating a WINDOW VIEW, add the POPULATE keyword to the CREATE WINDOW VIEW statement to populate the view with existing data immediately. For example:

CREATE WINDOW VIEW view_name POPULATE AS <your_window_query>