Get elastic search java api query for distinct field and sorting

Question

I am using elastic search 2.3 version in my java project. I want to execute the following sql query for elastic search -

select fileName from (select distinct fileName from explore_object_metadata order by original_size desc)where rownum <=10

For this I try -

 client.prepareSearch()
                    .setIndices()
                    .setTypes(getType())
                    .addSort(fieldSort("sourceSize").order(DESC))
                    .setScroll(new TimeValue(ES_TIMEOUT_MS))
                    .setSize(10);

But it gives me 10 result in descending order with repeated fileName multiple times. What can I do to get top 10 records with unique filename and sorted in descending order by their size in elastic search.

parita porwal · Accepted Answer · 2017-03-22 07:50:37Z

1

Sense query to get the above query is -

{ 

  "aggs": {
    "id1_count": {
      "terms": { "field": "empname" ,
      "order": {
          "Max_Marks": "desc"
        }
      },

      "aggs": {
        "Max_Marks": {
          "max": {
            "field": "marks"
          }
        },
        "min_marks":{
            "min":{
                "field":"marks"
            }
        }
      }

answered Mar 22, 2017 at 7:50

parita porwal

6723 gold badges11 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

Get elastic search java api query for distinct field and sorting

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related