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);
    }

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