How to create a mapping for dynamic keys in elasticsearch

Question

If I put a document like this:

$ curl -XPOST "http://localhost:9200/test/test/" -d '
{
  "books": {
    "id1": {
        "name": "Hello World!"
    },
    "id2": {
        "name": "Hitchhiker Guide To The Galaxy"
    }
  }
}'

Then it creates a mapping like this:

$ curl -XGET "http://localhost:9200/test/test/_mapping"
{
  "test":{
    "mappings":{
      "test":{
        "properties":{
          "books":{
            "properties":{
              "id1":{
                "properties":{
                  "name":{
                    "type":"string"
                  }
                }
              },
              "id2":{
                "properties":{
                  "name":{
                    "type":"string"
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}

The properties / keys in the "books" object are dynamic and the mapping will grow endlessly. How can I make ES not look at the keys for "books" and make it understand that each value in "books" is of the same type? E.g. the mapping should not contain a new entry for each book id.

And why are you doing this? Why is the list of keys endlessly? Do you not give a meaning to this property? — Roeland Van Heddegem
– Roeland Van Heddegem, Commented Jun 23, 2015 at 11:49
Per document, there are like 1-5 entries in the map ("books" in this specific example). But because the ids are different for each document - the mapping continues to grow. — sebdehne
– sebdehne, Commented Jun 23, 2015 at 11:51
Why don't you make a property id and store the id number there? I think you are trying to solve this problem in the wrong way. Just my 2c. — Roeland Van Heddegem
– Roeland Van Heddegem, Commented Jun 23, 2015 at 12:27

NikoNyrh · Accepted Answer · 2015-10-20 07:25:32Z

-1

You can store only one document at a time, unless you use bulk upload. A single document could look like this:

$ curl -XPOST "http://localhost:9200/test/test/" -d '
{
    "id": "id1",
    "name": "Hello World!"
}'

Or:

$ curl -XPOST "http://localhost:9200/test/test/id1" -d '
{
    "name": "Hello World!"
}'

answered Oct 20, 2015 at 7:25

NikoNyrh

4,2084 gold badges21 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

How to create a mapping for dynamic keys in elasticsearch

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related