这周么搞个了 Canal Adapter 同步 es。有个问题关于字段 key 大小写的问题基于什么考量,还是我还有没看到的地方

查看 4|回复 0
作者:cobbage   
DML: {"data":[{"ID":"01238f0d262106456d3a864247117b48","LOGIN_NAME":"ttt","USERNAME":"tt"}],"database":"zzcm","destination":"example","es":1731220850000,"groupId":"g1","isDdl":false,"old":[{"LOGIN_NAME":"tttt"}],"pkNames":["ID"],"sql":"","table":"sys_user","ts":1731220854645,"type":"UPDATE"}
DML: {"data":[{"ID":"01238f0d262106456d3a864247117b46","LOGIN_NAME":"tttt","USERNAME":"tt"}],"database":"zzcm","destination":"example","es":1731221326000,"groupId":"g1","isDdl":false,"old":null,"pkNames":["ID"],"sql":"","table":"sys_user","ts":1731221327113,"type":"DELETE"}
DML: {"data":[{"ID":"01238f0d262106456d3a864247117b99","LOGIN_NAME":"tttt","USERNAME":"tt"}],"database":"zzcm","destination":"example","es":1731221336000,"groupId":"g1","isDdl":false,"old":null,"pkNames":["ID"],"sql":"","table":"sys_user","ts":1731221336823,"type":"INSERT"}
DML 里面字段 key 大写;表名小写;
需要和配置 sql 大小写吻合才行(这个稍不注意有些数据就不合适和匹配不上了 还不报错!!!)。
还有指定的 id/pk 也是大小写吻合。
您需要登录后才可以回帖 登录 | 立即注册

返回顶部