I'm preparing for a talk about streaming databases and would like to know if RisingWave supports setting a retention time for tables or materialized views to automatically delete older rows. Is there a feature like this in RisingWave, or is there another way to manage memory usage?
Joe Lin
Asked on Mar 25, 2024
retention_seconds option in the CREATE TABLE/MATERIALIZED VIEW statement.create table for storing ingested data and create source for building materialized views without storing data.create view) are logical constructs that do not store data but can simplify SQL queries.