How to search in multiple fields in elasticsearch?

Question

Suppose I have documents with the following structure.

{
  "text": "This is the road I mentioned",
  "created_at": "2015-01-11T05:30:36.000Z",
  "language": "en",
  "character_count": 25,
  "userInfo": {
    "id": 553669398108446700,
    "user_id": 2803103316,
    "user_screen_name": "blue555555"
  }
}

I need to search for a keyword say "road" in the field "text" and another keyword "blue555555" in the field "user_screen_name". This is basically searching on multiple fields, how can I do that in elasticsearch?

Val · Accepted Answer · 2016-01-14 06:56:55Z

1

You can use a combination of match and term queries inside a bool/must query so that both constraints match.

{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "text": "road"
          }
        },
        {
          "term": {
            "userInfo.user_screen_name": "blue555555"
          }
        }
      ]
    }
  }
}

answered Jan 14, 2016 at 6:56

Val

218k14 gold badges377 silver badges384 bronze badges

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

Comments

Vineeth Mohan · Accepted Answer · 2016-02-21 05:16:39Z

1

As one of the search is of query behavior and other is filter behavior , I would suggest filtered query.

{
  "query": {
    "filtered": {
      "query": {
        "match": {
          "text": "road"
        }
      },
      "filter": {
        "term": {
          "userInfo.user_screen_name": "blue555555"
        }
      }
    }
  }

}

answered Feb 21, 2016 at 5:16

Vineeth Mohan

19.4k9 gold badges70 silver badges81 bronze badges

Collectives™ on Stack Overflow

How to search in multiple fields in elasticsearch?

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