HdfsBridge::recordReaderFillBuffer - Unexpected error encountered filling record reader buffer: HadoopSqlException: -- Arithmetic overflow error converting expression to data type NVARCHAR.

Question

Hi Team,

I am trying to load data from Oracle table which has multiple CLOB columns to synapse dedicated pool table having nvarchar(max) columns and facing this error in Title. The issue happens when I am trying to read external table pointing to parquet file.

Interestingly the load works fine with Bulk Insert/Copy options with Copy activity to a stage table. Is this a known limitation with hadoop external tables. I haven't tried with native external tables as that is not in GA yet.

Answer 1

Hi,

Thanks for reaching out to Microsoft Q&A.

Looks like datatype mapping error. Can you go through the following link once

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/design-elt-data-loading#define-the-tables

Please Upvote and Accept as answer if the reply was helpful, this will be benefitting the other community members who go through the same issue.