Getting type error while reading data from PostgreSQL using dynamic schema

[SumitYadav]

Hi,

I am querying data from PostgreSQL and using dynamic schema to store the data in parquet file, However when i try to store in file i get the below error:

error

: type = FIXED_LEN_BYTE_ARRAY, name = param_value_num, original type = DECIMAL.

Can anyone help me solve this issue

[Anonymous]

Hello @Sumit Yadav​ ,

It's a known issue (TDI-48104) which is fixed in 8.0.1-R2022-07 studio

Please contact with talend support to get the patch 8.0.1-R2022-07 or later version to fix the issue

Best regards

Aiming

[SumitYadav]

hi @Aiming Chen​ 

Thanks for the reply.

I am running my job on Talend cloud. So don't know if Studio Version is required here

Regards,

Sumit