mapping设置如下: `"mappings": { "_doc": { "properties": {
"cardid": {
"type": "keyword"
},
"machid": {
"type": "keyword"
},
"machcode": {
"type": "keyword"
},
"machtypeid": {
"type": "keyword"
},
"schid": {
"type": "keyword"
},
"userid": {
"type": "keyword"
},
"usertype": {
"type": "keyword"
},
"phycno": {
"type": "keyword"
},
"py_phycno": {
"type": "keyword"
},
"phycno1": {
"type": "keyword"
},
"machname": {
"type": "keyword"
},
"cardtime_date": {
"type": "date"
},
"direction": {
"type": "keyword"
},
"remark": {
"type": "keyword"
},
"recdtime_date": {
"type": "date"
},
"name": {
"type": "keyword"
},
"sex": {
"type": "keyword"
},
"code": {
"type": "keyword"
},
"orgid": {
"type": "keyword"
},
"orgname": {
"type": "keyword"
},
"parentorgid": {
"type": "keyword"
},
"areaid": {
"type": "keyword"
},
"areaname": {
"type": "keyword"
},
"areatype": {
"type": "keyword"
},
"imgid": {
"type": "keyword"
},
"imgur": {
"type": "keyword"
},
"isstay": {
"type": "keyword"
},
"blockname": {
"type": "keyword"
},
"dormname": {
"type": "keyword"
},
"phycnotype": {
"type": "keyword"
}
}
}
}`
同步过来数据cardtime_date字段由08点变成了09点,es版本6.3.2,canal版本1.1.4,还请各位大神帮忙看看: { "took": 1, "timed_out": false, "_shards": { "total": 1, "successful": 1, "skipped": 0, "failed": 0 }, "hits": { "total": 4, "max_score": 11.456225, "hits": [ { "_index": "uther_index_atndetail", "_type": "_doc", "_id": "1285445876", "_score": 11.456225, "_source": { "cardid": "21423269", "machid": "16185", "machcode": "61", "machtypeid": "10002", "schid": "4414019", "userid": "10438384", "usertype": "st", "imgurl": null, "isstay": "zs", "blockname": "14栋", "dormname": "603", "phycno": "3760656717", "cardtime_date": "2019-10-21T09:12:41-05:00", "direction": "ex", "remark": null, "recdtime_date": "2019-10-21T09:12:42-05:00", "name": "凌佳艳", "sex": "男", "code": "191500058855", "blockid": 16028070, "dormid": 16033394, "orgid": "16006099", "orgname": "高三(10)班", "parentorgid": "16006044", "areaname": "学校大门(左)", "areatype": "public", "areaid": "16005625", "imgid": "0", "machname": "校门远距离考勤01", "py_phycno": "1292969952", "phycno1": "3760656717", "phycnotype": "at" } }, { "_index": "uther_index_atndetail", "_type": "_doc", "_id": "1285445902", "_score": 11.456225, "_source": { "cardid": "21423269", "machid": "16186", "machcode": "62", "machtypeid": "10002", "schid": "4414019", "userid": "10438384", "usertype": "st", "imgurl": null, "isstay": "zs", "blockname": "14栋", "dormname": "603", "phycno": "3760656717", "cardtime_date": "2019-10-21T09:12:43-05:00", "direction": "ex", "remark": null, "recdtime_date": "20
原提问者GitHub用户mgqonline
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。
你这个时区不对,adapter默认会取操作系统的时区,你看一下你操作系统的时区是否不是东八区
原回答者GitHub用户rewerma