Problem when creating dataset from parquet files - Column Types

1

I can’t set the id int32 column to integer type.

In Dataset Settings, the column is recognized as integer (#).

However, the Data itself doesn’t recognize the type (A#) and also cannot be converted or splitted - “Unexpected error occurred”.

(All files have the same schema.)

2

@fdeoliveirag What version of Dremio is this? Do all Parquet files have int32 and Dremio promotes as INT (#) or Dremio promotes as mixed type (A#)?

3

Version 12.1.0. Dremio promotes the column as mixed type.

4

@fdeoliveirag Mixed types is deprecated until 18.0 and then removed, there is automatic coercion for file system sources for supported types, what is your source?