https://community.cloudera.com/t5/Support-Questions/Spark-write-ordered-Dataframe-to-CSV/m-p/280086#M208667 <P>I'm trying to write an <STRONG>ordered</STRONG> Dataframe/Dataset into <STRONG>multiples</STRONG> CSV Files, and <STRONG>preserve both global and local sort</STRONG>.</P><P>&nbsp;</P><P>I have the following code :</P><LI-CODE lang="java">df .orderBy("date") .coalesce(100) .write .csv(...)</LI-CODE><P>&nbsp;</P><P>Does this code guarantee that :</P><P>- I will have <STRONG>100 output files</STRONG></P><P>- Each single CSV file is <STRONG>locally sorted</STRONG>, I mean by the "date" column ascending<BR />- <STRONG>Files are globally sorted</STRONG>, I mean CSV part-0000 have "date" inferior to CSV part-0001, CSV part-0001 have "date" inferior to CSV part-0002 and so on ..</P><P>&nbsp;</P><P>Thanks</P> Mon, 14 Oct 2019 09:25:34 GMT Plop564 2019-10-14T09:25:34Z