ES多条件or查询

最新推荐文章于 2024-09-22 14:00:07 发布

zhanghe687

最新推荐文章于 2024-09-22 14:00:07 发布

阅读量430

点赞数

文章标签： elasticsearch java

本文链接：https://blog.csdn.net/zhanghe687/article/details/140035409

版权

SELECT *
FROM your_table
WHERE 
  (xx = 'qw' AND yy = 'zz')
  OR
  (xx = 'zz' AND yy = 'qw');

上面SQL换成对应的ES 查询：

SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();

        BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery()
                .should(
                        QueryBuilders.boolQuery()
                                .must(QueryBuilders.termQuery("xx", qw))
                                .must(QueryBuilders.termQuery("yy", zz))
                )
                .should(
                        QueryBuilders.boolQuery()
                                .must(QueryBuilders.termQuery("xx", zz))
                                .must(QueryBuilders.termQuery("yy", qw))
                );

        searchSourceBuilder.query(boolQueryBuilder);