Clickhouse: Modifying TTL on ReplicatedMergeTree does not seem to work

Created on 31 May 2019  路  2Comments  路  Source: ClickHouse/ClickHouse

Describe the bug
Modifying TTL on ReplicatedMergeTree

  • does not work,
  • does not show the added TTL option,
  • or does not throw an error if it's not supported.

How to reproduce

  • Which ClickHouse server version to use
    19.6.2.11
  • Which interface to use, if matters
    clickhouse-client

  • Non-default settings, if any
    n/a

  • CREATE TABLE statements for all tables involved

CREATE TABLE test.repl1 (
    `dt` DateTime, 
    `test` Int64
) ENGINE = ReplicatedMergeTree('/clickhouse/tables/{layer}-{shard}/test.repl1', '{replica}') 
ORDER BY dt 
SETTINGS index_granularity = 8192;
  • Sample data for all these tables, use clickhouse-obfuscator if necessary
    n/a
  • Queries to run that lead to unexpected result
ALTER TABLE test.repl1 MODIFY TTL dt + INTERVAL 1 DAY;

Expected behavior
A clear and concise description of what you expected to happen.

SHOW CREATE TABLE test.repl1; should show TTL dt + toIntervalDay(1) but it doesn't.

Error message and/or stacktrace
If applicable, add screenshots to help explain your problem.
n/a

Additional context
Add any other context about the problem here.

bug comp-ttl

Most helpful comment

Fixed in master and will be available in next testing release within a day.

All 2 comments

Fixed in master and will be available in next testing release within a day.

Was this page helpful?
0 / 5 - 0 ratings