weixin_40857858的博客

Elasticsearch时区问题

Elasticsearch时区问题

{ "bool": { "filter": [{ "bool": { "must": [{ "bool": { "must": [{ "term": { "字段A": { "value": "字段A值", "boost": 1.0 } } }, { "range": { "日期字段B": { "from": "1

问题原因：ElasticSearch Date时区问题 解决方案：存储时使用时间戳，查询时也使用时间戳

{ “job”: { “setting”: { “speed”: { “channel”: 32 } }, “content”: [{ “reader”: { “name”: “mysqlreader”, “parameter”: { “username”: “数据库用户名”, “password”: “数据库密码”, “column”:[ “id”, “id”, “列名1”, “列名2”, “列名n” ], “connection”: [{ “table”: [ “表名1”, “表名2”, “表名n” ]

POST 索引名称/_mapping/文档名称 { "文档名称":{ "dynamic":"false", "properties":{ "financeApprovalTime":{ "type":"date", "null_value":"-62167420800000" "format":"yyyy-MM-dd HH:mm:ss" }

PUT 索引名 { "aliases": { "索引别名(可自定义)": {} }, "mappings": { "索引文档名(可自定义)": { "dynamic": "false", "properties": { "字段名称": { "type": "keyword", //字段类型，有keyword,integer,double,text,long等类型