all-things-risingwave
How to get the current time in RW and filter records created in the last 5 minutes using materialized view?
Mahmoud is trying to get the current time in RW and filter records created in the last 5 minutes using a materialized view, but encountering errors. Eric suggests using now()
in the where
clause for streaming queries. Mahmoud provides the query and error messages. Liang suggests a temporary solution by resetting to a specific commit and changing the column type to resolve the bug.
ma
mahmoud elhalwany
Asked on Jan 26, 2023
now()
is supported in thewhere
clause for streaming queries.- Mahmoud encountered an error while trying to create a materialized view with a filter based on time.
- Liang suggests resetting to a specific commit and changing the column type to resolve the bug temporarily.
- The bug has been fixed in the latest main branch.
Jan 26, 2023Edited by