select id,name,score, k,v from table_test lateral view posexplode(score) tmp as k,v order by id;
posexplode 函数在 3.0 版本支持的,建议到3.0.6