java 操作es 实现俩个字段之间进行比对_es 查两个字段不一样的语句-CSDN博客

本文链接：https://blog.csdn.net/weixin_37757233/article/details/81162308

本文介绍了一种使用ELK栈进行日志搜索的方法，并详细解释了如何通过编写特定的Painless脚本来过滤数据，同时提供了Java API实现的示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

sql 例如:

select * from user t where t.count = t.num;

es 查询语句如下:

{
"from": 0,
"size": 100,
"query": {
"bool": {
"filter": {
"script": {
"script": {
"inline": "doc['category_code'].value - doc['user_group_id'].value == 531",
"lang": "painless"
},
"boost": 1
}
}
}
}
}

javaApi 如下:

 Map<String, Object> params = new HashMap<>();
        Script script = new Script(ScriptType.INLINE,"painless","doc['category_code'].value - doc['user_group_id'].value == 864",params);
        ScriptQueryBuilder scriptQueryBuilder = new ScriptQueryBuilder(script);
        StringBuffer queryString = new StringBuffer();
//        queryString.append("goods_id:18506");
        QueryStringQueryBuilder queryStringQueryBuilder = new QueryStringQueryBuilder(queryString.toString());
        BoolQueryBuilder booleanQueryBuilder = QueryBuilders.boolQuery();
        booleanQueryBuilder.must(scriptQueryBuilder);
        if (queryString.length() > 0){
            booleanQueryBuilder.must(queryStringQueryBuilder);
        }
        System.out.println("查询条件:" + booleanQueryBuilder);
        SearchResponse searchResponse = getClient().prepareSearch("group_catagory_goods_recommend")
                .setTypes("goods_tags")
                .setQuery(booleanQueryBuilder)
                .get();
        SearchHit[] hits = searchResponse.getHits().getHits();
        List list = new ArrayList();
        for (int i = 0; i < hits.length; i++) {
            System.out.println(JSON.toJSON(hits[i]));
//            list.add(hits[i].getId());
        }