Compond query with Elasticsearch

Question

I'm trying to perform a search with the intended criteria being (activationDate in range 1598889600 to 1602051579) or someFlag=true.

Below is the query I tried, but it does not yield any records with someFlag=true (even with a big size, e.g. 5000). My Elasticsearch does have a lot of records with someFlag=true.

There are about 3000 total documents and this query returns around 280 documents.

{
  "query": {
    "bool": {
      "must": [
        {
          "range": {
            "activationDate": {
              "gte": 1598889600
            }
          }
        },
        {
          "range": {
            "activationDate": {
              "lte": 1602051579
            }
          }
        }
      ],
      "should": {
        "match": {
          "someFlag": true
        }
      }
    }
  },
  "from": 1,
  "size": 1000
}

Am I missing something?

Evaldas Buinauskas · Accepted Answer · 2020-10-07 06:52:24Z

1

This should work:

{
  "query": {
    "bool": {
      "filter": [
        {
          "bool": {
            "should": [
              {
                "range": {
                  "activationDate": {
                    "gte": 1598889600,
                    "lte": 1602051579
                  }
                }
              },
              {
                "term": {
                  "someFlag": true
                }
              }
            ]
          }
        }
      ]
    }
  }
}

In theory this should do the same:

{
  "query": {
    "bool": {
      "should": [
        {
          "range": {
            "activationDate": {
              "gte": 1598889600,
              "lte": 1602051579
            }
          }
        },
        {
          "term": {
            "someFlag": true
          }
        }
      ]
    }
  }
}

However the first query I've given wraps bool clause within a filter context (so that it does not need to score and query becomes cacheable).

Your bool query might have not worked because you were using match query, not term. match is normally used for text search only.

answered Oct 7, 2020 at 6:52

Evaldas Buinauskas

14.2k11 gold badges63 silver badges119 bronze badges

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

1 Comment

Akshay Maldhure Over a year ago

Thanks. If I replace term with match in your second query, that works too.

ibexit · Accepted Answer · 2020-10-07 06:41:01Z

1

Replace the must with an should and set minimum_should_match=1 as is is an OR query and you are fine if just one of the ceiterias is met by any record. Next reduce the two range criterias to just one, where you combine gte and lte.

answered Oct 7, 2020 at 6:41

ibexit

3,7121 gold badge14 silver badges27 bronze badges

1 Comment

Akshay Maldhure Over a year ago

{ "query": { "bool": { "should": [ { "range": { "activationDate": { "gte": 1598889600, "lte": 1602051579 } } }, { "match": { "someFlag": true } } ], "minimum_should_match": 1 } }, "from": 1, "size": 1000 } Like this? This works.

Collectives™ on Stack Overflow

Compond query with Elasticsearch

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related