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.