troubleshooting

Can RW specify the current time field in a MATERIALIZED VIEW?

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?

po

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.

Feb 23, 2024Edited by