ElasticSearch sort order for multiple fields

Question

What is the best way to specify the sort order in ElasticSearch for multiple fields? The query string format does not seem to work at all:

http://elasticsearch_url/index/_search?sort=field1:asc&sort=field2:desc&size=100

One would like to sort first by field1, then by field2, but only one of the fields seems to be sorted correctly. The full notations works better, but the first entries have occasionally the wrong search order:

curl -s -XGET http://elasticsearch_url/index/_search -d '
{
    "sort": [
        { "field1": { "order": "desc" }},
        { "field2": { "order": "desc" }}
    ],
    "size": 100
}'

You can't sort multiple fields using the first query string you have used because just one field sort is taking into consideration. If you wish to apply sort on multiple fields, you'll need to use the full notation sort description — eliasah
– eliasah, Commented Apr 22, 2015 at 15:38

jjbskir · Accepted Answer · 2020-02-07 21:03:16Z

21

Apparently the second, full notation works better.

There was another problem that one of the fields contained urls, which was parsed in odd ways by ElasticSearch. Even normal string fields can be difficult to sort, indexing a url in ElasticSearch is even more difficult.

The sort keyword takes in an array that can target multiple fields.

curl -s -XGET http://elasticsearch_url/index/_search -d '
{
    "sort": [
        { "field1": { "order": "desc" }},
        { "field2": { "order": "desc" }}
    ],
    "size": 100
}'

edited Feb 7, 2020 at 21:03

jjbskir

11.3k10 gold badges49 silver badges63 bronze badges

answered Apr 22, 2015 at 18:26

0x4a6f4672

28.3k19 gold badges110 silver badges144 bronze badges

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

3 Comments

DollarAkshay Over a year ago

They are the code snippets identical ? What was the change. I still didnt get it

coredumped0x Over a year ago

@DollarAkshay same. Have you found a solution to this, please?

Manroop Over a year ago

I am also facing the problem to sort with multiple fields, @0x4a6f4672 have you got any resolution to above?

Collectives™ on Stack Overflow

ElasticSearch sort order for multiple fields

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related