I am trying to read data from a Parquet file on blob in Azure Synapse via an External Table , the file is generated from a SQL DB via ADF (Copy Activity)
The external table has datatype for all columns as varchar
While reading the data via external table , i am getting the below error :
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')
Is there any way , this issue can be resolved.
I also tried updating the destination datatype to string in mapping in ADF (editing the JSON script) & tried to create a file (Refer below screenshot) , was still not able to read the file via an External Table with the same error
Is there any specific reason for this ?
Appreciate your help.