Elastic Search基于Spring Boot实现复杂查询和对复杂查询结果的映射银行账户对象并获取对应信息------Elastic Search

已于 2024-07-17 13:37:35 修改
阅读量1.2k 收藏 19
点赞数 33
分类专栏： # Elastic Search # Spring-Boot框架 数据库 文章标签： 搜索引擎 微服务 数据库 后端 mybatis elasticsearch spring cloud
于 2024-07-17 13:35:05 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/2201_75960169/article/details/140492560
版权 
package com.alatus.search;

import com.alatus.search.config.MallElasticSearchConfig;
import com.alibaba.fastjson.JSON;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.ToString;
import org.elasticsearch.action.index.IndexRequest;
import org.elasticsearch.action.index.IndexResponse;
import org.elasticsearch.action.search.SearchRequest;
import org.elasticsearch.action.search.SearchResponse;
import org.elasticsearch.client.RequestOptions;
import org.elasticsearch.client.RestHighLevelClient;
import org.elasticsearch.common.xcontent.XContentType;
import org.elasticsearch.index.query.QueryBuilders;
import org.elasticsearch.search.SearchHit;
import org.elasticsearch.search.SearchHits;
import org.elasticsearch.search.aggregations.Aggregation;
import org.elasticsearch.search.aggregations.AggregationBuilder;
import org.elasticsearch.search.aggregations.AggregationBuilders;
import org.elasticsearch.search.aggregations.Aggregations;
import org.elasticsearch.search.aggregations.bucket.terms.Terms;
import org.elasticsearch.search.aggregations.bucket.terms.TermsAggregationBuilder;
import org.elasticsearch.search.aggregations.metrics.Avg;
import org.elasticsearch.search.aggregations.metrics.AvgAggregationBuilder;
import org.elasticsearch.search.builder.SearchSourceBuilder;
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.SpringRunner;

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

@RunWith(SpringRunner.class)
@SpringBootTest
public class TestLoad {
    @Autowired
    private RestHighLevelClient client;
    @Test
    public void load(){
        System.out.println(client);
    }
    @Test
    public void index() throws IOException {
        IndexRequest request = new IndexRequest("users");
        request.id("1");
        request.source("username","Jack","age",18,"gender","男");
        String jsonString = JSON.toJSONString(new User("Rose", 18, "女"));
        request.source(jsonString, XContentType.JSON);
//        执行操作
        IndexResponse index = client.index(request, MallElasticSearchConfig.COMMON_OPTIONS);
        System.out.println(index);
    }
    @Test
    public void searchData() throws IOException {
//        创建检索请求
        SearchRequest searchRequest = new SearchRequest();
//        指定索引
        searchRequest.indices("bank");
//        指定DSL,检索条件
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
//        检索条件
        searchSourceBuilder.query(QueryBuilders.matchQuery("address","mill"));
        searchSourceBuilder.from(1);
        searchSourceBuilder.size(10);
//        设置聚合条件
//        按照年龄的值做了一次聚合
        TermsAggregationBuilder ageAgg = AggregationBuilders.terms("ageAgg").field("age").size(1);
        searchSourceBuilder.aggregation(ageAgg);
//        按照平均工资做一次聚合
        AvgAggregationBuilder balanceAgg = AggregationBuilders.avg("balanceAvg").field("balance");
        searchSourceBuilder.aggregation(balanceAgg);
        searchRequest.source(searchSourceBuilder);
//        打印检索条件
        System.out.println(searchRequest);
//        执行检索
        SearchResponse searchResponse = client.search(searchRequest, MallElasticSearchConfig.COMMON_OPTIONS);
//        获取所有命中的记录
//        这里是转为map对象
        Map map = JSON.parseObject(searchResponse.toString(), Map.class);
//        获取命中的记录
        SearchHits hits = searchResponse.getHits();
        SearchHit[] searchHits = hits.getHits();
        for (SearchHit searchHit : searchHits) {
            System.out.println(searchHit.getIndex());
            System.out.println(searchHit.getId());
//            Map<String, Object> sourceAsMap = searchHit.getSourceAsMap();
            String sourceAsString = searchHit.getSourceAsString();
            Account account = JSON.parseObject(sourceAsString, Account.class);
            System.out.println(account);
        }
        System.out.println(map);
        System.out.println(searchResponse);
//        获取检索到的分析信息
        Aggregations aggregations = searchResponse.getAggregations();
        List<Aggregation> list = aggregations.asList();
        for (Aggregation aggregation : list) {
            System.out.println(aggregation.getName());
        }
        Terms ageAggTon = aggregations.get("ageAgg");
        for (Terms.Bucket bucket : ageAggTon.getBuckets()) {
            System.out.println("年龄"+bucket.getKeyAsString());
            System.out.println(bucket.getDocCount());
        }
        Avg balanceAvg = aggregations.get("balanceAvg");
        System.out.println("平均薪资"+balanceAvg.getValue());
    }
    @Data
    @AllArgsConstructor
    @NoArgsConstructor
    class User{
        private String username;
        private Integer age;
        private String gender;
    }

    @Data
    @NoArgsConstructor
    @AllArgsConstructor
    @ToString
    static class Account{
    /**
     * Copyright 2024 bejson.com
     */

    /**
     * Auto-generated: 2024-07-17 13:20:0
     *
     * @author bejson.com (i@bejson.com)
     * @website http://www.bejson.com/java2pojo/
     */
        private int account_number;
        private int balance;
        private String firstname;
        private String lastname;
        private int age;
        private String gender;
        private String address;
        private String employer;
        private String email;
        private String city;
        private String state;
    }
}

package com.alatus.search;

import com.alatus.search.config.MallElasticSearchConfig;
import com.alibaba.fastjson.JSON;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.ToString;
import org.elasticsearch.action.index.IndexRequest;
import org.elasticsearch.action.index.IndexResponse;
import org.elasticsearch.action.search.SearchRequest;
import org.elasticsearch.action.search.SearchResponse;
import org.elasticsearch.client.RequestOptions;
import org.elasticsearch.client.RestHighLevelClient;
import org.elasticsearch.common.xcontent.XContentType;
import org.elasticsearch.index.query.QueryBuilders;
import org.elasticsearch.search.SearchHit;
import org.elasticsearch.search.SearchHits;
import org.elasticsearch.search.aggregations.Aggregation;
import org.elasticsearch.search.aggregations.AggregationBuilder;
import org.elasticsearch.search.aggregations.AggregationBuilders;
import org.elasticsearch.search.aggregations.Aggregations;
import org.elasticsearch.search.aggregations.bucket.terms.Terms;
import org.elasticsearch.search.aggregations.bucket.terms.TermsAggregationBuilder;
import org.elasticsearch.search.aggregations.metrics.Avg;
import org.elasticsearch.search.aggregations.metrics.AvgAggregationBuilder;
import org.elasticsearch.search.builder.SearchSourceBuilder;
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.SpringRunner;

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

@RunWith(SpringRunner.class)
@SpringBootTest
public class TestLoad {
    @Autowired
    private RestHighLevelClient client;
    @Test
    public void load(){
        System.out.println(client);
    }
    @Test
    public void index() throws IOException {
        IndexRequest request = new IndexRequest("users");
        request.id("1");
        request.source("username","Jack","age",18,"gender","男");
        String jsonString = JSON.toJSONString(new User("Rose", 18, "女"));
        request.source(jsonString, XContentType.JSON);
//        执行操作
        IndexResponse index = client.index(request, MallElasticSearchConfig.COMMON_OPTIONS);
        System.out.println(index);
    }
    @Test
    public void searchData() throws IOException {
//        创建检索请求
        SearchRequest searchRequest = new SearchRequest();
//        指定索引
        searchRequest.indices("bank");
//        指定DSL,检索条件
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
//        检索条件
        searchSourceBuilder.query(QueryBuilders.matchQuery("address","mill"));
        searchSourceBuilder.from(1);
        searchSourceBuilder.size(10);
//        设置聚合条件
//        按照年龄的值做了一次聚合
        TermsAggregationBuilder ageAgg = AggregationBuilders.terms("ageAgg").field("age").size(1);
        searchSourceBuilder.aggregation(ageAgg);
//        按照平均工资做一次聚合
        AvgAggregationBuilder balanceAgg = AggregationBuilders.avg("balanceAvg").field("balance");
        searchSourceBuilder.aggregation(balanceAgg);
        searchRequest.source(searchSourceBuilder);
//        打印检索条件
        System.out.println(searchRequest);
//        执行检索
        SearchResponse searchResponse = client.search(searchRequest, MallElasticSearchConfig.COMMON_OPTIONS);
//        获取所有命中的记录
//        这里是转为map对象
        Map map = JSON.parseObject(searchResponse.toString(), Map.class);
//        获取命中的记录
        SearchHits hits = searchResponse.getHits();
        SearchHit[] searchHits = hits.getHits();
        for (SearchHit searchHit : searchHits) {
            System.out.println(searchHit.getIndex());
            System.out.println(searchHit.getId());
//            Map<String, Object> sourceAsMap = searchHit.getSourceAsMap();
            String sourceAsString = searchHit.getSourceAsString();
            Account account = JSON.parseObject(sourceAsString, Account.class);
            System.out.println(account);
        }
        System.out.println(map);
        System.out.println(searchResponse);
//        获取检索到的分析信息
        Aggregations aggregations = searchResponse.getAggregations();
        List<Aggregation> list = aggregations.asList();
        for (Aggregation aggregation : list) {
            System.out.println(aggregation.getName());
        }
        Terms ageAggTon = aggregations.get("ageAgg");
        for (Terms.Bucket bucket : ageAggTon.getBuckets()) {
            System.out.println("年龄"+bucket.getKeyAsString());
            System.out.println(bucket.getDocCount());
        }
        Avg balanceAvg = aggregations.get("balanceAvg");
        System.out.println("平均薪资"+balanceAvg.getValue());
    }
    @Data
    @AllArgsConstructor
    @NoArgsConstructor
    class User{
        private String username;
        private Integer age;
        private String gender;
    }

    @Data
    @NoArgsConstructor
    @AllArgsConstructor
    @ToString
    static class Account{
    /**
     * Copyright 2024 bejson.com
     */

    /**
     * Auto-generated: 2024-07-17 13:20:0
     *
     * @author bejson.com (i@bejson.com)
     * @website http://www.bejson.com/java2pojo/
     */
        private int account_number;
        private int balance;
        private String firstname;
        private String lastname;
        private int age;
        private String gender;
        private String address;
        private String employer;
        private String email;
        private String city;
        private String state;
    }
}

/**
  * Copyright 2024 bejson.com 
  */
package com.bejson.pojo;

/**
 * Auto-generated: 2024-07-17 13:20:0
 *
 * @author bejson.com (i@bejson.com)
 * @website http://www.bejson.com/java2pojo/
 */
public class JsonRootBean {

    private int account_number;
    private int balance;
    private String firstname;
    private String lastname;
    private int age;
    private String gender;
    private String address;
    private String employer;
    private String email;
    private String city;
    private String state;
    public void setAccount_number(int account_number) {
         this.account_number = account_number;
     }
     public int getAccount_number() {
         return account_number;
     }

    public void setBalance(int balance) {
         this.balance = balance;
     }
     public int getBalance() {
         return balance;
     }

    public void setFirstname(String firstname) {
         this.firstname = firstname;
     }
     public String getFirstname() {
         return firstname;
     }

    public void setLastname(String lastname) {
         this.lastname = lastname;
     }
     public String getLastname() {
         return lastname;
     }

    public void setAge(int age) {
         this.age = age;
     }
     public int getAge() {
         return age;
     }

    public void setGender(String gender) {
         this.gender = gender;
     }
     public String getGender() {
         return gender;
     }

    public void setAddress(String address) {
         this.address = address;
     }
     public String getAddress() {
         return address;
     }

    public void setEmployer(String employer) {
         this.employer = employer;
     }
     public String getEmployer() {
         return employer;
     }

    public void setEmail(String email) {
         this.email = email;
     }
     public String getEmail() {
         return email;
     }

    public void setCity(String city) {
         this.city = city;
     }
     public String getCity() {
         return city;
     }

    public void setState(String state) {
         this.state = state;
     }
     public String getState() {
         return state;
     }

}

/**
  * Copyright 2024 bejson.com 
  */
package com.bejson.pojo;

/**
 * Auto-generated: 2024-07-17 13:20:0
 *
 * @author bejson.com (i@bejson.com)
 * @website http://www.bejson.com/java2pojo/
 */
public class JsonRootBean {

    private int account_number;
    private int balance;
    private String firstname;
    private String lastname;
    private int age;
    private String gender;
    private String address;
    private String employer;
    private String email;
    private String city;
    private String state;
    public void setAccount_number(int account_number) {
         this.account_number = account_number;
     }
     public int getAccount_number() {
         return account_number;
     }

    public void setBalance(int balance) {
         this.balance = balance;
     }
     public int getBalance() {
         return balance;
     }

    public void setFirstname(String firstname) {
         this.firstname = firstname;
     }
     public String getFirstname() {
         return firstname;
     }

    public void setLastname(String lastname) {
         this.lastname = lastname;
     }
     public String getLastname() {
         return lastname;
     }

    public void setAge(int age) {
         this.age = age;
     }
     public int getAge() {
         return age;
     }

    public void setGender(String gender) {
         this.gender = gender;
     }
     public String getGender() {
         return gender;
     }

    public void setAddress(String address) {
         this.address = address;
     }
     public String getAddress() {
         return address;
     }

    public void setEmployer(String employer) {
         this.employer = employer;
     }
     public String getEmployer() {
         return employer;
     }

    public void setEmail(String email) {
         this.email = email;
     }
     public String getEmail() {
         return email;
     }

    public void setCity(String city) {
         this.city = city;
     }
     public String getCity() {
         return city;
     }

    public void setState(String state) {
         this.state = state;
     }
     public String getState() {
         return state;
     }

}

GET users/_search

GET /bank/_search
{
  "from": 1,
  "size": 10,
  "query": {
    "match": {
      "address": {
        "query": "mill",
        "operator": "OR",
        "prefix_length": 0,
        "max_expansions": 50,
        "fuzzy_transpositions": true,
        "lenient": false,
        "zero_terms_query": "NONE",
        "auto_generate_synonyms_phrase_query": true,
        "boost": 1
      }
    }
  },
  "aggregations": {
    "ageAgg": {
      "terms": {
        "field": "age",
        "size": 1,
        "min_doc_count": 1,
        "shard_min_doc_count": 0,
        "show_term_doc_count_error": false,
        "order": [
          { "_count": "desc" },
          { "_key": "asc" }
        ]
      }
    },
    "balanceAvg": {
      "avg": {
        "field": "balance"
      }
    }
  }
}

GET users/_search

GET /bank/_search
{
  "from": 1,
  "size": 10,
  "query": {
    "match": {
      "address": {
        "query": "mill",
        "operator": "OR",
        "prefix_length": 0,
        "max_expansions": 50,
        "fuzzy_transpositions": true,
        "lenient": false,
        "zero_terms_query": "NONE",
        "auto_generate_synonyms_phrase_query": true,
        "boost": 1
      }
    }
  },
  "aggregations": {
    "ageAgg": {
      "terms": {
        "field": "age",
        "size": 1,
        "min_doc_count": 1,
        "shard_min_doc_count": 0,
        "show_term_doc_count_error": false,
        "order": [
          { "_count": "desc" },
          { "_key": "asc" }
        ]
      }
    },
    "balanceAvg": {
      "avg": {
        "field": "balance"
      }
    }
  }
}
 

{
  "took" : 2,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 4,
      "relation" : "eq"
    },
    "max_score" : 5.4032025,
    "hits" : [
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "136",
        "_score" : 5.4032025,
        "_source" : {
          "account_number" : 136,
          "balance" : 45801,
          "firstname" : "Winnie",
          "lastname" : "Holland",
          "age" : 38,
          "gender" : "M",
          "address" : "198 Mill Lane",
          "employer" : "Neteria",
          "email" : "winnieholland@neteria.com",
          "city" : "Urie",
          "state" : "IL"
        }
      },
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "345",
        "_score" : 5.4032025,
        "_source" : {
          "account_number" : 345,
          "balance" : 9812,
          "firstname" : "Parker",
          "lastname" : "Hines",
          "age" : 38,
          "gender" : "M",
          "address" : "715 Mill Avenue",
          "employer" : "Baluba",
          "email" : "parkerhines@baluba.com",
          "city" : "Blackgum",
          "state" : "KY"
        }
      },
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "472",
        "_score" : 5.4032025,
        "_source" : {
          "account_number" : 472,
          "balance" : 25571,
          "firstname" : "Lee",
          "lastname" : "Long",
          "age" : 32,
          "gender" : "F",
          "address" : "288 Mill Street",
          "employer" : "Comverges",
          "email" : "leelong@comverges.com",
          "city" : "Movico",
          "state" : "MT"
        }
      }
    ]
  },
  "aggregations" : {
    "ageAgg" : {
      "doc_count_error_upper_bound" : 0,
      "sum_other_doc_count" : 2,
      "buckets" : [
        {
          "key" : 38,
          "doc_count" : 2
        }
      ]
    },
    "balanceAvg" : {
      "value" : 25208.0
    }
  }
}

 {
  "took" : 2,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 4,
      "relation" : "eq"
    },
    "max_score" : 5.4032025,
    "hits" : [
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "136",
        "_score" : 5.4032025,
        "_source" : {
          "account_number" : 136,
          "balance" : 45801,
          "firstname" : "Winnie",
          "lastname" : "Holland",
          "age" : 38,
          "gender" : "M",
          "address" : "198 Mill Lane",
          "employer" : "Neteria",
          "email" : "winnieholland@neteria.com",
          "city" : "Urie",
          "state" : "IL"
        }
      },
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "345",
        "_score" : 5.4032025,
        "_source" : {
          "account_number" : 345,
          "balance" : 9812,
          "firstname" : "Parker",
          "lastname" : "Hines",
          "age" : 38,
          "gender" : "M",
          "address" : "715 Mill Avenue",
          "employer" : "Baluba",
          "email" : "parkerhines@baluba.com",
          "city" : "Blackgum",
          "state" : "KY"
        }
      },
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "472",
        "_score" : 5.4032025,
        "_source" : {
          "account_number" : 472,
          "balance" : 25571,
          "firstname" : "Lee",
          "lastname" : "Long",
          "age" : 32,
          "gender" : "F",
          "address" : "288 Mill Street",
          "employer" : "Comverges",
          "email" : "leelong@comverges.com",
          "city" : "Movico",
          "state" : "MT"
        }
      }
    ]
  },
  "aggregations" : {
    "ageAgg" : {
      "doc_count_error_upper_bound" : 0,
      "sum_other_doc_count" : 2,
      "buckets" : [
        {
          "key" : 38,
          "doc_count" : 2
        }
      ]
    },
    "balanceAvg" : {
      "value" : 25208.0
    }
  }
}

SearchRequest{searchType=QUERY_THEN_FETCH, indices=[bank], indicesOptions=IndicesOptions[ignore_unavailable=false, allow_no_indices=true, expand_wildcards_open=true, expand_wildcards_closed=false, allow_aliases_to_multiple_indices=true, forbid_closed_indices=true, ignore_aliases=false, ignore_throttled=true], types=[], routing='null', preference='null', requestCache=null, scroll=null, maxConcurrentShardRequests=0, batchedReduceSize=512, preFilterShardSize=128, allowPartialSearchResults=null, localClusterAlias=null, getOrCreateAbsoluteStartMillis=-1, ccsMinimizeRoundtrips=true, source={"from":1,"size":10,"query":{"match":{"address":{"query":"mill","operator":"OR","prefix_length":0,"max_expansions":50,"fuzzy_transpositions":true,"lenient":false,"zero_terms_query":"NONE","auto_generate_synonyms_phrase_query":true,"boost":1.0}}},"aggregations":{"ageAgg":{"terms":{"field":"age","size":1,"min_doc_count":1,"shard_min_doc_count":0,"show_term_doc_count_error":false,"order":[{"_count":"desc"},{"_key":"asc"}]}},"balanceAvg":{"avg":{"field":"balance"}}}}}
bank
136
TestLoad.Account(account_number=136, balance=45801, firstname=Winnie, lastname=Holland, age=38, gender=M, address=198 Mill Lane, employer=Neteria, email=winnieholland@neteria.com, city=Urie, state=IL)
bank
345
TestLoad.Account(account_number=345, balance=9812, firstname=Parker, lastname=Hines, age=38, gender=M, address=715 Mill Avenue, employer=Baluba, email=parkerhines@baluba.com, city=Blackgum, state=KY)
bank
472
TestLoad.Account(account_number=472, balance=25571, firstname=Lee, lastname=Long, age=32, gender=F, address=288 Mill Street, employer=Comverges, email=leelong@comverges.com, city=Movico, state=MT)
{_shards={"total":1,"failed":0,"successful":1,"skipped":0}, hits={"hits":[{"_index":"bank","_type":"account","_source":{"account_number":136,"firstname":"Winnie","address":"198 Mill Lane","balance":45801,"gender":"M","city":"Urie","employer":"Neteria","state":"IL","age":38,"email":"winnieholland@neteria.com","lastname":"Holland"},"_id":"136","_score":5.4032025},{"_index":"bank","_type":"account","_source":{"account_number":345,"firstname":"Parker","address":"715 Mill Avenue","balance":9812,"gender":"M","city":"Blackgum","employer":"Baluba","state":"KY","age":38,"email":"parkerhines@baluba.com","lastname":"Hines"},"_id":"345","_score":5.4032025},{"_index":"bank","_type":"account","_source":{"account_number":472,"firstname":"Lee","address":"288 Mill Street","balance":25571,"gender":"F","city":"Movico","employer":"Comverges","state":"MT","age":32,"email":"leelong@comverges.com","lastname":"Long"},"_id":"472","_score":5.4032025}],"total":{"value":4,"relation":"eq"},"max_score":5.4032025}, took=1, timed_out=false, aggregations={"lterms#ageAgg":{"doc_count_error_upper_bound":0,"sum_other_doc_count":2,"buckets":[{"doc_count":2,"key":38}]},"avg#balanceAvg":{"value":25208.0}}}
{"took":1,"timed_out":false,"_shards":{"total":1,"successful":1,"skipped":0,"failed":0},"hits":{"total":{"value":4,"relation":"eq"},"max_score":5.4032025,"hits":[{"_index":"bank","_type":"account","_id":"136","_score":5.4032025,"_source":{"account_number":136,"balance":45801,"firstname":"Winnie","lastname":"Holland","age":38,"gender":"M","address":"198 Mill Lane","employer":"Neteria","email":"winnieholland@neteria.com","city":"Urie","state":"IL"}},{"_index":"bank","_type":"account","_id":"345","_score":5.4032025,"_source":{"account_number":345,"balance":9812,"firstname":"Parker","lastname":"Hines","age":38,"gender":"M","address":"715 Mill Avenue","employer":"Baluba","email":"parkerhines@baluba.com","city":"Blackgum","state":"KY"}},{"_index":"bank","_type":"account","_id":"472","_score":5.4032025,"_source":{"account_number":472,"balance":25571,"firstname":"Lee","lastname":"Long","age":32,"gender":"F","address":"288 Mill Street","employer":"Comverges","email":"leelong@comverges.com","city":"Movico","state":"MT"}}]},"aggregations":{"lterms#ageAgg":{"doc_count_error_upper_bound":0,"sum_other_doc_count":2,"buckets":[{"key":38,"doc_count":2}]},"avg#balanceAvg":{"value":25208.0}}}
ageAgg
balanceAvg
年龄38
2
平均薪资25208.0
2024-07-17 13:32:02.766  INFO 10088 --- [extShutdownHook] o.s.s.c.ThreadPoolTaskScheduler          : Shutting down ExecutorService 'Nacso-Watch-Task-Scheduler'
2024-07-17 13:32:02.772  INFO 10088 --- [extShutdownHook] o.s.s.concurrent.ThreadPoolTaskExecutor  : Shutting down ExecutorService 'applicationTaskExecutor'

 SearchRequest{searchType=QUERY_THEN_FETCH, indices=[bank], indicesOptions=IndicesOptions[ignore_unavailable=false, allow_no_indices=true, expand_wildcards_open=true, expand_wildcards_closed=false, allow_aliases_to_multiple_indices=true, forbid_closed_indices=true, ignore_aliases=false, ignore_throttled=true], types=[], routing='null', preference='null', requestCache=null, scroll=null, maxConcurrentShardRequests=0, batchedReduceSize=512, preFilterShardSize=128, allowPartialSearchResults=null, localClusterAlias=null, getOrCreateAbsoluteStartMillis=-1, ccsMinimizeRoundtrips=true, source={"from":1,"size":10,"query":{"match":{"address":{"query":"mill","operator":"OR","prefix_length":0,"max_expansions":50,"fuzzy_transpositions":true,"lenient":false,"zero_terms_query":"NONE","auto_generate_synonyms_phrase_query":true,"boost":1.0}}},"aggregations":{"ageAgg":{"terms":{"field":"age","size":1,"min_doc_count":1,"shard_min_doc_count":0,"show_term_doc_count_error":false,"order":[{"_count":"desc"},{"_key":"asc"}]}},"balanceAvg":{"avg":{"field":"balance"}}}}}
bank
136
TestLoad.Account(account_number=136, balance=45801, firstname=Winnie, lastname=Holland, age=38, gender=M, address=198 Mill Lane, employer=Neteria, email=winnieholland@neteria.com, city=Urie, state=IL)
bank
345
TestLoad.Account(account_number=345, balance=9812, firstname=Parker, lastname=Hines, age=38, gender=M, address=715 Mill Avenue, employer=Baluba, email=parkerhines@baluba.com, city=Blackgum, state=KY)
bank
472
TestLoad.Account(account_number=472, balance=25571, firstname=Lee, lastname=Long, age=32, gender=F, address=288 Mill Street, employer=Comverges, email=leelong@comverges.com, city=Movico, state=MT)
{_shards={"total":1,"failed":0,"successful":1,"skipped":0}, hits={"hits":[{"_index":"bank","_type":"account","_source":{"account_number":136,"firstname":"Winnie","address":"198 Mill Lane","balance":45801,"gender":"M","city":"Urie","employer":"Neteria","state":"IL","age":38,"email":"winnieholland@neteria.com","lastname":"Holland"},"_id":"136","_score":5.4032025},{"_index":"bank","_type":"account","_source":{"account_number":345,"firstname":"Parker","address":"715 Mill Avenue","balance":9812,"gender":"M","city":"Blackgum","employer":"Baluba","state":"KY","age":38,"email":"parkerhines@baluba.com","lastname":"Hines"},"_id":"345","_score":5.4032025},{"_index":"bank","_type":"account","_source":{"account_number":472,"firstname":"Lee","address":"288 Mill Street","balance":25571,"gender":"F","city":"Movico","employer":"Comverges","state":"MT","age":32,"email":"leelong@comverges.com","lastname":"Long"},"_id":"472","_score":5.4032025}],"total":{"value":4,"relation":"eq"},"max_score":5.4032025}, took=1, timed_out=false, aggregations={"lterms#ageAgg":{"doc_count_error_upper_bound":0,"sum_other_doc_count":2,"buckets":[{"doc_count":2,"key":38}]},"avg#balanceAvg":{"value":25208.0}}}
{"took":1,"timed_out":false,"_shards":{"total":1,"successful":1,"skipped":0,"failed":0},"hits":{"total":{"value":4,"relation":"eq"},"max_score":5.4032025,"hits":[{"_index":"bank","_type":"account","_id":"136","_score":5.4032025,"_source":{"account_number":136,"balance":45801,"firstname":"Winnie","lastname":"Holland","age":38,"gender":"M","address":"198 Mill Lane","employer":"Neteria","email":"winnieholland@neteria.com","city":"Urie","state":"IL"}},{"_index":"bank","_type":"account","_id":"345","_score":5.4032025,"_source":{"account_number":345,"balance":9812,"firstname":"Parker","lastname":"Hines","age":38,"gender":"M","address":"715 Mill Avenue","employer":"Baluba","email":"parkerhines@baluba.com","city":"Blackgum","state":"KY"}},{"_index":"bank","_type":"account","_id":"472","_score":5.4032025,"_source":{"account_number":472,"balance":25571,"firstname":"Lee","lastname":"Long","age":32,"gender":"F","address":"288 Mill Street","employer":"Comverges","email":"leelong@comverges.com","city":"Movico","state":"MT"}}]},"aggregations":{"lterms#ageAgg":{"doc_count_error_upper_bound":0,"sum_other_doc_count":2,"buckets":[{"key":38,"doc_count":2}]},"avg#balanceAvg":{"value":25208.0}}}
ageAgg
balanceAvg
年龄38
2
平均薪资25208.0
2024-07-17 13:32:02.766  INFO 10088 --- [extShutdownHook] o.s.s.c.ThreadPoolTaskScheduler          : Shutting down ExecutorService 'Nacso-Watch-Task-Scheduler'
2024-07-17 13:32:02.772  INFO 10088 --- [extShutdownHook] o.s.s.concurrent.ThreadPoolTaskExecutor  : Shutting down ExecutorService 'applicationTaskExecutor'

旧约Alatus
关注
  • 33
    点赞
  • 踩
  • 19
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
ElasticSearch集成SpringData史上最全查询教程
CharlesYooSky的博客
09-16 3061
1、简单介绍 springboot 使用springdata操作es,ElasticsearchRepository使用QueryBuilder构造查询条件 2、集成es //maven集成 <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-elasticsearch<
spring-data-elasticsearch-example:Spring Data Elasticsearch示例
05-11
这个示例项目 "spring-data-elasticsearch-example-master" 可能包含了更多的细节，如实体映射、自定义查询、索引管理等，通过深入研究源代码，可以进一步提升对 Spring Data Elasticsearch 的理解和使用能力。
spring data elasticSearch 复杂查询
最新发布
u014007760的博客
04-24 229
且 ( (订单状态为1时 商品名称为[name1 or name2]) or (订单状态为2时 办理人为张三) )且 创建时间在 2023-09-20 16:05:24-2023-09-20 17:05:23之间。假设有一张订单表 查询条件为。对应的查询条件拼接代码。
spring data elasticsearch的一个复杂查询条件
justlpf的专栏
03-04 1万+
原文地址:https://www.cnblogs.com/snake23/p/9438785.html CriteriaQuery criteriaQuery = new CriteriaQuery(new Criteria() .and(new Criteria("clusterName").is("app")) .and(new Criteria("ip").is("127.0.0.1...
Spring Data访问Elasticsearch----查询方法，程序员必学
m0_60707660的博客
04-08 886
不支持使用GeoJson参数构建Geo-shape查询的方法名。如果您需要在存储库中拥有这样的函数，请在自定义存储库实现中使用ElasticsearchOperations和CriteriaQuery。
Spring Data访问Elasticsearch----查询方法(1)
m0_60707660的博客
04-08 153
【代码】Spring Data访问Elasticsearch----查询方法(1)
elasticjob-spring-boot-starter:elasticjob-spring-boot-starter
03-29
Elastic-Job-Lite Spring Boot Starter。 快速开始 1.添加elasticjob-spring-boot-starter依赖项 pom.xml： <groupId>org.springframework.boot <artifactId>spring-boot-starter-parent <version>1.5.12....
spring-boot-elasticsearch.zip
12-04
在本项目"spring-boot-elasticsearch.zip"中，我们聚焦于集成Spring Boot与Elasticsearch，一个流行的全文搜索引擎，用于高效地存储、检索和分析大量数据。Spring Boot简化了Elasticsearch的配置和使用，使得在Java...
spring-data-elasticsearch
05-24
1. **复杂查询**: 除了基本的 CRUD 操作，Spring Data Elasticsearch 还支持复杂的查询构造，如 Term 查询、Match 查询、Geo 查询等，以及聚合分析功能。 2. **脚本字段**: 你可以使用 Elasticsearch 的脚本字段...
人工智能-项目实践-搜索引擎-SpringBoot+ElasticSearch全文搜索引擎
02-26
在本项目实践中，我们将深入探讨如何使用Spring...通过以上步骤，我们可以构建出一个基于Spring Boot和Elasticsearch的全文搜索引擎，该搜索引擎具备高效率、可扩展性和易用性，为人工智能项目提供强大的数据检索支持。
ElasticSearch 安装，保存，查询，更新，复杂查询，模糊查询，高亮查询
weixin_44673447的博客
10-09 322
ik分词器的安装，将ik分词器下载并解压，新建文件夹ik，将解压内容放进ik文件夹中，将ik文件夹放在es安装路径的plugin文件夹中。
spring-boot操作elasticsearch
littleschemer的博客
03-12 701
在Spring Boot可以使用Spring Data Elasticsearch来简化开发过程。本文演示如何使用ElasticsearchRepository对文档进行简单的增删查改，使用ElasticsearchRestTemplate相关API进行较复杂的查询。
Java实战：SpringBoot+ElasticSearch 实现模糊查询
oandy0的博客
03-08 2535
本文将详细介绍如何使用SpringBoot整合ElasticSearch，实现模糊查询、批量CRUD、排序、分页和高亮功能。我们将深入探讨ElasticSearch的相关概念和技术细节，以及如何使用SpringData Elasticsearch库简化开发过程。
simpread-使用 QueryBuilders、NativeSearchQuery 实现复杂查询
青鸟飞鱼
11-27 734
ElasticsearchRestTemplate 是 Spring 封装 ES 客户端的一些原生 api 模板，方便实现一些查询，和 ElasticsearchTemplate 一样，但是目前 spring 推荐使用前者，是一种更高级的 REST 风格 api。废话不多说，先上一个 demo，下面分类具体介绍下。
Spring Data Elasticsearch--ElasticsearchRestTemplate--使用/教程/实例
热门推荐
IT利刃出鞘的博客
10-14 1万+
本文用实例来介绍如何使用Spring Data Elasticsearch的ElasticsearchRestTemplate来操作ES。包括：索引的增删等、文档的增删改查、文档的动态查询（或者说：多条件查询、复杂查询）。 动态查询的含义：查询条件有多个时，某个查询条件可能有也可能没有，这时就需要手动判断，如果为空则不拼装搜索条件。 本文用博客的业务进行示例。索引名：blog，里边有标题、内容、作者、创建时间等。
ElasticSearch与Spring Data Elasticsearch：如何使用Spring Data Elasticsearch与ElasticSearch集成...
禅与计算机程序设计艺术
01-18 1078
1.背景介绍 Elasticsearch是一个基于Lucene的搜索引擎，它提供了实时、可扩展和高性能的搜索功能。Spring Data Elasticsearch是Spring Data项目的一部分，它提供了一种简单的方式来与Elasticsearch集成。在本文中，我们将讨论如何使用Spring Data Elasticsearch与Elasticsearch集成，以及其核心概念、算法原理、...
待完善 Elasticsearch 在大数据的应用：Spring Boot + Elasticsearch：高效管理大数据的利器
.
02-27 642
ES作为一个功能丰富、性能优越的大数据搜索引擎，已经被越来越多的企业广泛应用。本文介绍了ES的核心组件、数据结构和数据类型、查询和聚合操作等知识点，以及ES的实践操作，并通过Java代码示例进行讲解。希望本文能够帮助开发者更好地了解和应用ES，进一步推动ES的发展和应用。
ElasticSearch 实战：Spring Data ElasticSearch 的使用 NativeSearchQuery 高亮查询
qq_33240556的博客
04-02 490
根据实际需求，您可以进一步调整高亮参数（如设置高亮标签、片段大小等），或者为其他字段添加高亮支持。同时，注意处理不同 Spring Data Elasticsearch 版本间的差异，以正确访问高亮内容。访问高亮内容的方法取决于 Spring Data Elasticsearch 的版本。假设您已经有一个使用 Spring Data Elasticsearch 注解的实体类，如。可以实现更为灵活和复杂的查询，包括高亮（highlighting）功能。在需要执行高亮查询的地方，创建一个。
springboot集成ElasticSearch的具体操作（系统全文检索）
wangwei的博客
08-01 461
springboot集成ElasticSearch的具体操作
spring-boot-starter-data-elasticsearch使用
08-13
使用 Spring Boot Starter Data Elasticsearch 可以轻松地在 Spring Boot 应用中集成 Elasticsearch。以下是使用步骤： 1. 添加依赖：在你的 pom.xml 文件中添加 Spring Boot Starter Data Elasticsearch 依赖： ```xml <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-elasticsearch</artifactId> </dependency> ``` 2. 配置连接：在应用的配置文件中，配置 Elasticsearch 的连接信息。例如，在 application.properties 文件中添加以下配置： ```properties spring.data.elasticsearch.cluster-nodes=localhost:9200 ``` 3. 创建实体类：创建一个与 Elasticsearch 索引文档对应的实体类，并使用注解进行映射。例如： ```java import org.springframework.data.annotation.Id; import org.springframework.data.elasticsearch.annotations.Document; @Document(indexName = "myindex", type = "mytype") public class MyDocument { @Id private String id; private String name; // Getters and setters } ``` 在上面的示例中，`@Document` 注解用于指定索引名称和类型，`@Id` 注解表示文档的唯一标识。 4. 创建仓库接口：创建一个继承自 ElasticsearchRepository 的接口，用于定义与 Elasticsearch 进行交互的方法。例如： ```java import org.springframework.data.elasticsearch.repository.ElasticsearchRepository; public interface MyDocumentRepository extends ElasticsearchRepository<MyDocument, String> { List<MyDocument> findByName(String name); } ``` 在上面的示例中，`ElasticsearchRepository` 提供了一些基本的 CRUD 操作，你还可以定义自己的查询方法。 5. 使用仓库接口：在需要使用 Elasticsearch 的地方，通过注入仓库接口来进行操作。例如，在一个服务类中注入 `MyDocumentRepository` 并使用它执行查询： ```java import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; @Service public class MyService { @Autowired private MyDocumentRepository repository; public List<MyDocument> searchByName(String name) { return repository.findByName(name); } } ``` 以上就是使用 Spring Boot Starter Data Elasticsearch 的基本步骤。你可以根据自己的需求，进行更多的配置和操作，包括自定义查询、分页等。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值