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

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
2,618 questions
{count} votes