phpClickHouse icon indicating copy to clipboard operation
phpClickHouse copied to clipboard

FORMAT JSON doesn't work with SETTING materialize_ttl_after_modify

Open emfadei opened this issue 1 year ago • 0 comments

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

emfadei avatar Sep 24 '24 07:09 emfadei