店铺设计效果图软件seo专业论坛

在某些场景下需要进行 with 嵌套

需要以下进行处理，报如图错误

with abc as (select * from ..
)
insert into xxx
select * from abc

尝试创建物化视图

CREATE MATERIALIZED VIEW IF NOT EXISTS ads_test.xxx_mv
REFRESH DEFERRED MANUAL
AS 
with abc as (select * from ..
)
select * from abc

创建视图

create view ads_test.tmp_20240927_70_vip_view as
with abc as (select * from ..
)
select * from abc