1, array
create table test1 as select 1, '1';
create table test
(
id int,
id_list array<INT>
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
COLLECTION ITEMS TERMINATED BY ':';
insert overwrite table test
select 1, array(1, 2, 3, 4) from test1;
insert into table test
select 2, array(4,5,6,7,8,9) from test1;