topic Re: Getting type error while reading data from PostgreSQL using dynamic schema in Talend Studio

Getting type error while reading data from PostgreSQL using dynamic schema

SumitYadav — Fri, 15 Nov 2024 21:51:34 GMT

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

Re: Getting type error while reading data from PostgreSQL using dynamic schema

Anonymous — Fri, 28 Apr 2023 01:23:23 GMT

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

Re: Getting type error while reading data from PostgreSQL using dynamic schema

SumitYadav — Fri, 28 Apr 2023 08:32:42 GMT

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