java elasticsearch 使用painless 脚本更新字段

        在上一篇mongo中提过，我们有增量更新的需求，mongo因为深层嵌套，更新麻烦，于是采用先删除后新增的方法。同样的，es也存在深层嵌套的数据。这部分数据同样不易更新，也是在开始的时候尝试过，虽然后来和mongo同样采取了先删除后新增的方式，但这深层嵌套的更新方式还是想要记录一下

       首先，下面是数据结构

{"_index" : "test_index","_type" : "_doc","_id" : "1","_score" : 1.0,"_source" : {"id" : "1","name" : "哈哈哈","pageView" : 0,"personCerts" : [{"certNo" : "333""regMajor" : "321","regType" : "231"},{"certNo" : "334""regMajor" : "322","regType" : "233},{"certNo" : "335""regMajor" : "323","regType" : "231}]}
}

我想修改 certNo = 333 的嵌套文档，使 regMajor = 000 , regType = 111 ,因为personCerts 的数组长度为3，想要匹配到 333 ，我使用了 for循环 , 语句如下

POST test_index/_update/1
{"script": {"source": """ def targets = ctx._source.personCerts
.findAll(personCert -> personCert.certNo == params.personCerts.certNo);for(personCert in targets) { personCert.regMajor     = params.personCerts.regMajor ;personCert.regType      = params.personCerts.regType ;}""","lang": "painless","params": {"personCerts": {"regMajor": "000","regType":"111","certNo":"333"}}}
}

java 写法如下

Map<String,Object> personCert = new HashMap<>();
personCert.put("regMajor" ,"000");
personCert.put("regType"  ,"111");
personCert.put("certNo"   ,"333");
Map<String, Object> personCerts = Collections.singletonMap("personCerts",personCert);Script inline = new Script(ScriptType.INLINE, "painless","def targets = ctx._source.personCerts.findAll(personCert -> personCert.certNo == params.personCerts.certNo ); " +"for(personCert in targets) { " +"personCert.regMajor = params.personCerts.regMajor ;" +"personCert.regType  = params.personCerts.regType  ;" +"}", personCerts);executeScript(inline,"test_index","1")

public void executeScript(Script inline, String id, String index) {UpdateRequest request = new UpdateRequest( index,  id);request.script(inline);try{UpdateResponse response = restHighLevelClient.update(request, RequestOptions.DEFAULT);log.info("...... result status {} ...... ",response.status().getStatus());}catch (Exception e){log.info("...... execute script failed ...... ");}}