当前位置: 代码网 > it编程>编程语言>Java > java操作ElasticSearch聚合查询的示例代码

java操作ElasticSearch聚合查询的示例代码

2024年08月02日 Java 我要评论
1、引入依赖<!-- es工具--><dependency><groupid>org.springframework.boot</groupid><

1、引入依赖

<!-- es工具-->
		<dependency>
			<groupid>org.springframework.boot</groupid>
			<artifactid>spring-boot-starter-data-elasticsearch</artifactid>
		</dependency>

2、配置es连接信息

sring:
  elasticsearch:
    rest:
      uris: "http://localhost:9200"

3、构建索引

@document(indexname = "test_index_person")
public class testperson{
    public testperson( string personname, integer personid, string gmtcreate, string gmtmodified) {
        this.personname = personname;
        this.personid = personid;
        this.gmtcreate = gmtcreate;
        this.gmtmodified = gmtmodified;
    }
    public testperson() {
    }
    @override
    public string tostring() {
        return "testperson{" +
                "id='" + id + '\'' +
                ", personname='" + personname + '\'' +
                ", personid=" + personid +
                ", gmtcreate=" + gmtcreate +
                ", gmtmodified=" + gmtmodified +
                '}';
    }
    @id
    private string id;
    @field(type = fieldtype.text, analyzer = "ik_analyzer",name = "person_name")
    private string personname;
    @field(type = fieldtype.integer,name = "person_id")
    private integer personid;
    @field(type = fieldtype.date,name = "gmt_create")
    private string gmtcreate;
    @field(type = fieldtype.date,name = "gmt_modified")
    private string gmtmodified;
    public string getid() {
        return id;
    }
    public void setid(string id) {
        this.id = id;
    }
    public string getpersonname() {
        return personname;
    }
    public void setpersonname(string personname) {
        this.personname = personname;
    }
    public integer getpersonid() {
        return personid;
    }
    public void setpersonid(integer personid) {
        this.personid = personid;
    }
    public string getgmtcreate() {
        return gmtcreate;
    }
    public void setgmtcreate(string gmtcreate) {
        this.gmtcreate = gmtcreate;
    }
    public string getgmtmodified() {
        return gmtmodified;
    }
    public void setgmtmodified(string gmtmodified) {
        this.gmtmodified = gmtmodified;
    }
}

4、查询(包含自定义聚合查询)

    @autowired
    elasticsearchoperations elasticsearchoperations;
    /***
     * 自定义 match 查询
     */
    @test
    public void test6(){
        // 构建查询条件
        nativesearchquerybuilder querybuilder = new nativesearchquerybuilder();
        // 添加基本分词查询
        matchquerybuilder matchquerybuilder = querybuilders.matchquery("person_name", "小黑子");
        querybuilder.withquery(matchquerybuilder);
        searchhits<testperson> searchhits = elasticsearchoperations.search(querybuilder.build(), testperson.class);
        searchhits.foreach(item ->{
            system.out.println(item);
        });
    }
    /***
     * 自定义 term 查询
     */
    @test
    public void test7(){
        // 构建查询条件
        nativesearchquerybuilder querybuilder = new nativesearchquerybuilder();
        // 添加基本分词查询
        termquerybuilder personid = querybuilders.termquery("person_id", "1");
        querybuilder.withquery(personid);
        searchhits<testperson> searchhits = elasticsearchoperations.search(querybuilder.build(), testperson.class);
        searchhits.foreach(item ->{
            system.out.println(item);
        });
    }
    /***
     * 自定义 match_all 查询
     */
    @test
    public void test8(){
        // 构建查询条件
        nativesearchquerybuilder querybuilder = new nativesearchquerybuilder();
        // 添加基本分词查询
        matchallquerybuilder matchallquerybuilder = querybuilders.matchallquery();
        querybuilder.withquery(matchallquerybuilder);
        searchhits<testperson> searchhits = elasticsearchoperations.search(querybuilder.build(), testperson.class);
        searchhits.foreach(item ->{
            system.out.println(item);
        });
    }
    /***
     * 自定义 match_phrase 查询
     */
    @test
    public void test9(){
        // 构建查询条件
        nativesearchquerybuilder querybuilder = new nativesearchquerybuilder();
        // 添加基本分词查询
        matchphrasequerybuilder matchphrasequerybuilder = querybuilders.matchphrasequery("person_name", "小黑子");
        querybuilder.withquery(matchphrasequerybuilder);
        searchhits<testperson> searchhits = elasticsearchoperations.search(querybuilder.build(), testperson.class);
        searchhits.foreach(item ->{
            system.out.println(item);
        });
    }
    /***
     * 范围查询
     */
    @test
    public void test10(){
        // 构建查询条件
        nativesearchquerybuilder querybuilder = new nativesearchquerybuilder();
        // 添加基本分词查询
        rangequerybuilder rangequery = querybuilders.rangequery("gmt_create");
        rangequery.gte("2024-01-31t11:00:00");
        rangequery.lt("2024-07-31t11:00:00");
        querybuilder.withquery(rangequery);
        searchhits<testperson> searchhits = elasticsearchoperations.search(querybuilder.build(), testperson.class);
        searchhits.foreach(item ->{
            system.out.println(item);
        });
    }
    /***
     * 模糊匹配
     */
    @test
    public void test11(){
        // 构建查询条件
        nativesearchquerybuilder querybuilder = new nativesearchquerybuilder();
        // 添加基本分词查询
        fuzzyquerybuilder fuzzyquerybuilder = querybuilders.fuzzyquery("person_name", "张三");
        querybuilder.withquery(fuzzyquerybuilder);
        searchhits<testperson> searchhits = elasticsearchoperations.search(querybuilder.build(), testperson.class);
        searchhits.foreach(item ->{
            system.out.println(item);
        });
    }
    /***
     * 布尔查询 必须匹配(must) 过滤(filter) 至少匹配一个(should)
     */
    @test
    public void test12(){
        // 构建查询条件
        nativesearchquerybuilder querybuilder = new nativesearchquerybuilder();
        // 构建布尔查询
        boolquerybuilder boolquerybuilder = querybuilders.boolquery();
        //布尔查询下添加must
        list<querybuilder> must = boolquerybuilder.must();
        termquerybuilder personid = querybuilders.termquery("person_id", "1");
        must.add(personid);
        //布尔查询下添加filter
        list<querybuilder> filter = boolquerybuilder.filter();
        rangequerybuilder rangequery = querybuilders.rangequery("gmt_create");
        rangequery.gte("2024-07-31t10:00:00");
        filter.add(rangequery);
       //布尔查询下添加should
        list<querybuilder> should = boolquerybuilder.should();
        termquerybuilder shouldterm = querybuilders.termquery("person_id", "111");
        should.add(shouldterm);
        //布尔查询下添加must_not
        list<querybuilder> querybuilders = boolquerybuilder.mustnot();
        termquerybuilder mustnotterm = querybuilders.termquery("person_name", "哈哈哈");
        querybuilders.add(mustnotterm);
        //构建布尔查询语法,准备执行
        querybuilder.withquery(boolquerybuilder);
        searchhits<testperson> searchhits = elasticsearchoperations.search(querybuilder.build(), testperson.class);
        searchhits.foreach(item ->{
            system.out.println(item);
        });
    }
    /***
     * 分页
     */
    @test
    public void test13(){
        // 构建查询条件
        nativesearchquerybuilder querybuilder = new nativesearchquerybuilder();
        // 查询全部
        matchallquerybuilder matchallquerybuilder = querybuilders.matchallquery();
        querybuilder.withquery(matchallquerybuilder);
        pageable pageable = pagerequest.of(0, 10, sort.by("personid").descending());
        querybuilder.withpageable(pageable);
        searchhits<testperson> searchhits = elasticsearchoperations.search(querybuilder.build(), testperson.class);
        searchhits.foreach(item ->{
            system.out.println(item);
        });
    }
    /***
     * 对查询出来的值进行聚合查询 统计每个唯一值的个数
     */
    @test
    public void test14(){
        // 构建查询条件
        nativesearchquerybuilder querybuilder = new nativesearchquerybuilder();
        //查询数据
        matchquerybuilder matchquery = querybuilders.matchquery("person_name", "张三");
        querybuilder.withquery(matchquery);
        //聚合数据
        termsaggregationbuilder termsaggregationbuilder = aggregationbuilders.terms("test_aggs").field("gmt_create");
        querybuilder.addaggregation(termsaggregationbuilder);
        searchhits<testperson> searchhits = elasticsearchoperations.search(querybuilder.build(), testperson.class);
        searchhits.foreach(item ->{
            system.out.println(item);
        });
        aggregations aggregations = searchhits.getaggregations();
        // 检查 aggregations 是否为 null
        if (aggregations != null) {
            // 第二步:通过聚合名称获取特定的聚合结果
            terms testaggs = aggregations.get("test_aggs");
            // 检查特定聚合是否存在
            if (testaggs != null) {
                // 第三步:遍历聚合中的桶(buckets)
                for (terms.bucket bucket : testaggs.getbuckets()) {
                    // 获取桶的键(在这个例子中是 gmt_create 的值)
                    string keyasstring = bucket.getkeyasstring();
                    // 获取桶中文档的数量
                    long doccount = bucket.getdoccount();
                    // 打印或处理每个桶的结果
                    system.out.println("key: " + keyasstring + ", doccount: " + doccount);
                }
            }
        }
    }
    /***
     * 对查询出来的值进行聚合查询 统计每个唯一值的个数  仅仅返回聚合结果
     */
    @test
    public void test15(){
        nativesearchquerybuilder querybuilder = new nativesearchquerybuilder();
        //仅仅返回聚合结果
        querybuilder.withpageable(pagerequest.of(0,1));
        //查询数据
        matchquerybuilder matchquerybuilder = querybuilders.matchquery("person_name", "张三");
        querybuilder.withquery(matchquerybuilder);
        //聚合
        termsaggregationbuilder aggregationbuilder = aggregationbuilders.terms("test_aggs").field("gmt_create");
        querybuilder.addaggregation(aggregationbuilder);
        //获取聚合信息
        searchhits<testperson> search = elasticsearchoperations.search(querybuilder.build(), testperson.class);
        aggregations aggregations = search.getaggregations();
        if (aggregations != null){
            terms terms = aggregations.get("test_aggs");
            list<? extends terms.bucket> buckets = terms.getbuckets();
            buckets.foreach(item ->{
                system.out.println("key:"+item.getkeyasstring()  +"===="+"doc_count:"+item.getdoccount());
            });
        }
    }
    /***
     * 多个聚合
     */
    @test
    public void test16(){
        nativesearchquerybuilder querybuilder = new nativesearchquerybuilder();
        //仅仅返回聚合结果
        querybuilder.withpageable(pagerequest.of(0,1));
        termsaggregationbuilder test_aggs = aggregationbuilders.terms("test_aggs").field("gmt_create");
        querybuilder.addaggregation(test_aggs);
        avgaggregationbuilder test_aggs2 = aggregationbuilders.avg("test_aggs2").field("person_id");
        querybuilder.addaggregation(test_aggs2);
        searchhits<testperson> search = elasticsearchoperations.search(querybuilder.build(), testperson.class);
        aggregations aggregations = search.getaggregations();
        if (aggregations != null){
            terms test_aggs1 = aggregations.get("test_aggs");
            if (test_aggs != null){
                test_aggs1.getbuckets().foreach(item ->{
                    system.out.println("key:"+ item.getkeyasstring()+"===="+"doc_count:"+item.getdoccount());
                });
            }
            avg test2_aggs = aggregations.get("test_aggs2");
            system.out.println( test2_aggs.getvalue());
        }
    }
    /***
     * 子聚合 先分组,再计算
     */
    @test
    public void test17(){
        nativesearchquerybuilder querybuilder = new nativesearchquerybuilder();
        querybuilder.withpageable(pagerequest.of(0,1));
        termsaggregationbuilder test_aggs = aggregationbuilders.terms("test_aggs").field("gmt_create");
        test_aggs.subaggregation(aggregationbuilders.avg("son_aggs_test").field("person_id"));
        querybuilder.addaggregation(test_aggs);
        searchhits<testperson> search = elasticsearchoperations.search(querybuilder.build(), testperson.class);
        aggregations aggregations = search.getaggregations();
        terms testagges =  aggregations.get("test_aggs");
        testagges.getbuckets().foreach(item ->{
            avg aggregations1 = item.getaggregations().get("son_aggs_test");
            system.out.println("key:"+item.getkeyasstring()+"--doc_count:"+item.getkeyasstring()+"--son_aggs_test"+aggregations1.getvalue());
        });
    }
    /**
     * 取聚合最大值
     */
    @test
    public void test18(){
        nativesearchquerybuilder querybuilder = new nativesearchquerybuilder();
        querybuilder.addaggregation(aggregationbuilders.max("test_agg").field("person_id"));
        searchhits<testperson> search = elasticsearchoperations.search(querybuilder.build(), testperson.class);
        aggregations aggregations = search.getaggregations();
        max test_agg = aggregations.get("test_agg");
        system.out.println(test_agg.getvalue());
    }

到此这篇关于java操作elasticsearch(包含聚合查询)的文章就介绍到这了,更多相关java操作elasticsearch内容请搜索代码网以前的文章或继续浏览下面的相关文章希望大家以后多多支持代码网!

(0)

相关文章:

版权声明:本文内容由互联网用户贡献,该文观点仅代表作者本人。本站仅提供信息存储服务,不拥有所有权,不承担相关法律责任。 如发现本站有涉嫌抄袭侵权/违法违规的内容, 请发送邮件至 2386932994@qq.com 举报,一经查实将立刻删除。

发表评论

验证码:
Copyright © 2017-2025  代码网 保留所有权利. 粤ICP备2024248653号
站长QQ:2386932994 | 联系邮箱:2386932994@qq.com