Guowei Zhu created KYLIN-5088: --------------------------------- Summary: kylin4 build cube cannot correct process explode array column Key: KYLIN-5088 URL: https://issues.apache.org/jira/browse/KYLIN-5088 Project: Kylin Issue Type: Bug Components: Spark Engine Affects Versions: v4.0.0 Reporter: Guowei Zhu
there is hive(hive-3.1.2) table and view as below {code:java} //代码占位符 create table pageAds2(id int,pageid STRING,adid_list Array<string>) row format delimited fields terminated by ',' collection items terminated by '_'; insert into pageAds2 select 1, 'front_page', array('1','2','3'); insert into pageAds2 select 2, 'contact_page', array('3','4','5'); create view pageAds2_view as SELECT pageid, adid FROM pageAds2 LATERAL VIEW explode(adid_list) adTable AS adid; {code} After building cube of pageAds2_view in kylin Insight execute below sql {code:java} //代码占位符 select ADID , count(*) from PAGEADS2_VIEW group by ADID {code} got below result ||ADID||EXPR$1|| |1_2_3|1| |3_4_5|1| but execute the same sql in hive got below result ||adid||_c1|| |1|1| |2|1| |3|2| |4|1| |5|1| -- This message was sent by Atlassian Jira (v8.3.4#803005)