Debezium的ExtractNewRecordState转换无法正常工作

用户名

我正在构建一个数据同步器,它捕获MySQL Source中的数据更改,并将数据导出到配置单元。

我选择使用Kafka Connect来实现这一点。我使用Debezium作为源连接器,并使用汇合的hdfs作为接收器连接器。

Debezium提供了单个消息转换,让我after从复杂事件消息中提取字段。我所做的配置与列出的文档相同,但是没有用。

{
    // omit ...
    "transform": "unwrap",
    "transform.unwrap.type": "io.debezium.transforms.ExtractNewRecordState"
}

我尝试在源连接器端和接收器连接器端都配置转换,但仍然无法正常工作。事实上,当我在源连接器侧进行配置,然后检查对应主题中的消息,我发现消息仍然包含包括所有字段beforesource等等。

ythh@openstack2:~/confluent-5.5.0$ bin/kafka-avro-console-consumer --from-beginning --bootstrap-server localhost:9092 --topic dbserver1.test_data_1.student3
{"before":null,"after":{"dbserver1.test_data_1.student3.Value":{"id":1,"name":"ggg"}},"source":{"version":"1.1.1.Final","connector":"mysql","name":"dbserver1","ts_ms":1589005572000,"snapshot":{"string":"false"},"db":"test_data_1","table":{"string":"student3"},"server_id":1,"gtid":null,"file":"mysql-bin.000011","pos":9474,"row":0,"thread":{"long":6013},"query":null},"op":"c","ts_ms":{"long":1589005572172},"transaction":null}
{"before":null,"after":{"dbserver1.test_data_1.student3.Value":{"id":2,"name":"no way"}},"source":{"version":"1.1.1.Final","connector":"mysql","name":"dbserver1","ts_ms":1589005893000,"snapshot":{"string":"false"},"db":"test_data_1","table":{"string":"student3"},"server_id":1,"gtid":null,"file":"mysql-bin.000011","pos":11218,"row":0,"thread":{"long":6030},"query":null},"op":"c","ts_ms":{"long":1589005893773},"transaction":null}
{"before":null,"after":{"dbserver1.test_data_1.student3.Value":{"id":3,"name":"not work"}},"source":{"version":"1.1.1.Final","connector":"mysql","name":"dbserver1","ts_ms":1589005900000,"snapshot":{"string":"false"},"db":"test_data_1","table":{"string":"student3"},"server_id":1,"gtid":null,"file":"mysql-bin.000011","pos":11501,"row":0,"thread":{"long":6030},"query":null},"op":"c","ts_ms":{"long":1589005900724},"transaction":null}

我还检查了kafka连接日志,这是一些输出:

ythh@openstack2:~/kafka_2.12-2.5.0/logs$ cat connect.log | grep transform
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
[2020-05-09 14:29:30,470] INFO    transform.unwrap.type = io.debezium.transforms.ExtractNewRecordState (io.debezium.connector.common.BaseSourceTask:97)
[2020-05-09 14:29:30,470] INFO    transform = unwrap (io.debezium.connector.common.BaseSourceTask:97)
[2020-05-09 14:29:30,471] INFO    transform.unwrap.drop.tombstones = false (io.debezium.connector.common.BaseSourceTask:97)
[2020-05-09 14:29:30,471] INFO    transform.unwrap.delete.handling.mode = rewrite (io.debezium.connector.common.BaseSourceTask:97)
        transforms = []
        transforms = []
[2020-05-09 14:29:32,419] INFO    transform.unwrap.type = io.debezium.transforms.ExtractNewRecordState (io.debezium.connector.common.BaseSourceTask:97)
[2020-05-09 14:29:32,419] INFO    transform = unwrap (io.debezium.connector.common.BaseSourceTask:97)
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
        transforms = []
伊斯库斯科夫·亚历山大(Iskuskov Alexander)

您好像输入了错字(transform而不是transforms)。试试这个配置:

{
    // omit ...
    "transforms": "unwrap",
    "transforms.unwrap.type": "io.debezium.transforms.ExtractNewRecordState"
}

本文收集自互联网,转载请注明来源。

如有侵权,请联系[email protected] 删除。

编辑于
0

我来说两句

0条评论
登录后参与评论

相关文章

来自分类Dev

转换转换无法正常工作

来自分类Dev

转换功能无法正常工作

来自分类Dev

日期转换无法正常工作

来自分类Dev

按钮转换无法正常工作

来自分类Dev

温度转换在JFrame中无法正常工作

来自分类Dev

WPF转换器无法正常工作

来自分类Dev

在IE中进行转换无法正常工作

来自分类Dev

jQuery转换为单词无法正常工作

来自分类Dev

灰烬原始JSON转换无法正常工作?

来自分类Dev

边界到顶部的转换无法正常工作

来自分类Dev

为什么这种转换无法正常工作?

来自分类Dev

距离转换-该功能无法正常工作

来自分类Dev

Libreoffice转换为无法正常工作

来自分类Dev

我的转换JSF无法正常工作

来自分类Dev

jQuery转换后的代码无法正常工作

来自分类Dev

Excel日期/时间转换无法正常工作

来自分类Dev

转换数据框的功能无法正常工作

来自分类Dev

在IE中进行转换无法正常工作

来自分类Dev

KG到磅的转换无法正常工作

来自分类Dev

Recycler Item 材料转换无法正常工作

来自分类Dev

为什么在Safari上转换转换无法正常工作?

来自分类Dev

为什么类型转换在Swift 2.0中无法正常工作?

来自分类Dev

Chrome无法响应CSS动画/转换,但Firefox可以正常工作

来自分类Dev

UITapGesture在转换后的UIView上无法正常工作

来自分类Dev

共享元素转换和壁画无法正常工作

来自分类Dev

无法使Cordova文本语音转换插件正常工作

来自分类Dev

转换os.path到pathlib模块无法正常工作

来自分类Dev

在C#中将int转换为char无法正常工作

来自分类Dev

将float转换为int在C中无法正常工作