Hive 炸裂函数 explode(map) 宽表转高表SQL:
select
slice_id,
user_id,
shop_id,
'user_stats_public...from
( select
user_id,
-1 as shop_id,
abs(hash(user_id) % 20000) as slice_id,
map...C')) tf;
select tf.* from (select 0) t lateral view explode(array('A','B','C')) tf as col;
explode (map...)
select explode(map('A',10,'B',20,'C',30));
select explode(map('A',10,'B',20,'C',30)) as (key,value)...;
select tf.* from (select 0) t lateral view explode(map('A',10,'B',20,'C',30)) tf;
select tf.* from