How to create a Materialized View in Risingwave to compute the mean of data every 30 seconds and ensure it updates only with new data?
I am trying to create a mean materialized view in Risingwave that computes the mean of the message every 30 seconds. I need to ensure the view updates only with new data coming in and starts computing from the current time, not including data from the past. The current query I tried updates the view every 60 seconds and seems to be updating at a higher rate than expected. Am I misusing Risingwave?
Atiqul Islam
Asked on Apr 07, 2024
-
To create a Materialized View in Risingwave that computes the mean of data every 30 seconds and updates only with new data, you can adjust the query to filter data based on the current time.
-
Ensure that the Materialized View is computed based on the data coming in starting from now, not including data collected over the last two days.
-
Modify the query to accurately calculate the mean of the data within the specified 30-second window.
-
Check the update frequency of the Materialized View to ensure it aligns with the expected rate of new data coming in.