考虑以下任务:我们列出了欧洲不同城镇的日平均气温。{Hamburg:[14,15,16,14,18,17,20,11,21,18,19,11],Munich:[16,17,19,20,21,23,22,21,20,19,24,23],Madrid:[24,23,20,24,24,23,21,22,24,20,24,22],Stockholm:[16,14,12,15,13,14,14,12,11,14,15,14],Warsaw:[17,15,16,18,20,20,21,18,19,18,17,20]}我们想将这些城镇分为两组:“温暖”和“炎热”。“温暖”应该是至少有3天温度高于19
我有以下查询,从中获取数据并创建过去每个小时的聚合:query={"query":{"bool":{"must":[{"term":{"deviceId":device}},{"match":{"eventType":"Connected"}}],"must_not":[{"query_string":{"query":"Pong","fields":["data.message"]}},]},},"size":0,"sort":[{"timestamp":{"order":"desc"}}],"aggs":{"time_buckets":{"date_histogram":{"fie