spark sql ----- sql on spark

2018-06-16  本文已影响0人  章鱼哥呀

待补充# Spark2 Dataset之collect_set与collect_list

collect_set去除重复元素;collect_list不去除重复元素
select gender,
concat_ws(',', collect_set(children)),
concat_ws(',', collect_list(children))
from Affairs
group by gender

|

上一篇下一篇

猜你喜欢

热点阅读