Skip to content

Support live/window views for clickhouse #59

Description

@MasterOdin

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions