一 转换到map操作
1 行数据聚合成map
with init_data as ( -- 构造数据源
select '11' as id, 'app_1' as pkg, 1 as is_init
union all
select '11' as id, 'app_2' as pkg, 0 as is_init
union all
select '22' as id, 'app_3' as pkg, 0 as is_init
union all
select '22' as id, 'app_4' as pkg, 0 as is_init
)
select
id,
map_from_entries( collect_list(struct(pkg, is_init)) ) as info
from
init_data
group by
id
;