Help me modify this query so that it can find out the matches which contain N terms in a specific order as opposed to all matches possible which contain the N terms

Elastic Stack Elasticsearch
1

This is what I had, this can query for phrases but they will always be in any order

{'query': {'bool': {'should': [{'bool': {'must': [{'match_phrase': {'data': 'word1'}}, {'match_phrase': {'data': 'word2'}}]}}]}}, 'from': 0, 'size': 9000}

The results returned by the above are:

bla bla word1 word2 bla
X Y word2 word1 bla bla
MNO bla bla word1 word2
ABC word1 word2 bla bla

The results I want for a given query of (word1,word2) are:

bla bla word1 word2 bla
ABC word1 word2 bla bla
MNO bla bla word1 word2

Similarly, for a query of (word2,word1), I want the results:

X Y word2 word1 bla bla

Can someone please tell me how to fix this query to include order of sequences

2

Hi,

You may want to look at Intervals Queries. One possible way to rewrite the query you provided is as follows:

GET my_index/_search
{
  "query": {
    "intervals": {
      "data": {
        "match": {
          "ordered": "true",
          "query": "word1 word2"
        }
      }
    }
  }
}

There are probably a few other ways to approach using word order in queries, so let me know if this doesn't solve your problem.

-William

1 Like
3

Hi William,

Thank you for your prompt response.

I'm using the python API. If I do a search of this form:

body = {
  "query": {
    "intervals": {
      "data": {
        "match": {
          "ordered": "true",
          "query": "word1 word2"
        }
      }
    }
  }
}
result = es.search(index=index, body=body)

I get an error:

RequestError(400, 'parsing_exception', 'no [query] registered for [intervals]')

4

Apparently, match_phrase is a solution but according to this article this is not the case:

body = {
    "query": {
        "multi_match" : {
            "query": "word1 word2",
            "fields": ["data"],
            "type": "phrase",
            "slop": 9999
        }
    }
}

Just tried this, can confirm, that it gives same results regardless of order of words considered.

5

Intervals query was introduced in Elasticsearch 7.0 I believe. Which version are you using?

6

If it's a version thing, I think I could be using an older one, any way I could check?

7

Running curl localhost:9200 should give you the version number.

8

If you have the URL of your elasticsearch instance, you can curl it or enter it in a browser to see version information. You should see something like this:

{
  "name" : "...",
  "cluster_name" : "...",
  "cluster_uuid" : "...",
  "version" : {
    "number" : "7.2.0",
    "build_flavor" : "default",
    "build_type" : "tar",
    "build_hash" : "508c38a",
    "build_date" : "2019-06-20T15:54:18.811730Z",
    "build_snapshot" : false,
    "lucene_version" : "8.0.0",
    "minimum_wire_compatibility_version" : "6.8.0",
    "minimum_index_compatibility_version" : "6.0.0-beta1"
  },
  "tagline" : "You Know, for Search"
}
9

And I apologize for not mentioning that Intervals queries are a somewhat new feature.

10

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.