"云数据仓库ADB中中有数组转成字符串的函数吗？[阿里云云原生数据仓库]

“云数据仓库ADB中中有数组转成字符串的函数吗？好像concat_ws 用不了。
有类似这种功能吗？
SELECT owner_company_id
,owner_company_name
,concat_ws(‘,’, COLLECT_SET(owner_dept_id)) AS owner_dept_ids
,concat_ws(‘,’,COLLECT_SET(owner_dept_name) ) AS owner_dept_names
,COUNT(*) AS order_num
,SUM(budget / 100 / 10000) AS total_budget
FROM dws_bid_all_order_info_da
WHERE order_type IN (‘招标’,’询比’)
AND status_name != ‘已流标’
AND (
owner_company_id IN (5,27,14)
OR owner_dept_id IN (12,62,10,15,79,7)
)
GROUP BY owner_company_id
,owner_company_name”