行转列,group_concat
mysql实现:
select A,GROUP_CONCAT(B)
from table
group by A
;
行转列,concat_ws
hive实现转换:
SELECT A,concat_ws(’,’, collect_set(B))
FROM table
GROUP BY B;
行转列,group_concat
mysql实现:
select A,GROUP_CONCAT(B)
from table
group by A
;
行转列,concat_ws
hive实现转换:
SELECT A,concat_ws(’,’, collect_set(B))
FROM table
GROUP BY B;