如何使用Spark/Scala将这种嵌套的多行json文件读入数据帧

import org.apache.spark.sql.{SparkSession, DataFrame}
import org.apache.spark.sql.functions._

val spark = SparkSession.builder()
  .appName("Nested JSON to DataFrame")
  .getOrCreate()

val jsonFile = "path/to/json/file.json"
val jsonDataFrame = spark.read.json(jsonFile)

def flattenDataFrame(df: DataFrame): DataFrame = {
  val fields = df.schema.fields

  fields.foldLeft(df) { (acc, field) =>
    field.dataType match {
      case st: StructType =>
        val fieldNames = st.fieldNames.map(name => col(s"${field.name}.$name").alias(s"${field.name}_$name"))
        acc.select(col("*") +: fieldNames: _*).drop(field.name)
      case _ => acc
    }
  }
}

val flattenedDataFrame = flattenDataFrame(jsonDataFrame)

val filteredDataFrame = flattenedDataFrame.filter(col("column_name") === "value")
val aggregatedDataFrame = flattenedDataFrame.groupBy("column_name").agg(count("*"))