Elasticsearch aggregation using Java api

Question

Hi I am trying to do query on elastic search by following the sql query and I want to implement same logic using Java API

select dttime, avg(cpu) from table cpustats where server="X" and dttime="Y" group by dttime,cpu

Now I have the following Java code but it does not return expected output

SearchResponse response = client.prepareSearch("cpuindex")
      .setTypes("cputype")
      .setQuery(QueryBuilders.matchAllQuery())
      .addAggregation(AggregationBuilders.terms("cpu_agg")
           .field("cpu").size(100))
      .execute().actionGet();

Please guide I am new to Elastic search. Thanks in advance.

Abhijith S · Accepted Answer · 2018-03-10 06:28:14Z

18

I think this will help.

SearchResponse response=
                client.prepareSearch("your_index_name_here").setQuery(QueryBuilders.filteredQuery(QueryBuilders.matchAllQuery(),
                FilterBuilders.andFilter(
                        FilterBuilders.termFilter("server","x"),
                        FilterBuilders.termFilter("dt_time","x")
                ))).addAggregation(
                AggregationBuilders.terms("dt_timeaggs").field("dt_time").size(100).subAggregation(
                        AggregationBuilders.terms("cpu_aggs").field("cpu").size(100)
                )
        ).setSize(0).get();

please verify.

edited Mar 10, 2018 at 6:28

Abhijith S

5925 silver badges19 bronze badges

answered Jul 26, 2014 at 3:50

progrrammer

4,4892 gold badges32 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Umesh Kacha Over a year ago

Hi thanks for the answer. I have doubt what is requestBuilder here? New to Java APIs of elasticsearch its difficult to find what is it. Please guide.

progrrammer Over a year ago

its, what client.prepareSearch() returns.

progrrammer Over a year ago

See, i've changed my answer. If it solved your problem then accept it ??

Umesh Kacha Over a year ago

I am working on it query fails it is not returning any results. Sure I will accept your answer once it is working I will edit it for others reference.

progrrammer Over a year ago

what's your data look like?

Sean Zhu · Accepted Answer · 2016-06-09 15:38:42Z

2

since elastic search 2.3, FilterBuilders class has been removed from JavaAPI. you can use

QueryBuilder qb = QueryBuilders.boolQuery()
        .must(QueryBuilders.matchQuery("_all", "JPMORGAN"))
        .must(QueryBuilders.matchQuery(field, value)) ;

instead, and set it to

.setQuery(qb).

answered Jun 9, 2016 at 15:38

Sean Zhu

212 bronze badges

Collectives™ on Stack Overflow

Elasticsearch aggregation using Java api

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related