Elasticsearch - sort multi-index query

Question

I'm building an autocomplete search with elasticsearch so I need to query 3 indexes posts, comments, authors. I have the following query:

{
   "query":{
      "query_string":{
         "query":"something"
      }
   }
}

the call:

curl -X GET 'http://localhost:9200/posts,comments,authors/_search?pretty' -d '{
  "query": {
    "query_string": {
      "query": "something"
    }
  }
}'

I need to sort the results by specific index fields, for example:

posts index has a field called comments_count, comments votes_count and authors posts_count. When comparing posts, then it should sort by comments_count, when comments then votes_count, when authors then posts_count.

It's possible to do something like that? I wouldn't like to merge the indexes into one because they indexes completely different documents.

Marcus Mansur · Accepted Answer · 2013-06-01 06:10:35Z

3

Well, my problem was that if i sort by a field that is not present in all indexes, documents wont be returned.

Managed to solve with:

{
   "_script":{
      "script":"type=doc['_type'].value;if(type=='posts'){return doc['comments_count'].value} else {return 0};",
      "type":"number",
      "order":"desc"
   }
}

at least now the documents are shown, even if at the bottom.

answered Jun 1, 2013 at 6:10

Marcus Mansur

3371 gold badge4 silver badges14 bronze badges

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

2 Comments

Geert-Jan Over a year ago

"if i sort by a field that is not present in all indexes, documents wont be returned." That is controllable. See elasticsearch.org/guide/reference/api/search/sort. In your case you should probably use {"missing" : "_last"}

Jagjot Over a year ago

@Geert-Jan thanks for pointing in the right direction! Using scripts for this is way too complicated.

peresleguine · Accepted Answer · 2018-02-22 14:29:54Z

3

Instead of using comments_count, votes_count and posts_count you could put into index the same name (e.g. items_count) and perform usual sort:

{
  "sort": [
    { "items_count": "desc" }
  ]
}

If there are other entities which lack items_count there is an option to ignore unmapped fields:

{
  "sort": [
    { "items_count": { "order": "desc", "unmapped_type": "long" } }
  ]
}

answered Feb 22, 2018 at 14:29

peresleguine

2,4232 gold badges32 silver badges36 bronze badges

Comments

Divya Devaraj · Accepted Answer · 2015-07-01 18:58:21Z

2

https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-sort.html

Use ignore unmapped_type to ignore the field when querying against multiple indexes and the field does not exist in other indexes.

answered Jul 1, 2015 at 18:58

Divya Devaraj

211 bronze badge

1 Comment

OhBeWise Over a year ago

Whilst this may theoretically answer the question, it would be preferable to include the essential parts of the answer here, and provide the link for reference.

Collectives™ on Stack Overflow

Elasticsearch - sort multi-index query

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related