Sorting by an nested object field

Patrik_Johansson · December 15, 2011, 10:13pm

Hi all!

I have an nested mapping and data like the one in this example:
http://www.elasticsearch.org/guide/reference/mapping/nested-type.html
This works great when I'm using a nested filter or nested query.

{
"obj1" : [
{
"name" : "blue",
"count" : 4
},
{
"name" : "green",
"count" : 6
}
]
}
[Snippet is copied from http://www.elasticsearch.org/guide/reference/mapping/nested-type.html]

Now I'm trying to sort after on one the fields in the nested object
but having problems how to solve this problem.
So, how would you guys try to sort based on value of "count" in the
example above?

Thanks in advance,
Patrik

kimchy · December 16, 2011, 3:47pm

You can't sort on nest fields, moreover, since they are multi valued, even
if they were in the "root" object, you can't sort on them.

On Fri, Dec 16, 2011 at 12:13 AM, Patrik Johansson <
patrik.j.johansson@kentor.se> wrote:

Hi all!

I have an nested mapping and data like the one in this example:
Elasticsearch Platform — Find real-time answers at scale | Elastic
This works great when I'm using a nested filter or nested query.

{
"obj1" : [
{
"name" : "blue",
"count" : 4
},
{
"name" : "green",
"count" : 6
}
]
}
[Snippet is copied from
Elasticsearch Platform — Find real-time answers at scale | Elastic]

Now I'm trying to sort after on one the fields in the nested object
but having problems how to solve this problem.
So, how would you guys try to sort based on value of "count" in the
example above?

Thanks in advance,
Patrik

Patrik_Johansson · December 19, 2011, 8:13am

Thanks for the reply!

So if pure sorting on nest fields is a no-go, is it possible to do some kind of
boosting or custom_score based of the value (or boost) for the nest fields?

//Patrik J

16 dec 2011 kl. 16.47 skrev Shay Banon:

You can't sort on nest fields, moreover, since they are multi valued, even if they were in the "root" object, you can't sort on them.

On Fri, Dec 16, 2011 at 12:13 AM, Patrik Johansson <patrik.j.johansson@kentor.semailto:patrik.j.johansson@kentor.se> wrote:
Hi all!

I have an nested mapping and data like the one in this example:
http://www.elasticsearch.org/guide/reference/mapping/nested-type.html
This works great when I'm using a nested filter or nested query.

{
"obj1" : [
{
"name" : "blue",
"count" : 4
},
{
"name" : "green",
"count" : 6
}
]
}
[Snippet is copied from http://www.elasticsearch.org/guide/reference/mapping/nested-type.html]

Now I'm trying to sort after on one the fields in the nested object
but having problems how to solve this problem.
So, how would you guys try to sort based on value of "count" in the
example above?

Thanks in advance,
Patrik

kimchy · December 20, 2011, 3:11pm

You can, but "within" the nested query per nested element, but check if its
fast enough for you.

On Mon, Dec 19, 2011 at 10:16 AM, Patrik Johansson <
patrik.j.johansson@kentor.se> wrote:

Thanks for the reply!

So if pure sorting on nest fields is a no-go, is it possible to do some
kind of
boosting or custom_score based of the value (or boost) for the nest fields?

//Patrik J

16 dec 2011 kl. 16.47 skrev Shay Banon:

You can't sort on nest fields, moreover, since they are multi valued, even
if they were in the "root" object, you can't sort on them.

On Fri, Dec 16, 2011 at 12:13 AM, Patrik Johansson <
patrik.j.johansson@kentor.se> wrote:

Hi all!

I have an nested mapping and data like the one in this example:
Elasticsearch Platform — Find real-time answers at scale | Elastic
This works great when I'm using a nested filter or nested query.

{
"obj1" : [
{
"name" : "blue",
"count" : 4
},
{
"name" : "green",
"count" : 6
}
]
}
[Snippet is copied from
Elasticsearch Platform — Find real-time answers at scale | Elastic]

Now I'm trying to sort after on one the fields in the nested object
but having problems how to solve this problem.
So, how would you guys try to sort based on value of "count" in the
example above?

Thanks in advance,
Patrik

Dane_Bertram · May 22, 2013, 6:24pm

In case you're still working on this problem, support for sorting by fields
inside of nested documents was added in 0.90:

github.com/elastic/elasticsearch

Add support for sorting by fields inside one or more nested objects

opened 07:01PM - 18 Feb 13 UTC

closed 09:28PM - 18 Feb 13 UTC

martijnvg

>feature v0.90.0.Beta1

The sorting by nested field support has the following parameters on top of the a…lready existing sort options: - `nested_path` - Defines the on what nested object to sort. The actual sort field must be a direct field inside this nested object. The default is to use the most immediate inherited nested object from the sort field. - `nested_filter` - A filter the inner objects inside the nested path should match with in order for its field values to be taken into account by sorting. Common case is to repeat the query / filter inside the nested filter or query. By default no `nested_filter` is active. Either the highest (max) or lowest (min) inner object is picked for during sorting depending on the `sort_mode` being used. The `sort_mode` options `avg` and `sum` can still be used for number based fields inside nested objects. All the values for the sort field are taken into account for each nested object.

On Thursday, 15 December 2011 17:13:37 UTC-5, Patrik Johansson wrote:

Hi all!

I have an nested mapping and data like the one in this example:
Elasticsearch Platform — Find real-time answers at scale | Elastic
This works great when I'm using a nested filter or nested query.

{
"obj1" : [
{
"name" : "blue",
"count" : 4
},
{
"name" : "green",
"count" : 6
}
]
}
[Snippet is copied from
Elasticsearch Platform — Find real-time answers at scale | Elastic]

Now I'm trying to sort after on one the fields in the nested object
but having problems how to solve this problem.
So, how would you guys try to sort based on value of "count" in the
example above?

Thanks in advance,
Patrik

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

garnaes · May 23, 2013, 8:36am

That's what I thought, but I can't get it working
(see Redirecting to Google Groups).
Can someone provide a working example?

On Wednesday, 22 May 2013 20:24:27 UTC+2, Dane Bertram wrote:

In case you're still working on this problem, support for sorting by
fields inside of nested documents was added in 0.90:

Add support for sorting by fields inside one or more nested objects · Issue #2662 · elastic/elasticsearch · GitHub

On Thursday, 15 December 2011 17:13:37 UTC-5, Patrik Johansson wrote:

Hi all!

I have an nested mapping and data like the one in this example:
Elasticsearch Platform — Find real-time answers at scale | Elastic
This works great when I'm using a nested filter or nested query.

{
"obj1" : [
{
"name" : "blue",
"count" : 4
},
{
"name" : "green",
"count" : 6
}
]
}
[Snippet is copied from
Elasticsearch Platform — Find real-time answers at scale | Elastic]

Now I'm trying to sort after on one the fields in the nested object
but having problems how to solve this problem.
So, how would you guys try to sort based on value of "count" in the
example above?

Thanks in advance,
Patrik

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.