I am trying to specify the current time field in a MATERIALIZED VIEW in RW but encountering errors related to using current_timestamp(). Is it possible to define the current time field in a MATERIALIZED VIEW in RW?
pony lee
Asked on Feb 22, 2024
RW currently does not support specifying the current time field in a MATERIALIZED VIEW directly. The proctime column must be defined on the base table and selected in downstream queries. Additionally, defining the current_timestamp() as a generated column on the table t1
is recommended. RW may consider allowing proc time on the results of MATERIALIZED VIEWS and sinks in the future, but it requires careful consideration due to potential costs on retractable streams.