首页 文章

ElasticSearch地理距离过滤器,阵列中有多个位置 - 可能吗?

提问于
浏览
19

假设我们在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 的数组 .

2 回答

  • 27

    您是否为文档指定了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
                        }
                    }
                }
            }
        }
    }'
    
  • 3

    对于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
                        }
                    }
                }
            }
        }
    }'
    

相关问题