How to create and add nested object into nested field in Elasticsearch?

Question

https://www.elastic.co/guide/en/elasticsearch/reference/current/nested.html

Consider:

PUT my_index
{
  "mappings": {
    "_doc": {
      "properties": {
        "user": {
          "type": "nested" 
        }
      }
    }
  }
}

PUT my_index/_doc/1
{
  "group" : "fans",
  "user" : [
    {
      "first" : "John",
      "last" :  "Smith"
    },
    {
      "first" : "Alice",
      "last" :  "White"
    }
  ]
}

When I run a painless script like:

ctx._source.user.add({
    "first" : "Foo",
    "last" : "Bar"
})

It is not working. I tried but cannot find any related documents or discussion started by other.

tom10271 · Accepted Answer · 2020-12-22 12:52:50Z

16

https://www.elastic.co/guide/en/elasticsearch/reference/5.4/modules-scripting-painless-syntax.html#painless-maps

You can create a map like ['first': 'Foo', 'last': 'Bar', 'sthElse': 100] then add it.

So:

ctx._source.user.add([
    "first" : "Foo",
    "last" : "Bar"
])

Please note that map in painless can be mixed type.

edited Dec 22, 2020 at 12:52

answered Mar 20, 2018 at 6:56

tom10271

4,6897 gold badges41 silver badges69 bronze badges

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

Comments

Bharat · Accepted Answer · 2018-03-20 07:34:48Z

5

POST my_index/_doc/1/_update
{
   "script": {
      "lang": "painless",
      "inline": "ctx._source.user.add(params.object)",
      "params": {
         "object": {
            "first" : "Foo",
            "last" : "Bar"
         }
      }
   }
}

edited Mar 20, 2018 at 7:34

answered Mar 20, 2018 at 7:32

Bharat

1624 bronze badges

4 Comments

tom10271 Over a year ago

No I need to create my nested object dynamically.

Bharat Over a year ago

Please elaborate what you want to do.

tom10271 Over a year ago

I have solution already as mentioned below. stackoverflow.com/a/49378001/2736817

ndtreviv Over a year ago

I like this. Could my params.object be a JsonData.of(myObject) where myObject is a Java record, for example?

Collectives™ on Stack Overflow

How to create and add nested object into nested field in Elasticsearch?

2 Answers 2

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related