CODEWITHSUNDEEP
clickhousematerialized-viewsttl
user
user

Reputation: 73

Clickhouse - TTL - Move data to another table

Is it possible to transfer expired data into another table ? I want to implement an efficient mechanism to transfer previous day data into weekly table, previous week data into monthly table etc.

I don't want to use multiple materialized views, to not calculate summary data for each table when new data comes.

Any design suggestion to handle this is also welcome.

Upvotes: 1

Views: 1124

Answers (1)

Denny Crane
Denny Crane

Reputation: 13310

Options:

Upvotes: 0

Related Questions