已经看过关于正则表达式的FAQ了,下面是关于过滤表的配置 canal.instance.filter.regex=bi.small_loan_borrow
在kafka中按理说只有这一个表的更新数据,但是kafka里有所有的表的更新数据。 请大佬帮忙解答一下!!!
还有一个问题,就是kafka里面保存的是:
{"data":null,"database":"","es":1543723390000,"id":1,"isDdl":false,"mysqlType":null,"old":null,"sql":"UPDATE JOB_EXECUTION_LOG SET is_success = 1, complete_time = '2018-12-02 12:03:00.017' WHERE id = 'eb2e855f-f9a3-4bb2-8496-3d5aab3bd91b'","sqlType":null,"table":"JOB_EXECUTION_LOG","ts":1543727446802,"type":"QUERY"} {"data":null,"database":"","es":1543723390000,"id":1,"isDdl":false,"mysqlType":null,"old":null,"sql":"UPDATE JOB_EXECUTION_LOG SET is_success = 1, complete_time = '2018-12-02 12:03:00.027' WHERE id = 'f09dc4d6-5355-4da6-b9c5-c75e72e4f656'","sqlType":null,"table":"JOB_EXECUTION_LOG","ts":1543727446802,"type":"QUERY"} {"data":null,"database":"","es":1543723390000,"id":1,"isDdl":false,"mysqlType":null,"old":null,"sql":"UPDATE JOB_EXECUTION_LOG SET is_success = 1, complete_time = '2018-12-02 12:03:00.022' WHERE id = 'daba8475-1b0d-47a7-9fdf-4903888bd79c'","sqlType":null,"table":"JOB_EXECUTION_LOG","ts":1543727446802,"type":"QUERY"} {"data":null,"database":"","es":1543723390000,"id":1,"isDdl":false,"mysqlType":null,"old":null,"sql":"UPDATE JOB_EXECUTION_LOG SET is_success = 1, complete_time = '2018-12-02 12:03:00.022' WHERE id = '4c77f36c-49b0-4705-befc-909d06cf4297'","sqlType":null,"table":"JOB_EXECUTION_LOG","ts":1543727446802,"type":"QUERY"}
data、sqlType,old字段都是空的,是哪里还需要配置吗?
原提问者GitHub用户jbshen
canal.instance.filter.query.dml = false 修改成 canal.instance.filter.query.dml = true 看看是不是你想要的 FAQ里面有这个
原回答者GitHub用户bookc-man
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。