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;