Elasticsearch return error when querying a nested field

Question

I have some indexed data in elastic search, I am trying to use postman to get the data using the below request.

{
"_source": ["_id"],
"query":  {
    "nested" : {
        "path" : "data",
        "query" : {
            "bool" : {
                "must" : [
                { "match" : {"data.id": "3456"} }
                ]
            }
        },
        "score_mode" : "avg"
    }
}

}

But I am getting the exception

[nested] nested object under path [data] is not of nested type

My mapping definition is like

    {
  "property": {
    "mappings": {
      "property": {
        "properties": {
          "data": {
            "properties": {
              "id": {
                "type": "text",
                "fields": {
                  "keyword": {
                    "type": "keyword",
                    "ignore_above": 256
                  }
                }
              }
            }
          },
          "point": {
            "properties": {
              "lat": {
                "type": "float"
              },
              "lon": {
                "type": "float"
              }
            }
          },
          "popId": {
            "type": "text",
            "fields": {
              "keyword": {
                "type": "keyword",
                "ignore_above": 256
              }
            }
          }
        }
      }
    }
  }
}

Any idea why it is happening ?

What is your elastic version? and where is destinations nested object in your mappings? — Assael Azran
– Assael Azran, Commented Nov 13, 2019 at 13:34
Robin please add a copy-paste of the real mapping ( from GET <your_index>/_mapping . What you added seems to be a "handwritten" mapping. Plus: you certainly did not add the correct query to your question since the error mentions a "destination" path when your query to not mention it. — Pierre Mallet
– Pierre Mallet, Commented Nov 13, 2019 at 13:38

Assael Azran · Accepted Answer · 2019-11-13 14:25:55Z

Field data is an object so it should be of type nested.

Nested Type

Try these mapping configurations instead:

PUT property
{
  "mappings": {
    "property": {
      "properties": {
        "point": {
          "properties": {
            "lat": {
              "type": "float"
            },
            "lon": {
              "type": "float"
            }
          }
        },
        "popId": {
          "type": "text",
          "fields": {
            "keyword": {
              "type": "keyword",
              "ignore_above": 256
            }
          }
        },
        "data": {
          "type": "nested",
          "properties": {
            "id": {
              "type": "text",
              "fields": {
                "keyword": {
                  "type": "keyword",
                  "ignore_above": 256
                }
              }
            }
          }
        }
      }
    }
  }
}

You will have to delete your index and recreate it with the new mapping configurations.

If you don't want to delete your data this might help

Hope it helps

Collectives™ on Stack Overflow

Elasticsearch return error when querying a nested field

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