none
Unexpected error encountered filling record reader buffer RRS feed

  • Question

  • This is my currnent data flow:

    1. Download CSV from remote API (SUCCESS)

    2. Mapping Data Flow (SUCCESS)

       a. Map the Projections of data types from the CSV String to Integer, Date, etc...

       b. Add a new column to the data set for a "Load Date"

       c. Save the updated data set to a Parquet file.

    3. Load the data into a table in SQL Synapse Analytics (FAILURE)

    The error message is below...I've been at this all day and am at a total loss at this point.

        "message": "ErrorCode=FailedDbOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error happened when loading data into SQL Data Warehouse.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=HdfsBridge::recordReaderFillBuffer - Unexpected error encountered filling record reader buffer: ClassCastException: class java.lang.Integer cannot be cast to class parquet.io.api.Binary (java.lang.Integer is in module java.base of loader 'bootstrap'; parquet.io.api.Binary is in unnamed module of loader 'app'),Source=.Net SqlClient Data Provider,SqlErrorNumber=106000,Class=16,ErrorCode=-2146232060,State=1,Errors=[{Class=16,Number=106000,State=1,Message=HdfsBridge::recordReaderFillBuffer - Unexpected error encountered filling record reader buffer: ClassCastException: class java.lang.Integer cannot be cast to class parquet.io.api.Binary (java.lang.Integer is in module java.base of loader 'bootstrap'; parquet.io.api.Binary is in unnamed module of loader 'app'),},],'",

    Friday, February 14, 2020 9:44 PM

All replies