[
https://issues.apache.org/jira/browse/FLINK-34769?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17828699#comment-17828699
]
Flink CDC Issue Import commented on FLINK-34769:
------------------------------------------------
Date: Wed Mar 20 12:31:27 CST 2024, Author:
[tony0021074|https://github.com/tony0021074]
Postgresql connector's changelog mode can be configurated through Flink SQL API
while MySQL connector's cannot.
I hope @yeezychao proposed PR would be reviewed & merged soon. @leonardBang
> [mysql-cdc] Add upsert changelog mode to avoid UPDATE_BEFORE records push down
> ------------------------------------------------------------------------------
>
> Key: FLINK-34769
> URL: https://issues.apache.org/jira/browse/FLINK-34769
> Project: Flink
> Issue Type: Improvement
> Components: Flink CDC
> Reporter: Flink CDC Issue Import
> Priority: Major
> Labels: github-import
>
> **Is your feature request related to a problem? Please describe.**
> I try to use flink sql to write mysql cdc-data into redis as a dimension
> table for other business use. When executing `UPDATE` DML, the cdc-data will
> be converted into `-D (UPDATE_BEFORE)` and `+I (UPDATE_AFTER)` two records
> to sink redis. However, delete first will cause other data streams to be
> lost(NULL) when join data, which is unacceptable.
> **Describe the solution you'd like**
> I think we can add support for [upsert changelog
> mode|https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/concepts/dynamic_tables/#table-to-stream-conversion]
> by adding changelogMode option with mandatory primary key
> configuration.Basically, with `changelogMode=upsert` we will avoid
> `UPDATE_BEFORE` rows and we will require a primary key for the table.
> **Describe alternatives you've considered**
> n/a
> ---------------- Imported from GitHub ----------------
> Url: https://github.com/apache/flink-cdc/issues/1898
> Created by: [yeezychao|https://github.com/yeezychao]
> Labels: enhancement,
> Created at: Tue Feb 07 11:16:04 CST 2023
> State: open
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
