v.19.14Experimental Feature

Implementation of LIVE VIEW Tables That Were Originally Proposed in #2898, Prepared in #3925, and Then Updated in #5541

Official CH changelog text
Implementation of LIVE VIEW tables that were originally proposed in #2898, prepared in #3925, and then updated in #5541. See #5541 for detailed description. #5541 (vzakaznikov) #6425 (Nikolai Kochetov) #6656 (vzakaznikov) Note that LIVE VIEW feature may be removed in next versions.
Introduces LIVE VIEW tables, a new table engine that allows users to create live, continuously updating views based on a query.

Why it matters

The LIVE VIEW feature solves the problem of needing real-time or continuously refreshed view results without manually triggering refreshes. It enables users to automatically monitor and interact with constantly updated query results, improving observability and ease of use for live data streams.

How to use it

Create a LIVE VIEW table by specifying the LIVE VIEW engine in the CREATE TABLE statement, followed by a query. For example:

CREATE LIVE VIEW view_name AS
SELECT ... FROM ...;

The view will then continuously refresh its result set automatically.

Related resources

PreviousNext