v.20.3Improvement

Now uses CREATE LIVE VIEW for temporary views instead of CREATE TEMPORARY LIVE VIEW

Official CH changelog text
Now temporary LIVE VIEW is created by CREATE LIVE VIEW name WITH TIMEOUT [42] ... instead of CREATE TEMPORARY LIVE VIEW ..., because the previous syntax was not consistent with CREATE TEMPORARY TABLE ... #9131 (tavplubix)
Temporary LIVE VIEW is now created using the syntax CREATE LIVE VIEW name WITH TIMEOUT [seconds] ... instead of CREATE TEMPORARY LIVE VIEW ....

Why it matters

This change improves syntax consistency in ClickHouse by aligning the creation of temporary live views with the existing syntax for temporary tables (CREATE TEMPORARY TABLE ...). It clarifies the semantics and usage patterns for temporary live views by explicitly specifying a timeout duration.

How to use it

To create a temporary live view, use the statement:

CREATE LIVE VIEW view_name WITH TIMEOUT 42 AS
SELECT ...


Replace 42 with the desired timeout in seconds. This replaces the old syntax CREATE TEMPORARY LIVE VIEW.

Related resources

PreviousNext