ElasticSearch simple query

Question

I have structure like this in my ElasticSearch

{
        _index: 'index',
        _type: 'product',
        _id: '896',
        _score: 0,
        _source: {
          entity_id: '896',
          category: [
            {
              category_id: 2,
              is_virtual: 'false'
            },
            {
              category_id: 82,
              is_virtual: 'false'
            }
          ]
        }
      }

I want return all "producs" that have "82" category_id.

{
  "query": {
    "bool": {
      "filter": {
        "terms": {
          "category.category_id": [
            82
          ]
        }
      }
    }
  }
}

This query gives me 0 hits.

What is right way to do this?

score 2 · Accepted Answer · 2020-06-04 06:45:47Z

Adding working example, you need to define the category as nested field and modify your search query by including the nested path

Index Mapping

{
    "mappings": {
        "properties": {
            "entity_id": {
                "type": "text"
            },
            "category": {
                "type": "nested"
            }
        }
    }
}

Index your document

{
    "entity_id": "896",
    "category": [
        {
            "category_id": 2,
            "is_virtual": false
        },
        {
            "category_id": 82,
            "is_virtual": false
        }
    ]
}

Proper search query, note we are using nested query which doesn't support normal filter(so your query gives error)

{
    "query": {
        "nested": {
            "path": "category",
            "query": {
                "bool": {
                    "must": [
                        {
                            "match": {
                                "category.category_id": 82
                            }
                        }
                    ]
                }
            }
        }
    }
}

Search result retuns indexed doc

 "hits": [
            {
                "_index": "complexnested",
                "_type": "_doc",
                "_id": "1",
                "_score": 1.0,
                "_source": {
                    "entity_id": "896",
                    "category": [
                        {
                            "category_id": 2,
                            "is_virtual": false
                        },
                        {
                            "category_id": 82,
                            "is_virtual": false
                        }
                    ]
                }
            }
        ]

Given his query doesn't return anything, it probably means that category is already nested, but he is not using a nested query. So I conclude that his mapping is right, but his query is not
ok you mean if category wasn't nested then his query would have returned the reult?
Yes, it would have returned something because it is a query on a simple object field
@Val, yeah but he has not provided his mapping so I thought of mentioning this but got your point.

Val · Accepted Answer · 2020-06-04 06:59:58Z

1

If your query gives you no results, I suspect that category is of type nested in your index mapping. If that's the case, that's good and you can modify your query like this to use the nested query:

{
  "query": {
    "bool": {
      "filter": {
        "nested": {
          "path": "category",
          "query": {
            "terms": {
              "category.category_id": [
                82
              ]
            }
          }
        }
      }
    }
  }
}

edited Jun 4, 2020 at 6:59

answered Jun 4, 2020 at 6:16

Val

218k14 gold badges377 silver badges384 bronze badges

Collectives™ on Stack Overflow

ElasticSearch simple query

2 Answers 2

Index Mapping

Index your document

Proper search query, note we are using nested query which doesn't support normal filter(so your query gives error)

Search result retuns indexed doc

8 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Index Mapping

Index your document

Proper search query, note we are using nested query which doesn't support normal filter(so your query gives error)

Search result retuns indexed doc

8 Comments

Comments

Related