ElasticSearch 实现sqlIn查询

比如查询 text in ('1','2','3');

1.使用should

BoolQueryBuilder boolBuilder = QueryBuilders.boolQuery();
boolBuilder.should(QueryBuilders.matchPhraseQuery("param", "1"));
boolBuilder.should(QueryBuilders.matchPhraseQuery("param", "2"));
boolBuilder.should(QueryBuilders.matchPhraseQuery("param", "3"));

2.解决ES搜索，should和must共用，should失效的问题

boolBuilder.minimumShouldMatch(1);// 解决ES搜索，should和must共用，should失效的问题

3.同时查询多个的另一个写法

// 同时查询多个的另一个写法
MultiSearchRequest request = new MultiSearchRequest();
for(){
BoolQueryBuilder boolBuilder = QueryBuilders.boolQuery();
...
SearchSourceBuilder sourceBuilder = new SearchSourceBuilder();
sourceBuilder.query(boolBuilder);
SearchRequest searchRequest = new SearchRequest(index); searchRequest.source(sourceBuilder);
request.add(searchRequest);
}
MultiSearchResponse multiesponse = client.msearch(request, RequestOptions.DEFAULT);

4.两种写法结合就可以筛选业务索引的同时，筛选必要的过滤条件

比如小明、小红的数学、英语成绩

public static void main(String[] args) {String index = "esIndex";MultiSearchRequest request = new MultiSearchRequest();List<String> nameList = new ArrayList<>();nameList.add("小明");nameList.add("小红");List<String> subjectList = new ArrayList<>();subjectList.add("数学");subjectList.add("英语");// 根据name IN查询for (int i = 0; i < nameList.size(); i++) {BoolQueryBuilder boolBuilder = QueryBuilders.boolQuery();boolBuilder.must(QueryBuilders.matchPhraseQuery("name", nameList.get(i)));// 根据subject IN查询if (subjectList != null && subjectList.size() > 0) {for (int j = 0; j < subjectList.size(); j++) {boolBuilder.should(QueryBuilders.matchPhraseQuery("subject", subjectList.get(j)));}boolBuilder.minimumShouldMatch(1);}SearchSourceBuilder sourceBuilder = new SearchSourceBuilder();sourceBuilder.query(boolBuilder);SearchRequest searchRequest = new SearchRequest(index);searchRequest.source(sourceBuilder);request.add(searchRequest);}MultiSearchResponse multiesponse = client.msearch(request, RequestOptions.DEFAULT);}

以上，如果可以帮到你，留个赞让我知道好吗？