sql-整理
一行拆多行1、使用explode或posexplode方法1.1 对单列实行列转行 explode 配合 lateral view 使用with temp as(select 1 as id ,'a,b,c' as name union select 2 as id ,'d,e,f' as name) select id,name,s_namefrom temp lateral view explode(spli
原创
2021-11-21 21:50:30 ·
484 阅读 ·
0 评论