hive sql纵表横表互相转换

枞表转横表

select 
        product_id
        ,max(case when field='test1' then 1 else 0 end) as test1
        ,max(case when field='test2' then 1 else 0 end) as test2
        ,max(case when field='test2' then 1 else 0 end) as test2
from 
    test_table_name
group by id

横表转枞表

主要是explode、split、concat_ws等方法组合使用
https://www.cnblogs.com/foolangirl/p/14145147.html