Elastic search query in java api

Question

I want to execute this sql query in java api for get elastic search data -

 select mime_type,count(*),sum(original_size) 
 from explore_object_metadata 
 group by mime_type;

I am able to get the data from elastic search for the following sql query -

select mimetype,count(*) 
from table 
group by mimetype

By the code in following link - elastic search aggregation in java for all indexes in elastic search

How I get this.

Did you try using sub-aggregations, elastic.co/blog/intro-to-aggregations-pt-2-sub-aggregations? — Rahul
– Rahul, Commented Mar 10, 2017 at 7:58

quit · Accepted Answer · 2017-03-10 09:27:49Z

1

You should use aggregations for this.

Use terms aggregation to aggregate by mime_type https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html. Count for each mime_type will be calculated in each terms bucket.
For sum(original_size) user sum aggregation https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-sum-aggregation.html as a sub aggregations of terms, to get sum(original_size) for each mime_type.

answered Mar 10, 2017 at 9:27

quit

2822 silver badges9 bronze badges

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

Comments

码匠笔记 · Accepted Answer · 2017-03-10 09:18:01Z

0

I am using the ElasticSearch API to execute the CRUD request. the API can build JSON content with JAVA code.

Here is the official document for the API: https://www.elastic.co/blog/found-java-clients-for-elasticsearch

Here is the Maven config.

    <dependency>
        <groupId>org.elasticsearch</groupId>
        <artifactId>elasticsearch</artifactId>
        <version>1.6.0</version>
    </dependency>

answered Mar 10, 2017 at 9:18

码匠笔记

1331 gold badge1 silver badge8 bronze badges

Collectives™ on Stack Overflow

Elastic search query in java api

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related