物化视图视图创建失败,select查询结果正常,物化视图不支持LATERAL VIEW EXPLODE_OUTER吗?
CREATE MATERIALIZED VIEW user_center.mv_member_funder
BUILD IMMEDIATE
REFRESH COMPLETE ON MANUAL
AS
SELECT
member_id,
member_name,
member_type,
category,
ctag.province_code,
ctag.city_code,
ctag.area_code,
ctag.address,
ctag.province_name,
ctag.city_name,
ctag.area_name,
ctag.identity_number,
ctag.market_ids,
ctag.market_names,
funder_info.funder_name AS funder_name,
funder_info.branch_org_name AS branch_org_name
FROM user_center.ads_customer_tag ctag
LATERAL VIEW EXPLODE_OUTER(ctag.fund_info) tmp AS funder_info;
其中ads_customer_tag表结构为
CREATE TABLE `ads_customer_tag` (
`member_id` int NULL COMMENT "会员ID",
`member_name` text NULL COMMENT "会员名称",
`member_type` tinyint NULL COMMENT "会员类型",
`category` text NULL COMMENT "父级项目名称",
`province_code` int NULL COMMENT "省编码",
`city_code` int NULL COMMENT "省编码",
`area_code` int NULL COMMENT "省编码",
`address` text NULL COMMENT "详细地址",
`province_name` varchar(100) NULL COMMENT "省名称",
`city_name` varchar(100) NULL COMMENT "市名称",
`area_name` varchar(100) NULL COMMENT "区名称",
`identity_number` varchar(500) NULL COMMENT "证件号码",
`market_names` text NULL COMMENT "市场名称",
`fund_info` array<struct<org_id:int,org_name:varchar(300),funder_name:varchar(100),branch_org_id:int,branch_org_name:varchar(300)>> NULL
) ENGINE=OLAP
UNIQUE KEY(`member_id`)
COMMENT '客户信息'