CODEWITHSUNDEEP
spring-mvcelasticsearchspring-data
Jimmy Geers
Jimmy Geers

Reputation: 742

ES Spring data add size into spring data format

I am trying to convert my JSON ES query to Java I am using Spring data. I am almost there but the problem is i cannot get the "size": 0 into my query in Java.

GET someserver/_search
{
   "query": { ...},
   "size": 0, 
    "aggregations" : {
    "parent_aggregation" : {
        "terms" : {
            "field": "fs.id"
        },
        "aggs": {
          "sub_aggs" : {
            "top_hits": {
              "sort": [
                  {
                    "fs.smallVersion": {
                      "order": "desc"
                    }
                  }
                ],
                "size": 1
            }
          }
        }
    }
  }
}

In Java I am building an NativeSearchQuery object on which I think it should be possible to set the size?

NativeSearchQuery searchQuery = createNativeSearchQuery(data, validIndices, query, filter);
es.getElasticsearchTemplate().query(searchQuery, response -> extractResult(data, response));

Upvotes: 0

Views: 1248

Answers (1)

Jettro Coenradie
Jettro Coenradie

Reputation: 4733

If you are using elasticsearch before 2.0, you can use the search type feature to do what you want, which is not return docs. This can be accomplished using the NativeSearchQueryBuilder. If you set the SearchType to COUNT you will not get docs. Beware that in elasticsearch 2.x this is deprecated and you should use the size is 0. If the spring elasticsearch project will support elasticsearch 2.0 this will most likely change and the size attribute should be exposed in this builder as well.

SearchQuery searchQuery = new NativeSearchQueryBuilder()
            .withQuery(matchAllQuery())
            .withSearchType(SearchType.COUNT)
            .withIndices("yourindex")
            .addAggregation(terms("nameofagg").field("thefield"))
            .build();

Upvotes: 1

Related Questions