Sort ElasticSearch based on number of objects of array type field

Question

I have the elastic search cluster of the form:

{
    "_id":"xxxx"
    "contents":[
        {
            "name":"abc",
            "age":"24"
        }
    ]
},
{
    "_id":"yyyy"
    "contents":[
        {
            "name":"xyz",
            "age":"25"
        },
        {
            "name":"pqr",
            "age":"29"
        },
    ]

}

I have to perform a sort based query on the size of the object array field 'contents'.

I have tried:

{
    "size": 10,
    "from": 0,
    "query": {
        "match_all": {} 
    },
    "sort" : {
        "_script" : {
            "script": "doc['contents.name'].values.size()",
            "order": "desc",
            "type" : "string",
        }
    }
}

The above query sometime gives me the correct result, but most of the times it fails to give the results in sorted order.

do yo tried using type : number ?

progrrammer
– progrrammer

2014-09-01 12:10:15 +00:00
Commented Sep 1, 2014 at 12:10 — progrrammer
– progrrammer, Commented Sep 1, 2014 at 12:10
Yes, I tried that also

Ashish Bhumkar
– Ashish Bhumkar

2014-09-01 12:39:17 +00:00
Commented Sep 1, 2014 at 12:39 — Ashish Bhumkar
– Ashish Bhumkar, Commented Sep 1, 2014 at 12:39

Yasha · Accepted Answer · 2015-01-11 03:57:45Z

1

Your contents field is an array, not an object. So when you try and access contents.name in your script it's undefined. You should get the size of the contents array:

{
  "size": 10,
  "from": 0,
  "query": {
    "match_all": {} 
  },
  "sort" : {
    "_script" : {
      "script": "doc['contents'].values.size()",
      "order": "desc",
      "type" : "string",
    }
  }
}

answered Jan 11, 2015 at 3:57

Yasha

1,07912 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Sort ElasticSearch based on number of objects of array type field

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