为了更快的定位您的问题，请提供以下信息，谢谢
【详述】基于iceberg创建异步物化视图失败
【是否存算分离】否
【StarRocks版本】3.2.2
外表是一个iceberg表，分区是PARTITIONED BY (hours(mtimestamp),bucket(20,key),bucket(20,key1))
。 mtimestamp是一个TIMESTAMP字段。我想基于这张表进行一个异步物化视图，结果报错了。 Materialized view partition column in partition exp must be base table partition column.
CREATE MATERIALIZED VIEW view_test
REFRESH ASYNC EVERY (interval 5 MINUTE)
PARTITION BY ts
PROPERTIES
(
“excluded_trigger_tables”=“1”,
“auto_refresh_partitions_limit”=“2”
)
AS SELECT
date_trunc(“HOUR”,mtimestamp) as ts,key1
FROM iceberg.iceberg_db.mytable
GROUP BY key1,ts;