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)
