hive将一行记录拆分成多行

见：https://blog.csdn.net/yeweiouyang/article/details/46352845

一、业务背景

username	product
john	a,b,c,d
tom	e,f

 

 

 

 

二、实现方式

借助 lateral view和explode()来完成

select 
    username,
    browse_product
from pms.test_user_browse
lateral view explode(split(product,",")) mytable as browse_product;