select
catagories,
concat_ws(",",collect_set(movie)) movies
from
(select
movie,
catagories
from
movie_info m
lateral view
explode(category) tb1 as catagories) t
group by
catagories;
原文：https://www.cnblogs.com/leigepython/p/12384319.html