Re: sort descending with multiple columns

2016-11-21 Thread Sreekanth Jella
Yes, thank you. Thanks, Sreekanth, +1 (571) 376-0714 On Nov 18, 2016 6:33 AM, "Stuart White" wrote: > Is this what you're looking for? > > val df = Seq( > (1, "A"), > (1, "B"), > (1, "C"), > (2, "D"), > (3, "E") > ).toDF("foo", "bar") > > val colList =

Re: sort descending with multiple columns

2016-11-18 Thread Rabin Banerjee
++Stuart val colList = df.columns can be used On Fri, Nov 18, 2016 at 8:03 PM, Stuart White wrote: > Is this what you're looking for? > > val df = Seq( > (1, "A"), > (1, "B"), > (1, "C"), > (2, "D"), > (3, "E") > ).toDF("foo", "bar") > > val colList =

Re: sort descending with multiple columns

2016-11-18 Thread Stuart White
Is this what you're looking for? val df = Seq( (1, "A"), (1, "B"), (1, "C"), (2, "D"), (3, "E") ).toDF("foo", "bar") val colList = Seq("foo", "bar") df.sort(colList.map(col(_).desc): _*).show +---+---+ |foo|bar| +---+---+ | 3| E| | 2| D| | 1| C| | 1| B| | 1| A| +---+---+ On

sort descending with multiple columns

2016-11-17 Thread Sreekanth Jella
Hi, I'm trying to sort multiple columns and column names are dynamic. df.sort(colList.head, colList.tail: _*) But I'm not sure how to sort in descending order for all columns, I tried this but it's for only first column.. df.sort(df.col(colList.head).desc) How can I pass all column names (or