java Elasticsearch or and 同时使用

最新推荐文章于 2022-10-17 14:38:12 发布

Wiley_L

最新推荐文章于 2022-10-17 14:38:12 发布

阅读量787

点赞数 2

分类专栏： spring boot Elasticsearch 文章标签： elasticsearch 搜索引擎大数据 java

本文链接：https://blog.csdn.net/weixin_42277397/article/details/124689975

版权

spring boot 同时被 2 个专栏收录

1 篇文章 0 订阅

订阅专栏

Elasticsearch

1 篇文章 0 订阅

订阅专栏

Elasticsearch想实现下面这个sql

select * from user where a=1 and ((b=2 and c=3 and d !=4) or (e=4 and f=5))

java Elasticsearch 实现


BoolQueryBuilder boolBuilder = QueryBuilders.boolQuery();

boolBuilder.must(QueryBuilders.termQuery("a",1));


QueryBuilder queryBuilder1 = QueryBuilders.boolQuery()
                    .must(QueryBuilders.termQuery("b", 2))
                    .must(QueryBuilders.termQuery("c", 3))
                    .mustNot(QueryBuilders.termQuery("d", 4));

QueryBuilder queryBuilder2 = QueryBuilders.boolQuery()
                    .must(QueryBuilders.termQuery("e", 4))
                    .must(QueryBuilders.termQuery("f", 5));

QueryBuilder queryBuilder = QueryBuilders.boolQuery()
                    .should(queryBuilder1)
                    .should(queryBuilder2);

boolBuilder.must(queryBuilder);