后端查询es数据

最新推荐文章于 2024-10-10 11:17:27 发布

置顶 King-Mouse

最新推荐文章于 2024-10-10 11:17:27 发布

阅读量1.3k

点赞数 1

分类专栏：技术类消息队列文章标签： java es 数据查询 es数据查询 elasticsearch

本文链接：https://blog.csdn.net/qq_22331931/article/details/117693887

版权

技术类同时被 2 个专栏收录

19 篇文章 0 订阅

订阅专栏

消息队列

2 篇文章 0 订阅

订阅专栏

一、构建es连接

本次我们通过RestClien来连接es服务端，代码很简单，就不废话了，直接上代码：

 		HttpHost httpHost1 = new HttpHost("192.168.1.100", 8000, "http");
        HttpHost httpHost2 = new HttpHost("192.168.1.101", 8000, "http");
        HttpHost httpHost3 = new HttpHost("192.168.1.102", 8000, "http");
        HttpHost httpHost4 = new HttpHost("192.168.1.103", 8000, "http");
        HttpHost httpHost5 = new HttpHost("192.168.1.104", 8000, "http");

        // 创建es链接
        RestClientBuilder builder = RestClient.builder(httpHost1, httpHost2, httpHost3, httpHost4, httpHost5);
        RestHighLevelClient restHighLevelClient = new RestHighLevelClient(builder);

备注：以上连接的是es集群，如果连接单个es服务端，只需要创建一个HttpHost即可

二、创建查询条件

同样很简单，老规矩上代码：

		// 开始查询数据
        SearchRequest searchRequest = new SearchRequest("index-2021.06.08");
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
        // 构造查询条件
        BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery();
        // 查询所有数据
        MatchAllQueryBuilder matchAllQueryBuilder = QueryBuilders.matchAllQuery();

        boolQueryBuilder.must(matchAllQueryBuilder);
        searchSourceBuilder.query(boolQueryBuilder);
        // 查询10条
        searchSourceBuilder.size(10);
        searchRequest.source(searchSourceBuilder);

三、查询es数据

这个过程更简单，只需要把创建好的条件传入我们之前构建的es连接即可，代码如下：

		try {
            // 条件构造完毕，开始查询es
            SearchResponse search = restHighLevelClient.search(searchRequest);
            LOGGER.info("查询原始数据为：{}", search);

            //取出具体业务数据
            List<String> list = Arrays.asList(search.getHits().getHits())
                    .stream()
                    .map(SearchHit::getSourceAsString)
                    .collect(Collectors.toList());
            LOGGER.info("业务数据大小：{}  业务数据：{}", list.size(), list);
        } catch (Exception e) {
            LOGGER.error("es查询异常：{}", e.getMessage());
        }

四、数据验证

通过以上三个步骤我们就可以拿到我们放到es服务端的数据啦，所有不贴运行结果的代码都是耍流氓，所以请看：
验证结果
完整代码：

package com.kingmouse.es.book;

import org.apache.http.HttpHost;
import org.elasticsearch.action.search.SearchRequest;
import org.elasticsearch.action.search.SearchResponse;
import org.elasticsearch.client.RestClient;
import org.elasticsearch.client.RestClientBuilder;
import org.elasticsearch.client.RestHighLevelClient;
import org.elasticsearch.index.query.BoolQueryBuilder;
import org.elasticsearch.index.query.MatchAllQueryBuilder;
import org.elasticsearch.index.query.QueryBuilders;
import org.elasticsearch.search.SearchHit;
import org.elasticsearch.search.builder.SearchSourceBuilder;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import java.util.Arrays;
import java.util.List;
import java.util.stream.Collectors;

/**
 * Created with IntelliJ IDEA
 *
 * @auther kingMouse
 * @date 2021/6/8 10:31 上午
 * Description: 后端查询es服务端数据demo
 */

public class Esdemo {

    private static final Logger LOGGER = LoggerFactory.getLogger(Esdemo.class);

    public static void main(String[] args) {
        HttpHost httpHost1 = new HttpHost("192.168.1.100", 8000, "http");
        HttpHost httpHost2 = new HttpHost("192.168.1.101", 8000, "http");
        HttpHost httpHost3 = new HttpHost("192.168.1.102", 8000, "http");
        HttpHost httpHost4 = new HttpHost("192.168.1.103", 8000, "http");
        HttpHost httpHost5 = new HttpHost("192.168.1.104", 8000, "http");

        // 创建es链接
        RestClientBuilder builder = RestClient.builder(httpHost1, httpHost2, httpHost3, httpHost4, httpHost5);
        RestHighLevelClient restHighLevelClient = new RestHighLevelClient(builder);

        // 开始查询数据
        SearchRequest searchRequest = new SearchRequest("index-2021.06.08");
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
        // 构造查询条件
        BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery();
        // 查询所有数据
        MatchAllQueryBuilder matchAllQueryBuilder = QueryBuilders.matchAllQuery();

        boolQueryBuilder.must(matchAllQueryBuilder);
        searchSourceBuilder.query(boolQueryBuilder);
        // 查询10条
        searchSourceBuilder.size(10);
        searchRequest.source(searchSourceBuilder);

        try {
            // 条件构造完毕，开始查询es
            SearchResponse search = restHighLevelClient.search(searchRequest);
            LOGGER.info("查询原始数据为：{}", search);

            //取出具体业务数据
            List<String> list = Arrays.asList(search.getHits().getHits())
                    .stream()
                    .map(SearchHit::getSourceAsString)
                    .collect(Collectors.toList());
            LOGGER.info("业务数据大小：{}  业务数据：{}", list.size(), list);
        } catch (Exception e) {
            LOGGER.error("es查询异常：{}", e.getMessage());
        }
    }
}

什么？你要带条件的查询？ok，满足你们，上代码：

		// 开始查询数据
        SearchRequest searchRequest = new SearchRequest("index-2021.06.08");
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
        // 构造查询条件
        BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery();
      
        // 查询请求时间在2021-06-08 08:00:00～2021-06-08 09:00:00之间的数据
        RangeQueryBuilder rangeQueryBuilder = QueryBuilders.rangeQuery("reqTime.keyword")
                .gt("2021-06-08 08:00:00").lt("2021-06-08 09:00:00");
        // 查询状态是success的数据
        MatchQueryBuilder matchQueryBuilder = QueryBuilders.matchQuery("status.keyword","success");

        // must表示各条件之间是and的关系
        boolQueryBuilder.must(rangeQueryBuilder);
        boolQueryBuilder.must(matchQueryBuilder);
        searchSourceBuilder.query(boolQueryBuilder);
        // 查询10条
        searchSourceBuilder.size(10);
        searchRequest.source(searchSourceBuilder);