• es : java 查询

    1. POM 配置

    1.  <dependency>
    2.       <groupId>org.elasticsearch.client</groupId>
    3.       <artifactId>elasticsearch-rest-high-level-client</artifactId>
    4.       <version>7.6.2</version>
    5.  </dependency>

    2. 建立ES集群连接

    1.  
    2. RestHighLevelClient client = new RestHighLevelClient(
    3.                 RestClient.builder(
    4.                         new HttpHost(IP, PORT, "http")));
    5.  
    6. 同样，如果我们要连接集群中多个ES节点时，只需要在RestClient 的 builder 方法中多添加几个HttpPost对象即可
    7. String ipPort = "10.xx:9200,10.xx:9200,10.xx:9200";
    8. String[] ipPortArry = ipPort.split(",");
    9. List<HttpHost>  httpHostsList = new ArrayList();
    10.         for(String ips : ipPortArry){
    11.            String[] ipArray = ips.split(":");
    12.             httpHostsList.add(new HttpHost(ipArray[0], Integer.parseInt(ipArray[1]), "http"));
    13.         }
    14.  
    15. RestHighLevelClient client = new RestHighLevelClient(  RestClient.builder(httpHostsList.toArray(new HttpHost[httpHostsList.size()])));
    16.  
    17.  
    18. 补充：
    19. Java配置多个ES节点时，请求的时候会随机选一个节点作为协调节点负责分发请求和处理结果，所以Java链接ES节点数量的多少，不会影响到Java请求ES查询结果的速度，只是其中某个节点宕机时，其他节点可以保证正常的查询和操作。
    20.  
    21. ES 端口9200与9300的区别：
    22. 9200作为Http协议，主要用于外部通讯
    23. 9300作为Tcp协议，jar之间就是通过tcp协议通讯
    24. ES集群之间是通过9300进行通讯

    3. 简单的查询并获取查询结果

    1. RestHighLevelClient client = new RestHighLevelClient(
    2.             RestClient.builder(
    3.                 new HttpHost("localhost", 9200, "http")));
    4.  
    5. SearchRequest searchRequest = new SearchRequest("my_index");
    6. //或者
    7. /*
    8.  SearchRequest searchRequest = new SearchRequest();
    9.  searchRequest.indices("my_index");
    10. */
    11.  
    12. SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
    13. searchSourceBuilder.query(QueryBuilders.matchAllQuery());
    14. //配置source源字段过虑，1显示的，2排除的
    15. searchSourceBuilder.fetchSource(new String[]{"name","studymodel","description"},new String[]{});
    16.  
    17. searchRequest.source(searchSourceBuilder);
    18. SearchResponse searchResponse = client.search(searchRequest);
    19. //获取所有搜索结果、总匹配数量
    20.         SearchHits hits = searchResponse.getHits();
    21.         long totalHits = hits.getTotalHits();    //如果总是超过1万, index没有设置,则返回1万
    22.         SearchHit[] searchHits = hits.getHits();
    23.         //遍历结果
    24.         for(SearchHit searchHit:searchHits){
    25.             String index = searchHit.getIndex();
    26.             String type = searchHit.getType();
    27.             String id = searchHit.getId();
    28.             float score = searchHit.getScore();
    29.             String sourceAsString = searchHit.getSourceAsString();
    30.             Map<String, Object> sourceAsMap = searchHit.getSourceAsMap();
    31.             String name = (String) sourceAsMap.get("name");
    32.             String studymodel = (String) sourceAsMap.get("studymodel");
    33.             String description = (String) sourceAsMap.get("description");
    34.             System.out.println(name);
    35.             System.out.println(studymodel);
    36.             System.out.println(description);
    37.         }
    38.  
    39. //关闭链接
    40. client.close()
    41.  
    42.  
    43. es的dsl: 
    44.  {
    45.         "query": {
    46.         	"match_all": {}
    47.         },
    48.         "_source" : ["name","studymodel","description"]
    49. }

    4. 使用es的json 拼接查询语句

    1. StringBuffer dsl = new StringBuffer();
    2. 		dsl.append("{\"bool\": {");
    3. 		dsl.append("      \"must\": [");
    4. 		dsl.append("        {");
    5. 		dsl.append("          \"term\": {");
    6. 		dsl.append("            \"mdid.keyword\": {");
    7. 		dsl.append("              \"value\": \"2fa9d41e1af460e0d47ce36ca8a98737\"");
    8. 		dsl.append("            }");
    9. 		dsl.append("          }");
    10. 		dsl.append("        }");
    11. 		dsl.append("      ]");
    12. 		dsl.append("    }");
    13. 		dsl.append("}");
    14.  
    15.  
    16.  SearchRequest searchRequest = new SearchRequest();
    17.  searchRequest.indices("my_index");
    18.  
    19.  
    20. SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
    21. searchSourceBuilder.query(ueryBuilders.wrapperQuery(dsl.toString()));
    22. //配置source源字段过虑，1显示的，2排除的
    23. searchSourceBuilder.fetchSource(new String[]{"name","studymodel","description"},new String[]{});
    24.  
    25. searchRequest.source(searchSourceBuilder);
    26. SearchResponse searchResponse = client.search(searchRequest);

    5. query 

    5.0 QueryBuilders转换为JSON字符串,方便调试
    1. QueryBuilder query = QueryBuilders.termQuery("name", "John");
    2. SearchSourceBuilder sourceBuilder = new SearchSourceBuilder();
    3. sourceBuilder.query(query);
    4.  
    5. String json = sourceBuilder.toString();
    6. System.out.println(json);
    7. 并将其转换为JSON字符串
    8. toString()方法返回的字符串是格式化的，可以在控制台中方便地查看和调试。
    5.1 Term Query
    1.  {
    2.         "query": {
    3.             "term" : {
    4.                 "name": "spring"
    5.             }
    6.         },
    7.         "_source" : ["name","studymodel"]
    8.     }
    9.  
    10.  
    11. SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
    12. searchSourceBuilder.query(QueryBuilders.termQuery("name","spring"));
    13. searchSourceBuilder.fetchSource(new String[]{"name","studymodel","description"}, new String[]{});
    14.
    5.2  terms query ES提供根据多个id值匹配的方法
    1. {
    2.   "query": {
    3.     "terms": {
    4.       "systemAssignedTo.keyword": [
    5.         "1",
    6.         "2"
    7.       ]
    8.     }
    9.     
    10.   }
    11. }
    12.  
    13. select  *  from  mr_zcy where  systemAssignedTo in ('1','2')
    14.  
    15. SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
    16. String[] ids = {"1", "2"};
    17. searchSourceBuilder.query(QueryBuilders.termsQuery("systemAssignedTo.keyword",ids));
    18.  
    19.
    5.3 match query (匹配单个字段)
    1. {
    2.         "query": {
    3.             "match": {
    4.                 "name": {
    5.                     "query": "spring开发",
    6.                     "operator": "or"
    7.                 }
    8.             }
    9.         },
    10.     	"_source" : ["name"]
    11.     }
    12. SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
    13. searchSourceBuilder.query(QueryBuilders.matchQuery("name","spring开发").operator(Operator.OR));
    14. searchSourceBuilder.fetchSource(new String[]{"name"}, new String[]{});

    5.4 minimum_should_match
    1. {
    2.         "query": {
    3.             "match": {
    4.                 "description": {
    5.                     "query": "spring开发框架",
    6.                     "minimum_should_match": "80%"
    7.                 }
    8.             }
    9.         }
    10.     }
    11. spring开发框架 会被分为三个词：spring、开发、框架
    12.  
    13. 设置 minimum_should_match:80% 表示，三个词在文档的匹配占比为 80%，即 3 * 0.8=2.4，向上取整得2，表示至少有 两个词 在文档中要匹配成功。
    14.  
    15. searchSourceBuilder.query(QueryBuilders.matchQuery("description","spring开发框架").minimumShouldMatch("80%"));
    5.5 multi query (匹配多个字段)
    1. {
    2.         "query": {
    3.             "multi_match": {
    4.                 "query": "spring框架",
    5.                 "minimum_should_match": "50%",
    6.                 "fields": [
    7.                     "name^10",
    8.                     "description"
    9.                 ]
    10.             }
    11.         }
    12.     }
    13. 拿关键字 spring css去匹配 name 和 description 字段。
    14. name^10 表示权重提升 10 倍，执行上边的查询，发现 name 中包括 spring 关键字的文档排在前边
    15. MultiMatchQueryBuilder multiMatchQueryBuilder = QueryBuilders.multiMatchQuery("spring框架", "name", "description").minimumShouldMatch("50%");
    16. multiMatchQueryBuilder.field("name",10);
    17. searchSourceBuilder.query(multiMatchQueryBuilder);
     5.6 布尔查询
    1. {
    2.         "_source": [
    3.             "name",
    4.             "studymodel",
    5.             "description"
    6.         ],
    7.         "from": 0,
    8.         "size": 1,
    9.         "query": {
    10.             "bool": {
    11.                 "must": [
    12.                     {
    13.                         "multi_match": {
    14.                             "query": "spring框架",
    15.                             "minimum_should_match": "50%",
    16.                             "fields": [
    17.                                 "name^10",
    18.                                 "description"
    19.                             ]
    20.                         }
    21.                     },
    22.                     {
    23.                         "term": {
    24.                             "studymodel": "201001"
    25.                         }
    26.                     }
    27.                 ]
    28.             }
    29.         }
    30.     }
    31.  
    32.  
    33.  
    34.  
    35.         //创建multiMatch查询
    36. MultiMatchQueryBuilder multiMatchQueryBuilder = QueryBuilders.multiMatchQuery("spring框架", "name", "description").minimumShouldMatch("50%");
    37.         multiMatchQueryBuilder.field("name",10);
    38.         //创建term查询
    39. TermQueryBuilder termQueryBuilder = QueryBuilders.termQuery("studymodel", 201001);
    40.  
    41.         //创建布尔查询
    42. BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery();
    43. boolQueryBuilder.must(multiMatchQueryBuilder);
    44. boolQueryBuilder.must(termQueryBuilder);
    5.7 过滤器 
    1. {
    2.         "_source": [
    3.             "name",
    4.             "studymodel",
    5.             "description",
    6.             "price"
    7.         ],
    8.         "query": {
    9.             "bool": {
    10.                 "must": [
    11.                     {
    12.                         "multi_match": {
    13.                             "query": "spring框架",
    14.                             "minimum_should_match": "50%",
    15.                             "fields": [
    16.                                 "name^10",
    17.                                 "description"
    18.                             ]
    19.                         }
    20.                     }
    21.                 ],
    22.                 "filter": [
    23.                     {
    24.                         "term": {
    25.                             "studymodel": "201001"
    26.                         }
    27.                     },
    28.                     {
    29.                         "range": {
    30.                             "price": {
    31.                                 "gte": 60,
    32.                                 "lte": 100
    33.                             }
    34.                         }
    35.                     }
    36.                 ]
    37.             }
    38.         }
    39.     }
    40.  
    41.  
    42. SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
    43.         //创建multiMatch查询
    44. MultiMatchQueryBuilder multiMatchQueryBuilder = QueryBuilders.multiMatchQuery("spring框架", "name", "description").minimumShouldMatch("50%");
    45.  
    46. multiMatchQueryBuilder.field("name",10);
    47.  
    48.         //布尔查询
    49. BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery();
    50. boolQueryBuilder.must(multiMatchQueryBuilder);
    51.         //过虑条件
    52. boolQueryBuilder.filter(QueryBuilders.termQuery("studymodel", "201001"));
    53. boolQueryBuilder.filter(QueryBuilders.rangeQuery("price").gte(60).lte(100));
    54. searchSourceBuilder.query(boolQueryBuilder);
     5.8 排序

    可以在字段上添加一个或多个排序，支持在 keyword、date、float 等类型上添加，text 类型的字段上不允许添加排序。

    1. {
    2.        "_source": [
    3.            "name",
    4.            "studymodel",
    5.            "description",
    6.            "price"
    7.        ],
    8.        "query": {
    9.            "bool": {
    10.                "filter": [
    11.                    {
    12.                        "range": {
    13.                            "price": {
    14.                                "gte": 0,
    15.                                "lte": 100
    16.                            }
    17.                        }
    18.                    }
    19.                ]
    20.            }
    21.        },
    22.        "sort": [
    23.            {
    24.                "studymodel": "desc"
    25.            },
    26.            {
    27.                "price": "asc"
    28.            }
    29.        ]
    30.    }
    31.  
    32.  
    33. SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
    34.         //boolQuery搜索方式
    35.         //定义一个boolQuery
    36. BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery();
    37.         //定义过虑器
    38.  boolQueryBuilder.filter(QueryBuilders.rangeQuery("price").gte(0).lte(100));
    39.         
    40. searchSourceBuilder.query(boolQueryBuilder);
    41.  
    42.         //添加排序
    43.         searchSourceBuilder.sort("studymodel", SortOrder.DESC);
    44.         searchSourceBuilder.sort("price", SortOrder.ASC);
    45.         searchSourceBuilder.fetchSource(new String[]{"name","studymodel","description"}, new String[]{});
    46.         //向搜索请求对象中设置搜索源
    47.         searchRequest.source(searchSourceBuilder);
     5.9 高亮
    1. public void testHighlight() throws IOException, ParseException {
    2.         //搜索请求对象
    3.         SearchRequest searchRequest = new SearchRequest("xc_course");
    4.         //指定类型
    5.         searchRequest.types("doc");
    6.         //搜索源构建对象
    7.         SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
    8.  
    9.         //boolQuery搜索方式
    10.         //先定义一个MultiMatchQuery
    11.         MultiMatchQueryBuilder multiMatchQueryBuilder = QueryBuilders.multiMatchQuery("开发框架", "name", "description")
    12.                 .minimumShouldMatch("50%")
    13.                 .field("name", 10);
    14.  
    15.         //定义一个boolQuery
    16.         BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery();
    17.         boolQueryBuilder.must(multiMatchQueryBuilder);
    18.         //定义过虑器
    19.         boolQueryBuilder.filter(QueryBuilders.rangeQuery("price").gte(0).lte(100));
    20.  
    21.         searchSourceBuilder.query(boolQueryBuilder);
    22.         //设置源字段过虑,第一个参数结果集包括哪些字段，第二个参数表示结果集不包括哪些字段
    23.         searchSourceBuilder.fetchSource(new String[]{"name","studymodel","price","timestamp"},new String[]{});
    24.  
    25.         //设置高亮
    26.         HighlightBuilder highlightBuilder = new HighlightBuilder();
    27.         highlightBuilder.preTags("");
    28.         highlightBuilder.postTags("");
    29.         highlightBuilder.fields().add(new HighlightBuilder.Field("name"));
    30. //        highlightBuilder.fields().add(new HighlightBuilder.Field("description"));
    31.         searchSourceBuilder.highlighter(highlightBuilder);
    32.  
    33.         //向搜索请求对象中设置搜索源
    34.         searchRequest.source(searchSourceBuilder);
    35.         //执行搜索,向ES发起http请求
    36.         SearchResponse searchResponse = client.search(searchRequest);
    37.         //搜索结果
    38.         SearchHits hits = searchResponse.getHits();
    39.         //匹配到的总记录数
    40.         long totalHits = hits.getTotalHits();
    41.         //得到匹配度高的文档
    42.         SearchHit[] searchHits = hits.getHits();
    43.         //日期格式化对象
    44.         SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    45.         for(SearchHit hit:searchHits){
    46.             //文档的主键
    47.             String id = hit.getId();
    48.             //源文档内容
    49.             Map<String, Object> sourceAsMap = hit.getSourceAsMap();
    50.             //源文档的name字段内容
    51.             String name = (String) sourceAsMap.get("name");
    52.             //取出高亮字段
    53.             Map<String, HighlightField> highlightFields = hit.getHighlightFields();
    54.             if(highlightFields!=null){
    55.                 //取出name高亮字段
    56.                 HighlightField nameHighlightField = highlightFields.get("name");
    57.                 if(nameHighlightField!=null){
    58.                     Text[] fragments = nameHighlightField.getFragments();
    59.                     StringBuffer stringBuffer = new StringBuffer();
    60.                     for(Text text:fragments){
    61.                         stringBuffer.append(text);
    62.                     }
    63.                     name = stringBuffer.toString();
    64.                 }
    65.             }
    66.  
    67.             //由于前边设置了源文档字段过虑，这时description是取不到的
    68.             String description = (String) sourceAsMap.get("description");
    69.             //学习模式
    70.             String studymodel = (String) sourceAsMap.get("studymodel");
    71.             //价格
    72.             Double price = (Double) sourceAsMap.get("price");
    73.             //日期
    74.             Date timestamp = dateFormat.parse((String) sourceAsMap.get("timestamp"));
    75.             System.out.println(name);
    76.             System.out.println(studymodel);
    77.             System.out.println(description);
    78.         }
    79.  
    80.     }
     5.10 聚合
    1. #聚合搜索 address 中包含 mill 的所有人的年龄分布以及平均薪资
    2. GET bank/_search
    3. {
    4.   "query":{
    5.     "match": {
    6.       "address": "mill"
    7.     }
    8.   },
    9.   "aggs": {
    10.     "ageAgg": {
    11.       "terms": {
    12.         "field": "age",
    13.         "size": 10
    14.       }
    15.     },
    16.     "balanceAvg":{
    17.       "avg":{
    18.         "field": "balance"
    19.       }
    20.     }
    21.   },
    22.   "size": 0
    23. }
    24.  
    25.  
    26. SearchRequest searchRequest = new SearchRequest();
    27. //指定索引
    28. searchRequest.indices("bank");
    29. 		//指定DSL 检索条件
    30. SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
    31. searchSourceBuilder.query(QueryBuilders.matchQuery("address","mill"));
    32. //按照年龄只分布进行聚合
    33. TermsAggregationBuilder ageAgg = AggregationBuilders.terms("ageAgg").field("age").size(10);
    34. 		searchSourceBuilder.aggregation(ageAgg);
    35. //计算平均薪资
    36. AvgAggregationBuilder balanceAvg = AggregationBuilders.avg("balanceAvg").field("blance");
    37. searchSourceBuilder.aggregation(balanceAvg);
    38.  
    39. //打印检索条件
    40. System.out.println("检索条件："+searchSourceBuilder);
    41. searchRequest.source(searchSourceBuilder);
    42. //执行检索
    43. SearchResponse search = client.search(searchRequest, RequestOptions.DEFAULT);
    44. SearchHits hits = search.getHits();
    45. SearchHit[] searchHits = hits.getHits();
    46. for (SearchHit hit: searchHits){
    47.  
    48. 			String sourceAsString = hit.getSourceAsString();
    49. 			Accout accout = JSON.parseObject(sourceAsString, Accout.class);
    50. 			System.out.println(accout.toString());
    51. }
    52. //获取检索的分析信息
    53. Aggregations aggregations = search.getAggregations();
    54. //		for (Aggregation aggregation : aggregations.asList()) {
    55. //			System.out.println("当前聚合名字："+aggregation.getName());
    56. //		}
    57. //分类聚合
    58. Terms ageAgg1 = aggregations.get("ageAgg");
    59. for (Terms.Bucket bucket : ageAgg1.getBuckets()) {
    60. 			String keyAsString = bucket.getKeyAsString();
    61. 			System.out.println("年龄：" + keyAsString + "人数："+bucket.getDocCount());
    62. }
    63. //平局值
    64. Avg balanceAvg1 = aggregations.get("balanceAvg");
    65. System.out.println("平均薪资"+ balanceAvg1.getValue());
    66.

    6.分页查询

    6.1  from,size
    1. SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
    2. searchSourceBuilder.query(QueryBuilders.matchAllQuery());
    3. //分页查询，设置起始下标，从0开始
    4. searchSourceBuilder.from(0);
    5. //每页显示个数
    6. searchSourceBuilder.size(10);
    7. //source源字段过虑
    8. searchSourceBuilder.fetchSource(new String[]{"name","studymodel"}, new String[]{});
    9. searchRequest.source(searchSourceBuilder);
    10. SearchResponse searchResponse = client.search(searchRequest);

    6.2 searchAfter
    1. searchSourceBuilder.query(QueryBuilders.wrapperQuery(dsl.toString()));
    2. searchSourceBuilder.size(10);
    3. searchSourceBuilder.sort("id", SortOrder.ASC);
    4. searchRequest.source(searchSourceBuilder);
    5.  
    6. SearchResponse searchResponse = client.search(searchRequest, RequestOptions.DEFAULT);
    7. SearchHit[] searchHits = searchResponse.getHits().getHits();
    8.         while (searchHits.length > 0) {
    9.    
    10.             SearchHit last = searchHits[searchHits.length - 1];
    11.             sourceBuilder.searchAfter(last.getSortValues());
    12.             searchResponse = client.search(searchRequest, RequestOptions.DEFAULT);
    13.             searchHits = searchResponse.getHits().getHits();
    14.         }
    6.3 Scroll分页 

    Elasticsearch-Scroll分页-Java示例-CSDN博客

    1. searchSourceBuilder.query(QueryBuilders.wrapperQuery(dsl.toString()));
    2. searchSourceBuilder.size(10);
    3. searchSourceBuilder.sort("id", SortOrder.ASC);
    4.  
    5. searchRequest.source(searchSourceBuilder);
    6. // 指定超时时间
    7. searchRequest.scroll(new TimeValue(5000));
    8.  
    9. SearchResponse searchResponse = highLevelClient.search(searchRequest, RequestOptions.DEFAULT);
    10.  
    11. long length = searchResponse.getHits().getHits().length;
    12. String scrollId = null;
    13. while (length > 0) {
    14.             consumer.accept(searchResponse);
    15.             scrollId = searchResponse.getScrollId();
    16.             SearchScrollRequest scrollRequest = new SearchScrollRequest(scrollId)
    17.                     .scroll(keepAlive);
    18.             searchResponse = highLevelClient.scroll(scrollRequest, RequestOptions.DEFAULT);
    19.             length = searchResponse.getHits().getHits().length;
    20. }
    21.  
    22. // 清空快照记录，避免内存占用
    23.         if (isClearScroll && scrollId != null) {
    24.             ClearScrollRequest clearScrollRequest = new ClearScrollRequest();
    25.             clearScrollRequest.addScrollId(scrollId);
    26.  
    27.             highLevelClient.clearScrollAsync(clearScrollRequest, RequestOptions.DEFAULT, new ActionListener<ClearScrollResponse>() {
    28.             @Override
    29.             public void onResponse(ClearScrollResponse clearScrollResponse) {
    30.  
    31.             }
    32.  
    33.             @Override
    34.             public void onFailure(Exception e) {
    35.                 throw new ElasticsearchException(e);
    36.             }
    37.         });
    38.  
    39.         }
    40.  
    41.

  • 相关阅读:
    前端实现页面内容的截图与下载（html2canvas）
    php比特教务选排课系统的设计与实现毕业设计源码301826
    JMeter 扩展开发：自定义 Java Sampler
    算法总结-最短距离和问题
    十三、Java Agent
    什么是P = NP?问题
    【全面速懂】C#使用WSDL服务
    网络安全基础技术扫盲篇 — 名词解释之“数据包“
    ⼀⽂读懂加密资产交易赛道的新锐⼒量Bitdu
    STM32H7高性能MCU系列 STM32H7A3NGH6 32-bit RISC内核
  • 原文地址：https://blog.csdn.net/zhuchunyan_aijia/article/details/133961896