大道至简

explode() 列转行 SELECT stu_name, ecourse, escore from student_score_2 lateral view posexplode(split(course, ',')) cr as a, ecourse lateral view posexplode(split(score, ',')) sc as b, escore where a=b; 结果 -- 结果为： -- 张三 语文 98 -- 张三 数学

https://blog.youkuaiyun.com/zyq522376829/article/details/47686867