flink版本为:1.19
cdc任务报错,请问是否是mysql8.x的配置有什么问题?具体报错如下:
    Caused by: java.io.InvalidClassException: org.apache.flink.cdc.connectors.shaded.com.fasterxml.jackson.databind.cfg.MapperConfig; incompatible types for field _mapperFeatures
flinksql如下:
SET 'execution.checkpointing.interval' = '40s';
SET 'execution.checkpointing.max-concurrent-checkpoints'='1';
SET 'execution.checkpointing.externalized-checkpoint-retention' = 'RETAIN_ON_CANCELLATION';
CREATE TABLE IF NOT EXISTS mysql_tag_categories_source(
    id  varchar(80),
    parent_id  varchar(80),
    name varchar(512),
    level INT,
    ranking BIGINT,
    path varchar(512),
    PRIMARY KEY (id) NOT ENFORCED
  ) WITH (
    'connector' = 'mysql-cdc',
    'server-id' = '60200-60300',
    'database-name' = 'sc_stagm',
    'table-name' = 'tag_categories',
    'hostname' = '10.8.1.20',
    'port' = '3317',
    'username' = 's1',
    'password' = '$0&M@2o22',
    'server-time-zone' = 'Asia/Shanghai'
);
CREATE TABLE IF NOT EXISTS doris_tag_categories_sink (
    id  string,
    parent_id  string,
    name string,
    level INT,
    ranking BIGINT,
    path string,
    PRIMARY KEY(id) NOT ENFORCED
)
WITH (
      'connector' = 'doris',
      'table.identifier' = 'sc_scndp.dim_tag_categories',
      'sink.label-prefix' = 'doris_dim_tag_categories_1',
     'fenodes' = '10.8.1.24:8030',
     'username' = 'root',
'password' = '123456',
'sink.properties.format' = 'json',
'sink.properties.read_json_by_line' = 'true',
 'sink.enable-2pc'='true'
);
insert into doris_tag_categories_sink select * FROM mysql_tag_categories_source;
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。
请检查FlinkSQL中的数据类型是否与Doris表中的数据类型匹配,确保数据类型兼容。参考官方文档链接:https://www.aliyun.com/product/doris。如果需要进一步帮助,可以询问一下阿里云的工作人员。如果对您有帮助的话,可以帮忙采纳一下。谢谢。
实时计算Flink版是阿里云提供的全托管Serverless Flink云服务,基于 Apache Flink 构建的企业级、高性能实时大数据处理系统。提供全托管版 Flink 集群和引擎,提高作业开发运维效率。