Sorting rows in descending order in Spark SQL

Question

df.orderBy("col") & df.sort("col") sorts the rows in ascending order. Can anyone tell me how to use native dataframe in spark to sort the rows in descending order?

Answer 1

Import org.apache.spark.sql.DataFrame library. You can sort in descending order by the following command:

df.sort($"col".desc)

Answer 2

df.orderBy(org.apache.spark.sql.functions.col("columnname").desc)

Answer 3

df.orderBy($"col".desc) - this works as well

Comments

Hi, @Sai,

Thanks for your contribution.

Cheers.