详细内容参考官网
示例1:
##根据年龄聚合
GET /bank/_search
{
"query": {
"match_all": {}
},
"aggs": {
"ageAgg": {
"terms": {
"field": "age",
"size": 1000 #展示多少种情况
}
}
},
"sort": [
{
"age": {
"order": "desc"
}
}
]
}
实例1结果集:
{
"took" : 7,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 1000,
"relation" : "eq"
},
"max_score" : null,
"hits" : [
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "291",
"_score" : null,
"_source" : {
"account_number" : 291,
"balance" : 19955,
"firstname" : "Lynn",
"lastname" : "Pollard",
"age" : 40,
"gender" : "F",
"address" : "685 Pierrepont Street",
"employer" : "Slambda",
"email" : "lynnpollard@slambda.com",
"city" : "Mappsville",
"state" : "ID"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "474",
"_score" : null,
"_source" : {
"account_number" : 474,
"balance" : 35896,
"firstname" : "Obrien",
"lastname" : "Walton",
"age" : 40,
"gender" : "F",
"address" : "192 Ide Court",
"employer" : "Suremax",
"email" : "obrienwalton@suremax.com",
"city" : "Crucible",
"state" : "UT"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "479",
"_score" : null,
"_source" : {
"account_number" : 479,
"balance" : 31865,
"firstname" : "Cameron",
"lastname" : "Ross",
"age" : 40,
"gender" : "M",
"address" : "904 Bouck Court",
"employer" : "Telpod",
"email" : "cameronross@telpod.com",
"city" : "Nord",
"state" : "MO"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "549",
"_score" : null,
"_source" : {
"account_number" : 549,
"balance" : 1932,
"firstname" : "Jacqueline",
"lastname" : "Maxwell",
"age" : 40,
"gender" : "M",
"address" : "444 Schenck Place",
"employer" : "Fuelworks",
"email" : "jacquelinemaxwell@fuelworks.com",
"city" : "Oretta",
"state" : "OR"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "664",
"_score" : null,
"_source" : {
"account_number" : 664,
"balance" : 16163,
"firstname" : "Hart",
"lastname" : "Mccormick",
"age" : 40,
"gender" : "M",
"address" : "144 Guider Avenue",
"employer" : "Dyno",
"email" : "hartmccormick@dyno.com",
"city" : "Carbonville",
"state" : "ID"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "878",
"_score" : null,
"_source" : {
"account_number" : 878,
"balance" : 49159,
"firstname" : "Battle",
"lastname" : "Blackburn",
"age" : 40,
"gender" : "F",
"address" : "234 Hendrix Street",
"employer" : "Zilphur",
"email" : "battleblackburn@zilphur.com",
"city" : "Wanamie",
"state" : "PA"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "885",
"_score" : null,
"_source" : {
"account_number" : 885,
"balance" : 31661,
"firstname" : "Valdez",
"lastname" : "Roberson",
"age" : 40,
"gender" : "F",
"address" : "227 Scholes Street",
"employer" : "Delphide",
"email" : "valdezroberson@delphide.com",
"city" : "Chilton",
"state" : "MT"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "948",
"_score" : null,
"_source" : {
"account_number" : 948,
"balance" : 37074,
"firstname" : "Sargent",
"lastname" : "Powers",
"age" : 40,
"gender" : "M",
"address" : "532 Fiske Place",
"employer" : "Accuprint",
"email" : "sargentpowers@accuprint.com",
"city" : "Umapine",
"state" : "AK"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "998",
"_score" : null,
"_source" : {
"account_number" : 998,
"balance" : 16869,
"firstname" : "Letha",
"lastname" : "Baker",
"age" : 40,
"gender" : "F",
"address" : "206 Llama Court",
"employer" : "Dognosis",
"email" : "lethabaker@dognosis.com",
"city" : "Dunlo",
"state" : "WV"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "40",
"_score" : null,
"_source" : {
"account_number" : 40,
"balance" : 33882,
"firstname" : "Pace",
"lastname" : "Molina",
"age" : 40,
"gender" : "M",
"address" : "263 Ovington Court",
"employer" : "Cytrak",
"email" : "pacemolina@cytrak.com",
"city" : "Silkworth",
"state" : "OR"
},
"sort" : [
40
]
}
]
},
"aggregations" : {
"ageAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : 31,
"doc_count" : 61
},
{
"key" : 39,
"doc_count" : 60
},
{
"key" : 26,
"doc_count" : 59
},
{
"key" : 32,
"doc_count" : 52
},
{
"key" : 35,
"doc_count" : 52
},
{
"key" : 36,
"doc_count" : 52
},
{
"key" : 22,
"doc_count" : 51
},
{
"key" : 28,
"doc_count" : 51
},
{
"key" : 33,
"doc_count" : 50
},
{
"key" : 34,
"doc_count" : 49
},
{
"key" : 30,
"doc_count" : 47
},
{
"key" : 21,
"doc_count" : 46
},
{
"key" : 40,
"doc_count" : 45
},
{
"key" : 20,
"doc_count" : 44
},
{
"key" : 23,
"doc_count" : 42
},
{
"key" : 24,
"doc_count" : 42
},
{
"key" : 25,
"doc_count" : 42
},
{
"key" : 37,
"doc_count" : 42
},
{
"key" : 27,
"doc_count" : 39
},
{
"key" : 38,
"doc_count" : 39
},
{
"key" : 29,
"doc_count" : 35
}
]
}
}
}
实例2:
{
"took" : 7,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 1000,
"relation" : "eq"
},
"max_score" : null,
"hits" : [
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "291",
"_score" : null,
"_source" : {
"account_number" : 291,
"balance" : 19955,
"firstname" : "Lynn",
"lastname" : "Pollard",
"age" : 40,
"gender" : "F",
"address" : "685 Pierrepont Street",
"employer" : "Slambda",
"email" : "lynnpollard@slambda.com",
"city" : "Mappsville",
"state" : "ID"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "474",
"_score" : null,
"_source" : {
"account_number" : 474,
"balance" : 35896,
"firstname" : "Obrien",
"lastname" : "Walton",
"age" : 40,
"gender" : "F",
"address" : "192 Ide Court",
"employer" : "Suremax",
"email" : "obrienwalton@suremax.com",
"city" : "Crucible",
"state" : "UT"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "479",
"_score" : null,
"_source" : {
"account_number" : 479,
"balance" : 31865,
"firstname" : "Cameron",
"lastname" : "Ross",
"age" : 40,
"gender" : "M",
"address" : "904 Bouck Court",
"employer" : "Telpod",
"email" : "cameronross@telpod.com",
"city" : "Nord",
"state" : "MO"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "549",
"_score" : null,
"_source" : {
"account_number" : 549,
"balance" : 1932,
"firstname" : "Jacqueline",
"lastname" : "Maxwell",
"age" : 40,
"gender" : "M",
"address" : "444 Schenck Place",
"employer" : "Fuelworks",
"email" : "jacquelinemaxwell@fuelworks.com",
"city" : "Oretta",
"state" : "OR"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "664",
"_score" : null,
"_source" : {
"account_number" : 664,
"balance" : 16163,
"firstname" : "Hart",
"lastname" : "Mccormick",
"age" : 40,
"gender" : "M",
"address" : "144 Guider Avenue",
"employer" : "Dyno",
"email" : "hartmccormick@dyno.com",
"city" : "Carbonville",
"state" : "ID"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "878",
"_score" : null,
"_source" : {
"account_number" : 878,
"balance" : 49159,
"firstname" : "Battle",
"lastname" : "Blackburn",
"age" : 40,
"gender" : "F",
"address" : "234 Hendrix Street",
"employer" : "Zilphur",
"email" : "battleblackburn@zilphur.com",
"city" : "Wanamie",
"state" : "PA"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "885",
"_score" : null,
"_source" : {
"account_number" : 885,
"balance" : 31661,
"firstname" : "Valdez",
"lastname" : "Roberson",
"age" : 40,
"gender" : "F",
"address" : "227 Scholes Street",
"employer" : "Delphide",
"email" : "valdezroberson@delphide.com",
"city" : "Chilton",
"state" : "MT"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "948",
"_score" : null,
"_source" : {
"account_number" : 948,
"balance" : 37074,
"firstname" : "Sargent",
"lastname" : "Powers",
"age" : 40,
"gender" : "M",
"address" : "532 Fiske Place",
"employer" : "Accuprint",
"email" : "sargentpowers@accuprint.com",
"city" : "Umapine",
"state" : "AK"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "998",
"_score" : null,
"_source" : {
"account_number" : 998,
"balance" : 16869,
"firstname" : "Letha",
"lastname" : "Baker",
"age" : 40,
"gender" : "F",
"address" : "206 Llama Court",
"employer" : "Dognosis",
"email" : "lethabaker@dognosis.com",
"city" : "Dunlo",
"state" : "WV"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "40",
"_score" : null,
"_source" : {
"account_number" : 40,
"balance" : 33882,
"firstname" : "Pace",
"lastname" : "Molina",
"age" : 40,
"gender" : "M",
"address" : "263 Ovington Court",
"employer" : "Cytrak",
"email" : "pacemolina@cytrak.com",
"city" : "Silkworth",
"state" : "OR"
},
"sort" : [
40
]
}
]
},
"aggregations" : {
"ageAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : 31,
"doc_count" : 61
},
{
"key" : 39,
"doc_count" : 60
},
{
"key" : 26,
"doc_count" : 59
},
{
"key" : 32,
"doc_count" : 52
},
{
"key" : 35,
"doc_count" : 52
},
{
"key" : 36,
"doc_count" : 52
},
{
"key" : 22,
"doc_count" : 51
},
{
"key" : 28,
"doc_count" : 51
},
{
"key" : 33,
"doc_count" : 50
},
{
"key" : 34,
"doc_count" : 49
},
{
"key" : 30,
"doc_count" : 47
},
{
"key" : 21,
"doc_count" : 46
},
{
"key" : 40,
"doc_count" : 45
},
{
"key" : 20,
"doc_count" : 44
},
{
"key" : 23,
"doc_count" : 42
},
{
"key" : 24,
"doc_count" : 42
},
{
"key" : 25,
"doc_count" : 42
},
{
"key" : 37,
"doc_count" : 42
},
{
"key" : 27,
"doc_count" : 39
},
{
"key" : 38,
"doc_count" : 39
},
{
"key" : 29,
"doc_count" : 35
}
]
}
}
}
实例2结果集:
{
"took" : 30,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 1000,
"relation" : "eq"
},
"max_score" : null,
"hits" : [
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "291",
"_score" : null,
"_source" : {
"account_number" : 291,
"balance" : 19955,
"firstname" : "Lynn",
"lastname" : "Pollard",
"age" : 40,
"gender" : "F",
"address" : "685 Pierrepont Street",
"employer" : "Slambda",
"email" : "lynnpollard@slambda.com",
"city" : "Mappsville",
"state" : "ID"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "474",
"_score" : null,
"_source" : {
"account_number" : 474,
"balance" : 35896,
"firstname" : "Obrien",
"lastname" : "Walton",
"age" : 40,
"gender" : "F",
"address" : "192 Ide Court",
"employer" : "Suremax",
"email" : "obrienwalton@suremax.com",
"city" : "Crucible",
"state" : "UT"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "479",
"_score" : null,
"_source" : {
"account_number" : 479,
"balance" : 31865,
"firstname" : "Cameron",
"lastname" : "Ross",
"age" : 40,
"gender" : "M",
"address" : "904 Bouck Court",
"employer" : "Telpod",
"email" : "cameronross@telpod.com",
"city" : "Nord",
"state" : "MO"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "549",
"_score" : null,
"_source" : {
"account_number" : 549,
"balance" : 1932,
"firstname" : "Jacqueline",
"lastname" : "Maxwell",
"age" : 40,
"gender" : "M",
"address" : "444 Schenck Place",
"employer" : "Fuelworks",
"email" : "jacquelinemaxwell@fuelworks.com",
"city" : "Oretta",
"state" : "OR"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "664",
"_score" : null,
"_source" : {
"account_number" : 664,
"balance" : 16163,
"firstname" : "Hart",
"lastname" : "Mccormick",
"age" : 40,
"gender" : "M",
"address" : "144 Guider Avenue",
"employer" : "Dyno",
"email" : "hartmccormick@dyno.com",
"city" : "Carbonville",
"state" : "ID"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "878",
"_score" : null,
"_source" : {
"account_number" : 878,
"balance" : 49159,
"firstname" : "Battle",
"lastname" : "Blackburn",
"age" : 40,
"gender" : "F",
"address" : "234 Hendrix Street",
"employer" : "Zilphur",
"email" : "battleblackburn@zilphur.com",
"city" : "Wanamie",
"state" : "PA"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "885",
"_score" : null,
"_source" : {
"account_number" : 885,
"balance" : 31661,
"firstname" : "Valdez",
"lastname" : "Roberson",
"age" : 40,
"gender" : "F",
"address" : "227 Scholes Street",
"employer" : "Delphide",
"email" : "valdezroberson@delphide.com",
"city" : "Chilton",
"state" : "MT"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "948",
"_score" : null,
"_source" : {
"account_number" : 948,
"balance" : 37074,
"firstname" : "Sargent",
"lastname" : "Powers",
"age" : 40,
"gender" : "M",
"address" : "532 Fiske Place",
"employer" : "Accuprint",
"email" : "sargentpowers@accuprint.com",
"city" : "Umapine",
"state" : "AK"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "998",
"_score" : null,
"_source" : {
"account_number" : 998,
"balance" : 16869,
"firstname" : "Letha",
"lastname" : "Baker",
"age" : 40,
"gender" : "F",
"address" : "206 Llama Court",
"employer" : "Dognosis",
"email" : "lethabaker@dognosis.com",
"city" : "Dunlo",
"state" : "WV"
},
"sort" : [
40
]
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "40",
"_score" : null,
"_source" : {
"account_number" : 40,
"balance" : 33882,
"firstname" : "Pace",
"lastname" : "Molina",
"age" : 40,
"gender" : "M",
"address" : "263 Ovington Court",
"employer" : "Cytrak",
"email" : "pacemolina@cytrak.com",
"city" : "Silkworth",
"state" : "OR"
},
"sort" : [
40
]
}
]
},
"aggregations" : {
"ageAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : 31,
"doc_count" : 61,
"salaryAvg" : {
"value" : 28312.918032786885
}
},
{
"key" : 39,
"doc_count" : 60,
"salaryAvg" : {
"value" : 25269.583333333332
}
},
{
"key" : 26,
"doc_count" : 59,
"salaryAvg" : {
"value" : 23194.813559322032
}
},
{
"key" : 32,
"doc_count" : 52,
"salaryAvg" : {
"value" : 23951.346153846152
}
},
{
"key" : 35,
"doc_count" : 52,
"salaryAvg" : {
"value" : 22136.69230769231
}
},
{
"key" : 36,
"doc_count" : 52,
"salaryAvg" : {
"value" : 22174.71153846154
}
},
{
"key" : 22,
"doc_count" : 51,
"salaryAvg" : {
"value" : 24731.07843137255
}
},
{
"key" : 28,
"doc_count" : 51,
"salaryAvg" : {
"value" : 28273.882352941175
}
},
{
"key" : 33,
"doc_count" : 50,
"salaryAvg" : {
"value" : 25093.94
}
},
{
"key" : 34,
"doc_count" : 49,
"salaryAvg" : {
"value" : 26809.95918367347
}
},
{
"key" : 30,
"doc_count" : 47,
"salaryAvg" : {
"value" : 22841.106382978724
}
},
{
"key" : 21,
"doc_count" : 46,
"salaryAvg" : {
"value" : 26981.434782608696
}
},
{
"key" : 40,
"doc_count" : 45,
"salaryAvg" : {
"value" : 27183.17777777778
}
},
{
"key" : 20,
"doc_count" : 44,
"salaryAvg" : {
"value" : 27741.227272727272
}
},
{
"key" : 23,
"doc_count" : 42,
"salaryAvg" : {
"value" : 27314.214285714286
}
},
{
"key" : 24,
"doc_count" : 42,
"salaryAvg" : {
"value" : 28519.04761904762
}
},
{
"key" : 25,
"doc_count" : 42,
"salaryAvg" : {
"value" : 27445.214285714286
}
},
{
"key" : 37,
"doc_count" : 42,
"salaryAvg" : {
"value" : 27022.261904761905
}
},
{
"key" : 27,
"doc_count" : 39,
"salaryAvg" : {
"value" : 21471.871794871793
}
},
{
"key" : 38,
"doc_count" : 39,
"salaryAvg" : {
"value" : 26187.17948717949
}
},
{
"key" : 29,
"doc_count" : 35,
"salaryAvg" : {
"value" : 29483.14285714286
}
}
]
}
}
}
实例3:
#获取各年龄段男女的平均薪资
GET /bank/_search
{
"query": {
"match_all": {}
},
"aggs": {
"ageAgg": {
"terms": {
"field": "age",
"size": 100
},
"aggs": {
"genderAgg": {
"terms": {
"field": "gender.keyword",
"size": 10
},
"aggs": {
"salaryAgg": {
"avg": {
"field": "balance"
}
}
}
}
}
}
}
}
示例三结果集:
{
"took" : 41,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 1000,
"relation" : "eq"
},
"max_score" : 1.0,
"hits" : [
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "1",
"_score" : 1.0,
"_source" : {
"account_number" : 1,
"balance" : 39225,
"firstname" : "Amber",
"lastname" : "Duke",
"age" : 32,
"gender" : "M",
"address" : "880 Holmes Lane",
"employer" : "Pyrami",
"email" : "amberduke@pyrami.com",
"city" : "Brogan",
"state" : "IL"
}
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "6",
"_score" : 1.0,
"_source" : {
"account_number" : 6,
"balance" : 5686,
"firstname" : "Hattie",
"lastname" : "Bond",
"age" : 36,
"gender" : "M",
"address" : "671 Bristol Street",
"employer" : "Netagy",
"email" : "hattiebond@netagy.com",
"city" : "Dante",
"state" : "TN"
}
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "13",
"_score" : 1.0,
"_source" : {
"account_number" : 13,
"balance" : 32838,
"firstname" : "Nanette",
"lastname" : "Bates",
"age" : 28,
"gender" : "F",
"address" : "789 Madison Street",
"employer" : "Quility",
"email" : "nanettebates@quility.com",
"city" : "Nogal",
"state" : "VA"
}
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "18",
"_score" : 1.0,
"_source" : {
"account_number" : 18,
"balance" : 4180,
"firstname" : "Dale",
"lastname" : "Adams",
"age" : 33,
"gender" : "M",
"address" : "467 Hutchinson Court",
"employer" : "Boink",
"email" : "daleadams@boink.com",
"city" : "Orick",
"state" : "MD"
}
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "20",
"_score" : 1.0,
"_source" : {
"account_number" : 20,
"balance" : 16418,
"firstname" : "Elinor",
"lastname" : "Ratliff",
"age" : 36,
"gender" : "M",
"address" : "282 Kings Place",
"employer" : "Scentric",
"email" : "elinorratliff@scentric.com",
"city" : "Ribera",
"state" : "WA"
}
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "25",
"_score" : 1.0,
"_source" : {
"account_number" : 25,
"balance" : 40540,
"firstname" : "Virginia",
"lastname" : "Ayala",
"age" : 39,
"gender" : "F",
"address" : "171 Putnam Avenue",
"employer" : "Filodyne",
"email" : "virginiaayala@filodyne.com",
"city" : "Nicholson",
"state" : "PA"
}
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "32",
"_score" : 1.0,
"_source" : {
"account_number" : 32,
"balance" : 48086,
"firstname" : "Dillard",
"lastname" : "Mcpherson",
"age" : 34,
"gender" : "F",
"address" : "702 Quentin Street",
"employer" : "Quailcom",
"email" : "dillardmcpherson@quailcom.com",
"city" : "Veguita",
"state" : "IN"
}
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "37",
"_score" : 1.0,
"_source" : {
"account_number" : 37,
"balance" : 18612,
"firstname" : "Mcgee",
"lastname" : "Mooney",
"age" : 39,
"gender" : "M",
"address" : "826 Fillmore Place",
"employer" : "Reversus",
"email" : "mcgeemooney@reversus.com",
"city" : "Tooleville",
"state" : "OK"
}
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "44",
"_score" : 1.0,
"_source" : {
"account_number" : 44,
"balance" : 34487,
"firstname" : "Aurelia",
"lastname" : "Harding",
"age" : 37,
"gender" : "M",
"address" : "502 Baycliff Terrace",
"employer" : "Orbalix",
"email" : "aureliaharding@orbalix.com",
"city" : "Yardville",
"state" : "DE"
}
},
{
"_index" : "bank",
"_type" : "_doc",
"_id" : "49",
"_score" : 1.0,
"_source" : {
"account_number" : 49,
"balance" : 29104,
"firstname" : "Fulton",
"lastname" : "Holt",
"age" : 23,
"gender" : "F",
"address" : "451 Humboldt Street",
"employer" : "Anocha",
"email" : "fultonholt@anocha.com",
"city" : "Sunriver",
"state" : "RI"
}
}
]
},
"aggregations" : {
"ageAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : 31,
"doc_count" : 61,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "M",
"doc_count" : 35,
"salaryAgg" : {
"value" : 29565.628571428573
}
},
{
"key" : "F",
"doc_count" : 26,
"salaryAgg" : {
"value" : 26626.576923076922
}
}
]
}
},
{
"key" : 39,
"doc_count" : 60,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "F",
"doc_count" : 38,
"salaryAgg" : {
"value" : 26348.684210526317
}
},
{
"key" : "M",
"doc_count" : 22,
"salaryAgg" : {
"value" : 23405.68181818182
}
}
]
}
},
{
"key" : 26,
"doc_count" : 59,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "M",
"doc_count" : 32,
"salaryAgg" : {
"value" : 25094.78125
}
},
{
"key" : "F",
"doc_count" : 27,
"salaryAgg" : {
"value" : 20943.0
}
}
]
}
},
{
"key" : 32,
"doc_count" : 52,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "M",
"doc_count" : 28,
"salaryAgg" : {
"value" : 22941.964285714286
}
},
{
"key" : "F",
"doc_count" : 24,
"salaryAgg" : {
"value" : 25128.958333333332
}
}
]
}
},
{
"key" : 35,
"doc_count" : 52,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "M",
"doc_count" : 28,
"salaryAgg" : {
"value" : 24226.321428571428
}
},
{
"key" : "F",
"doc_count" : 24,
"salaryAgg" : {
"value" : 19698.791666666668
}
}
]
}
},
{
"key" : 36,
"doc_count" : 52,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "M",
"doc_count" : 31,
"salaryAgg" : {
"value" : 20884.677419354837
}
},
{
"key" : "F",
"doc_count" : 21,
"salaryAgg" : {
"value" : 24079.04761904762
}
}
]
}
},
{
"key" : 22,
"doc_count" : 51,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "F",
"doc_count" : 27,
"salaryAgg" : {
"value" : 22152.74074074074
}
},
{
"key" : "M",
"doc_count" : 24,
"salaryAgg" : {
"value" : 27631.708333333332
}
}
]
}
},
{
"key" : 28,
"doc_count" : 51,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "F",
"doc_count" : 31,
"salaryAgg" : {
"value" : 27076.8064516129
}
},
{
"key" : "M",
"doc_count" : 20,
"salaryAgg" : {
"value" : 30129.35
}
}
]
}
},
{
"key" : 33,
"doc_count" : 50,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "F",
"doc_count" : 26,
"salaryAgg" : {
"value" : 26437.615384615383
}
},
{
"key" : "M",
"doc_count" : 24,
"salaryAgg" : {
"value" : 23638.291666666668
}
}
]
}
},
{
"key" : 34,
"doc_count" : 49,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "F",
"doc_count" : 30,
"salaryAgg" : {
"value" : 26039.166666666668
}
},
{
"key" : "M",
"doc_count" : 19,
"salaryAgg" : {
"value" : 28027.0
}
}
]
}
},
{
"key" : 30,
"doc_count" : 47,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "F",
"doc_count" : 25,
"salaryAgg" : {
"value" : 25316.16
}
},
{
"key" : "M",
"doc_count" : 22,
"salaryAgg" : {
"value" : 20028.545454545456
}
}
]
}
},
{
"key" : 21,
"doc_count" : 46,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "F",
"doc_count" : 24,
"salaryAgg" : {
"value" : 28210.916666666668
}
},
{
"key" : "M",
"doc_count" : 22,
"salaryAgg" : {
"value" : 25640.18181818182
}
}
]
}
},
{
"key" : 40,
"doc_count" : 45,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "M",
"doc_count" : 24,
"salaryAgg" : {
"value" : 26474.958333333332
}
},
{
"key" : "F",
"doc_count" : 21,
"salaryAgg" : {
"value" : 27992.571428571428
}
}
]
}
},
{
"key" : 20,
"doc_count" : 44,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "M",
"doc_count" : 27,
"salaryAgg" : {
"value" : 29047.444444444445
}
},
{
"key" : "F",
"doc_count" : 17,
"salaryAgg" : {
"value" : 25666.647058823528
}
}
]
}
},
{
"key" : 23,
"doc_count" : 42,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "M",
"doc_count" : 24,
"salaryAgg" : {
"value" : 27730.75
}
},
{
"key" : "F",
"doc_count" : 18,
"salaryAgg" : {
"value" : 26758.833333333332
}
}
]
}
},
{
"key" : 24,
"doc_count" : 42,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "F",
"doc_count" : 23,
"salaryAgg" : {
"value" : 29414.521739130436
}
},
{
"key" : "M",
"doc_count" : 19,
"salaryAgg" : {
"value" : 27435.052631578947
}
}
]
}
},
{
"key" : 25,
"doc_count" : 42,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "M",
"doc_count" : 23,
"salaryAgg" : {
"value" : 29336.08695652174
}
},
{
"key" : "F",
"doc_count" : 19,
"salaryAgg" : {
"value" : 25156.263157894737
}
}
]
}
},
{
"key" : 37,
"doc_count" : 42,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "M",
"doc_count" : 23,
"salaryAgg" : {
"value" : 25015.739130434784
}
},
{
"key" : "F",
"doc_count" : 19,
"salaryAgg" : {
"value" : 29451.21052631579
}
}
]
}
},
{
"key" : 27,
"doc_count" : 39,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "F",
"doc_count" : 21,
"salaryAgg" : {
"value" : 21618.85714285714
}
},
{
"key" : "M",
"doc_count" : 18,
"salaryAgg" : {
"value" : 21300.38888888889
}
}
]
}
},
{
"key" : 38,
"doc_count" : 39,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "F",
"doc_count" : 20,
"salaryAgg" : {
"value" : 27931.65
}
},
{
"key" : "M",
"doc_count" : 19,
"salaryAgg" : {
"value" : 24350.894736842107
}
}
]
}
},
{
"key" : 29,
"doc_count" : 35,
"genderAgg" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "M",
"doc_count" : 23,
"salaryAgg" : {
"value" : 29943.17391304348
}
},
{
"key" : "F",
"doc_count" : 12,
"salaryAgg" : {
"value" : 28601.416666666668
}
}
]
}
}
]
}
}
}