表结构:operation_name, network_type, shell_time, shell_time2, load_time
需求:将shell_time, shell_time2, load_time三个字段转为两个字段:type, time,type为字段名称,time为字段的值
样例数据:
operation_name network_type type time
移动 4G 49 19 2111
电信 NONETWORK 100 36 3175
实现代码:
select operation_name, network_type, type, time
from temp.temp_page_detail_load_time
lateral view explode(map('shell_time', shell_time, 'shell_time2', shell_time2, 'load_time', load_time)) t as type, time
limit 2;
reslut:
移动 4G shell_time 49
移动 4G shell_time2 19