es 聚合多字段查询

最新推荐文章于 2023-04-12 16:03:42 发布

weixin_33736832

最新推荐文章于 2023-04-12 16:03:42 发布

阅读量1.9k

点赞数

文章标签： python 数据库

原文链接：https://my.oschina.net/u/2617600/blog/1559835

版权

2019独角兽企业重金招聘Python工程师标准>>>

{ "size": 2, "source": { "includes": [ "room","eta","etd","quantity"] }, "query": { "bool": { "must": [ { "range": { "eta": { "gte": "2017-11-01", "lte": "2017-11-01", "time_zone": "+08:00" } } } ] } }, "aggregations": { "type": { "terms": { "field": "room" }, "aggregations": { "checkin": { "date_histogram": { "field": "eta", "time_zone": "+08:00", "interval": "1d", "format" : "yyyy-MM-dd" }, **

"aggregations": {

        "sumq": {
              "scripted_metric": {
              	"init_script" : "params._agg.transactions = []",
              	"map_script" : "params._agg.transactions.add(doc.etd.value+'_'+doc.eta.value+'_'+doc.quantity.value)"
            }
        }

_** } } } } }, "sort": { "eta": { "order": "asc" }} }

转载于:https://my.oschina.net/u/2617600/blog/1559835