dongxian3574
2018-10-25 14:09
浏览 195

Elasticsearch查询:通过比较值列表选择文档(golang)

I have a type of document indexed in ElasticSearch, with a simplified structure as follows:

{
    id: "54"
    properties: ["nice", "green", "small", "dry"]
}

Now I want to select all the documents in this index, which doesn't contain a list of given values in the properties field.

Something like: SELECT * FROM index WHERE properties NOT CONTAINS ["red", "big", "scary"]

How can I implements that on elasticsearch? (And I someone knows how can I implements such a query on Golang, I'll be even better :-) )

Thanks!

图片转代码服务由CSDN问答提供 功能建议

我有一种类型的文档在ElasticSearch中建立了索引,其简化结构如下: \ n

  {
 id:“ 54” 
属性:[“ nice”,“ green”,“ small”,“ dry”] 
} 
   \  n 
 

现在我要选择此索引中的所有文档,这些文档 properties 字段中包含给定值的列表。

类似于: SELECT * FROM index WHERE properties NOT CONTAINS [“ red”,“ big”,“ scary”]

(我知道如何在Golang上实现这样的查询,我会更好:-))

谢谢! p>

  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • doue9730 2018-10-25 14:49
    已采纳

    You can match those documents from index using the clause bool. It will look something like this:

    {
        "bool": {
            "must_not": [
                { "term": { "properties": "red" }},
                { "term": { "properties": "big" }},
                { "term": { "properties": "scary" }}
             ]
        }
    }
    

    The query could be like this:

    {
      "filtered": {
        "query": {
          "match": { "id": "54" }
        },
        "filter":{
          "bool": {
            "must_not": [
                { "term": { "properties": "red" }},
                { "term": { "properties": "big" }},
                { "term": { "properties": "scary" }}
            ]
          }
        }
      }
    }
    

    For more information you can check this link: Filtered query

    已采纳该答案
    打赏 评论

相关推荐 更多相似问题