join left semi_spark sql join表链接 left leftjoin leftouter leftsemi leftanti区别

为了测试先初始化student和score这两个dataframe

var score = Seq(

("student1", "001", "quest1",10),

("student1", "001", "quest2",20),

("student1", "002", "quest2",20),

("student2", "001", "quest1",70),

("student2", "001", "quest2",60),

("student2", "002", "quest2",50)

).toDF("student_id", "subject_id", "quest_id","quest_score")

var student=Seq(

("student1","张三"),

("student1","张三"),

("student2","李四")

).toDF("student_id", "student_name")

1.spark sql支持join的类型

val supported = Seq(

"inner",

"outer", "full", "fullouter", "full_outer",<