Skip to content

FORMAT JSON doesn't work with SETTING materialize_ttl_after_modify #227

Open
@emfadei

Description

@emfadei

After 190 the problem appeared

example
ALTER TABLE table
ON CLUSTER cluster
MODIFY TTL toStartOfMonth(created_at) + INTERVAL 3 MONTH
SETTINGS materialize_ttl_after_modify=0
FORMAT JSON;

return error - Syntax error: failed at position 157 ('FORMAT') (line 5, col 5): FORMAT JSON. Expected end of query.
It doesn't matter whether we add ON CLUSTER or not

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions