Hive行转列函数
concat
select e.empno,e.ename,e.job,concat(e.empno,e.ename,e.job) from emp e;
cancat_ws:concat加强版,但是只能够处理string,所以需要强转
select e.empno,e.ename,e.job,concat_ws('-',case(e.empno as string),e.ename,e.job) from emp e;
collect_list:多行转一列,不去重
select collect_list(deptno) from emp;
collect_set:多行转一列,去重
select collect_set(deptno) from emp;