格式化：select deptno_jobename from select concat_wscastdeptno as stringjob as deptno_jobconcat_ws-collect_listename as ename_list from emp group by concat_wscastdeptno as stringjob x LATERAL VIEW

SELECT deptno_job, ename FROM ( SELECT CONCAT_WS(',', CAST(deptno AS STRING), job) AS deptno_job, CONCAT_WS('-', COLLECT_LIST(ename)) AS ename_list FROM emp GROUP BY CONCAT_WS(',', CAST(deptno AS STRING), job) ) x LATERAL VIEW EXPLODE(SPLIT(ename_list, '-')) t AS ename;