Elasticsearch 统计订单销售高峰时间段

索引mapping：

{
    "mappings" : {
      "properties" : {
        "createDate" : {
          "type" : "long"
        },
        "goodsCode" : {
          "type" : "keyword"
        },
        "id" : {
          "type" : "text",
          "fields" : {
            "keyword" : {
              "type" : "keyword",
              "ignore_above" : 256
            }
          }
        },
        "orderNumber" : {
          "type" : "keyword"
        },
        "payDate" : {
          "type" : "long"
        },
        "saleQty" : {
          "type" : "double"
        }
      }
    }
  }
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

需求：
根据今年以来的销售数据，统计一天中销售的高峰时间段。

{
  "query": {
    "range": {
      "payDate": {
        "gte": 1704038400000
      }
    }
  },
  "size":0, 
  "aggs": {
    "hours_sales":{
      "terms": {
        "script": {
          "source": """
        DateTimeFormatter df = DateTimeFormatter.ofPattern("HH").withZone(ZoneId.systemDefault());
           return df.format(Instant.ofEpochMilli(doc['payDate'].value));
        """,
        "lang":"painless"
        },
        "size": 24
      },
      "aggs": {
        "sale_sum": {
          "sum": {
            "field": "saleQty"
          }
        }
      },
    "meta":{
      "bucket_sort": {
        "sort": [
          {
            "sale_sum":{
              "order":"desc"
            }
          }
        ]
      }
    }
    }
  }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42

hours_sales：按小时统计
sale_sum：同样小时的销售数量
bucket_sort：根据销售数量倒序

输出：

{
    "month_sales" : {
      "meta" : {
        "bucket_sort" : {
          "sort" : [
            {
              "sale_sum" : {
                "order" : "desc"
              }
            }
          ]
        }
      },
      "doc_count_error_upper_bound" : 0,
      "sum_other_doc_count" : 0,
      "buckets" : [
        {
          "key" : "21",
          "doc_count" : 1490119,
          "sale_sum" : {
            "value" : 2219320.0
          }
        },
        {
          "key" : "22",
          "doc_count" : 1394689,
          "sale_sum" : {
            "value" : 1984438.0
          }
        },
        {
          "key" : "23",
          "doc_count" : 1169223,
          "sale_sum" : {
            "value" : 1621883.0
          }
        },
        {
          "key" : "20",
          "doc_count" : 1135145,
          "sale_sum" : {
            "value" : 1684774.0
          }
        },
        {
          "key" : "12",
          "doc_count" : 1101876,
          "sale_sum" : {
            "value" : 1970868.0
          }
        },
        {
          "key" : "11",
          "doc_count" : 1087839,
          "sale_sum" : {
            "value" : 1718736.0
          }
        },
        {
          "key" : "13",
          "doc_count" : 1029868,
          "sale_sum" : {
            "value" : 1555518.0
          }
        },
        {
          "key" : "10",
          "doc_count" : 1019584,
          "sale_sum" : {
            "value" : 1964907.0
          }
        },
        {
          "key" : "15",
          "doc_count" : 951064,
          "sale_sum" : {
            "value" : 1716640.0
          }
        },
        {
          "key" : "09",
          "doc_count" : 933940,
          "sale_sum" : {
            "value" : 1509718.0
          }
        },
        {
          "key" : "14",
          "doc_count" : 930368,
          "sale_sum" : {
            "value" : 1386315.0
          }
        },
        {
          "key" : "16",
          "doc_count" : 925275,
          "sale_sum" : {
            "value" : 1670132.0
          }
        },
        {
          "key" : "19",
          "doc_count" : 909453,
          "sale_sum" : {
            "value" : 1392385.0
          }
        },
        {
          "key" : "17",
          "doc_count" : 863353,
          "sale_sum" : {
            "value" : 1311020.0
          }
        },
        {
          "key" : "18",
          "doc_count" : 795198,
          "sale_sum" : {
            "value" : 1251265.0
          }
        },
        {
          "key" : "08",
          "doc_count" : 776007,
          "sale_sum" : {
            "value" : 1253125.0
          }
        },
        {
          "key" : "00",
          "doc_count" : 771251,
          "sale_sum" : {
            "value" : 1019472.0
          }
        },
        {
          "key" : "07",
          "doc_count" : 568447,
          "sale_sum" : {
            "value" : 919369.0
          }
        },
        {
          "key" : "01",
          "doc_count" : 369065,
          "sale_sum" : {
            "value" : 503474.0
          }
        },
        {
          "key" : "06",
          "doc_count" : 293302,
          "sale_sum" : {
            "value" : 467315.0
          }
        },
        {
          "key" : "02",
          "doc_count" : 207584,
          "sale_sum" : {
            "value" : 293993.0
          }
        },
        {
          "key" : "03",
          "doc_count" : 139777,
          "sale_sum" : {
            "value" : 202227.0
          }
        },
        {
          "key" : "05",
          "doc_count" : 121415,
          "sale_sum" : {
            "value" : 188120.0
          }
        },
        {
          "key" : "04",
          "doc_count" : 111086,
          "sale_sum" : {
            "value" : 166002.0
          }
        }
      ]
    }
  }
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187

如果已销售100w为高峰，由此推断销售高峰期是 20-23点，其次是8-18点。