REFRESH MATERIALIZED VIEW lo_mv1 PARTITION START (“2020-02-01”) END (“2020-03-01”),2020-02-01能不能用日期函数替代?

REFRESH MATERIALIZED VIEW lo_mv1
PARTITION START (“2020-02-01”) END (“2020-03-01”);

START (“2020-02-01”) END (“2020-03-01”) 能不能使用日期相关的函数替代,还是只能写入固定的日期值?
同时,能不能使用第三方调度或etl工具调用REFRESH MATERIALIZED VIEW lo_mv1
PARTITION START (“2020-02-01”) END (“2020-03-01”);?

1赞