elasticsearch 多聚合查询

[hersing]

原始es中数据格式：

{
  "took" : 3,
  "timed_out" : false,
  "_shards" : {
    "total" : 5,
    "successful" : 5,
    "failed" : 0
  },
  "hits" : {
    "total" : 3,
    "max_score" : 1.0,
    "hits" : [ {
      "_index" : "demo",
      "_type" : "information",
      "_id" : "8cbadcec89a04f288b57a3296fee65f5",
      "_score" : 1.0,
      "_source" : {
        "id" : "8cbadcec89a04f288b57a3296fee65f5",
        "name" : "james",
        "date" : 1501743474101,
        "address" : "深圳福田",
        "money" : null,
        "money2" : 33.33
      }
    }, {
      "_index" : "demo",
      "_type" : "information",
      "_id" : "b717309157b14fe7a66f0cf10669e542",
      "_score" : 1.0,
      "_source" : {
        "id" : "b717309157b14fe7a66f0cf10669e542",
        "name" : "jono",
        "date" : 1501743474213,
        "address" : "深圳罗湖",
        "money" : null,
        "money2" : 11.11
      }
    }, {
      "_index" : "demo",
      "_type" : "information",
      "_id" : "8072a1f1c52240d8a031a43f703f2085",
      "_score" : 1.0,
      "_source" : {
        "id" : "8072a1f1c52240d8a031a43f703f2085",
        "name" : "jono",
        "date" : 1501743473596,
        "address" : "深圳南山",
        "money" : null,
        "money2" : 55.55
      }
    } ]
  }
}

我现在想要通过name,id做group by，还要通过money2做sum操作，预想的查询结果应该为2条数据，但是最终的查询结果还是为3条数据，下面的是我的请求语句：

{
  "fields": [
    "id",
    "name",
    "money2"
  ],
  "query": {
    "filtered": {
      "query": {
        "query_string": {
          "query": "*"
        }
      }
    }
  },
  "aggs": {
    "nameCount": {
      "terms": {
        "field": "name"
      },
      "aggs": {
        "idCount": {
          "terms": {
            "field": "id"
          },
          "aggs": {
            "moneyAmount": {
              "sum": {
                "field": "money2"
              }
            }
          }
        }
      }
    }
  }
}

我想的是es搜索引擎应该是支持这种查询的，但是具体的实现方式不太清楚，希望有老司机来解惑，网上看的大多数只是得到聚合后的单个结果，而我是想要得到结果集

[hersing]

没人

[hersing]

为何没人

[hersing]

引用 4 楼 shpery 的回复:

帮顶....没用过。。。

[hersing]

果然这个东西很冷门吗

[shpery]

帮顶....没用过。。。

[六六六嗷]

把你聚合的结果贴上来看下

[jjshouji]

是要这样的结果？ select name,id,sum(money2) from demo group by name,id

[Munger6]

楼主：你的查询结果是对的，因为你的id不同 当去除id匹配条件，将查询回来两条结果：jono 加总。