开发者社区> 问答> 正文

canal.instance.filter.regex没生效

已经看过关于正则表达式的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

展开
收起
古拉古拉 2023-05-08 17:01:36 165 0
1 条回答
写回答
取消 提交回答
  • canal.instance.filter.query.dml = false 修改成 canal.instance.filter.query.dml = true 看看是不是你想要的 FAQ里面有这个

    原回答者GitHub用户bookc-man

    2023-05-09 18:36:10
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
低代码开发师(初级)实战教程 立即下载
冬季实战营第三期:MySQL数据库进阶实战 立即下载
阿里巴巴DevOps 最佳实践手册 立即下载