表中数据转表头信息--hql面试

由源表转为结果表

select 
id,
sub['数学'] as math,
sub['语文'] as yuwen 
from 
(
select 
id,
str_to_map(concat_ws(",",collect_set(concat_ws(':', subject, cast(score as string))))) as sub
from
test_1
GROUP BY id
)t