search

memiiso / debezium-server-iceberg

Replicates any database (CDC events) to Apache Iceberg (To Cloud Storage)
Apache License 2.0
200 stars 36 forks source link

debezium changing schema's datatype from float or int to struct #397

Open ASLDnT opened 3 months ago

ASLDnT commented 3 months ago

Hi Debezium Iceberg Team,

We are currently encountering an issue with our setup. After resolving the previous problem, we now face a new error where Debezium changes the schema's datatype from float or int to struct.

To help you understand the situation better, we will share the schemas, logs, application properties, and screenshots of the table outputs. Your guidance on this matter would be greatly appreciated. Thank you, DnT

app_pro.txt schemaanddata.txt image image image image image image

ASLDnT commented 3 months ago

Hi Debezium Iceberg Team, After examining our database, we have identified an issue where columns designated as foreign keys for other tables are returning Base64 encoded values. This behavior is causing unexpected data representation in our system.

Could you please provide guidance on how to resolve this issue so that the foreign key columns display the correct values instead of Base64 encoded data? Thank you, DnT