(1)concat_ws()
select user
,concat_ws(';' , collect_set(cast(amt as string))) as amt
from table
group by user
(2)concat()
select concat('202211','04')
result:20221104