Igor is looking for a way to limit the Table space based on a Kafka topic in RisingWave to only keep recent data and purge old data. He wants to create an index for recent data without keeping unused data in RisingWave. Is this possible with RisingWave?
Igor Artamonov
Asked on Mar 02, 2024
Example:
CREATE MATERIALIZED VIEW MV AS
SELECT * FROM sales
WHERE sale_date > NOW() - INTERVAL '1 week';
This will ensure that only recent data is stored in the Table, and old data will be purged automatically.