Filter by terms in an array

Question

I'm trying to filter by terms within an array on elasticsearch documents. This is what the documents look like:

{
    "name": "Foo",
    "id": 10,
    "industries": ["Tech", "Fashion"],
    ...
}

But for the various filter-based queries I try, I've gotten zero results. e.g.:

$ curl -XGET 'http://localhost:9200/_search?pretty=true' -d '
{
    "query": {
        "filtered": {
            "filter": {
                "bool": {
                    "must": [{
                        "terms": {
                            "industries": ["Tech"],
                            "execution": "or"
                        }
                    }]
                }
            },
            "query": {"match_all": {}}
        }
    },
    "from": 0,
    "size": 20
}
'

I've tried about a dozen different queries against various simplifications and filter clauses, e.g. here's a simplified one:

$ curl -XGET 'http://localhost:9200/_search?pretty=true' -d '
{
    "query": {
        "filtered": {
            "filter": {
                "terms": {
                    "industries": ["Tech"],
                    "execution": "or"
                }
            }
        }

    },
    "from": 0,
    "size": 20
}
'

What am I missing here?

What analyzer are you using for the industries field? If you are using the default, it will actually lower case and split your stings, which would explain why your filters aren't picking those documents up (e.g., it's looking for "Tech" when only "tech" exists). If you set the mapping to not_analyzed (or use the multi fields option), that might solve your problem. — Chris
– Chris, Commented Apr 16, 2014 at 20:19
Yep, that did it. Thanks Chris! If you make it an answer I can accept it. — ysimonson
– ysimonson, Commented Apr 16, 2014 at 21:47

Chris · Accepted Answer · 2014-04-21 19:01:28Z

1

What analyzer are you using for the industries field? If you are using the default, it will actually lower case and split your stings, which would explain why your filters aren't picking those documents up (e.g., it's looking for "Tech" when only "tech" exists). If you set the mapping to not_analyzed (or use the multi fields option), that might solve your problem.

answered Apr 21, 2014 at 19:01

Chris

1462 bronze badges

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

Collectives™ on Stack Overflow

Filter by terms in an array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related