Elasticsearch: nested object under path is not of nested type

Question

I've been trying to search on my document which contains a nested field. I created the nested mapping like this:

{
  "message": {
    "properties": {
      "messages": {
        "type": "nested",
        "properties": {
          "message_id": { "type": "string" },
          "message_text": { "type": "string" },
          "message_nick": { "type": "string" }
        }
      }
    }
  }
}

My search looks like this:

curl -XGET 'localhost:9200/thread_and_messages/thread/_search' \
     -d '{"query": {"bool": {"must": [{"match": {"thread_name": "Banana"}}, {"nested": {"path": "messages", "query": {"bool": {"must": [{"match": {"messages.message_text": "Banana"}}]}}}]}}}}'

Yet I am receiving this error message:

QueryParsingException[[thread_and_messages] [nested] nested object under path [messages] is not of nested type]

EDIT

I am still receiving this error. I am doing this via Java so this is the document I am trying to create:

{
  "_id": {
    "path": "3",
    "thread_id": "3",
    "thread_name": "Banana",
    "created": "Wed Mar 25 2015",
    "first_nick": "AdminTech",
    "messages": [
      {
        "message_id": "9",
        "message_text": "Banana",
        "message_nick": "AdminTech"
      }
    ]
  }
}

Creating the index like so:

CreateIndexRequestBuilder indexRequest = client.admin().indices().prepareCreate(INDEX).addMapping("message", mapping);

I think I am possibly indexing the document incorrectly.

Babken Vardanyan · Accepted Answer · 2017-05-07 11:08:56Z

33

TLDR: Put "type": "nested", in your nested type.

Say we have a normal type, and another type nested in it:

{
   "some_index": {
      "mappings": {
         "normal_type": {
            "properties": {
               "nested_type": {
                  "type": "nested",
                  "properties": {
                     "address": {
                        "type": "string"
                     },
                     "country": {
                        "type": "string"
                     }
                  }
               },
               "first_name": {
                  "type": "string"
               },
               "last_name": {
                  "type": "string"
               }
            }
         }
      }
   }
}

The "type": "nested", line is required for the nested queries to work which have "path": assigned to nested_type, like this:

GET /some_index/normal_type/_search
{
  "query": {
    "nested": {
      "query": {
        "bool": {}
      },
      "path": "nested_type"
    }
  }
}

The "type": "nested", line seems to be required in newer Elasticsearch versions only (since 1.1.1 ?).

edited May 7, 2017 at 11:08

answered Apr 20, 2015 at 13:24

Babken Vardanyan

15.3k15 gold badges80 silver badges91 bronze badges

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

1 Comment

MrMartin Over a year ago

But the OP already has "type": "nested". Is it in the wrong place? I'm having the same issue

Royer Adames · Accepted Answer · 2022-03-29 03:07:30Z

1

If your field is type object you will need to use the flatten name <object name>.<object key> has if it was a normal variable. For example:

Not this

{
  "nested":
  {
    "path":"album",
    "query":{
      "bool":{
        "boost":5,
        "should":[{"match":{"album.name":"lady"}}]
      }
    }
  }
},

Yes to this

{
  "match":{
    "genre":{
      "query":"lady",
      "boost":2
    }
  }
},

In meme form:

edited Mar 29, 2022 at 3:07

answered Mar 29, 2022 at 3:00

Royer Adames

1,08414 silver badges13 bronze badges

Comments

Kalpesh Soni · Accepted Answer · 2019-09-18 16:28:08Z

0

Syntax error in query DSL. Incorrect closing for must block query->bool->must

{
    "query": {
        "bool": {
                "must": [

            }// Should be ] 
        }
    }
}

Correct version query are :

curl -XGET 'localhost:9200/thread_and_messages/thread/_search' -d '{
   "query": {
      "bool": {
         "must": [
            {
               "match": {
                  "thread_name": "Banana"
               }
            },
            {
               "nested": {
                  "path": "messages",
                  "query": {
                     "bool": {
                        "must": [
                           {
                              "match": {
                                 "messages.message_text": "Banana"
                              }
                           }
                        ]
                     }
                  }
               }
            }
         ]
      }
   }
}'

edited Sep 18, 2019 at 16:28

Kalpesh Soni

7,3672 gold badges58 silver badges64 bronze badges

answered Mar 30, 2015 at 13:18

Roopendra

7,75716 gold badges72 silver badges95 bronze badges

2 Comments

Daniel Buckle Over a year ago

I have made an edit to my original post since I am still receiving the error.

Sebastialonso Over a year ago

This code is wrong. "path" field should be "messages", not "message".

Collectives™ on Stack Overflow

Elasticsearch: nested object under path is not of nested type

3 Answers 3

1 Comment

Not this

Yes to this

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Not this

Yes to this

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related