ElasticSearch Failing to Sort Nested Object in order

Question

ElasticSearch 6.5.2 Given the mapping and query, the document order is not effected by changing 'desc' to 'asc' and vice versa. Not seeing any errors, just sort: [Infinity] in the results.

Mapping:

{
  "mappings": {
    "_doc": {
      "properties": {
        "tags": {
          "type": "keyword"
        },
        "metrics": {
          "type": "nested",
          "dynamic": true
        }
      }
    }
  }
}

Query

{
  "query": {
    "match_all": {
    }
  },
  "sort": [
    {
      "metrics.http.test.value": {
        "order": "desc"
      }
    }
  ]
}

Document structure:

{
  "tags": ["My Tag"],
  "metrics": {
    "http.test": {
      "updated_at": "2018-12-08T23:22:07.056Z",
      "value": 0.034
    }
  }
}

Nishant · Accepted Answer · 2018-12-09 15:24:27Z

2

When sorting by nested field it is necessary to tell the path of nested field using nested param. One thing more you were missing in the query is the field on which to sort. Assuming you want to sort on updated_at the query will be:

{
  "query": {
    "match_all": {}
  },
  "sort": [
    {
      "metrics.http.test.updated_at": {
        "order": "desc",
        "nested": {
          "path": "metrics"
        }
      }
    }
  ]
}

One more thing that you should keep in mind while sorting using nested field is about filter clause in sort. Read more about it here.

answered Dec 9, 2018 at 15:24

Nishant

7,9121 gold badge24 silver badges37 bronze badges

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

2 Comments

Justin Thomas Over a year ago

The nested path thing wasn't required, that's for pre 6.5 I believe. Got it to work though, will mark yours up and add the solution, looks like I pasted the query a bit long.

Nishant Over a year ago

Nested path will be required if the field is of nested doc.

Justin Thomas · Accepted Answer · 2018-12-10 18:29:20Z

0

Apparently changing the mapping to this:

"metrics": {
  "dynamic": true,
  "properties": {}
}

Fixed it and allowed sorting to happen in the correct order.

answered Dec 10, 2018 at 18:29

Justin Thomas

5,8473 gold badges44 silver badges63 bronze badges

1 Comment

Nishant Over a year ago

The reason this worked is because metrics is now of object type rather than nested.

Collectives™ on Stack Overflow

ElasticSearch Failing to Sort Nested Object in order

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related