phpClickHouse
phpClickHouse copied to clipboard
FORMAT JSON doesn't work with SETTING materialize_ttl_after_modify
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