concat_ws，concat_list, concat_set,sort_array

select sort_array(collect_list(job)) from wlby_test

select concat_ws('+',collect_list(job)) from wlby_test

select concat_ws('+',sort_array(collect_list(job))) from wlby_test

select *,concat_ws(",",sort_array(collect_set(b) over(distribute by a))) c from a;