scala中使用多列的Spark数据帧排序

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

// 创建SparkSession
val spark = SparkSession.builder()
  .appName("DataFrame Sorting")
  .getOrCreate()

// 创建示例数据
val data = Seq(
  ("Alice", 25, "New York"),
  ("Bob", 30, "San Francisco"),
  ("Charlie", 20, "Los Angeles")
)

// 创建数据帧
val df = spark.createDataFrame(data).toDF("Name", "Age", "City")

// 按照多列排序
val sortedDF = df.orderBy(col("Age").asc, col("City").desc)

// 显示排序结果
sortedDF.show()