I am trying to read in files via the COPY INTO command but I am getting this error lately for a certain subset of the data;
`Error while reading file: Schema conversion error: cannot convert Parquet type INT64 to Photon type double`
These are my options; I have tried with a mixture of mergeSchema and overwriteSchema
What might I do to make this more reliable?
FILEFORMAT = PARQUET
FORMAT_OPTIONS ('overwriteSchema' = 'true')
COPY_OPTIONS ('overwriteSchema' = 'true', 'overwrite' = 'true')