【详述】创建物化视图, 因为分区字段长度过大,导致启动恢复失败, 最后清空所有元数据
【背景】创建视图
CREATE MATERIALIZED VIEW mv_device_2_clct_date
DISTRIBUTED BY HASH(device_sn)
PARTITION BY date_trunc(“MONTH”, clct_date)
REFRESH ASYNC START(‘2024-04-24 10:00:00’) EVERY (interval 10 MINUTE)
AS
select device_sn, data_date as clct_date from data_record_index group by device_sn, data_date
union
select device_sn, date_format(time, ‘%Y%m%d’) as clct_date from event_data group by device_sn, clct_date;
ALTER MATERIALIZED VIEW mv_device_2_clct_date ACTIVE;
【业务影响】
因为分区字段长度过大,导致启动恢复失败, 最后清空所有元数据
【是否存算分离】
否
【StarRocks版本】 3.0.7
【集群规模】单机
【错误信息】
com.starrocks.sql.analyzer.SemanticException: Unsupported partition type VARCHAR(1048576) for function date_trunc(‘month’, fleetplatform.mv_device_2_clct_date.clct_date)
