物化视图创建-使用LATERAL VIEW EXPLODE_OUTER

Viewed 6

物化视图视图创建失败,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 '客户信息'
0 Answers