行转列实现:
表信息:
test_rowcol(dt_m,vaild_num, unvaild_num)
场景一:使用concat_ws和collect_set函数
select dt_m, 'vaild_num', concat_ws(',', collect_set(vaild_num)) from test_rowcol group by dt_m
union all
select dt_m, 'unvaild_num', concat_ws(',', collect_set(unvaild_num)) from test_rowcol group by dt_m;
说明:collect_set函数可以返回一个Array类型。
concat_ws函数可以拼接数组,如下:
se