How to query distinct records from Elasticsearch via API

Question

I have the following Elasticsearch get query:

GET /...
{
   "size":"0",
   "aggs" : {
      "locations" : {
         "terms" : { "field" : "locationid.keyword" }
      }
   }
}

which works on console as it should. But the goal is to have this query programmatic via the Java API. I'm using Spring Boor with ElasticSearchRepository:

@Query("{\"size\" : \"0\" , \"aggs\" : {\"locations\" : {\"terms\" : { \"field\" : \"locationid.keyword\" }}}}")
List<Bucket> findDistinctLocationids();

So, now my problem is the following Exception:

ParsingException[size] query malformed, no start_object after query name

The error message is clear but which annotation or is useful for this case instead of @Query? Or is there any other way to retrive distinct records?

This answer should help: stackoverflow.com/a/40084422/4604579 — Val
– Val, Commented Oct 1, 2018 at 13:55

piet · Accepted Answer · 2018-10-02 08:09:07Z

1

So, after some hours of try and error i found a solution based on @Vals comment. First, i set up a search which gives me a SearchResponse:

final SearchResponse sr = client.prepareSearch("index").setTypes("type").setQuery(QueryBuilders.matchAllQuery()).setSearchType(SearchType.DEFAULT).addAggregation(
            AggregationBuilders.terms("field").field("locationid.keyword")).execute().actionGet();

From this response i receive a Terms object which holds the results in its Bucktes:

final Terms locations = sr.getAggregations().get("field");
for (final Terms.Bucket entry : locations.getBuckets()) {
    System.out.println(entry.getKey());
    System.out.println(entry.getDocCount());
}

with exactly the result as in console is given.

answered Oct 2, 2018 at 8:09

piet

4041 gold badge7 silver badges21 bronze badges

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

1 Comment

Tiago Medici Over a year ago

how would you do in case you wanna group by (aggregate) and the same time filter (query a filed by value) ?

Collectives™ on Stack Overflow

How to query distinct records from Elasticsearch via API

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related