ElasticSearch: sort in specific order

Question

i have an indexed string field in my docs with letters a-z as possible values.
Is it possible to sort the query result in specific(given) order?
Something like:

{
    "sort" : [
        { "letters" : {"order" : ["k", "g", "a"...]}}
}

zt1983811 · Accepted Answer · 2015-12-16 12:19:11Z

3

I think instead of sorting you can use function score

"query": {
    "function_score": {
        "query": {},
        "functions": [
           {
                "field_value_factor": 
                {
                    "field": "rank",
                    "factor": 1
                }
            },
            {
                "filter": {"term": {"letters": "k"}},
                "weight": 50
            },
            {
                "filter": {"term": {"letters": "g"}},
                "weight": 40
            },
            {
                "filter": {"term": {"letters": "a"}},
                "weight": 30
            }
        ],
        "score_mode": "sum",
        "boost_mode": "sum"
    }
}

edited Dec 16, 2015 at 12:19

answered Dec 15, 2015 at 13:57

zt1983811

1,0153 gold badges15 silver badges34 bronze badges

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

9 Comments

Stefan Weiss Over a year ago

Thx, I will test it. But unfortunately my question was incomplete, I need to sort on 2 fields: first on letters and then on integer field(ranking) on same letters. How to do it with function score?

Stefan Weiss Over a year ago

I need the following: if the letters are equal, order by ranking. in mysql: ORDER BY FIELD(letters, 'k', 'g', 'a'), ranking

Stefan Weiss Over a year ago

it doesn't work as expected. More "weight" results in less score. i have played with boost mode and score mode, but the letters in results still can be mixed

Stefan Weiss Over a year ago

So:) My rank is in range 1 to 1000, so i gave "weight" 50000 to 100000 to letters. It Works! Thx!

user3821178 Over a year ago

Is there a way of implementing this using the java api?

|

Collectives™ on Stack Overflow

ElasticSearch: sort in specific order

1 Answer 1

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related