posexplode

备注:explode(x)和posexplode()均为炸裂函数,区别在于explode炸出一个值,posexplode不仅炸出一个值还附带索引号 举例: select split(col1,",")[idx] as col1 ,type as col2 from test t lateral vi ......