hive对列按顺序转换为行

--创造数据
create table persona.test_hz 

已有数据

1 1 a

1 2 b
1 3 c
1 4 d
1 5 e
2 5 e
2 4 d
2 3 c
2 2 b
2 1 a
3 1 a
3 2 b
3 3 c
3 4 d
3 5 e
4 5 e
4 4 d
4 3 c
4 2 b

4 1 a

select id,collect_list(value) from 
(
select * from persona.test_hz 
distribute by id sort by label 
) as tmp1 group by id