Unexpected results when sorting with deeply nested filters

pmeskers · November 8, 2016, 2:58pm

Howdy all.

I'm trying to perform some sorting based on the attributes of a document's deeply nested children. The example is provided here, along with curl commands for reproducing the index/mappings:

gist.github.com

https://gist.github.com/pmeskers/eee33df28af6556b27836fd38255f366

es-nested-filter.md

Let's say we have an index filled with **publisher** documents. A `publisher` has a collection of **books**, and 
each `book` has a title, a published flag, and a collection of **genre scores**. A `genre_score` represents how well
a particular book matches a particular genre, or in this case a `genre_id`. 

First, let's define some mappings (for simplicity, we will only be explicit about the nested types):

```json
curl -XPUT 'localhost:9200/book_index' -d '
  {
    "mappings": {

This file has been truncated. show original

Basically, when my nested_filter has terms that are applied to different nested paths (in the above example, it's books.published and books.genre_scores.genre_id), some weird results are being used as the sorting value.

Can anyone provide some insight as to why this behavior is happening? And additionally, if there are any viable solutions to the proposed query/sort?

Thanks!
Paul

system · December 6, 2016, 2:58pm

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.