# Elasticsearch not returning hits for multi-valued field **URL:** \ **Category:** Elasticsearch\ **Created:** [August 5, 2015, 5:28pm UTC](https://discuss.elastic.co/t/elasticsearch-not-returning-hits-for-multi-valued-field/26912 "2015-08-05T17:28:42Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![pferrel](https://avatars.discourse-cdn.com/v4/letter/p/59ef9b/32.png) [@pferrel](https://discuss.elastic.co/u/pferrel)\ **Post date:** [August 5, 2015, 5:28pm UTC](https://discuss.elastic.co/t/elasticsearch-not-returning-hits-for-multi-valued-field/26912/1 "2015-08-05T17:28:42Z")
I am using Elasticsearch with no modifications whatsoever. This means the mappings, norms, and analyzed/not\_analyzed are all default config. I have a very small data set of two items for experimentation purposes (trying to migrate from Solr). The items have several fields but I query only on one, which is a multi-valued/array of strings field. The doc looks like this: ``` { "_index": "index_profile", "_type": "items", "_id": "ega", "_version": 1, "found": true, "_source": { "clicked": [ "ega" ], "profile_topics": [ "Twitter", "Entertainment", "ESPN", "Comedy", "University of Rhode Island", "Humor", "Basketball", "Sports", "Movies", "SnapChat", "Celebrities", "Rite Aid", "Education", "Television", "Country Music", "Seattle", "Beer", "Hip Hop", "Actors", "David Cameron", ... // other topics ], "id": "ega" } } ``` A sample query is: ``` GET /index_profile/items/_search { "size": 10, "query": { "bool": { "should": [{ "terms": { "profile_topics": [ "Basketball" ] } }] } } } ``` Again there are only two items and the one listed should match the query because the `profile_topics` field matches with the "Basketball" term. The other item does not match. I only get a result if I ask for `clicked` = `ega` in the should. With Solr I would probably specify that the fields are multi-valued string arrays and are to have no norms and no analyzer so profile\_topics are not stemmed or tokenized since all values should be treated as tokens (even the spaces). Not sure this would solve the problem but it is how I treat similar data on Solr. I assume I have run afoul of some norm/analyzer/TF-IDF issue, if so how do I solve this so that even with two items the query will return `ega`. If possible I'd like to solve this index or type wide rather than field specific. ---
**Author:** ![dantuff](https://avatars.discourse-cdn.com/v4/letter/d/e79b87/32.png) [@dantuff](https://discuss.elastic.co/u/dantuff)\ **Post date:** [August 5, 2015, 9:50pm UTC](https://discuss.elastic.co/t/elasticsearch-not-returning-hits-for-multi-valued-field/26912/2 "2015-08-05T21:50:56Z")
You're not getting a match with that query because you are using the `terms` query, the `terms` query doesn't analyze the search term. So during indexing the term was analyzed using the standard analyzer, the resulting term in the index would be `basketball` (lowercased), therefore your unanalyzed search term `Basketball` will not match. Change the term query to a [match query](https://www.elastic.co/guide/en/elasticsearch/reference/1.6/query-dsl-match-query.html). ---
**Author:** ![pferrel](https://avatars.discourse-cdn.com/v4/letter/p/59ef9b/32.png) [@pferrel](https://discuss.elastic.co/u/pferrel)\ **Post date:** [August 5, 2015, 10:39pm UTC](https://discuss.elastic.co/t/elasticsearch-not-returning-hits-for-multi-valued-field/26912/3 "2015-08-05T22:39:11Z")
Awesome. That's it. But I need to keep the array of terms and `match` doesn't seem to allow that. Actually the method is probably to disable all analysis everywhere, no lowercasing, no stemming, no tokenizing, no breaking by spaces in query or index. The query data will be an exact match to some of the tokens in the doc named field. I think Solr lets you set an analyzer to none and the same analyzer is used for query data as is used in the index. Any advice on how to turn all that off, preferably for an index and all queries? ---
**Author:** ![dantuff](https://avatars.discourse-cdn.com/v4/letter/d/e79b87/32.png) [@dantuff](https://discuss.elastic.co/u/dantuff)\ **Post date:** [August 6, 2015, 7:46am UTC](https://discuss.elastic.co/t/elasticsearch-not-returning-hits-for-multi-valued-field/26912/4 "2015-08-06T07:46:07Z")
To do exact matches use the `not_analyzed` index attribute in your custom mapping . [https://www.elastic.co/guide/en/elasticsearch/guide/current/mapping-intro.html#custom-field-mappings](https://www.elastic.co/guide/en/elasticsearch/guide/current/mapping-intro.html#custom-field-mappings) ---
**Author:** ![pferrel](https://avatars.discourse-cdn.com/v4/letter/p/59ef9b/32.png) [@pferrel](https://discuss.elastic.co/u/pferrel)\ **Post date:** [August 6, 2015, 8:12pm UTC](https://discuss.elastic.co/t/elasticsearch-not-returning-hits-for-multi-valued-field/26912/5 "2015-08-06T20:12:47Z")
Thanks, I've read this but it seems to apply to only a single field and I don't know what fields will be called in the docs when the index is created. So I think I need to have the entire index `not_analyzed` and so may need some form of put mapping (though that also seems tied to fields)? I'm obviously missing something, sorry. ---
**Author:** ![dantuff](https://avatars.discourse-cdn.com/v4/letter/d/e79b87/32.png) [@dantuff](https://discuss.elastic.co/u/dantuff)\ **Post date:** [August 7, 2015, 9:43am UTC](https://discuss.elastic.co/t/elasticsearch-not-returning-hits-for-multi-valued-field/26912/6 "2015-08-07T09:43:01Z")
You can set a [dynamic template](https://www.elastic.co/guide/en/elasticsearch/guide/current/custom-dynamic-mapping.html#dynamic-templates) on the [default mapping](https://www.elastic.co/guide/en/elasticsearch/guide/current/default-mapping.html) when you create the index, this mapping will then apply to all fields in every mapping in your index: ``` POST /index_profile { "mappings": { "_default_": { "dynamic_templates": [ { "all_fields": { "match": "*", "match_mapping_type": "string", "mapping": { "type": "string", "index": "not_analyzed" } } } ] } } } ``` ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 5, 2017, 11:56pm UTC](https://discuss.elastic.co/t/elasticsearch-not-returning-hits-for-multi-valued-field/26912/7 "2017-07-05T23:56:52Z")