Hi @Swathi Garudasu ,
Thank you for posting query in Microsoft Q&A Platform.
As per my understanding you created an external table on top of parquet file but while querying that table ending up with the error. Please correct me if I am wrong.
Usually this kind of error will come when data type not mapped properly between parquet file data types and SQL data types. As you mentioned below link gives clear idea about these data type mappings.
Could you please try below steps to see for making sure data types properly matching and see if that helps?
Create Integrated Dataset for your parquet file and navigate to schema tab and take data types of parquet file from there and then try to see corresponding SQL data types from above documentation and define them accordingly in your external table.
Please check below Q&A link in which similar discussion there. In that post also we are trying to take data types of parquet from dataset schema tab and then checking documentation accordingly.
Please let us know how it goes.
Between, you have not shared full error message. Requesting to share error message if possible. Thank you.