如何在spark scala中编写固定宽度的输出文件

import org.apache.spark.sql.SparkSession
import org.apache.spark.sql.functions._

val spark = SparkSession.builder()
  .appName("Fixed Width Output")
  .master("local[*]") // 根据实际情况设置Master节点
  .getOrCreate()

val data = Seq(("John", 25, "Male"),
               ("Jane", 30, "Female"),
               ("Bob", 35, "Male")).toDF("Name", "Age", "Gender")

val width = 10
val columns = Seq("Name", "Age", "Gender")
val positions = Array(0, width, width * 2)

val output = columns.zip(positions).foldLeft(data) { case (df, (col, pos)) =>
  df.withColumn(col, substring(col(col), pos + 1, width))
}

output.write.text("output.txt")