# Mappings & Analyzer **URL:** \ **Category:** Elasticsearch\ **Created:** [April 27, 2012, 7:04am UTC](https://discuss.elastic.co/t/mappings-analyzer/7487 "2012-04-27T07:04:27Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![bcoder](https://avatars.discourse-cdn.com/v4/letter/b/3e96dc/32.png) [@bcoder](https://discuss.elastic.co/u/bcoder)\ **Post date:** [April 27, 2012, 7:04am UTC](https://discuss.elastic.co/t/mappings-analyzer/7487/1 "2012-04-27T07:04:27Z")
I tried to google and read [elasticsearch.org](http://elasticsearch.org) before. But due to my lack of previous background in Lucene, etc, I find it tough to grasp idea of mapping and analyzer in elasticsearch. My documents schema is something like this: { "a": ["astr1", "astr2", "astr3", ...], "dont\_search\_me": "blahhhh", "substring\_search\_me": "hello world", "b": { "c": ["cstr1", "cstr2", ...], "description": "A potentially large string here ...", "name": "blah", "class": { "class1": "description for class1", "class2": "description for class2", .... } "modified": 1234567 // An integer value (unix timestamp) } } I want to: 1. Query by typing in some free text, which should match text in any of the fields (including inside the string arrays), except for field: "dont\_search\_me" 2. I also want to search "keys" in b.class field, i.e., "class1", "class2",... should also match search result (key names, and also their values) 3. Filter the result by modified date 4. A match within field "name" should have rank higher, then say inside any string in array "c" 5. The field "substring\_search\_me" should allow arbitrary substring matching inside it's content. For example, in content above, a string "ello" should match the field 6. I want to get all unique string in "c" (across all search results), i.e., facets for "c" along with their counts (in the search output). Can someone suggest me mapping, analyzer and kind of queries I require for this task. From my constrained understanding I think, I need an NGram analyzer for allowing substring matching (is that correct?) .. How do I remove field "substring\_search\_me" from index (apart from removing it while adding document to elasticsearch itself ?). Also how do I allow string matching for "key" names as well (but only inside b.class hash, and not any other key name) ? For example in above: "class1" should match the document (since it is inside b.class hash), but "name" should not match (since it is not inside b.class hash). How do I specify such a mapping ? How do I stop content of "modified" field from being searched using text searching, but still be able to filter on it's value based on range of dates etc ? Thanks a ton for your help in advance! ---
**Author:** ![Eric\_Jain](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/eric_jain/32/834_2.png) [@Eric\_Jain](https://discuss.elastic.co/u/Eric_Jain)\ **Post date:** [April 27, 2012, 5:47pm UTC](https://discuss.elastic.co/t/mappings-analyzer/7487/2 "2012-04-27T17:47:14Z")
On Apr 27, 12:04 am, bcoder [blitzkriegco...@gmail.com](mailto:blitzkriegco...@gmail.com) wrote: > 1. Query by typing in some free text, which should match text in any > of the fields (including inside the string arrays), except for field: > "dont\_search\_me" Add index : "no" to the mapping for the "dont\_search\_me" field. All other fields will be copied to an \_all field by default. > **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)** > > Power insights and outcomes with the Elasticsearch Platform and AI. See into your data and find answers that matter with enterprise solutions designed to help you build, observe, and protect. Try Elasticsearch free today. > 1. I also want to search "keys" in b.class field, i.e., "class1", > "class2",... should also match search result (key names, and also > their values) You can do simple field or term queries like a.b.class1:description. > 1. Filter the result by modified date You can filter on exact dates or date ranges. > **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)** > > Power insights and outcomes with the Elasticsearch Platform and AI. See into your data and find answers that matter with enterprise solutions designed to help you build, observe, and protect. Try Elasticsearch free today. > 1. A match within field "name" should have rank higher, then say > inside any string in array "c" You can set a \_boost value either when indexing, or in the query. > **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)** > > Power insights and outcomes with the Elasticsearch Platform and AI. See into your data and find answers that matter with enterprise solutions designed to help you build, observe, and protect. Try Elasticsearch free today. > **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)** > > Power insights and outcomes with the Elasticsearch Platform and AI. See into your data and find answers that matter with enterprise solutions designed to help you build, observe, and protect. Try Elasticsearch free today. > 1. The field "substring\_search\_me" should allow arbitrary substring > matching inside it's content. For example, in content above, a string > "ello" should match the field You can do wildcard queries on "not\_analyzed" fields, however this may be slow (unless using the ngram tokenizer?). > **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)** > > Power insights and outcomes with the Elasticsearch Platform and AI. See into your data and find answers that matter with enterprise solutions designed to help you build, observe, and protect. Try Elasticsearch free today. > 1. I want to get all unique string in "c" (across all search results), > i.e., facets for "c" along with their counts (in the search output). Term facets should work on nested fields. > **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)** > > Power insights and outcomes with the Elasticsearch Platform and AI. See into your data and find answers that matter with enterprise solutions designed to help you build, observe, and protect. Try Elasticsearch free today. > .. How do I remove > field "substring\_search\_me" from index (apart from removing it while > adding document to elasticsearch itself ?). You can either just not index it (see above), or you can filter it from \_source, in which case it could still be indexed, but won't be present when you retrieve the document. > **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)** > > Power insights and outcomes with the Elasticsearch Platform and AI. See into your data and find answers that matter with enterprise solutions designed to help you build, observe, and protect. Try Elasticsearch free today. > Also how do I allow string matching for "key" names as well (but only > inside b.class hash, and not any other key name) ? For example in > above: "class1" should match the document (since it is inside b.class > hash), but "name" should not match (since it is not inside b.class > hash). How do I specify such a mapping ? There is no need for a special mapping, you can specify the path in the query (see above). > How do I stop content of "modified" field from being searched using > text searching, but still be able to filter on it's value based on > range of dates etc ? Add "include\_in\_all" : false to the mapping for the "modified" field. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 3:30am UTC](https://discuss.elastic.co/t/mappings-analyzer/7487/3 "2017-07-06T03:30:51Z")