topic Error when writing dataframe to s3 location using PySpark in Data Engineering https://community.databricks.com/t5/data-engineering/error-when-writing-dataframe-to-s3-location-using-pyspark/m-p/18813#M12540 <P>I get an error when writing dataframe to s3 location </P><PRE><CODE>Found invalid character(s) among " ,;{}()\n\t=" in the column names of your</CODE></PRE><P>I have gone through all the columns and none of them have any special characters. Any idea how to fix this? </P> Thu, 02 Jun 2022 22:18:34 GMT Constantine 2022-06-02T22:18:34Z Error when writing dataframe to s3 location using PySpark https://community.databricks.com/t5/data-engineering/error-when-writing-dataframe-to-s3-location-using-pyspark/m-p/18813#M12540 <P>I get an error when writing dataframe to s3 location </P><PRE><CODE>Found invalid character(s) among " ,;{}()\n\t=" in the column names of your</CODE></PRE><P>I have gone through all the columns and none of them have any special characters. Any idea how to fix this? </P> Thu, 02 Jun 2022 22:18:34 GMT https://community.databricks.com/t5/data-engineering/error-when-writing-dataframe-to-s3-location-using-pyspark/m-p/18813#M12540 Constantine 2022-06-02T22:18:34Z Re: Error when writing dataframe to s3 location using PySpark https://community.databricks.com/t5/data-engineering/error-when-writing-dataframe-to-s3-location-using-pyspark/m-p/18815#M12542 <P>I got this error when I was running a query given to me, and the author didn't have aliases on aggregates. Something like:</P><PRE><CODE>sum(dollars_spent)</CODE></PRE><P>needed an alias:</P><PRE><CODE>sum(dollars_spent) as sum_dollars_spent</CODE></PRE><P></P> Wed, 08 Jun 2022 01:23:28 GMT https://community.databricks.com/t5/data-engineering/error-when-writing-dataframe-to-s3-location-using-pyspark/m-p/18815#M12542 Emilie 2022-06-08T01:23:28Z Re: Error when writing dataframe to s3 location using PySpark https://community.databricks.com/t5/data-engineering/error-when-writing-dataframe-to-s3-location-using-pyspark/m-p/18817#M12544 <P>Hi @John Constantine​,</P><P></P><P>Just a friendly follow-up. Do you still need help or you were able to find the solution to this issue? please let us know.</P> Fri, 29 Jul 2022 01:19:11 GMT https://community.databricks.com/t5/data-engineering/error-when-writing-dataframe-to-s3-location-using-pyspark/m-p/18817#M12544 jose_gonzalez 2022-07-29T01:19:11Z