创建物化视图失败

查询没问题 但是建物化视图出现问题：

CREATE MATERIALIZED VIEW v_app_span_info_rpc_count
BUILD IMMEDIATE
REFRESH AUTO
ON SCHEDULE EVERY 1 MINUTE
PARTITION BY (date_trunc(receivetime,'DAY'))
DISTRIBUTED BY HASH(app_id) BUCKETS 10
PROPERTIES (
'partition_sync_limit'='7',
'partition_sync_time_unit'='DAY',
'replication_num' = '1'
)
AS
select
t.service_instance AS app_id,
t.service AS app_name,
kp.id as object_id,
am.id as module_id,
t.operationname rpc,
SUM(t.cost >=0 AND t.cost <1000) AS more_0s,
SUM(t.cost >=1000 AND t.cost <3000) AS more_1s,
SUM(t.cost >=3000 AND t.cost <5000) AS more_3s,
SUM(t.cost >=5000 AND t.cost <10000) AS more_5s,
SUM(t.cost >=10000 AND t.cost <20000) AS more_10s,
SUM(t.cost >=20000) AS more_20s,
COUNT(*) AS call_num,
SUM(t.iserror = 1) AS service_excep_num,
ROUND(AVG(t.cost), 2) AS average_elapsed,
date_trunc(t.receivetime,'minute') as receivetime
FROM app_span_info t
left join pg_cmdb_telepg.sync.k8s_pods kp on t.service_instance = kp.agent_id
left join pg_cmdb_telepg.sync.app_module am on t.service = am.invocation_chain_application_name
and kp.id IS NOT NULL AND am.app_type_code = 'AppType_CloudApp'
where t.spanid = 0
AND spanLayer IN (2, 3)
GROUP BY date_trunc(t.receivetime,'minute'), am.id,kp.id,t.service,t.service_instance,t.operationname;