ElasticSearch查询操作

最新推荐文章于 2024-05-02 20:45:42 发布
最新推荐文章于 2024-05-02 20:45:42 发布
阅读量670 收藏 5
点赞数
分类专栏： ElasticSearch 文章标签： elasticsearch java 大数据
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_39956506/article/details/129136872
版权

ElasticSearch查询操作

本文大纲
一、ElasticSearch查询总结
二、ElasticSearch索引操作
三、ElasticSearch文档操作
四、ElasticSearch聚合查询

一、ElasticSearch查询总结

1.词条查询

2.等值查询-term

3.多值查询-terms

5.范围查询-range

6.前缀查询-prefix

7.通配符查询-wildcard

8.复合查询

9.布尔查询

10.Filter查询

11.聚合查询

12.最值、平均值、求和

13.去重查询

14.分组聚合

15.单条件分组

16.多条件分组

17.过滤聚合

在这里插入图片描述

ElasticSearch的数据类型

在这里插入图片描述

二、ElasticSearch索引查询操作

添加依赖

 <dependencies>
        <dependency>
            <groupId>org.elasticsearch.client</groupId>
            <artifactId>elasticsearch-rest-high-level-client</artifactId>
            <version>7.8.0</version>
        </dependency>
        <dependency>
            <groupId>org.elasticsearch.client</groupId>
            <artifactId>elasticsearch-rest-client</artifactId>
            <version>7.8.0</version>
        </dependency>
        <dependency>
            <groupId>org.elasticsearch</groupId>
            <artifactId>elasticsearch</artifactId>
            <version>7.8.0</version>
        </dependency>
    </dependencies>

索引操作

package es;

import com.es.EsDemoApplication;
import org.elasticsearch.client.IndicesClient;
import org.elasticsearch.client.RequestOptions;
import org.elasticsearch.client.RestHighLevelClient;
import org.elasticsearch.client.indices.CreateIndexRequest;
import org.elasticsearch.client.indices.CreateIndexResponse;
import org.elasticsearch.client.indices.GetIndexRequest;
import org.elasticsearch.client.indices.GetIndexResponse;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import java.io.IOException;
import java.util.Map;

/**
 * @description 索引测试
 */
@RunWith(SpringJUnit4ClassRunner.class)
@SpringBootTest(classes = EsDemoApplication.class)
public class IndexTest {
    @Autowired
    private RestHighLevelClient client;

    private static final String PERSON_INDEX = "person";

    private static final int START_OFFSET = 0;

    private static final int MAX_COUNT = 2000;

    /**
     * 查询索引
     */
    @Test
    public void queryIndex() throws IOException {
        IndicesClient indices = client.indices();

        GetIndexRequest getRequest = new GetIndexRequest("person");
        GetIndexResponse response = indices.get(getRequest, RequestOptions.DEFAULT);
        System.out.println(response.getMappings());
        Map mappings = response.getMappings();
        //iter 提示foreach
        for (Object key : mappings.keySet()) {
            System.out.println(key + "===" + mappings.get(key));
        }
    }

    /**
     * 添加索引
     *
     * @throws IOException e
     */
    @Test
    public void addIndex() throws IOException {
        //1.使用client获取操作索引对象
        IndicesClient indices = client.indices();
        //2.具体操作获取返回值
        //2.1 设置索引名称
        CreateIndexRequest createIndexRequest = new CreateIndexRequest("persons");

        CreateIndexResponse createIndexResponse = indices.create(createIndexRequest, RequestOptions.DEFAULT);
        //3.根据返回值判断结果
        System.out.println(createIndexResponse);
    }
}

三、ElasticSearch文档操作

package es;

import com.alibaba.fastjson.JSONObject;
import lombok.extern.slf4j.Slf4j;
import org.apache.http.HttpHost;
import org.elasticsearch.action.get.GetRequest;
import org.elasticsearch.action.get.GetResponse;
import org.elasticsearch.action.search.SearchRequest;
import org.elasticsearch.action.search.SearchResponse;
import org.elasticsearch.client.RequestOptions;
import org.elasticsearch.client.RestClient;
import org.elasticsearch.client.RestHighLevelClient;
import org.elasticsearch.index.query.BoolQueryBuilder;
import org.elasticsearch.index.query.Operator;
import org.elasticsearch.index.query.QueryBuilders;
import org.elasticsearch.search.builder.SearchSourceBuilder;
import org.junit.Test;

import java.io.IOException;
import java.util.Arrays;

/**
 * @description ES条件查询
 */
//@RunWith(SpringJUnit4ClassRunner.class)
//@SpringBootTest(classes = EsDemoApplication.class)
@Slf4j
public class QueryTest {
    //    @Autowired
//    private RestHighLevelClient client;

    private static final String PERSON_INDEX = "person";

    private static final int START_OFFSET = 0;

    private static final int MAX_COUNT = 2000;

    /**
     *
     */
    RestHighLevelClient client = new RestHighLevelClient(RestClient.builder(new HttpHost("", 9200)));

    SearchRequest searchRequest = new SearchRequest(PERSON_INDEX);

    SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();

    /**
     * 通过id查询文档
     *
     * @throws IOException e
     */
    @Test
    public void queryDocumentById() throws IOException {
        GetRequest getRequest = new GetRequest(PERSON_INDEX, "1");
        GetResponse response = client.get(getRequest, RequestOptions.DEFAULT);
        System.out.println("geqPersonById================》" + JSONObject.toJSON(response));
    }

    /**
     * term等值查询，等同于 = 查询
     *
     * @throws IOException e
     */
    @Test
    public void termQueryTest() throws IOException {

        searchSourceBuilder.query(QueryBuilders.termQuery("sect.keyword", "明教"));
        System.out.println("searchSourceBuilder=====================》" + searchSourceBuilder);
        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    /**
     * constantScoreQuery，不打分查询
     *
     * @throws IOException e
     */
    @Test
    public void constantScoreQueryTest() throws IOException {
        // 这样构造的查询条件，将不进行score计算，从而提高查询效率
        searchSourceBuilder.query(QueryBuilders.constantScoreQuery(QueryBuilders.termQuery("sect.keyword", "明教")));
        System.out.println("searchSourceBuilder=====================》" + searchSourceBuilder);
        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    /**
     * terms多值查询，等同于 in 查询
     *
     * @throws IOException e
     */
    @Test
    public void termsQueryTest() throws IOException {
        searchSourceBuilder.query(QueryBuilders.termsQuery("sect.keyword", Arrays.asList("明教", "武当派")));
        System.out.println("查询语句=====================》" + searchSourceBuilder);
        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    /**
     * 范围查询，等同于between...and...
     * select * from persons where age between 10 and 30
     *
     * @throws IOException e
     */
    @Test
    public void rangeQueryTest() throws IOException {
        // 构建查询语句
        searchSourceBuilder.query(QueryBuilders.rangeQuery("age").gte(10).lte(30));
        System.out.println("查询语句=====================" + searchSourceBuilder);
        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    /**
     * 前缀查询，等同于 李%
     * select * from person where sect like ‘武当%’
     *
     * @throws IOException e
     */
    @Test
    public void prefixQueryTest() throws IOException {
        // 构建查询语句
        searchSourceBuilder.query(QueryBuilders.prefixQuery("sect.keyword", "武当"));
        System.out.println("查询语句=====================》" + searchSourceBuilder);
        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    /**
     * 通配符查询，等同于 %无%
     *
     * @throws IOException e
     */
    @Test
    public void wildcardQueryTest() throws IOException {
        // 构建查询语句
        searchSourceBuilder.query(QueryBuilders.wildcardQuery("sect.keyword", "张*忌"));
        System.out.println("查询语句=====================》" + searchSourceBuilder);
        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    /**
     * 布尔查询，构造多条件查询
     *
     * @throws IOException e
     */
    @Test
    public void boolQueryTest() throws IOException {
        // 构建查询语句
        searchSourceBuilder.query(QueryBuilders.boolQuery()
                .must(QueryBuilders.termQuery("sex", "女"))
                .must(QueryBuilders.termQuery("sect.keyword", "明教"))

        );
        System.out.println("查询语句=====================》" + searchSourceBuilder);
        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    @Test
    public void boolQueryTest2() throws IOException {
        // 构建查询语句
        searchSourceBuilder.query(QueryBuilders.boolQuery()
                .must(QueryBuilders.termQuery("sex", "女"))
                .should(QueryBuilders.termQuery("address.word", "峨眉山"))
                .should(QueryBuilders.termQuery("sect.keyword", "明教"))
                .minimumShouldMatch(1)
        );
        System.out.println("查询语句=====================》" + searchSourceBuilder);
        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    @Test
    public void boolQueryTest3() throws IOException {
        // 构建查询语句
        searchSourceBuilder.query(QueryBuilders.boolQuery()
                .must(QueryBuilders.rangeQuery("age").gte(10).lte(30))
                .must(QueryBuilders.termQuery("sect.keyword", "明教"))
                .filter(QueryBuilders.termQuery("sex", "男"))
        );

        System.out.println("查询语句=====================》" + searchSourceBuilder);
        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    /**
     * filter直接包含查询语句
     *
     * @throws IOException e
     */
    @Test
    public void filterTest() throws IOException {
        // 构建查询语句
        searchSourceBuilder.query(QueryBuilders.boolQuery()
                .filter(QueryBuilders.termQuery("sex", "男"))
        );// 构建查询语句
        searchSourceBuilder.query(QueryBuilders.boolQuery()
                .filter(QueryBuilders.termQuery("sex", "男"))
        );
        System.out.println("查询语句=====================》" + searchSourceBuilder);
        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    /**
     * filter与must等同级使用
     *
     * @throws IOException e
     */
    @Test
    public void filterTest2() throws IOException {
        // 构建查询语句
        searchSourceBuilder.query(QueryBuilders.boolQuery()
                .must(QueryBuilders.termQuery("sect.keyword", "明教"))
                .filter(QueryBuilders.termQuery("sex", "女"))
        );
        System.out.println("查询语句=====================》" + searchSourceBuilder);
        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    /**
     * filter包含must等
     *
     * @throws IOException e
     */
    @Test
    public void filterTest3() throws IOException {
        // 构建查询语句
        searchSourceBuilder.query(QueryBuilders.boolQuery()
                .filter(QueryBuilders.boolQuery()
                        .must(QueryBuilders.termQuery("sect.keyword", "明教"))
                        .must(QueryBuilders.rangeQuery("age").gte(20).lte(35))
                        .mustNot(QueryBuilders.termQuery("sex.keyword", "女")))
        );
        System.out.println("查询语句=====================》" + searchSourceBuilder);
        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    /**
     * filter
     *
     * @throws IOException e
     */
    @Test
    public void filterTest4() throws IOException {
        // 构建查询语句
        BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery()
                .must(QueryBuilders.termQuery("sex", "女"))
                .must(QueryBuilders.rangeQuery("age").gte(30).lte(40))
                .mustNot(QueryBuilders.termQuery("sect.keyword", "明教"))
                .should(QueryBuilders.termQuery("address.keyword", "峨眉山"))
                .should(QueryBuilders.rangeQuery("power.keyword").gte(50).lte(80))
                .minimumShouldMatch(1);

        searchSourceBuilder.query(boolQueryBuilder);

        System.out.println("查询语句=====================》" + searchSourceBuilder);

        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    /**
     * match：单条件匹配
     *
     * @throws IOException e
     */
    @Test
    public void matchQueryTest() throws IOException {
        // 构建查询语句
        searchSourceBuilder.query(QueryBuilders.matchQuery("name", "殷素素"));
        System.out.println("查询语句=====================》" + searchSourceBuilder);
        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    /**
     * multiMatch：多field对同一个text匹配
     *
     * @throws IOException e
     */
    @Test
    public void multiMatchQueryTest() throws IOException {
        // operator传入AND或OR，决定了多个匹配条件之间的关系是与还是或
        searchSourceBuilder.query(QueryBuilders.multiMatchQuery("武当", "sect", "address")
                .operator(Operator.valueOf("AND"))
                .minimumShouldMatch("50%"));

        System.out.println("查询语句=====================》" + searchSourceBuilder);
        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }
}

四、ElasticSearch聚合查询

package es;

import com.alibaba.fastjson.JSONObject;
import lombok.extern.slf4j.Slf4j;
import org.apache.http.HttpHost;
import org.elasticsearch.action.search.SearchRequest;
import org.elasticsearch.action.search.SearchResponse;
import org.elasticsearch.client.RequestOptions;
import org.elasticsearch.client.RestClient;
import org.elasticsearch.client.RestHighLevelClient;
import org.elasticsearch.index.query.QueryBuilders;
import org.elasticsearch.search.aggregations.AggregationBuilder;
import org.elasticsearch.search.aggregations.AggregationBuilders;
import org.elasticsearch.search.builder.SearchSourceBuilder;
import org.junit.Test;
import org.springframework.cglib.beans.BeanMap;

import java.io.IOException;
import java.util.HashMap;
import java.util.Map;

/**
 * @description ES聚合查询
 */
@Slf4j
public class AggTest {
    /*
     * 初始化客户端
     */
    RestHighLevelClient client = new RestHighLevelClient(RestClient.builder(new HttpHost("", 9200)));

    // 根据索引构造查询请求
    SearchRequest searchRequest = new SearchRequest(PERSON_INDEX);
    SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();

    private static final String PERSON_INDEX = "person";

    private static final int START_OFFSET = 0;

    private static final int MAX_COUNT = 2000;

    /**
     * 统计查询：max、min、sum、avg、count
     *
     * @throws IOException e
     */
    @Test
    public void maxQueryTest() throws IOException {
        AggregationBuilder maxBuilder = AggregationBuilders.max("max_age").field("age");
        // AggregationBuilder minBuilder = AggregationBuilders.min("min_age").field("age");
        // AggregationBuilder avgBuilder = AggregationBuilders.avg("min_age").field("age");
        // AggregationBuilder sumBuilder = AggregationBuilders.sum("min_age").field("age");
        // AggregationBuilder countBuilder = AggregationBuilders.count("min_age").field("age");
        searchSourceBuilder.size(5);
        searchSourceBuilder.aggregation(maxBuilder);
        System.out.println("查询语句=====================》" + searchSourceBuilder);

        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    /**
     * stats:一并求max、min、sum、count、avg
     * extendedStats：追加方差、标准差等
     *
     * @throws IOException e
     */
    @Test
    public void statsQueryTest() throws IOException {
        AggregationBuilder aggBuilder = AggregationBuilders.stats("person_stats").field("age");
        //  AggregationBuilder aggBuilder = AggregationBuilders.extendedStats("person_stats").field("age");

        SearchRequest searchRequest = new SearchRequest(PERSON_INDEX);
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
        searchSourceBuilder.aggregation(aggBuilder);
        System.out.println("查询语句=====================》" + searchSourceBuilder);

        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    /**
     * 先查询，再统计
     *
     * @throws IOException e
     */
    @Test
    public void queryAndAggQueryTest() throws IOException {
        SearchRequest searchRequest = new SearchRequest("person");
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
        // 对条件查询的结果进行统计
        AggregationBuilder maxBuilder = AggregationBuilders.max("max_age").field("age");
        searchSourceBuilder.query(QueryBuilders.termQuery("sect.keyword", "明教"));
        searchSourceBuilder.aggregation(maxBuilder);
        System.out.println("查询语句=====================》" + searchSourceBuilder);

        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    /**
     * 去重查询
     *
     * @throws IOException e
     */
    @Test
    public void cardinalityQueryTest() throws IOException {
        AggregationBuilder aggBuilder = AggregationBuilders.cardinality("sect_count").field("sect.keyword");

        SearchRequest searchRequest = new SearchRequest("person");
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
//        searchSourceBuilder.size(0);
        searchSourceBuilder.aggregation(aggBuilder);
        System.out.println("查询语句=====================》" + searchSourceBuilder);

        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    /**
     * 分组查询
     *
     * @throws IOException e
     */
    @Test
    public void groupQueryTest() throws IOException {
        SearchRequest searchRequest = new SearchRequest("person");
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
        searchSourceBuilder.size(0);
        // 按sect分组
        AggregationBuilder aggBuilder = AggregationBuilders.terms("sect_count").field("sect.keyword");
        searchSourceBuilder.aggregation(aggBuilder);
        System.out.println("查询语句=====================》" + searchSourceBuilder);

        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    @Test
    public void TermGroupQueryTest() throws IOException {
        SearchRequest searchRequest = new SearchRequest("person");
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
        searchSourceBuilder.size(0);
        // 按sex分组
        AggregationBuilder ageAggBuilder = AggregationBuilders.avg("age_avg").field("age");

        searchSourceBuilder.query(QueryBuilders.termQuery("sex", "女"));

        searchSourceBuilder.aggregation(ageAggBuilder);
        System.out.println("查询语句=====================》" + searchSourceBuilder);

        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }


    /**
     * 多字段分组
     *
     * @throws IOException e
     */
    @Test
    public void multiGroupQueryTest() throws IOException {
        SearchRequest searchRequest = new SearchRequest("person");
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
        searchSourceBuilder.size(0);
        // 按sect分组
        AggregationBuilder sexAggBuilder = AggregationBuilders.terms("sex_count").field("sex.keyword");
        AggregationBuilder sectAggBuilder = AggregationBuilders.terms("sect_count").field("sect.keyword")
                .subAggregation(sexAggBuilder);

        searchSourceBuilder.aggregation(sectAggBuilder);
        System.out.println("查询语句=====================》" + searchSourceBuilder);

        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    @Test
    public void multiGroupQueryTest2() throws IOException {
        SearchRequest searchRequest = new SearchRequest("person");
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
        searchSourceBuilder.size(0);
        // 先按性别分组
        AggregationBuilder sexAggBuilder = AggregationBuilders.terms("sex_count").field("sex.keyword");
        // 再按sect分组
        AggregationBuilder sectAggBuilder = AggregationBuilders.terms("sect_count").field("sect.keyword");
        // 求平均年龄
        AggregationBuilder ageAggBuilder = AggregationBuilders.avg("age_avg").field("age");

        sexAggBuilder.subAggregation(sectAggBuilder);
        sexAggBuilder.subAggregation(ageAggBuilder);


        searchSourceBuilder.aggregation(sexAggBuilder);
        System.out.println("查询语句=====================》" + searchSourceBuilder);

        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }

    @Test
    public void multiGroupQueryTest3() throws IOException {
        SearchRequest searchRequest = new SearchRequest("person");
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
        searchSourceBuilder.size(0);
        // 求平均年龄
        AggregationBuilder ageAggBuilder = AggregationBuilders.range("age_avg").field("age")
                .addRange(20, 40)
                .addRange(40, 60)
                .addRange(60, 120);


        searchSourceBuilder.aggregation(ageAggBuilder);
        System.out.println("查询语句=====================》" + searchSourceBuilder);

        searchRequest.source(searchSourceBuilder);
        SearchResponse response = client.search(searchRequest, RequestOptions.DEFAULT);
        System.out.println("查询结果=====================》" + JSONObject.toJSON(response));
    }


    /**
     * bean转为map
     *
     * @param bean bean
     * @param <T>  T
     * @return T
     */
    public static <T> Map<String, Object> beanToMap(T bean) {
        Map<String, Object> map = new HashMap<>();
        if (bean != null) {
            BeanMap beanMap = BeanMap.create(bean);
            for (Object key : beanMap.keySet()) {
                if (beanMap.get(key) != null)
                    map.put(key + "", beanMap.get(key));
            }
        }
        return map;
    }
}
jarenyVO
关注
  • 0
    点赞
  • 踩
  • 5
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Elasticsearch ES操作：查询数据（全部、分页、单条）
进击的小白
04-21 5465
在使用ES时经常需要通过接口或者查询工具查找ES中的数据，需要了解基本的查询命令。如精确查询，模糊匹配，多条件查询等。
ElasticSearch数据查看的两种方式
weixin_51259107的博客
10-18 6192
Kibana （1）下载kibana-7.3.2-windows-x86_64.zip，解压到当前文件夹。 （2）修改配置文件：kibana-7.3.2-windows-x86_64\config\kibana.yml elasticsearch.hosts: [“http://ip:端口”] （3）启动kibana：双击kibana-7.3.2-windows-x86_64\bin\kibana.bat启动。 （4）浏览器输入http://ip:端口，进入ES查询页面，编辑语句查询。 Head （1）谷歌
2024年大数据最新Elasticsearch 教程_elasticsearch怎么启动
最新发布
2401_84181368的博客
05-02 632
IK中⽂分词器ikanalyzer2012_u6```
ElasticSearch的term多条件与terms多值查询
热门推荐
星空的风fly
01-31 1万+
一次查询多个字段，每个字段对应一个值。如查询条件属性plan_id、sku_id，值分别为：11、121、json请求格式如下。
Elasticsearch 高级查询技巧
BXA
07-16 633
Elasticsearch 是一个开源的分布式搜索和分析引擎，它构建在 Apache Lucene 之上。它提供了分布式的实时搜索和分析功能，能够处理海量数据，并以毫秒级的响应时间返回查询结果。Elasticsearch 使用 JSON 格式来存储、搜索和分析数据。
ES中的三种查询
qq_40708942的博客
10-20 1万+
es的三种查询,以及需要注意的事项
elasticSearch查询语句DSL
06-27
在这篇资源中，我们将详细介绍如何使用DSL...最后，我们将分享一些实用技巧和最佳实践，帮助您充分发挥DSL在Elasticsearch中的优势。我们将探讨性能优化、查询调试和索引优化等关键主题，以提升查询效率和搜索准确性。
spring 操作elasticsearch查询使用方法
08-30
Spring 操作 Elasticsearch 查询使用方法 Spring 框架在数据存储和检索方面提供了强大的支持，而 Elasticsearch 则是当前最流行的搜索引擎之一。将 Spring 和 Elasticsearch 结合使用，可以实现高效、灵活的数据...
Java如何使用elasticsearch进行模糊查询
08-25
Java 使用 Elasticsearch 进行模糊查询 Elasticsearch 是一个基于 Lucene 的搜索引擎，提供了强大的搜索功能。Java 可以通过 Elasticsearch 的 API 来使用这些功能。本文将介绍如何使用 Java 语言在 Elasticsearch ...
es入门操作-elasticsearch入门操作
12-27
"Elasticsearch 入门操作" Elasticsearch 是一个基于 Lucene 库的搜索引擎，提供了一个分布式、支持多用户的全文搜索引擎，具有 HTTP Web 接口和无模式 JSON 文档。所有其他语言可以使用 RESTful API 通过端口 9200...
java使用elasticsearch分组进行聚合查询过程解析
08-25
Java 使用 Elasticsearch 进行分组聚合查询过程解析 Java 使用 Elasticsearch 进行分组聚合查询是一个常见的需求，特别是在大数据处理和数据分析领域。Elasticsearch 提供了强大的聚合功能，可以对数据进行分组、...
【教你通透ELK】Elasticsearch 索引和查询语法
走向CTO的路上...
08-06 602
在Elasticsearch中，索引是分片的，每个分片是一个Lucene索引。每个分片可以在不同的节点上存储，这样可以提高数据的可用性和性能。另外，每个分片可以有多个副本，副本可以在不同的节点上存储，以保证数据的高可用性。Elasticsearch中的索引类似于关系型数据库中的表，用于存储和索引数据。每个索引可以包含多个文档，每个文档包含多个字段。索引可以手动创建或自动创建，索引的名称必须是小写字母，不能包含空格。Elasticsearch支持多种查询语法，包括基本查询、聚合查询、地理位置查询等。
elasticsearch之多索引查询
无风听海
12-31 1万+
一、问题源起 在elasticsearch的查询中，我们一般直接通过URL来设置要search的index； 如果我们需要查询的索引比较多并且没有什么规律的话，就会面临一个尴尬的局面，超过URL的长度限制； 二、测试环境 elasticsearch 6.8.12 测试数据 新增三个测试的index，每个index里边一个document； PUT test1/_doc/1 { "id":1, "name":"test1-1" } # { # "_index" : "test1", # "
elasticsearch查询操作（语句方式）
qq_42108331的博客
07-25 4268
elasticsearch查询操作（DSL语句方式）
ES分布式搜索原理分析
发现问题，面对问题，分析问题，解决问题，总结问题
11-10 2217
文章目录基本介绍查询阶段取回阶段 基本介绍 一个CRUD操作只处理一个单独的文档。文档的唯一性由_index, _type和routing-value（通常默认是该文档的_id）的组合来确定。这意味着我们可以准确知道集群中的哪个分片持有这个文档。 找到所有匹配的文档只完成了这件事的一半。在搜索（search）API返回一页结果前，来自多个分片的结果必须被组合放到一个有序列表中。因此，搜索的执行过程分两个阶段，称为查询然后取回（query then fetch）。 在初始化查询阶段（query phase），
Elasticsearch 联结查询(joining queries)
liu1390910的博客
03-21 1218
在像 Elasticsearch 这样的分布式计算系统执行全 SQL 风格的联结操作代价昂贵。相应地，Elasticsearch 提供了两种形式的联结可以实现水平规模的扩展。 嵌套查询 nested query：文档包含 nested 类型的字段。这些字段用来索引数组对象，其中每个对象作为独立的文档可以被检索（使用 nested 查询）。 has_child 和 has_parent 查询：父...
Elasticsearch数据库索引及数据操作
稻草人
06-07 1721
Elasticsearch数据库索引及数据的增删改查
从入门到进阶：Elasticsearch高级查询技巧详解
小易
07-27 1843
Elasticsearch是一个功能强大的搜索引擎，拥有许多高级查询技巧。在实际使用中，可以根据具体需求选择合适的查询方式，并使用查询语句中的高级功能，来实现更复杂的查询操作。本教程介绍了Elasticsearch的基本查询方式和高级查询技巧，并提供了相应的代码示例，希望能帮助读者更好地掌握Elasticsearch的查询功能。相关阅读：​​深入了解Elasticsearch的监控和调优​​​​深入理解Elasticsearch的分布式架构​​​。
Elasticsearch 查询文档流程
John_chu的博客
10-13 123
假设存在三个节点 NODE1、NODE2、NODE3。其中 NODE1 会接受客户端的请求，它作为 Coordinate Node 或者成为 Master Node。将索引放到两个分片中，主分片分别为 P0 和 P1，P0 对应的两个副本 R0、R0，P1 对应的两个副本 R1、R1 客户端发送查询请求到NODE1。 接着NODE1使用文档的id决定文档属于P0分片，由于分片和对应的副本都可 以读取数据，此时算法可以随机选择分片或者副本进行路由，此时选择 R0 副本并 ...
elasticsearch 里的in查询操作
04-25
In Elasticsearch, the "in" query operation can be achieved using the "terms" query. The "terms" query allows you to specify multiple values for a field, and documents that match any of the specified values will be returned. Here is an example query: ``` GET /my_index/_search { "query": { "terms": { "my_field": [ "value1", "value2", "value3" ] } } } ``` This query will return all documents in "my_index" where the "my_field" field matches any of the specified values. Note that the values are case sensitive.

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值