yiminli-sp commented on PR #5804:
URL: https://github.com/apache/paimon/pull/5804#issuecomment-3808861741
@JingsongLi hi, master, may i know the detailed reason for removing the
default value from reader side? When synchronizing MySQL data using
Paimon(achieved by one-time full dump and synchronizing incremental data
through CDC), we may occasionally encounter some issue related to default
value: After the Paimon table has fully synchronized the data MySQL table, if a
new column with a default value is added to MySQL, reading the existing data of
Paimon table will yield different results compared to MySQL (the new column's
value in Paimon is null, whereas MySQL returns the default value). Currently we
fix this kind of issue by using "ALTER TABLE XXX SET
TBLPROPERTIES('fields.xxx.default-value' = 'xxx')" DDL to enable the Paimon
reader to replace the null value with default value. Otherwise, we could have
to redo the full dump, which would take a long time and consume lots of
resources
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
