"op_type":"U","op_ts":"2019-04-30 07:04:36.844662","current_ts":"2019-04-30T15:07:36.778001","pos":"00000016630241124960","before"


发现op_ts 和current_ts相差了8个小时。

关于这两个时间描述:

OP_TS and CURRENT_TS are not same.


OP_TS : The operation timestamp is the timestamp of the operation from the source trail file. 

Since this timestamp is from the source trail it is "fixed". 

Replaying the trail file will result in the same timestamp for the same operation.


CURRENT_TS : The current timestamp is a timestamp of the current time when formatter processes the current operation

 record. This timestamp follows the ISO-8601 format and includes microsecond precision. 

Replaying the trail file "will not" result in the same timestamp for the same operation.


这是由属性文件里的goldengate.userexit.timestamp=utc 参数引起。



来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29863023/viewspace-2643037/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/29863023/viewspace-2643037/

Logo

Kafka开源项目指南提供详尽教程,助开发者掌握其架构、配置和使用,实现高效数据流管理和实时处理。它高性能、可扩展,适合日志收集和实时数据处理,通过持久化保障数据安全,是企业大数据生态系统的核心。

更多推荐