Process data
Deletes and updates
Similar to traditional databases, RisingWave supports data updates and deletions within tables. Additionally, when data in a table is modified or deleted, any materialized views built on that table will be updated accordingly.
A few details worth noting:
- Data on a table can be updated or deleted, even if the table was created using the
CREATE TABLE ... WITH ...
statement. Of course, since RisingWave does not support transactions, users need to be extra careful with data accuracy; - A source does not hold any data, so users cannot perform any update or deletion operations on a source.
- Data on a materialized view cannot be directly updated or deleted by users, which aligns with the design of traditional databases.
Examples
Let’s quickly verify how RisingWave handles deletion or modification operations from upstream in materialized views.
First, we create a table t
and a materialized view mv
:
Let’s check the result in the materialized view:
We get the following result:
We then add two rows:
Then let’s check the result in the materialized view again:
We should get:
Delete three rows:
and then check the result in the materialized view:
We should get:
Was this page helpful?