Change data format in an existing DB table

Pien
New Contributor II

I got errors of incompatible filetypes while converting to pyspark df, so I changed all columns to string types. Now I'm trying to add this df to an existing table (where not everything was a string type). And I'm getting an error of incompatible datatypes:error 

How can I change the existing table to string type? It is a sql database table and the data is in the dbfs.