How can I convert a column that has numeric values loaded as strings to be an int data type? I know how to cast the results as int's, but is there a way to convert the column type and the data in the column? How about just creating a new column with data from another one?
Is there any performance to be gained by not using cast's?
Edit: the data is stored as a parquetfile