v.23.3Improvement

Support for CTE in Parameterized Views Implementation Update

Official CH changelog text
Support for CTE in parameterized views Implementation: Updated to allow query parameters while evaluating scalar subqueries. #48065 (SmitaRKulkarni).
Added support for Common Table Expressions (CTEs) in parameterized views by enabling query parameters in scalar subqueries.

Why it matters

This feature allows more flexible and dynamic view definitions in ClickHouse by supporting query parameters in scalar subqueries, resolving previous limitations and improving query modularity and readability.

How to use it

Define parameterized views that include scalar subqueries with query parameters. When querying these views, provide the required parameters as part of the query execution to leverage CTEs within the view logic.

Related resources

PreviousNext