Yanquan Lv created FLINK-36913:
----------------------------------

             Summary: Add an option in Kafka Sink to manual map table to topic 
name.
                 Key: FLINK-36913
                 URL: https://issues.apache.org/jira/browse/FLINK-36913
             Project: Flink
          Issue Type: New Feature
          Components: Flink CDC
    Affects Versions: cdc-3.3.0
            Reporter: Yanquan Lv
             Fix For: cdc-3.3.0


For many users who used Kafka as DataSink in YAML job, them usually want to 
send changelog to one topic, in current framework, we can use `route` module to 
do that, like what the following YAML file does:
{noformat}
source:
type: mysql
hostname: xxxxxx
port: 3306
username: flink
password: Flinkxxx
tables: flink_source.news_[0-9]

sink:
type: kafka
properties.bootstrap.servers: xxx:9092
value.format: canal-json


route:
- source-table: flink_source.news_[0-9]
sink-table: my_source
{noformat}

However, the out put of Kafka in canal-json format doesn't contain the original 
database/table information, instead, it only contains the database/table 
information after routing. Although this is in line with the functionality of 
route, it does not meet the needs of users.

Therefore, I suggest adding a parameter in the sink to let Kafka determine how 
to handle the mapping from table to topic name, so we can create one topic for 
many source tables, and keep all database/table information of source tables 
when output records.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to