select
id,
name
from
(select 1 as id,'1,2,3,4' as name) a
LATERAL VIEW explode(split(name,',')) temp as name
Hive-sql切割字符串法(列转行)
于 2022-08-25 17:33:10 首次发布
select
id,
name
from
(select 1 as id,'1,2,3,4' as name) a
LATERAL VIEW explode(split(name,',')) temp as name