all-things-risingwave
How can we define time to live for a table?
I am looking for ways to set a time to live for a table to automatically delete old records to prevent the table or materialized view from growing too large.
ma
mahmoud elhalwany
Asked on Jan 25, 2023
- RisingWave doesn't have explicit TTL functionality for base tables, but you can use window functions to enforce TTL for materialized views.
- For base tables, you can create materialized views with window functions to manage TTL.
- RisingWave recommends using Time Window or Temporal Filter as substitutes for explicit TTL functionality.
- Experimental support for table TTL was abandoned to maintain consistency between tables, materialized views, and states.
Jan 26, 2023Edited by