你可以做一个左连接，然后旋转 parent_pages :

val pathDF = Seq(
  (Array("page1", "page2", "page3")),
  (Array("page1", "page2", "page4"))
).toDF("path")

val pathParentDF = Seq(
  ("page1", "parent_1"),
  ("page2", "parent_2"),
  ("page3", "parent_3"),
  ("page4", "parent_4")
).toDF("page", "parent_page")

val result = pathDF
  .join(pathParentDF, array_contains(col("path"), col("page")), "left")
  .groupBy("path")
  .pivot("parent_page")
  .agg(first(lit(1)))

result.show(false)

//+---------------------+--------+--------+--------+--------+
//|path                 |parent_1|parent_2|parent_3|parent_4|
//+---------------------+--------+--------+--------+--------+
//|[page1, page2, page3]|1       |1       |1       |null    |
//|[page1, page2, page4]|1       |1       |null    |1       |
//+---------------------+--------+--------+--------+--------+