Why isn't this elasticsearch query matching a string exactly?

Question

I have an elasticsearch query that isn't matching a document that it should.

Here is the query:

POST _search
{
   "query": {
      "filtered": {
         "filter": {
            "bool": {
               "must": {
                  "term": {
                     "signupCompany": "NewBay Media"
                  }
               }
            }
         }
      }
   }
}

However, if I change the term to:

"signupCompanyID": 643

Then it finds the correct document. Here is my mapping:

"properties": {
      "body": {
        "type": "string"
      },
      "datetimeIndexed": {
        "type": "date",
        "format": "epoch_millis||yyyy/MM/dd HH:mm:ss||yyyy/MM/dd"
      },
      "datetimeReceived": {
        "type": "date",
        "format": "epoch_millis||yyyy/MM/dd HH:mm:ss||yyyy/MM/dd"
      },
      "duplicateOfEmailID": {
        "type": "long"
      },
      "enabled": {
        "type": "boolean"
      },
      "htmlBodyPath": {
        "type": "string"
      },
      "plainBodyPath": {
        "type": "string"
      },
      "secondsAgoReceived": {
        "type": "long"
      },
      "senderName": {
        "type": "string",
        "fields": {
          "raw": {
            "type": "string",
            "index": "not_analyzed"
          }
        }
      },
      "signupCompany": {
        "type": "string"
      },
      "signupCompanyEnabled": {
        "type": "boolean"
      },
      "signupCompanyID": {
        "type": "long"
      },
      "signupCompanyInitial": {
        "type": "string"
      },
      "subject": {
        "type": "string"
      }
    }

I have some other queries that are already working and in production, using the datetimeReceived field and enabled field, but haven't been able to get this particular string match to work.

It won't work with any signupCompany, not just this one.

Possible duplicate of How to make exact values and match queries on same field in elasticsearch? — Amir Raminfar
– Amir Raminfar, Commented Jan 11, 2016 at 1:43

court3nay · Accepted Answer · 2016-01-11 01:35:28Z

1

You need to set the mapping type for signupCompany to not_analyzed so that it doesn't try to match a partial string, only the exact value. - docs: https://www.elastic.co/guide/en/elasticsearch/guide/current/mapping-intro.html

"signupCompany": {
  "type":     "string",
  "index":    "not_analyzed"
}

answered Jan 11, 2016 at 1:35

court3nay

2,3651 gold badge13 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

Why isn't this elasticsearch query matching a string exactly?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related