这是物化视图SQL:
CREATE MATERIALIZED VIEW t_electronic_back_order_wide2
DISTRIBUTED BY HASH ( record_time )
PARTITION BY record_time
REFRESH ASYNC
START ( ‘2025-01-08 12:12:00’ )
EVERY ( INTERVAL 50 MINUTE )
AS
SELECT
xx_hash3_64(CONCAT(‘t_electronic_back_order_market’, id)) AS id,
xx_hash3_64(CONCAT(‘t_market’, market_id)) AS market_cabinet_id,
NULL as cabinet_id,
market_id ,
order_status,
record_time,
order_code,
order_total_price,
order_commodity_weight,
create_date,
business_id,
‘market’ as source – 标识数据来源是菜场订单表
FROM t_electronic_back_order_market
UNION ALL
SELECT
xx_hash3_64(CONCAT(‘t_electronic_back_order’, id)) AS id,
xx_hash3_64(CONCAT(‘t_cabinet’, cabinet_id)) AS market_cabinet_id,
cabinet_id,
NULL as market_id,
order_status,
record_time,
order_code,
order_total_price,
order_commodity_weight,
create_date,
NULL AS business_id,
‘cabinet’ as source – 标识数据来源是菜柜订单表
FROM t_electronic_back_order
配置了资源组没有效果，请问怎么解决