ES7.x 删除指定id下的key，使用Script脚本

原创已于 2024-03-13 14:55:46 修改 · 533 阅读

6 ·

CC 4.0 BY-SA版权

文章标签：

#java #开发语言

于 2024-02-26 16:48:03 首次发布

由于编辑数据，导致有些数据中，添加了脏数据，现在想删除这些脏数据（包括对应的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("指定的文档不存在或字段未更改");
            }



        }
    }