首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >为什么在使用术语查询elasticsearch时搜索结果有差异?

为什么在使用术语查询elasticsearch时搜索结果有差异?
EN

Stack Overflow用户
提问于 2021-04-19 04:28:32
回答 1查看 45关注 0票数 0

我最近开始学习elasticsearch,我的查询的搜索结果有所不同。名为"products“的索引的映射如下(我正在粘贴来自Kibana控制台工具的响应):

代码语言:javascript
复制
    {
    "products" : {
"mappings" : {
  "properties" : {
    "in_stock" : {
      "type" : "long"
    },
    "name" : {
      "type" : "text",
      "fields" : {
        "keyword" : {
          "type" : "keyword",
          "ignore_above" : 256
        }
      }
    },
    "price" : {
      "type" : "long"
    },
    "tags" : {
      "type" : "text",
      "fields" : {
        "keyword" : {
          "type" : "keyword",
          "ignore_above" : 256
        }
      }
    }
  }
}
}
}

索引中的数据如下(我正在粘贴来自Kibana控制台工具的响应):

代码语言:javascript
复制
{
   "took" : 0,
  "timed_out" : false,
  "_shards" : {
  "total" : 1,
  "successful" : 1,
  "skipped" : 0,
  "failed" : 0
  },
  "hits" : {
"total" : {
  "value" : 16,
  "relation" : "eq"
},
"max_score" : 1.0,
"hits" : [
  {
    "_index" : "products",
    "_type" : "_doc",
    "_id" : "202",
    "_score" : 1.0,
    "_source" : {
      "name" : "Vegetable Chopper",
      "price" : 10,
      "in_stock" : 250,
      "tags" : [
        "kitchen appliances",
        "vegetable slicer",
        "chopper"
      ]
    }
  },
  {
    "_index" : "products",
    "_type" : "_doc",
    "_id" : "203",
    "_score" : 1.0,
    "_source" : {
      "name" : "Dish Washer",
      "price" : 90,
      "in_stock" : 60,
      "tags" : [
        "kitchen appliances",
        "electrical",
        "electric washer"
      ]
    }
  },
  {
    "_index" : "products",
    "_type" : "_doc",
    "_id" : "205",
    "_score" : 1.0,
    "_source" : {
      "name" : "Microwave Oven",
      "price" : 100,
      "in_stock" : 50,
      "tags" : [
        "kitchen appliances",
        "electricals",
        "oven",
        "oven toaster",
        "microwave"
      ]
    }
  },
  {
    "_index" : "products",
    "_type" : "_doc",
    "_id" : "206",
    "_score" : 1.0,
    "_source" : {
      "name" : "Mixer Grinder",
      "price" : 55,
      "in_stock" : 130,
      "tags" : [
        "kitchen appliances",
        "electricals",
        "mixer",
        "grinder",
        "juicer",
        "food processor"
      ]
    }
  },
  {
    "_index" : "products",
    "_type" : "_doc",
    "_id" : "207",
    "_score" : 1.0,
    "_source" : {
      "name" : "Fruit Juicer",
      "price" : 40,
      "in_stock" : 100,
      "tags" : [
        "kitchen appliances",
        "electicals",
        "juicer",
        "mixer",
        "electric juicer",
        "juice maker"
      ]
    }
  },
  {
    "_index" : "products",
    "_type" : "_doc",
    "_id" : "208",
    "_score" : 1.0,
    "_source" : {
      "name" : "Knife Set",
      "price" : 15,
      "in_stock" : 250,
      "tags" : [
        "kitchen knife",
        "steel knives",
        "cutlery"
      ]
    }
  },
  {
    "_index" : "products",
    "_type" : "_doc",
    "_id" : "209",
    "_score" : 1.0,
    "_source" : {
      "name" : "Rice Maker",
      "price" : 85,
      "in_stock" : 60,
      "tags" : [
        "kitchen appliances",
        "electricals",
        "electric rice cooker",
        "electric pressure cooker"
      ]
    }
  },
  {
    "_index" : "products",
    "_type" : "_doc",
    "_id" : "210",
    "_score" : 1.0,
    "_source" : {
      "name" : "Induction Cooktop",
      "price" : 30,
      "in_stock" : 150,
      "tags" : [
        "kitchen appliances",
        "electricals",
        "hot plate heater",
        "electric hot place",
        "induction cooker",
        "induction stove"
      ]
    }
  },
  {
    "_index" : "products",
    "_type" : "_doc",
    "_id" : "211",
    "_score" : 1.0,
    "_source" : {
      "name" : "Coffee Maker",
      "price" : 50,
      "in_stock" : 100,
      "tags" : [
        "kitchen appliances",
        "electricals"
      ]
    }
  },
  {
    "_index" : "products",
    "_type" : "_doc",
    "_id" : "212",
    "_score" : 1.0,
    "_source" : {
      "name" : "Wine Glasses Set",
      "price" : 50,
      "in_stock" : 70,
      "tags" : [
        "kitchen and dining",
        "glassware",
        "stemware"
      ]
    }
  },
  {
    "_index" : "products",
    "_type" : "_doc",
    "_id" : "213",
    "_score" : 1.0,
    "_source" : {
      "name" : "Dinner Set",
      "price" : 100,
      "in_stock" : 40,
      "tags" : [
        "kitchen and dining",
        "crockery",
        "full dinner set"
      ]
    }
  },
  {
    "_index" : "products",
    "_type" : "_doc",
    "_id" : "214",
    "_score" : 1.0,
    "_source" : {
      "name" : "Whiskey Glasses Set",
      "price" : 60,
      "in_stock" : 50,
      "tags" : [
        "kitchen and dining",
        "glassware",
        "whiskey glasses",
        "old fashioned glass",
        "rocks glass",
        "short tumbler"
      ]
    }
  },
  {
    "_index" : "products",
    "_type" : "_doc",
    "_id" : "215",
    "_score" : 1.0,
    "_source" : {
      "name" : "Mug And Saucer Set",
      "price" : 35,
      "in_stock" : 60,
      "tags" : [
        "kitchen and dining",
        "mug set",
        "mugs and saucer",
        "crockery set"
      ]
    }
  },
  {
    "_index" : "products",
    "_type" : "_doc",
    "_id" : "201",
    "_score" : 1.0,
    "_source" : {
      "name" : "Milk Frother",
      "price" : 25,
      "in_stock" : 15,
      "tags" : [
        "kitchen appliances",
        "electricals",
        "milk"
      ]
    }
  },
  {
    "_index" : "products",
    "_type" : "_doc",
    "_id" : "200",
    "_score" : 1.0,
    "_source" : {
      "name" : "Espresso Maker",
      "price" : 180,
      "in_stock" : 5,
      "tags" : [
        "kitchen appliances",
        "electrical",
        "coffee maker"
      ]
    }
  },
  {
    "_index" : "products",
    "_type" : "_doc",
    "_id" : "204",
    "_score" : 1.0,
    "_source" : {
      "name" : "Pressure Fryer",
      "price" : 120,
      "in_stock" : 50,
      "tags" : [
        "air fryer",
        "kitchen appliances",
        "electric fryer",
        "fryer",
        "health fryer"
      ]
    }
  }
]
  }
}

使用下面的查询查询数据时,我只匹配六条记录:查询-1

代码语言:javascript
复制
GET /products/_search
{
  "query": {"terms" : {"tags": ["kitchen appliances","electricals"]}}
}

文档id的匹配为(201,205,206,209,210,211)

当我执行以下查询时,我将匹配11条记录:查询-2

代码语言:javascript
复制
GET /products/_search
{
  "query": {"terms" : {"tags.keyword": ["kitchen appliances","electricals"]}}
}

与第二个查询匹配的文档id为:(200,201,202,203,204,205,206,207,209,210,211)

有人能解释两个查询之间的区别吗?为什么Query-1是Query-2的一个子集,即使这两个查询都在同一个字段上执行?

EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2021-04-19 05:10:32

如果您有一个match text 类型字段,最好使用查询.

术语查询不对这个术语进行任何分析。它返回包含精确术语匹配文档的文档。

术语查询在精确的条件下工作。它返回具有一个或更多精确术语的文档。

查询1:

代码语言:javascript
复制
{
  "query": {
    "terms": {
      "tags": [
        "kitchen appliances",
        "electricals"
      ]
    }
  }
}

搜索结果是

代码语言:javascript
复制
"hits": [
      {
        "_index": "67155973",
        "_type": "_doc",
        "_id": "3",
        "_score": 1.0,
        "_source": {
          "name": "Microwave Oven",
          "price": 100,
          "in_stock": 50,
          "tags": [
            "kitchen appliances",
            "electricals",
            "oven",
            "oven toaster",
            "microwave"
          ]
        }
      },
      {
        "_index": "67155973",
        "_type": "_doc",
        "_id": "4",
        "_score": 1.0,
        "_source": {
          "name": "Mixer Grinder",
          "price": 55,
          "in_stock": 130,
          "tags": [
            "kitchen appliances",
            "electricals",
            "mixer",
            "grinder",
            "juicer",
            "food processor"
          ]
        }
      },
      {
        "_index": "67155973",
        "_type": "_doc",
        "_id": "7",
        "_score": 1.0,
        "_source": {
          "name": "Rice Maker",
          "price": 85,
          "in_stock": 60,
          "tags": [
            "kitchen appliances",
            "electricals",
            "electric rice cooker",
            "electric pressure cooker"
          ]
        }
      },
      {
        "_index": "67155973",
        "_type": "_doc",
        "_id": "8",
        "_score": 1.0,
        "_source": {
          "name": "Induction Cooktop",
          "price": 30,
          "in_stock": 150,
          "tags": [
            "kitchen appliances",
            "electricals",
            "hot plate heater",
            "electric hot place",
            "induction cooker",
            "induction stove"
          ]
        }
      },
      {
        "_index": "67155973",
        "_type": "_doc",
        "_id": "9",
        "_score": 1.0,
        "_source": {
          "name": "Coffee Maker",
          "price": 50,
          "in_stock": 100,
          "tags": [
            "kitchen appliances",
            "electricals"
          ]
        }
      },
      {
        "_index": "67155973",
        "_type": "_doc",
        "_id": "14",
        "_score": 1.0,
        "_source": {
          "name": "Milk Frother",
          "price": 25,
          "in_stock": 15,
          "tags": [
            "kitchen appliances",
            "electricals",
            "milk"
          ]
        }
      }
    ]

正如文档中提到的

术语查询不分析搜索项。术语查询只搜索所提供的确切术语。这意味着在搜索文本字段时,术语查询可能返回差的结果或没有结果。

查询2:

代码语言:javascript
复制
{
  "query": {
    "terms": {
      "tags.keyword": [
        "kitchen appliances",
        "electricals"
      ]
    }
  }
}

在上面的查询中,您使用的是tags.keyword 字段,它使用关键字分析器而不是标准分析器。在这里,查询搜索确切的术语,即"kitchen appliances"、或 "electricals"**,,因此返回11个文档。

票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/67155973

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档