SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = starts time must be greater than current time,物化视图代码为:
CREATE MATERIALIZED VIEW dws_sales_mv
BUILD IMMEDIATE
REFRESH AUTO
ON SCHEDULE EVERY 1 DAY STARTS '2026-08-05 0:30:00'
PARTITION BY (date_trunc(docdate, 'month')) -- 修改点:去掉 RANGE,用括号包裹表达式
DISTRIBUTED BY HASH(docentry) BUCKETS 4
PROPERTIES ('replication_num' = '1')
AS
SELECT ...;
当前时间是'2026-08-04 11:30:00'(服务器和本地时间一样),即使改成STARTS '2026-08-06 0:30:00'也不能创建,但把时间改成STARTS '2026-08-04 23:30:00'就可以创建了,大家有遇到这个情况吗?