Filtering across multiple indices using ElasticSearch

Question

Is is possible to write a conditional filter on an Elasticsearch multi-index query?

I am looking at the filter script, but I can't see anywhere in the documentation if the documents index is a variable I can check?

My existing query looks like this, note the filter script doesn't work - but I assume this is where I need to do my query.

{
    "index": "tweets,articles,animals,buildings",
    "type": "item",
    "body": {
        "query": {
            "multi_match": {
                "query": "cat",
                "type": "phrase_prefix",
                "fields": [
                    "label",
                    "body"
                ]
            }
        },
        "filter": {
            "script": {
                "script": "if (_index == \"animals\") {return true;} else {return false}
            }
        },
        "from": 0,
        "size": 8
    }
}

Obviously I'd like to do more in this filter than just exclude items from a certain index, this is simply an example.

which version of elasticsearch ?

keety
– keety

2016-04-14 17:16:10 +00:00
Commented Apr 14, 2016 at 17:16 — keety
– keety, Commented Apr 14, 2016 at 17:16
2.1.1 currently, but possible to upgrade if needed?

HelloPablo
– HelloPablo

2016-04-14 21:58:22 +00:00
Commented Apr 14, 2016 at 21:58 — HelloPablo
– HelloPablo, Commented Apr 14, 2016 at 21:58

pkhlop · Accepted Answer · 2016-04-14 18:50:14Z

3

You should be able to combine several indices query to solve this task.

answered Apr 14, 2016 at 18:50

pkhlop

1,8443 gold badges19 silver badges24 bronze badges

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

1 Comment

Murali KG Over a year ago

indices query is deprecated in 5.0. But you can filter on _index field just like any other field. {"term": {"_index": "animals"}}

Collectives™ on Stack Overflow

Filtering across multiple indices using ElasticSearch

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related