异步物化视图刷新报错

为了更快的定位您的问题,请提供以下信息,谢谢
【详述】创建异步物化视图成功之后,首次自动刷新报错,找不到相应字段
【背景】明细基表join mysql外表然后union all相同逻辑
【业务影响】
【是否存算分离】
【StarRocks版本】例如:3.3.5
【集群规模】例如:1fe+2be(测试集群)
【机器信息】CPU虚拟核/内存/网卡,例如:48C/64G/万兆
【附件】
报错信息
Refresh materialized view dh_isp_report_uv failed after retrying 1 times(try-lock 0 times), error-msg : Getting analyzing error. Detail message: Column u0027social.b.order_idu0027 cannot be resolved.

创建物化视图语句
CREATE MATERIALIZED VIEW dh_isp_report_uv
PARTITION BY (pure_date)
DISTRIBUTED BY HASH(campaign_id) BUCKETS 6
REFRESH ASYNC START(‘2025-04-17 15:00:00’) EVERY (interval 30 minute)
AS
SELECT
pure_date,
campaign_id,
campaign_name,
b.order_id deal_id,
channel,
person_name,
event,
‘电信’ AS operator,
a.rmid
FROM ods_analysis_saas_telecom_rawdata_test a
JOIN v_da_red_book_campaign_order b
ON a.tag = b.order_id
union all
SELECT
pure_date,
campaign_id,
‘’ campaign_name,
‘’ deal_id,
0 channel,
‘’ person_name,
0 event,
‘电信’ AS operator,
a.rmid
FROM ods_analysis_saas_telecom_rawdata_test a
JOIN v_da_red_book_campaign_order b ON a.tag = b.order_id;

v_da_red_book_campaign_order (mysql外表创建的物化视图,jdbc catalog创建)