https://community.cloudera.com/t5/Support-Questions/Unable-to-Create-a-single-file-with-PySpark-query/m-p/213876#M175800 <P>Hello Community,</P><P>I trying to create a single file from an output query that is overwritten each time query is run. However, I keep on getting multiple part-00001 files. I have tried the following codes. They appear to overwrite the file, but a different filename is generate each time.</P><PRE>example1.coalesce(1).write.option("header","true").mode("overwrite").csv("adl://carlslake.azuredatalakestore.net/jfolder2/outputfiles/myoutput4/newresults") </PRE><PRE>example1.coalesce(1).write.option("header","true").mode("overwrite").csv("adl://carlslake.azuredatalakestore.net/jfolder2/outputfiles/myoutput4/newresults/theresults.csv") carl = example1.show() </PRE><PRE>example1.coalesce(1).write.mode("append").json("adl://carlslake.azuredatalakestore.net/jfolder2/outputfiles/myoutput/myresults.json")</PRE><PRE>example1.repartition(1).write.format("csv").mode("overwrite").save("adl://carlslake.azuredatalakestore.net/jfolder2/outputfiles/myoutput/thefile.csv")</PRE><P>Can someone show me how write code that will result in a single file that is overwritten without changing the filename?</P> Sat, 20 Oct 2018 21:46:53 GMT barlow 2018-10-20T21:46:53Z