原始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搜索引擎应该是支持这种查询的，但是具体的实现方式不太清楚，希望有老司机来解惑，网上看的大多数只是得到聚合后的单个结果，而我是想要得到结果集
没人
果然这个东西很冷门吗
