Elasticsearch nested object query_string

Question

I have question about query_string query in ElasticSearch. I want create fulltext search over all types and fields in index. Is query_string string performed against nested objects ? For example I have this mapping

 {
  "my_index": {
    "mappings": {
      "my_type": {
        "properties": {
          "group": {
            "type": "string"
          },
          "user": {
            "type": "nested",
            "properties": {
              "first": {
                "type": "string"
              },
              "last": {
                "type": "string"
              }
            }
          }
        }
      }
    }
  }
}

And the query

GET /my_index/_search
{
  "query": {
      "query_string" : {
          "query" : "paul"
      }
    }

}

So when I call the query, will ES search across all fields including nested or only in my_type object and for nested search I will have to use nested query ?

anthonybruni · Accepted Answer · 2016-12-06 14:13:40Z

2

You cannot reference nested fields from a query_string at the root. i.e. this won't work:

{
    "query": {
         "query_string": {
          "query": "myNestedObj.myTextField:food"
         }
   }
}

To search in specific nested fields, you must use the nested clause:

{
    "query": {
      "nested": {
        "path": "myNestedObj",
        "query": {
         "query_string": {
          "query": "myNestedObj.myTextField:food"
         }
        }
      }
    }
  }
}

However, I've found that the pseudo-field "_all" does include nested fields, so this query would find documents containing 'food' in myNestedObj.myTextField (as well as anywhere else)

{
    "query": {
         "query_string": {
          "query": "_all:food"
         }
   }
}

answered Dec 6, 2016 at 14:13

anthonybruni

361 bronze badge

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

1 Comment

Pauli Over a year ago

Thanks @anthonybruni , "However, I've found that the pseudo-field "_all" does include nested fields, so this query would find documents containing 'food' in myNestedObj.myTextField (as well as anywhere else)" this answer was exactly what I was asking for

core · Accepted Answer · 2016-12-05 21:43:36Z

0

Try:

GET my_index/_search?q=paul

answered Dec 5, 2016 at 21:43

core

8711 gold badge9 silver badges28 bronze badges

Collectives™ on Stack Overflow

Elasticsearch nested object query_string

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related