为了更快的定位您的问题,请提供以下信息,谢谢
【详述】创建物化视图报错 [S1009] Can not issue data manipulation statements with executeQuery().
【背景】新建
【业务影响】
【是否存算分离】否
【StarRocks版本】3.15
【集群规模】3fe+3be(fe与be混部)
【机器信息】32g 16c
CREATE MATERIALIZED VIEW lo_mv1
REFRESH ASYNC
as
select t.third_acco,org_name,org_type
from fap_customer_establish_account t
left join fap_customer c on t.fofund_no = c.fofund_no and c.delete_flag = ‘0’
LEFT JOIN fap_organization B ON c.org_code=B.org_code
where t.delete_flag = ‘0’
;
[S1009] Can not issue data manipulation statements with executeQuery().