Skip to content

Instantly share code, notes, and snippets.

@johtani

johtani/line_aggregation_sample.json

Last active August 29, 2015 14:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save johtani/808d71cd8ba04073edd7 to your computer and use it in GitHub Desktop.
Save johtani/808d71cd8ba04073edd7 to your computer and use it in GitHub Desktop.
Download ZIP
nested aggregation sample: tested by elasticsearch 1.1.1
Raw
line_aggregation_sample.json
DELETE /line_aggs
# create index and mapping
PUT /line_aggs
{
"settings": {
"number_of_shards": 2,
"number_of_replicas": 0
},
"mappings": {
"tokyo" : {
"_id" : {
"path" : "id"
},
"properties": {
"id": {"type": "string", "index": "not_analyzed"},
"name": {"type": "string", "index": "not_analyzed"},
"station_near": {
"type": "nested",
"properties": {
"line" : {"type": "string", "index": "not_analyzed"},
"station" : {"type": "string", "index": "not_analyzed"},
"station_distance_by_walk": {"type": "integer"}
}
}
}
}
}
}
# get mapping
GET /line_aggs/_mapping
GET /line_aggs/tokyo/_search
{
"size": 0,
"query": {
"match_all": {}
},
"facets": {
"station": {
"terms": {
"field": "station"
},
"nested": "station_near"
}
}
}
GET /line_aggs/tokyo/_search
{
"size": 0,
"query": {
"match_all": {}
},
"aggs": {
"station_nested": {
"nested": {
"path": "station_near"
},
"aggs": {
"station": {
"terms": {
"field": "station_near.station",
"size": 50
}
}
}
},
"line-station": {
"nested": {
"path": "station_near"
},
"aggs": {
"ls_line": {
"terms": {
"field": "station_near.line",
"size": 10
},
"aggs": {
"ls_station": {
"terms": {
"field": "station_near.station",
"size": 10
}
}
}
}
}
}
}
}
Raw
line_aggs_data.json
{"id": "station_id0", "name": "name0", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 5 }]}
{"id": "station_id1", "name": "name1", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 7 }]}
{"id": "station_id2", "name": "name2", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 4 }]}
{"id": "station_id3", "name": "name3", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 8 }]}
{"id": "station_id4", "name": "name4", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 3 }]}
{"id": "station_id5", "name": "name5", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 9 }]}
{"id": "station_id6", "name": "name6", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 4 }]}
{"id": "station_id7", "name": "name7", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 3 }]}
{"id": "station_id8", "name": "name8", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "池袋", "station_distance_by_walk" : 9 }]}
{"id": "station_id9", "name": "name9", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 9 }]}
{"id": "station_id10", "name": "name10", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 7 }]}
{"id": "station_id11", "name": "name11", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 5 }]}
{"id": "station_id12", "name": "name12", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 7 }]}
{"id": "station_id13", "name": "name13", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 1 }]}
{"id": "station_id14", "name": "name14", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 2 }]}
{"id": "station_id15", "name": "name15", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 6 }]}
{"id": "station_id16", "name": "name16", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "池袋", "station_distance_by_walk" : 9 }]}
{"id": "station_id17", "name": "name17", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "池袋", "station_distance_by_walk" : 9 }]}
{"id": "station_id18", "name": "name18", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 6 }]}
{"id": "station_id19", "name": "name19", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 9 }]}
{"id": "station_id20", "name": "name20", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 3 }]}
{"id": "station_id21", "name": "name21", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 5 }]}
{"id": "station_id22", "name": "name22", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "池袋", "station_distance_by_walk" : 2 }]}
{"id": "station_id23", "name": "name23", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 7 }]}
{"id": "station_id24", "name": "name24", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 5 }]}
{"id": "station_id25", "name": "name25", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 3 }]}
{"id": "station_id26", "name": "name26", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 7 }]}
{"id": "station_id27", "name": "name27", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 4 }]}
{"id": "station_id28", "name": "name28", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 5 }]}
{"id": "station_id29", "name": "name29", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 9 }]}
{"id": "station_id30", "name": "name30", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 1 }]}
{"id": "station_id31", "name": "name31", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 10 }]}
{"id": "station_id32", "name": "name32", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 6 }]}
{"id": "station_id33", "name": "name33", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 2 }]}
{"id": "station_id34", "name": "name34", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 8 }]}
{"id": "station_id35", "name": "name35", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 7 }]}
{"id": "station_id36", "name": "name36", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 5 }]}
{"id": "station_id37", "name": "name37", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "池袋", "station_distance_by_walk" : 1 }]}
{"id": "station_id38", "name": "name38", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 5 }]}
{"id": "station_id39", "name": "name39", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 5 }]}
{"id": "station_id40", "name": "name40", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 6 }]}
{"id": "station_id41", "name": "name41", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 9 }]}
{"id": "station_id42", "name": "name42", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 1 }]}
{"id": "station_id43", "name": "name43", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 7 }]}
{"id": "station_id44", "name": "name44", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 6 }]}
{"id": "station_id45", "name": "name45", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 6 }]}
{"id": "station_id46", "name": "name46", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 9 }]}
{"id": "station_id47", "name": "name47", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 9 }]}
{"id": "station_id48", "name": "name48", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 8 }]}
{"id": "station_id49", "name": "name49", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 3 }]}
{"id": "station_id50", "name": "name50", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "池袋", "station_distance_by_walk" : 6 }]}
{"id": "station_id51", "name": "name51", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 6 }]}
{"id": "station_id52", "name": "name52", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 1 }]}
{"id": "station_id53", "name": "name53", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 9 }]}
{"id": "station_id54", "name": "name54", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 2 }]}
{"id": "station_id55", "name": "name55", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "池袋", "station_distance_by_walk" : 2 }]}
{"id": "station_id56", "name": "name56", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 10 }]}
{"id": "station_id57", "name": "name57", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 5 }]}
{"id": "station_id58", "name": "name58", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 7 }]}
{"id": "station_id59", "name": "name59", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 5 }]}
{"id": "station_id60", "name": "name60", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "池袋", "station_distance_by_walk" : 10 }]}
{"id": "station_id61", "name": "name61", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "池袋", "station_distance_by_walk" : 10 }]}
{"id": "station_id62", "name": "name62", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 10 }]}
{"id": "station_id63", "name": "name63", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 9 }]}
{"id": "station_id64", "name": "name64", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 8 }]}
{"id": "station_id65", "name": "name65", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "池袋", "station_distance_by_walk" : 7 }]}
{"id": "station_id66", "name": "name66", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "池袋", "station_distance_by_walk" : 8 }]}
{"id": "station_id67", "name": "name67", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 3 }]}
{"id": "station_id68", "name": "name68", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "池袋", "station_distance_by_walk" : 10 }]}
{"id": "station_id69", "name": "name69", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "池袋", "station_distance_by_walk" : 5 }]}
{"id": "station_id70", "name": "name70", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 8 }]}
{"id": "station_id71", "name": "name71", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 10 }]}
{"id": "station_id72", "name": "name72", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 4 }]}
{"id": "station_id73", "name": "name73", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 1 }]}
{"id": "station_id74", "name": "name74", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 4 }]}
{"id": "station_id75", "name": "name75", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 8 }]}
{"id": "station_id76", "name": "name76", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 4 }]}
{"id": "station_id77", "name": "name77", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 2 }]}
{"id": "station_id78", "name": "name78", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 4 }]}
{"id": "station_id79", "name": "name79", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 4 }]}
{"id": "station_id80", "name": "name80", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 6 }]}
{"id": "station_id81", "name": "name81", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 4 }]}
{"id": "station_id82", "name": "name82", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 9 }]}
{"id": "station_id83", "name": "name83", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 7 }]}
{"id": "station_id84", "name": "name84", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "池袋", "station_distance_by_walk" : 7 }]}
{"id": "station_id85", "name": "name85", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "池袋", "station_distance_by_walk" : 3 }]}
{"id": "station_id86", "name": "name86", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 7 }]}
{"id": "station_id87", "name": "name87", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 4 }]}
{"id": "station_id88", "name": "name88", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 1 }]}
{"id": "station_id89", "name": "name89", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 9 }]}
{"id": "station_id90", "name": "name90", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "渋谷", "station_distance_by_walk" : 10 }]}
{"id": "station_id91", "name": "name91", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 6 }]}
{"id": "station_id92", "name": "name92", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 7 }]}
{"id": "station_id93", "name": "name93", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 3 }]}
{"id": "station_id94", "name": "name94", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "池袋", "station_distance_by_walk" : 4 }]}
{"id": "station_id95", "name": "name95", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 9 }]}
{"id": "station_id96", "name": "name96", "station_near" : [{ "line": [ "京浜東北線","山手線" ], "station": "品川", "station_distance_by_walk" : 7 }]}
{"id": "station_id97", "name": "name97", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "池袋", "station_distance_by_walk" : 8 }]}
{"id": "station_id98", "name": "name98", "station_near" : [{ "line": [ "山手線" ], "station": "巣鴨", "station_distance_by_walk" : 3 }]}
{"id": "station_id99", "name": "name99", "station_near" : [{ "line": [ "埼京線","山手線" ], "station": "池袋", "station_distance_by_walk" : 2 }]}
Raw
response_aggs.json
# response
{
"took": 3,
"timed_out": false,
"_shards": {
"total": 2,
"successful": 2,
"failed": 0
},
"hits": {
"total": 100,
"max_score": 0,
"hits": []
},
"aggregations": {
"station_nested": {
"doc_count": 100,
"station": {
"buckets": [
{
"key": "品川",
"doc_count": 35
},
{
"key": "渋谷",
"doc_count": 26
},
{
"key": "巣鴨",
"doc_count": 21
},
{
"key": "池袋",
"doc_count": 18
}
]
}
},
"line-station": {
"doc_count": 100,
"ls_line": {
"buckets": [
{
"key": "山手線",
"doc_count": 100,
"ls_station": {
"buckets": [
{
"key": "品川",
"doc_count": 35
},
{
"key": "渋谷",
"doc_count": 26
},
{
"key": "巣鴨",
"doc_count": 21
},
{
"key": "池袋",
"doc_count": 18
}
]
}
},
{
"key": "埼京線",
"doc_count": 44,
"ls_station": {
"buckets": [
{
"key": "渋谷",
"doc_count": 26
},
{
"key": "池袋",
"doc_count": 18
}
]
}
},
{
"key": "京浜東北線",
"doc_count": 35,
"ls_station": {
"buckets": [
{
"key": "品川",
"doc_count": 35
}
]
}
}
]
}
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment