SQL error when querying parquet table added to Lake database via GUI

Andreas Nord
1
Reputation point
I created a Lake database and added a table via the "+Table / From data lake" option in the GUI, using a parquet file residing in my data lake.
When trying to query the added table I get the following error:
Column 'col' of type 'REAL' is not compatible with external data type 'Parquet physical type: DOUBLE', please try with 'FLOAT'. File/External table name: 'testtable'.
However the column type was correctly inferred as float, at least that is what shows up in the GUI