【elasticsearch系列】javaApi高级查询

最新推荐文章于 2024-07-03 10:21:34 发布
最新推荐文章于 2024-07-03 10:21:34 发布
阅读量935 收藏
点赞数
分类专栏： Elasticsearch 文章标签： elasticsearch java 大数据
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Ming_5257/article/details/120994286
版权
全匹配查询
// 创建客户端
RestHighLevelClient esClient=new RestHighLevelClient(
  RestClient.builder(new HttpHost("localhost",9200,"http"))
);
// 创建查询对象
SearchRequest request=new SearchRequest();
// 设置索引
request.indices("user");
// 设置查询条件
request.source(new SearchSourceBuilder().query(QueryBuilders.matchAllQuery()));
SearchResponse response = esClient.search(request, RequestOptions.DEFAULT);
SearchHits hits = response.getHits();
// 打印命中条数
System.out.println(hits.getTotalHits());
for(SearchHit hit: hits){
  // 打印每一项
  System.out.println(hit.getSourceAsString());
}
// 关闭客户端
esClient.close();
结果
7 hits
{"name":"张三","age":18,"sex":"女"}
{"name":"zhangsan","age":20,"sex":"男"}
{"name":"lisi","age":50,"sex":"女"}
{"name":"zhangsan1","age":30,"sex":"男"}
{"name":"lisi1","age":40,"sex":"男"}
{"name":"zhangsan2","age":40,"sex":"女"}
{"name":"lisi2","age":18,"sex":"男"}
条件查询
// 创建客户端
RestHighLevelClient esClient=new RestHighLevelClient(
  RestClient.builder(new HttpHost("47.94.217.248",9200,"http"))
);
// 创建查询对象
SearchRequest request=new SearchRequest();
// 设置索引
request.indices("user");
// 设置查询条件
// 查询年龄等于30的
request.source(new SearchSourceBuilder().query(QueryBuilders.termQuery("age",30)));
SearchResponse response = esClient.search(request, RequestOptions.DEFAULT);
SearchHits hits = response.getHits();
// 打印命中条数
System.out.println(hits.getTotalHits());
for(SearchHit hit: hits){
  // 打印每一项
  System.out.println(hit.getSourceAsString());
}
// 关闭客户端
esClient.close();
分页查询
// 创建客户端
RestHighLevelClient esClient=new RestHighLevelClient(
  RestClient.builder(new HttpHost("localhost",9200,"http"))
);
// 创建查询对象
SearchRequest request=new SearchRequest();
// 设置索引
request.indices("user");
// 设置查询条件
SearchSourceBuilder builder = new SearchSourceBuilder().query(QueryBuilders.matchAllQuery());
// 设置分页条件
// （当前页码-1）*每页显示数据条数
builder.from(0);
builder.size(2);
request.source(builder);
SearchResponse response = esClient.search(request, RequestOptions.DEFAULT);
SearchHits hits = response.getHits();
// 打印命中条数
System.out.println(hits.getTotalHits());
for(SearchHit hit: hits){
  // 打印每一项
  System.out.println(hit.getSourceAsString());
}
// 关闭客户端
esClient.close();
结果
7 hits
{"name":"张三","age":18,"sex":"女"}
{"name":"zhangsan","age":20,"sex":"男"}
过滤字段
// 创建客户端
RestHighLevelClient esClient=new RestHighLevelClient(
  RestClient.builder(new HttpHost("localhost",9200,"http"))
);
// 创建查询对象
SearchRequest request=new SearchRequest();
// 设置索引
request.indices("user");
// 设置查询条件
SearchSourceBuilder builder = new SearchSourceBuilder().query(QueryBuilders.matchAllQuery());
// 设置过滤条件
// 只查询包含name 的文档内容
String[] exclude={};// 可以指定排除字段
String[] include={"name"};
builder.fetchSource(include,exclude);
request.source(builder);
SearchResponse response = esClient.search(request, RequestOptions.DEFAULT);
SearchHits hits = response.getHits();
// 打印命中条数
System.out.println(hits.getTotalHits());
for(SearchHit hit: hits){
  // 打印每一项
  System.out.println(hit.getSourceAsString());
}
// 关闭客户端
esClient.close();
结果
7 hits
{"name":"张三"}
{"name":"zhangsan"}
{"name":"lisi"}
{"name":"zhangsan1"}
{"name":"lisi1"}
{"name":"zhangsan2"}
{"name":"lisi2"}
组合查询
//组合查询
// 创建客户端
RestHighLevelClient esClient=new RestHighLevelClient(
  RestClient.builder(new HttpHost("localhost",9200,"http"))
);
// 创建查询对象
SearchRequest request=new SearchRequest();
// 设置索引
request.indices("user");
// 设置组合查询条件
SearchSourceBuilder builder = new SearchSourceBuilder();
BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery();
boolQueryBuilder.must(QueryBuilders.matchQuery("sex","男"));
boolQueryBuilder.must(QueryBuilders.matchQuery("age",30));
// 查询年龄30或者40的
//boolQueryBuilder.should(QueryBuilders.matchQuery("age",30));
//boolQueryBuilder.should(QueryBuilders.matchQuery("age",40));
builder.query(boolQueryBuilder);
request.source(builder);
SearchResponse response = esClient.search(request, RequestOptions.DEFAULT);
SearchHits hits = response.getHits();
// 打印命中条数
System.out.println(hits.getTotalHits());
for(SearchHit hit: hits){
  // 打印每一项
  System.out.println(hit.getSourceAsString());
}
// 关闭客户端
esClient.close();
查询结果
1 hits
{"name":"zhangsan1","age":30,"sex":"男"}
范围查询
//范围查询
// 创建客户端
RestHighLevelClient esClient=new RestHighLevelClient(
  RestClient.builder(new HttpHost("47.94.217.248",9200,"http"))
);
// 创建查询对象
SearchRequest request=new SearchRequest();
// 设置索引
request.indices("user");
// 设置范围查询条件
SearchSourceBuilder builder = new SearchSourceBuilder();
RangeQueryBuilder rangeQuery = QueryBuilders.rangeQuery("age");
// 30=<年龄<=40
rangeQuery.gte(30); //gt: 大于
rangeQuery.lte(40); //lt: 小于
builder.query(rangeQuery);
request.source(builder);
SearchResponse response = esClient.search(request, RequestOptions.DEFAULT);
SearchHits hits = response.getHits();
// 打印命中条数
System.out.println(hits.getTotalHits());
for(SearchHit hit: hits){
  // 打印每一项
  System.out.println(hit.getSourceAsString());
}
// 关闭客户端
esClient.close();
结果
3 hits
{"name":"zhangsan1","age":30,"sex":"男"}
{"name":"lisi1","age":40,"sex":"男"}
{"name":"zhangsan2","age":40,"sex":"女"}
模糊查询
//模糊查询
// 创建客户端
RestHighLevelClient esClient=new RestHighLevelClient(
  RestClient.builder(new HttpHost("47.94.217.248",9200,"http"))
);
// 创建查询对象
SearchRequest request=new SearchRequest();
// 设置索引
request.indices("user");
// 设置模糊查询条件
SearchSourceBuilder builder = new SearchSourceBuilder();
// 模糊查询name=zhangsan的文档,允许差一位
builder.query(QueryBuilders.fuzzyQuery("name","zhangsan").fuzziness(Fuzziness.ONE));
request.source(builder);
SearchResponse response = esClient.search(request, RequestOptions.DEFAULT);
SearchHits hits = response.getHits();
// 打印命中条数
System.out.println(hits.getTotalHits());
for(SearchHit hit: hits){
  // 打印每一项
  System.out.println(hit.getSourceAsString());
}
// 关闭客户端
esClient.close();
结果
3 hits
{"name":"zhangsan","age":20,"sex":"男"}
{"name":"zhangsan1","age":30,"sex":"男"}
{"name":"zhangsan2","age":40,"sex":"女"}
高亮查询
//高亮查询
// 创建客户端
RestHighLevelClient esClient=new RestHighLevelClient(
  RestClient.builder(new HttpHost("47.94.217.248",9200,"http"))
);
// 创建查询对象
SearchRequest request=new SearchRequest();
// 设置索引
request.indices("user");
// 设置查询条件
SearchSourceBuilder builder = new SearchSourceBuilder();
TermQueryBuilder termQueryBuilder = QueryBuilders.termQuery("name", "zhangsan");
builder.query(termQueryBuilder);
// 设置高亮格式
HighlightBuilder highlightBuilder=new HighlightBuilder();
highlightBuilder.preTags("<font color='red'>");
highlightBuilder.postTags("</font>");
// 设置高亮字段
highlightBuilder.field("name");
builder.highlighter(highlightBuilder);
request.source(builder);
SearchResponse response = esClient.search(request, RequestOptions.DEFAULT);
SearchHits hits = response.getHits();
// 打印命中条数
System.out.println(hits.getTotalHits());
for(SearchHit hit: hits){
  // 打印每一项
  System.out.println(hit.getSourceAsString());
}
// 关闭客户端
esClient.close();
查询结果
{
    "took":2,
    "timed_out":false,
    "_shards":{
        "total":1,
        "successful":1,
        "skipped":0,
        "failed":0
    },
    "hits":{
        "total":{
            "value":1,
            "relation":"eq"
        },
        "max_score":1.7641908,
        "hits":[
            {
                "_index":"user",
                "_type":"_doc",
                "_id":"1002",
                "_score":1.7641908,
                "_source":{
                    "name":"zhangsan",
                    "age":20,
                    "sex":"[0xffffffe7][0xffffff94][0xffffffb7]"
                },
                "highlight":{
                    "name":[
                        "<font color='red'>zhangsan</font>"
                    ]
                }
            }
        ]
    }
}
聚合查询
最大年龄
// 创建客户端
RestHighLevelClient esClient=new RestHighLevelClient(
  RestClient.builder(new HttpHost("47.94.217.248",9200,"http"))
);
// 创建查询对象
SearchRequest request=new SearchRequest();
// 设置索引
request.indices("user");
// 设置查询条件
SearchSourceBuilder builder = new SearchSourceBuilder();
AggregationBuilder aggregationBuilder = AggregationBuilders.max("maxAge").field("age");
builder.aggregation(aggregationBuilder);
request.source(builder);
SearchResponse response = esClient.search(request, RequestOptions.DEFAULT);
SearchHits hits = response.getHits();
// 打印命中条数
System.out.println(hits.getTotalHits());
for(SearchHit hit: hits){
  // 打印每一项
  System.out.println(hit.getSourceAsString());
}
// 关闭客户端
esClient.close();
结果
{
    "took":2,
    "timed_out":false,
    "_shards":{
        "total":1,
        "successful":1,
        "skipped":0,
        "failed":0
    },
    "hits":{
        "total":{
            "value":7,
            "relation":"eq"
        },
        "max_score":1,
        "hits":[
            {
                "_index":"user",
                "_type":"_doc",
                "_id":"1001",
                "_score":1,
                "_source":{
                    "name":"[0xffffffe5][0xffffffbc][0xffffffa0][0xffffffe4][0xffffffb8][0xffffff89]",
                    "age":18,
                    "sex":"[0xffffffe5][0xffffffa5][0xffffffb3]"
                }
            },
            {
                "_index":"user",
                "_type":"_doc",
                "_id":"1002",
                "_score":1,
                "_source":{
                    "name":"zhangsan",
                    "age":20,
                    "sex":"[0xffffffe7][0xffffff94][0xffffffb7]"
                }
            },
            {
                "_index":"user",
                "_type":"_doc",
                "_id":"1003",
                "_score":1,
                "_source":{
                    "name":"lisi",
                    "age":50,
                    "sex":"[0xffffffe5][0xffffffa5][0xffffffb3]"
                }
            },
            {
                "_index":"user",
                "_type":"_doc",
                "_id":"1004",
                "_score":1,
                "_source":{
                    "name":"zhangsan1",
                    "age":30,
                    "sex":"[0xffffffe7][0xffffff94][0xffffffb7]"
                }
            },
            {
                "_index":"user",
                "_type":"_doc",
                "_id":"1005",
                "_score":1,
                "_source":{
                    "name":"lisi1",
                    "age":40,
                    "sex":"[0xffffffe7][0xffffff94][0xffffffb7]"
                }
            },
            {
                "_index":"user",
                "_type":"_doc",
                "_id":"1006",
                "_score":1,
                "_source":{
                    "name":"zhangsan2",
                    "age":40,
                    "sex":"[0xffffffe5][0xffffffa5][0xffffffb3]"
                }
            },
            {
                "_index":"user",
                "_type":"_doc",
                "_id":"1007",
                "_score":1,
                "_source":{
                    "name":"lisi2",
                    "age":18,
                    "sex":"[0xffffffe7][0xffffff94][0xffffffb7]"
                }
            }
        ]
    },
    "aggregations":{
        "max#maxAge":{
            "value":50
        }
    }
}
分组聚合查询
// 分组查询
// 创建客户端
RestHighLevelClient esClient=new RestHighLevelClient(
  RestClient.builder(new HttpHost("47.94.217.248",9200,"http"))
);
// 创建查询对象
SearchRequest request=new SearchRequest();
// 设置索引
request.indices("user");
// 设置查询条件
SearchSourceBuilder builder = new SearchSourceBuilder();
// 对age进行分组查询
AggregationBuilder aggregationBuilder = AggregationBuilders.terms("ageGroups").field("age");
builder.aggregation(aggregationBuilder);
request.source(builder);
SearchResponse response = esClient.search(request, RequestOptions.DEFAULT);
SearchHits hits = response.getHits();
// 打印命中条数
System.out.println(hits.getTotalHits());
for(SearchHit hit: hits){
  // 打印每一项
  System.out.println(hit.getSourceAsString());
}
// 关闭客户端
esClient.close();
结果
{
    "took":1,
    "timed_out":false,
    "_shards":{
        "total":1,
        "successful":1,
        "skipped":0,
        "failed":0
    },
    "hits":{
        "total":{
            "value":7,
            "relation":"eq"
        },
        "max_score":1,
        "hits":[
            {
                "_index":"user",
                "_type":"_doc",
                "_id":"1001",
                "_score":1,
                "_source":{
                    "name":"[0xffffffe5][0xffffffbc][0xffffffa0][0xffffffe4][0xffffffb8][0xffffff89]",
                    "age":18,
                    "sex":"[0xffffffe5][0xffffffa5][0xffffffb3]"
                }
            },
            {
                "_index":"user",
                "_type":"_doc",
                "_id":"1002",
                "_score":1,
                "_source":{
                    "name":"zhangsan",
                    "age":20,
                    "sex":"[0xffffffe7][0xffffff94][0xffffffb7]"
                }
            },
            {
                "_index":"user",
                "_type":"_doc",
                "_id":"1003",
                "_score":1,
                "_source":{
                    "name":"lisi",
                    "age":50,
                    "sex":"[0xffffffe5][0xffffffa5][0xffffffb3]"
                }
            },
            {
                "_index":"user",
                "_type":"_doc",
                "_id":"1004",
                "_score":1,
                "_source":{
                    "name":"zhangsan1",
                    "age":30,
                    "sex":"[0xffffffe7][0xffffff94][0xffffffb7]"
                }
            },
            {
                "_index":"user",
                "_type":"_doc",
                "_id":"1005",
                "_score":1,
                "_source":{
                    "name":"lisi1",
                    "age":40,
                    "sex":"[0xffffffe7][0xffffff94][0xffffffb7]"
                }
            },
            {
                "_index":"user",
                "_type":"_doc",
                "_id":"1006",
                "_score":1,
                "_source":{
                    "name":"zhangsan2",
                    "age":40,
                    "sex":"[0xffffffe5][0xffffffa5][0xffffffb3]"
                }
            },
            {
                "_index":"user",
                "_type":"_doc",
                "_id":"1007",
                "_score":1,
                "_source":{
                    "name":"lisi2",
                    "age":18,
                    "sex":"[0xffffffe7][0xffffff94][0xffffffb7]"
                }
            }
        ]
    },
    "aggregations":{
        "lterms#ageGroups":{
            "doc_count_error_upper_bound":0,
            "sum_other_doc_count":0,
            "buckets":[
                {
                    "key":18,
                    "doc_count":2
                },
                {
                    "key":40,
                    "doc_count":2
                },
                {
                    "key":20,
                    "doc_count":1
                },
                {
                    "key":30,
                    "doc_count":1
                },
                {
                    "key":50,
                    "doc_count":1
                }
            ]
        }
    }
}
LLLDa_&
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
elasticsearch java_ElasticSearch Java API方法简单使用实例
weixin_42362003的博客
02-12 791
ElasticSearch Java API提供强大的搜索功能，以下主要介绍Java API方法中，针对数据，进行简单增删改查的使用实例。1、获取ElasticSearchclient对象publicClientgetEsClient(){Clientclient=null;try{Settingssettings=ImmutableSettings.settingsBuilde...
Java调用Elasticsearch API查询
weixin_45143899的博客
08-26 1233
matchPhraseQuery和matchQuery的区别 matchPhraseQuery和matchQuery等的区别， 在使用matchQuery等时，在执行查询时，搜索的词会被分词器分词， 而使用matchPhraseQuery时，不会被分词器分词，而是直接以一个短语的形式查询，而如果你在创建索引所使用的field的value中没有这么一个短语（顺序无差，且连接在一起），那么将查询不出任何结果 ...
ElasticSearch基础篇-Java API操作
冰点契约的博客
07-30 779
ElasticSearch基础-Java API操作
Elasticsearch8.0版本中Elasticsearch Java API Client客户端的基本使用方法
热门推荐
无枫的博客，分享Java及Vue方向的技术文章
03-10 2万+
关于Elasticsearch Java API Client客户端如何连接以及如何对索引和文档进行基本的增删改查操作请查看我的上一篇博文：Elasticsearch RestHighLevelClient 已标记为被弃用 它的替代方案 Elasticsearch Java API Client 的基础教程及迁移方案_无枫的博客，分享Java及Vue方向的技术文章-CSDN博客 本篇主要描述在Elasticsearch Java API Client客户端中如何进行批量操作，以及如何进行各种条件及类..
elasticsearch(es)高级查询api
qq_19891197的博客
03-14 2380
elasticsearch高级查询api
ElasticSearch高级操作---javaAPI
m0_48639280的博客
10-02 809
批量操作 Bulk 批量操作是将文档的增删改查一些列操作，通过一次请求全都做完。减少网络传输次数。 脚本操作： POST _bulk {"delete":{"_index":"person","_id":"4"}} {"create":{"_index":"person","_id":"4"}} {"name":"五号","age":20,"address":"北京"} {"update":{"_index":"person","_id":"2"}} {"doc":{"name":"二号"}} 删除 索引
Elasticsearch javaApi 查询
harcrance的博客
11-25 277
Elasticsearch javaApi 查询 elasticsearch javaApi调用，实现条件查询~当前版本为elasticsearch 2.3X，es板门5.5版本后api有区别 引入pom依赖 <dependency> <groupId>org.elasticsearch</groupId> ...
基于Elasticsearch Java API的参考手册
04-29
### 三、Java API高级特性 1. **批量操作**: 使用`BulkProcessor`进行大批量索引、更新或删除操作，提高性能。 2. **脚本(Scripts)**: 动态执行脚本进行复杂计算或逻辑判断，支持Painless和Groovy语言。 3. **滚动...
elasticsearch java api 离线文档
01-11
**Elasticsearch Java API 离线文档** Elasticsearch 是一个开源的全文搜索引擎，它提供了高度可扩展的、实时的搜索与分析引擎服务。Java API 是 Elasticsearch 提供的用于与集群交互的主要接口，允许开发者在 Java...
Elasticsearch5.x Java API手册
06-14
总之，Elasticsearch 5.x Java API 手册为开发者提供了详尽的操作指南，涵盖了从基础操作到高级特性的全面内容。通过深入理解和熟练应用这些 API，开发者可以高效地利用 Elasticsearch 实现各种数据处理任务。
Elasticsearch查询API
10-13
【Elasticsearch查询API】是Elasticsearch中用于检索数据的核心功能，允许用户通过各种查询语句和过滤条件从索引中获取相关文档。本文将详细介绍Elasticsearch接口API的使用，特别是全文检索、查询匹配以及常用的...
ElasticSearch整合JavaApi代码
03-09
通过以上内容，我们可以了解到Elasticsearch与Java API的集成方式，涵盖了从基础的文档操作到复杂的查询和聚合，以及高级的性能优化和安全控制。无论是日志分析、全文检索还是实时数据分析，Elasticsearch都能以其...
Elasticsearch基础学习-常用查询和基本的JavaAPI操作ES
后端开发
05-17 2704
关于ES数据库的和核心倒排索引的介绍一、Elasticsearch概述简介关于全文检索引擎关系型数据库的全文检索功能缺点全文检索的应用场景Elasticsearch 应用案例二、Elasticsearch学习准备安装下载关于es检索的核心-倒排索引正向索引（forward index）倒排索引（inverted index）三、使用kibana执行ES的操作索引创建全部索引查询单个索引查询删除索引创建文档Dynamic mapping 动态映射的说明指定id创建文档主键查询GET方式全查询POST方式全查询
第07讲：Java操作之ElasticSearch高级查询
分享日常工作技术
01-09 1094
运行结果： 运行结果： 运行结果： 运行结果： 运行结果： 运行结果： 运行结果： 运行结果： 运行结果： 运行结果： 运行结果：
ES8(Java API Client)查询详解
Charge8的博客
09-04 1万+
ES8(Java API Client)查询详解
Java操作ElasticSearch相关内容
weixin_45892531的博客
08-11 791
Java连接ES 创建Maven工程 导入依赖 <dependencies> <!-- 1. elasticsearch--> <dependency> <groupId>org.elasticsearch</groupId> <artifactId>elasticsearch</artifactId> <version&gt...
ElasticSearch（12）Java API高级查询（常用重点）
учёба
12-28 1492
matchAll查询 matchAll查询:查询所有文档 package com.yy.esdemo; import com.alibaba.fastjson.JSON; import com.yy.esdemo.domain.Person; import com.yy.esdemo.domain.User; import com.yy.esdemo.mapper.UserMapper; import org.elasticsearch.action.bulk.BulkRequest; import o.
ElasticSearch 7.3.2 JavaAPI 插入、高级查询、高亮
Xiang想
08-29 951
内附 GitHub、Gitee 项目源码，源码内附有 sql 脚本，只需要有 ElasticSearch 环境即可学习、测试
Git 操作总结
最新发布
weixin_40134371的博客
07-03 997
Git 操作总结
elasticsearch5.5.1 java api client
08-08
该客户端库提供了一个高级的面向对象的接口，让开发者可以用Java代码来操作elasticsearch，而无需处理底层的网络通信和细节。 在5.5.1版本的elasticsearch中，Java API client引入了许多新的功能和改进。其中一项...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

LLLDa_&

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值