ES版本
{
"name": "node133-1",
"cluster_name": "cluster_name",
"cluster_uuid": "NHsCrgJ4SReF_i7uz1s9cw",
"version": {
"number": "6.2.1",
"build_hash": "7299dc3",
"build_date": "2018-02-07T19:34:26.990113Z",
"build_snapshot": false,
"lucene_version": "7.2.1",
"minimum_wire_compatibility_version": "5.6.0",
"minimum_index_compatibility_version": "5.0.0"
},
"tagline": "You Know, for Search"
}
需求一
查询数据时间在a-b间,且serviceId=1的数量折线图
{
"size": 0,
"query": {
"bool": {
"must": [
{
"range": {
"startTime": {
"gte": 1630857600000,
"lt": 1630943999000
}
}
},
{
"match": {
"serviceId": "3b5a659a719d6a1353f71a20197f9c78"
}
}
]
}
},
"aggs": {
"agg_by_time": {
"date_histogram": {
"field": "startTime",
"interval": "1m",
"time_zone": "+08:00",
"format": "yyyy-MM-dd HH:mm:ss",
"min_doc_count": 0
}
}
}
}
结果
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 6,
"successful": 6,
"skipped": 0,
"failed": 0
},
"hits": {
"total": 24,
"max_score": 0.0,
"hits": []
},
"aggregations": {
"agg_by_time": {
"buckets": [
{
"key_as_string": "2021-09-06 16:45:00",
"key": 1630917900000,
"doc_count": 3
},
{
"key_as_string": "2021-09-06 16:46:00",
"key": 1630917960000,
"doc_count": 4
},
{
"key_as_string": "2021-09-06 16:47:00",
"key": 1630918020000,
"doc_count": 0
},
{
"key_as_string": "2021-09-06 16:48:00",
"key": 1630918080000,
"doc_count": 0
},
{
"key_as_string": "2021-09-06 16:49:00",
"key": 1630918140000,
"doc_count": 0
},
{
"key_as_string": "2021-09-06 16:50:00",
"key": 1630918200000,
"doc_count": 0
},
{
"key_as_string": "2021-09-06 16:51:00",
"key": 1630918260000,
"doc_count": 0
},
{
"key_as_string": "2021-09-06 16:52:00",
"key": 1630918320000,
"doc_count": 0
},
{
"key_as_string": "2021-09-06 16:53:00",
"key": 1630918380000,
"doc_count": 0
},
{
"key_as_string": "2021-09-06 16:54:00",
"key": 1630918440000,
"doc_count": 0
},
{
"key_as_string": "2021-09-06 16:55:00",
"key": 1630918500000,
"doc_count": 3
},
{
"key_as_string": "2021-09-06 16:56:00",
"key": 1630918560000,