HIVE行转列和列转行

行转列

select dt_month,valid_num,unvalid_num from test.test_xw_rowtocol

数据如下

转换要求：行转列需保留列名，如下图

方式一：采用union all的形式

select  
  dt_month
 ,'valid_num'      as type
​ ,sum(valid_num)   as num 
​from  temp.temp_xw_rowtocol
​group by dt_month​
 union all
select  
  dt_month
 ,'unvalid_num'