Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

mysql8同步到es7.9.3版本date字段缺失"format"属性配置 #114

Closed
liufu1986007 opened this issue Apr 18, 2022 · 2 comments
Closed

mysql8同步到es7.9.3版本date字段缺失"format"属性配置 #114

liufu1986007 opened this issue Apr 18, 2022 · 2 comments
Labels
bug Something isn't working

Comments

@liufu1986007
Copy link

liufu1986007 commented Apr 18, 2022 •
edited
Loading

mysql8同步到es7.9.3版本date字段创建索引问题，"type":"date",缺失"format": "yyyy-MM-dd HH:mm:ss" 属性，
注意不同时间格式指定的"yyyy-MM-dd HH:mm:ss"不一样，必须要跟数据的格式保持一致。
否则会出现如下报错信息
image
@baisui1981
Copy link
Member

baisui1981 commented Apr 18, 2022 •
edited
Loading

例如：
8D846365-29E1-4302-8301-A968754F3E42

"format": "yyyy-MM-dd HH:mm:ss||yyyy-MM-dd||strict_date_optional_time||epoch_millis"
·

配上这个就全量和增量都好使了，就是存储的数据格式不一致了

@liufu1986007
Copy link
Author

应该是全量查询到的数据格式，跟增量查询到的数据格式不一致，这个也是个问题啊
image

@baisui1981 baisui1981 added bug Something isn't working 3.6.0 labels Apr 20, 2022
@baisui1981 baisui1981 closed this as not planned Won't fix, can't repro, duplicate, stale Nov 1, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@liufu1986007 @baisui1981