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.
3,091 questions
Synapse Analytics Tutorial error - HdfsBridge::recordReaderFillBuffer - Unexpected error encountered filling record reader buffer: ClassCastException: class java.lang.Long cannot be cast to class java.lang.Integer (java.lang.Long and java.lang.Integer are
Ricard Valero
0
Reputation points
At stage 5 in the Get started tutorial for Azure Synapse Analytics (link = https://learn.microsoft.com/en-us/azure/synapse-analytics/get-started-analyze-sql-pool), an error occurs when attempting to Load the NYC Taxi Data into SQLPOOL1. See below.
After pasting the code and running on Synapse, the error message is the following:
HdfsBridge::recordReaderFillBuffer - Unexpected error encountered filling record reader buffer: ClassCastException: class java.lang.Long cannot be cast to class java.lang.Integer (java.lang.Long and java.lang.Integer are in module java.base of loader 'bootstrap')
Unsure what to do since neither the parquet file can be edited, and I simply just copied the SQL code above.
{count} votes
-
BhargavaGunnam-MSFT 13,241 Reputation points Microsoft Employee
2023-05-26T18:37:43.3333333+00:00 Hello Ricard Valero,
Welcome to the MS Q&A platform.
I could run the script from my end without having any issues.
But as per the error message that you are getting, the issue seems to be a data type mismatch between the source data and the target.
ClassCastExceptionerror indicates that the code is trying to cast anIntegerobject to aLongobject, which is not allowed.Can you please change the data type of the dateID column to bigint and see if it helps?
Or please download the parquet file again and see if it helps(it could be an issue with your previous downloaded file)
I hope this helps.
Please let me know if you have any further questions
Sign in to comment