How to sort by column in descending order in Spark SQL?

by

You can also sort the column by importing the spark sql functions

import org.apache.spark.sql.functions._
df.orderBy(asc("col1"))

Or 

import org.apache.spark.sql.functions._
df.sort(desc("col1"))

importing sqlContext.implicits._

import sqlContext.implicits._
df.orderBy($"col1".desc)

Or 

import sqlContext.implicits._
df.sort($"col1".desc)

More Related Contents:

  1. Spark 2.0 Dataset vs DataFrame
  2. Spark – load CSV file as DataFrame?
  3. How to define partitioning of DataFrame?
  4. Encoder error while trying to map dataframe row to updated row
  5. Spark Scala: How to convert Dataframe[vector] to DataFrame[f1:Double, …, fn: Double)]
  6. How to define schema for custom type in Spark SQL?
  7. How can I change column types in Spark SQL’s DataFrame?
  8. Spark unionAll multiple dataframes
  9. How can I pass extra parameters to UDFs in Spark SQL?
  10. SparkSQL: How to deal with null values in user defined function?
  11. How to split a dataframe into dataframes with same column values?
  12. How to aggregate values into collection after groupBy?
  13. Dropping a nested column from Spark DataFrame
  14. How to read records in JSON format from Kafka using Structured Streaming?
  15. How to define a custom aggregation function to sum a column of Vectors?
  16. Spark DataFrame: does groupBy after orderBy maintain that order?
  17. Better way to convert a string field into timestamp in Spark
  18. Filling gaps in timeseries Spark
  19. Spark UDAF with ArrayType as bufferSchema performance issues
  20. Apache Spark how to append new column from list/array to Spark dataframe
  21. How to use COGROUP for large datasets
  22. What are possible reasons for receiving TimeoutException: Futures timed out after [n seconds] when working with Spark [duplicate]
  23. Why does join fail with “java.util.concurrent.TimeoutException: Futures timed out after [300 seconds]”?
  24. Create new Dataframe with empty/null field values
  25. Provide schema while reading csv file as a dataframe in Scala Spark
  26. Spark: Add column to dataframe conditionally
  27. Apache Spark, add an “CASE WHEN … ELSE …” calculated column to an existing DataFrame
  28. Calculate Cosine Similarity Spark Dataframe
  29. Why is join not possible after show operator?
  30. Difference between two rows in Spark dataframe

Leave a Comment