先把句子拆成单个单词，再行专列，再利用子查询做聚合。
select word, count(1) as cnts from
(select explode(split(sentence, ",")) as word from table) t
group by word
order by cnts desc;
04-24
1562
1562
评论
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
查看更多评论
添加红包
