sql-query-identifier icon indicating copy to clipboard operation
sql-query-identifier copied to clipboard

Support live/window views for clickhouse

Open MasterOdin opened this issue 3 years ago • 0 comments

See https://clickhouse.com/docs/en/sql-reference/statements/create/view, it supports the following two modifiers for creating views: LIVE and WINDOW:

an example usage:

CREATE LIVE VIEW lv AS SELECT sum(x) FROM mt;
CREATE WINDOW VIEW wv AS SELECT count(number), tumbleStart(w_id) as w_start from date GROUP BY tumble(now(), INTERVAL '5' SECOND) as w_id

MasterOdin avatar Aug 24 '22 22:08 MasterOdin