为了测试先初始化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",<