开发者社区> 问答> 正文

Flink启动后同步了全量数据,后面再改动的数据就捕获不到了,谁知道什么原因呢?DROP TABLE

Flink启动后同步了全量数据,后面再改动的数据就捕获不到了,谁知道什么原因呢?DROP TABLE IF EXISTS mysql_cdc; CREATE TABLE mysql_cdc ( order_id INT, order_date TIMESTAMP(0), customer_name STRING, price DECIMAL(10, 5), product_id INT, order_status BOOLEAN, PRIMARY KEY(order_id) NOT ENFORCED ) WITH ( 'connector' = 'mysql-cdc', 'hostname' = '10.243.67.119', 'port' = '3306', 'username' = 'root', 'password' = '123456', 'database-name' = 'flink_web', 'table-name' = 'orders' ); DROP TABLE IF EXISTS kafka_mysql_cdc; CREATE TABLE kafka_mysql_cdc ( order_id INT primary key not enforced, order_date TIMESTAMP(0), customer_name STRING, price DECIMAL(10, 5), product_id INT, order_status BOOLEAN, proctime AS PROCTIME () ) WITH ( 'connector' = 'kafka', 'topic' = 'test_in_1', 'properties.group.id' = 'test_in_consume_1', 'scan.startup.mode' = 'earliest-offset', 'properties.bootstrap.servers' = 'kafkasit02broker01.cxxg.com:9092', 'format' = 'debezium-json' ); INSERT INTO kafka_mysql_cdc SELECT * FROM mysql_cdc;

展开
收起
真的很搞笑 2023-04-19 17:58:02 151 0
1 条回答
写回答
取消 提交回答
  • scan.startup.mode' = 'latest-offset',此回答整理自钉群“Flink CDC 社区”

    2023-04-19 22:47:19
    赞同 展开评论 打赏
来源圈子
更多
收录在圈子:
实时计算 Flink 版(Alibaba Cloud Realtime Compute for Apache Flink,Powered by Ververica)是阿里云基于 Apache Flink 构建的企业级、高性能实时大数据处理系统,由 Apache Flink 创始团队官方出品,拥有全球统一商业化品牌,完全兼容开源 Flink API,提供丰富的企业级增值功能。
相关文档: 实时计算 Flink版
问答排行榜
最热
最新

相关电子书

更多
Flink CDC Meetup PPT - 龚中强 立即下载
Flink CDC Meetup PPT - 王赫 立即下载
Flink CDC Meetup PPT - 覃立辉 立即下载