How to update nested objects in Elasticsearch 2.2 script via Java API

Question

I'm trying to update a nested object in Elasticsearch via the Java API, using a technique similar to what is outlined here. The problem is how to pass the json into the script. If I just blindly concatenate the json to the script string as suggested here, the Groovy does not compile. If you pass it in directly as a parameter, it just gets parsed as a string. If I try to use JsonSlurper, like:

String script = "ctx._source.pete = new groovy.json.JsonSlurper().parseText(json)";
Map<String, Object> params = ImmutableMap.of("json", json);
return new Script(script, ScriptService.ScriptType.INLINE, null, params);

I get a compilation exception: unable to resolve class groovy.json.JsonSlurper

A further problem with the JsonSlurper approach seems to be that the Elasticsearch team has basically disabled it in 2.2.

Does anyone know how to pass the json in correctly via the Java API?

can you try to add import groovy.json.JsonSlurper; at the beginning of your script? Just to see if that compilation error gets out? — Val
– Val, Commented Mar 1, 2016 at 16:38
Was worth a try, though it's pretty clear why this has been disabled and why the ES folks stand firm by that decision. — Val
– Val, Commented Mar 1, 2016 at 16:43

PeteyPabPro · Accepted Answer · 2016-03-03 05:28:18Z

4

Thanks to the guys at Elasticsearch for helping me with this. The answer is to convert the JSON to a Map and then just pass the Map as a param:

String script = "ctx._source.pete = jsonMap";
Map<? ,?> jsonMap = new ObjectMapper().readValue(json, HashMap.class);
Map<String, Object> params = ImmutableMap.of("jsonMap", jsonMap);
return new Script(script, ScriptService.ScriptType.INLINE, null, params);

I'm using org.codehaus.jackson.map.ObjectMapper to do the conversion from JSON to the Map.

edited Mar 3, 2016 at 5:28

answered Mar 1, 2016 at 17:27

PeteyPabPro

84910 silver badges18 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:32:17Z

-1

I have written an extensive answer on that subject on StackOverflow in this thread. Instead of a script, I used the UpdateRequest class in Java, which you have to feed with a XContentBuilder object containing all the changes you wish to perform.

This is a snippet of the answer:

UpdateRequest updateRequest = new UpdateRequest();
//....
XContentBuilder jb = XContentFactory.jsonBuilder();
jb.startObject();
jb.startArray("..");

for ( /**/) {
   jb.startObject()
   .field("attrX", value)
   // ..
   .startObject("attrY")
   .field("attrZ", value)
   .endObject()
   .field("atrrW", value)
   .endObject();
}
jb.endArray();
b.endObject();
updateRequest.doc(jb);

edited May 23, 2017 at 12:32

CommunityBot

11 silver badge

answered May 6, 2016 at 12:47

KLaz

8125 silver badges20 bronze badges

Collectives™ on Stack Overflow

How to update nested objects in Elasticsearch 2.2 script via Java API

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related