- ‘*’为表中所有列,‘rank()为窗口,是一个新列,于Mysql的使用一致’
val df = df.selectExpr("*"," rank() over(partition by 字段 order by 字段 desc) as 字段别名" )
//selectExpr之后依旧可以执行一些其他操作
val df = df.selectExpr("*"," rank() over(partition by 字段 order by 字段 desc) as 字段别名" ).where.等等
val df = df.selectExpr("*"," rank() over(partition by 字段 order by 字段 desc) as 字段别名" )
//selectExpr之后依旧可以执行一些其他操作
val df = df.selectExpr("*"," rank() over(partition by 字段 order by 字段 desc) as 字段别名" ).where.等等