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
|