hive sql

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;