What is the reason for the inability of Pyspark to overwrite a CSV file stored in S3?

edit

The inability of Pyspark to overwrite a CSV file stored in S3 is mainly due to the nature of S3 storage. S3 is object storage and does not allow in-place updates, which means files cannot be overwritten or modified once they are stored in the bucket. Instead, the existing object must be deleted and replaced with a new version. Pyspark cannot directly overwrite a CSV file stored in S3 but can replace it by deleting the old file and writing the new one with the same name.