从kafka读出来的数据 ，里面的es字段和ts字段分别是什么意思
从kafka读出来的数据 ，里面的es字段和ts字段分别是什么意思{"data":[{"id":"1006405527991816192","title":"统计1","db_type":"hive", "db_config":"{"user":null,"password":null,"jdbcUrl":null,"driver":"org.apache.hive.jdbc.HiveDriver"}", "enabled_flag":"0","trace_id":null,"created_by":"959312361451229184","creation_date":"2018-06-12 13:21:20", "updated_by":"959312361451229184","updation_date":"2018-06-12 13:21:20"}],"database":"bigdata","es":1545905797000, "id":1033,"isDdl":false,"mysqlType":{"id":"bigint(20)","title":"varchar(30)","db_type":"varchar(30)", "db_config":"varchar(500)","enabled_flag":"int(11)","trace_id":"varchar(32)","created_by":"varchar(64)", "creation_date":"timestamp","updated_by":"varchar(64)","updation_date":"timestamp"},"old":[{"title":"统计"}], "sql":"","sqlType":{"id":-5,"title":12,"db_type":12,"db_config":12,"enabled_flag":4,"trace_id":12,"created_by":12, "creation_date":93,"updated_by":12,"updation_date":93},"table":"report_db","ts":1545905796190,"type":"UPDATE"}
原提问者GitHub用户Bruce2jiang
写回答
-
从这里来看， es 是数据库里面的执行时间(event time)， 而 ts 是解析时间(process time)
https://github.com/alibaba/canal/blob/master/server/src/main/java/com/alibaba/otter/canal/common/MQMessageUtils.java#L207
原回答者GitHub用户agapple
2023-05-09 18:14:36赞同 展开评论 打赏
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
