sql(presto语句）：一行转多行和多行转一行

一行转多行

table1:

name	cat
Mary	a,b
Cindy	a,f
Zary	c,g

select name,split_cat
FROM table1
CROSS JOIN UNNEST(SPLIT(cat,',')) AS t (split_cat)

结果如下：
table2:

name	split_cat
Mary	a
Mary	b
Cindy	a
Cindy	f
Zary	c
Zary	g

多行转一行

select name,array_join(array_agg(split_cat),',') as cat from table2
group by name