开发者社区> 问答> 正文

从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

展开
收起
古拉古拉 2023-05-08 16:44:17 105 0
1 条回答
写回答
取消 提交回答
  • 从这里来看, 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
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
Java Spring Boot开发实战系列课程【第16讲】:Spring Boot 2.0 实战Apache Kafka百万级高并发消息中间件与原理解析 立即下载
MaxCompute技术公开课第四季 之 如何将Kafka数据同步至MaxCompute 立即下载
消息队列kafka介绍 立即下载