例1:
select explode(map(1, 'Tom', 2, 'Mary', 3, 'Mary'));
返回:
key value
1 Tom
2 Mary
3 Mary
例2:
行转列
select recommendid,collect_list(status) status from ods.ods_aen_erp_comments where recommendid =686871 group by recommendid
注意,status这时是一个Array
列转行
这里使用explode函数看下效果:
select explode(status) from (
select recommendid,collect_list(status) status from os.os_aen_erp_comments where recommendid =686871 group by