由于编辑数据,导致有些数据中,添加了脏数据,现在想删除这些脏数据(包括对应的key)
public void update() throws IOException {
SearchRequest searchRequest = new SearchRequest("tablename");
SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
BoolQueryBuilder builder = new BoolQueryBuilder();
builder.must(QueryBuilders.termQuery("_id", "zzzzzzxxxxxxx"));
searchSourceBuilder.query(builder);
searchRequest.source(searchSourceBuilder);
SearchResponse searchResponse = elasticsearchClient.search(searchRequest, RequestOptions.DEFAULT);
for (SearchHit hit : searchResponse.getHits().getHits()) {
String id = hit.getId();
String index = hit.getIndex();
Map<String, Object> sourceAsMap = hit.getSourceAsMap();
// 使用 UpdateRequest 和 Script 对象来执行更新操作
UpdateRequest request = new UpdateRequest(index, id);
request.scriptedUpsert(true);
request.script(new Script(ScriptType.INLINE, "painless",
"ctx._source.remove('xxxx.yyy'); ctx._source.remove('xxx.zzz');" +
"ctx._source.remove('xxxx.aaaa');",
Collections.emptyMap()));
request.fetchSource(true); // 如果希望获取最新的结果,可以设置为 true
// 执行更新操作
UpdateResponse updateResponse = elasticsearchClient.update(request, RequestOptions.DEFAULT);
// 处理更新操作的结果
if (updateResponse.getResult() == DocWriteResponse.Result.UPDATED) {
System.out.println("文档更新成功");
} else if (updateResponse.getResult() == DocWriteResponse.Result.NOOP) {
System.out.println("指定的文档不存在或字段未更改");
}
}
}