Hive Window Functions for Data Transformation
Row to Column Conversion
Problem Analysis
Given the following employee data:
1,PK,RD,1
2,XIAOAI,RD,1
3,XIAOHONG,RD,2
4,XIAOZHANG,QA,1
5,XIAOLI,QA,2
6,XIAOFANG,QA,2
Group by department and gender to get:
QA,1 XIAOZHANG
QA,2 XIAOLI|XIAOFANG
RD,1 PK|XIAOAI
RD,2 XIAOHONG
Required Functions
concat: String concatenation
concat_ws: Stri ...
Posted on Wed, 02 Sep 2026 16:10:10 +0000 by thefury