hive多行变一行,不要数组,只要字符串 select concat('\'',concat_ws('\',\'', collect_set(werks))) werks from ods_ztsd039_full where dt = '2023-11-30' and is_deleted = 0 and mandt = '400' and zplant_flag = '01' order by werks