Error when writing dataframe to s3 location using PySpark

Constantine
Contributor III

I get an error when writing dataframe to s3 location

Found invalid character(s) among " ,;{}()\n\t=" in the column names of your

I have gone through all the columns and none of them have any special characters. Any idea how to fix this?

Emilie
New Contributor II

I got this error when I was running a query given to me, and the author didn't have aliases on aggregates. Something like:

sum(dollars_spent)

needed an alias:

sum(dollars_spent) as sum_dollars_spent

Hi @John Constantine​,

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.