Refreshing column metadata

I have a column in my parquet dataset which Dremio considers as mix_type, which prevents me from using this column in reflections.

I have cleaned the parquet files when the column was of wrong type (binary instead of string),
I have refreshed the source metadata using
ALTER PDS ‘mysource’ REFRESH METADATA DELETE WHEN MISSING

but still the column is seen by Dremio as mixed type.

Is there anything else to try , I want to avoid using FORGET METADATA on this dataset.

Thanks

Refreshing metadata is additive so it will not convert a mixed type to a base type. You could potentially change the column name in the parquet file and run a REFRESH if you want to avoid a FORGET.

that’s a very bad new.

Does the FORGET METADATA remove all the reflections configurations ?

Correct, you will lose the reflections and their definitions when doing a forget metadata.