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

  1. now() is supported in the where clause for streaming queries.
  2. Mahmoud encountered an error while trying to create a materialized view with a filter based on time.
  3. Liang suggests resetting to a specific commit and changing the column type to resolve the bug temporarily.
  4. The bug has been fixed in the latest main branch.
Jan 26, 2023Edited by