假设我们在ElasticSearch索引中有一堆文档。每个文档在数组中都有多个位置,如下所示:
{
"name": "foobar",
"locations": [
{
"lat": 40.708519,
"lon": -74.003212
},
{
"lat": 39.752609,
"lon": -104.998100
},
{
"lat": 51.506321,
"lon": -0.127140
}
]
}
根据ElasticSearch reference guide的说法
geo_distance
过滤器可以处理每个文档的多个位置/点。一旦单个位置/点与筛选器匹配,该文档将包含在筛选器中。
那么,有没有可能创建一个地理距离过滤器来检查数组中的所有位置?
不幸的是,这似乎不起作用:
{
"filter": {
"geo_distance": {
"distance": "100 km",
"locations": "40, -105"
}
}
}
抛出"QueryParsingException[[myIndex] failed to find geo_point field [locations]
“,因为locations
不是单个geo_point
,而是一个geo_point
数组。
发布于 2013-04-20 08:17:09
您是否为文档指定了geo_point mapping?
curl -XDELETE 'http://localhost:9200/twitter/'
curl -XPUT 'http://localhost:9200/twitter/'
curl -XPUT 'http://localhost:9200/twitter/tweet/_mapping' -d '
{
"tweet" : {
"properties" : {
"locations" : {"type" : "geo_point"}
}
}
}'
curl -XPUT 'http://localhost:9200/twitter/tweet/1' -d '
{
"user": "kimchy",
"postDate": "2009-11-15T13:12:00",
"message": "Trying out Elastic Search, so far so good?",
"locations" : [{
"lat" : 50.00,
"lon" : 10.00
},
{
"lat" : 40.00,
"lon" : 9.00
}]
}'
curl -XPUT 'http://localhost:9200/twitter/tweet/2' -d '
{
"user": "kimchy",
"postDate": "2009-11-15T13:12:00",
"message": "Trying out Elastic Search, so far so good?",
"locations" : [{
"lat" : 30.00,
"lon" : 8.00
},
{
"lat" : 20.00,
"lon" : 7.00
}]
}'
curl -XGET 'http://localhost:9200/twitter/tweet/_search' -d '{
"query": {
"filtered" : {
"query" : {
"match_all" : {}
},
"filter" : {
"geo_distance" : {
"distance" : "20km",
"tweet.locations" : {
"lat" : 40.00,
"lon" : 9.00
}
}
}
}
}
}'
发布于 2017-02-17 15:47:44
对于Elasticsearch版本5.1,对于上面的索引,查询将是这样的,
curl -XGET 'http://localhost:9200/twitter/tweet/_search' -d '
{
"query": {
"bool": {
"must": {
"match_all": {}
},
"filter": {
"geo_distance": {
"distance": "200km",
"locations": {
"lat": 40.00,
"lon": 9.00
}
}
}
}
}
}'
https://stackoverflow.com/questions/16113439
复制相似问题