Elasticsearch Array Comparison

Question

I'm new to elasticsearch, so be kind.

I'm trying to store and query data, which is tagged with N number of tags. I want to compare a search query array with the stored array and return the results in order of which items match the most tags.

Dataset example:

{ name: "karl", tags: ["terrible", "programmer"] }
{ name: "bob", tags: ["awesome", "programmer"] }

Query example, matching both people:

query: { tags: ["programmer"] }
result: [karl, bob]

And in this example, both are returned but bob scores high, because more tags were matched, Karl is still shown though, despite not matching on awesome.

query: { tags: ["programmer", "awesome"] }
result: [bob, karl]

The closet I have got is this, however it doesn't seem to score bob higher than karl

{
  "query": {
    "bool": {
      "should": [
        { "match": { "tags": "programmer" } },
        { "match": { "tags": "awesome" } }
       ],
      "minimum_number_should_match": 1
    }
  }
}

Would love some support :-) Thanks!

Both queries in your question will give higher score to more matches. Can you add actual result of the query and expected result — jaspreet chahal
– jaspreet chahal, Commented Mar 31, 2020 at 9:56

Jozef - Spatialized.io · Accepted Answer · 2020-03-31 19:23:35Z

2

It does score bob significantly higher than karl:

If you wanna match both of the tags, increase the minimum operator:

Which is essentially the same as a bunch of bool-musts:

GET karl/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "tags": "programmer"
          }
        },
        {
          "match": {
            "tags": "awesome"
          }
        }
      ]
    }
  }
}

answered Mar 31, 2020 at 19:23

Jozef - Spatialized.io

17k4 gold badges29 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Claudio · Accepted Answer · 2020-04-03 14:18:06Z

0

If you need to have only the document that match both (or even more) tags, you need to use a must query (https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-query.html) Your query looks like:

{
  "query": {
    "bool": {
      "must": [
        { "match": { "tags": "programmer" } },
        { "match": { "tags": "awesome" } }
       ]
    }
  }
}

answered Apr 3, 2020 at 14:18

Claudio

6524 silver badges13 bronze badges

Collectives™ on Stack Overflow

Elasticsearch Array Comparison

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related