# How to add several name fields to an unmach definition in a mapping definition? **URL:** \ **Category:** Elasticsearch\ **Created:** [July 10, 2014, 4:28pm UTC](https://discuss.elastic.co/t/how-to-add-several-name-fields-to-an-unmach-definition-in-a-mapping-definition/18581 "2014-07-10T16:28:07Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![JB\_Mere](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jb_mere/32/1420_2.png) [@JB\_Mere](https://discuss.elastic.co/u/JB_Mere)\ **Post date:** [July 10, 2014, 4:28pm UTC](https://discuss.elastic.co/t/how-to-add-several-name-fields-to-an-unmach-definition-in-a-mapping-definition/18581/1 "2014-07-10T16:28:07Z")
Hello to everybody and sorry for this, maybe naive question. I'm defining a mapping for an ES 1.X index database My interest should be to do like: ... "unmatch" : ["Hash","video\_hash"], "match" : "\*", ... but unfortunately it doesn't work? Can you figure out how to get it done ? Thanks in advance Joaquin -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/6c6fbcf6-40b4-447f-b09d-5d74ad67a1a9%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/6c6fbcf6-40b4-447f-b09d-5d74ad67a1a9%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![vineeth\_mohan\_2](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vineeth_mohan_2/32/747_2.png) [@vineeth\_mohan\_2](https://discuss.elastic.co/u/vineeth_mohan_2)\ **Post date:** [July 10, 2014, 5:46pm UTC](https://discuss.elastic.co/t/how-to-add-several-name-fields-to-an-unmach-definition-in-a-mapping-definition/18581/2 "2014-07-10T17:46:54Z")
Hello Joaquin , Your question is not very clear. Can you brief it once more. Thanks Vineeth On Thu, Jul 10, 2014 at 9:58 PM, JB Mere [jbmere@gmail.com](mailto:jbmere@gmail.com) wrote: > Hello to everybody and sorry for this, maybe naive question. > > I'm defining a mapping for an ES 1.X index database > > My interest should be to do like: > ... > "unmatch" : ["Hash","video\_hash"], > "match" : "\*", > ... > > but unfortunately it doesn't work? > > Can you figure out how to get it done ? > > Thanks in advance > > Joaquin > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit > [https://groups.google.com/d/msgid/elasticsearch/6c6fbcf6-40b4-447f-b09d-5d74ad67a1a9%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/6c6fbcf6-40b4-447f-b09d-5d74ad67a1a9%40googlegroups.com) > [https://groups.google.com/d/msgid/elasticsearch/6c6fbcf6-40b4-447f-b09d-5d74ad67a1a9%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/6c6fbcf6-40b4-447f-b09d-5d74ad67a1a9%40googlegroups.com?utm_medium=email&utm_source=footer) > . > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAGdPd5mOO91CHWrDuyh%3D4%3DHQSQZgASXTjzs0%3DcgbSYwsM96ZtQ%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAGdPd5mOO91CHWrDuyh%3D4%3DHQSQZgASXTjzs0%3DcgbSYwsM96ZtQ%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![JB\_Mere](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jb_mere/32/1420_2.png) [@JB\_Mere](https://discuss.elastic.co/u/JB_Mere)\ **Post date:** [July 10, 2014, 9:42pm UTC](https://discuss.elastic.co/t/how-to-add-several-name-fields-to-an-unmach-definition-in-a-mapping-definition/18581/3 "2014-07-10T21:42:57Z")
Hello Yes, sure, sorry for being quite unclear. Let me try to explin the issue better: Imagine I'm defining the following mapping: curl -XPUT '[http://localhost:9200/inteco5/inteco5/\_mapping](http://localhost:9200/inteco5/inteco5/_mapping)' -d '{ "inteco5" : { "dynamic\_templates" : [ { "date\_fields" : { "match" : "_Date_", "mapping" : { "type" : "date", "format" : "dateOptionalTime" } } }, { "location": { "match" : "asasec\_loc", "mapping" : { "type": "geo\_point" } } }, { "string\_generic" : { "match" : "\*", "unmatch" : "Hash", "mapping" : { "type" : "string" } } } ] } }' For sure it works, but what if I want to define in the string part that every keyword shall be string except those keys named Hash AND video\_hash ? Then, it should be like "match" : "\*", "unmatch" : ["Hash", "video\_hash"], but it does not work at all. Hopefully It is now clearer. Do you have any idea on how to specify it? Thanks a lot. Joaquin El jueves, 10 de julio de 2014 19:47:01 UTC+2, vineeth mohan escribió: > Hello Joaquin , > > Your question is not very clear. > Can you brief it once more. > > Thanks > Vineeth > > On Thu, Jul 10, 2014 at 9:58 PM, JB Mere \<[jbm...@gmail.com](mailto:jbm...@gmail.com) \\> > wrote: > > > Hello to everybody and sorry for this, maybe naive question. > > > > I'm defining a mapping for an ES 1.X index database > > > > My interest should be to do like: > > ... > > "unmatch" : ["Hash","video\_hash"], > > "match" : "\*", > > ... > > > > but unfortunately it doesn't work? > > > > Can you figure out how to get it done ? > > > > Thanks in advance > > > > Joaquin > > > > -- > > You received this message because you are subscribed to the Google Groups > > "elasticsearch" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/6c6fbcf6-40b4-447f-b09d-5d74ad67a1a9%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/6c6fbcf6-40b4-447f-b09d-5d74ad67a1a9%40googlegroups.com) > > [https://groups.google.com/d/msgid/elasticsearch/6c6fbcf6-40b4-447f-b09d-5d74ad67a1a9%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/6c6fbcf6-40b4-447f-b09d-5d74ad67a1a9%40googlegroups.com?utm_medium=email&utm_source=footer) > > . > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/497dff13-514d-4944-8d2f-0c1146d05487%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/497dff13-514d-4944-8d2f-0c1146d05487%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![vineeth\_mohan\_2](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vineeth_mohan_2/32/747_2.png) [@vineeth\_mohan\_2](https://discuss.elastic.co/u/vineeth_mohan_2)\ **Post date:** [July 11, 2014, 2:37am UTC](https://discuss.elastic.co/t/how-to-add-several-name-fields-to-an-unmach-definition-in-a-mapping-definition/18581/4 "2014-07-11T02:37:30Z")
Hi Joaquin , I believe you don't want certain words to be indexed. If that is the case , add those words as stop words - > **[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. Thanks Vineeth On Fri, Jul 11, 2014 at 3:12 AM, JB Mere [jbmere@gmail.com](mailto:jbmere@gmail.com) wrote: > Hello > > Yes, sure, sorry for being quite unclear. Let me try to explin the issue > better: > > Imagine I'm defining the following mapping: > curl -XPUT '[http://localhost:9200/inteco5/inteco5/\_mapping](http://localhost:9200/inteco5/inteco5/_mapping)' -d '{ > "inteco5" : { > "dynamic\_templates" : [ > { > "date\_fields" : { > "match" : "_Date_", > "mapping" : { > "type" : "date", > "format" : "dateOptionalTime" > } > } > }, > { > "location": { > "match" : "asasec\_loc", > "mapping" : { > "type": "geo\_point" > } > } > }, > { > "string\_generic" : { > "match" : "\*", > "unmatch" : "Hash", > "mapping" : { > "type" : "string" > } > } > } > ] > } > }' > > For sure it works, but what if I want to define in the string part that > every keyword shall be string except those keys named Hash AND video\_hash ? > > Then, it should be like > "match" : "\*", > "unmatch" : ["Hash", "video\_hash"], > but it does not work at all. > > Hopefully It is now clearer. > Do you have any idea on how to specify it? > > Thanks a lot. > > Joaquin > > El jueves, 10 de julio de 2014 19:47:01 UTC+2, vineeth mohan escribió: > > > Hello Joaquin , > > > > Your question is not very clear. > > Can you brief it once more. > > > > Thanks > > Vineeth > > > > On Thu, Jul 10, 2014 at 9:58 PM, JB Mere [jbm...@gmail.com](mailto:jbm...@gmail.com) wrote: > > > > > Hello to everybody and sorry for this, maybe naive question. > > > > > > I'm defining a mapping for an ES 1.X index database > > > > > > My interest should be to do like: > > > ... > > > "unmatch" : ["Hash","video\_hash"], > > > "match" : "\*", > > > ... > > > > > > but unfortunately it doesn't work? > > > > > > Can you figure out how to get it done ? > > > > > > Thanks in advance > > > > > > Joaquin > > > > > > -- > > > You received this message because you are subscribed to the Google > > > Groups "elasticsearch" group. > > > To unsubscribe from this group and stop receiving emails from it, send > > > an email to [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > > > > > To view this discussion on the web visit [https://groups.google.com/d/](https://groups.google.com/d/) > > > msgid/elasticsearch/6c6fbcf6-40b4-447f-b09d-5d74ad67a1a9% > > > [40googlegroups.com](http://40googlegroups.com) > > > [https://groups.google.com/d/msgid/elasticsearch/6c6fbcf6-40b4-447f-b09d-5d74ad67a1a9%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/6c6fbcf6-40b4-447f-b09d-5d74ad67a1a9%40googlegroups.com?utm_medium=email&utm_source=footer) > > > . > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > -- > > You received this message because you are subscribed to the Google Groups > > "elasticsearch" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/497dff13-514d-4944-8d2f-0c1146d05487%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/497dff13-514d-4944-8d2f-0c1146d05487%40googlegroups.com) > > [https://groups.google.com/d/msgid/elasticsearch/497dff13-514d-4944-8d2f-0c1146d05487%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/497dff13-514d-4944-8d2f-0c1146d05487%40googlegroups.com?utm_medium=email&utm_source=footer) > > . > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAGdPd5nd%3DnJpoGZdAprKsoFH0b8jJjB4D2LbDQiU5SmkzAnJMA%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAGdPd5nd%3DnJpoGZdAprKsoFH0b8jJjB4D2LbDQiU5SmkzAnJMA%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Ivan](https://avatars.discourse-cdn.com/v4/letter/i/df788c/32.png) [@Ivan](https://discuss.elastic.co/u/Ivan)\ **Post date:** [July 11, 2014, 6:10pm UTC](https://discuss.elastic.co/t/how-to-add-several-name-fields-to-an-unmach-definition-in-a-mapping-definition/18581/5 "2014-07-11T18:10:10Z")
Besides stop works, you can use a bool query one clause is the match all, and the other clause is must not with the terms in question. Something like: { "query": { "bool": { "must": [ { "match\_all": {} } ], "must\_not": [ { "terms": { "string\_generic": [ "Hash", "video\_hash" ] } } ] } } } Lucene used to have a limitation where you could not simply execute a not query by itself. The trick was simply to use a match all in conjunction with the not query. Not sure if the limitation still exists (it probably does), but I find it easier to read if you thrown in the explicit match all. Cheers, Ivan On Thu, Jul 10, 2014 at 7:37 PM, vineeth mohan [vm.vineethmohan@gmail.com](mailto:vm.vineethmohan@gmail.com) wrote: > Hi Joaquin , > > I believe you don't want certain words to be indexed. > If that is the case , add those words as stop words - > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/analysis-stop-tokenfilter.html) > > Thanks > Vineeth > > On Fri, Jul 11, 2014 at 3:12 AM, JB Mere [jbmere@gmail.com](mailto:jbmere@gmail.com) wrote: > > > Hello > > > > Yes, sure, sorry for being quite unclear. Let me try to explin the issue > > better: > > > > Imagine I'm defining the following mapping: > > curl -XPUT '[http://localhost:9200/inteco5/inteco5/\_mapping](http://localhost:9200/inteco5/inteco5/_mapping)' -d '{ > > "inteco5" : { > > "dynamic\_templates" : [ > > { > > "date\_fields" : { > > "match" : "_Date_", > > "mapping" : { > > "type" : "date", > > "format" : "dateOptionalTime" > > } > > } > > }, > > { > > "location": { > > "match" : "asasec\_loc", > > "mapping" : { > > "type": "geo\_point" > > } > > } > > }, > > { > > "string\_generic" : { > > "match" : "\*", > > "unmatch" : "Hash", > > "mapping" : { > > "type" : "string" > > } > > } > > } > > ] > > } > > }' > > > > For sure it works, but what if I want to define in the string part that > > every keyword shall be string except those keys named Hash AND video\_hash ? > > > > Then, it should be like > > "match" : "\*", > > "unmatch" : ["Hash", "video\_hash"], > > but it does not work at all. > > > > Hopefully It is now clearer. > > Do you have any idea on how to specify it? > > > > Thanks a lot. > > > > Joaquin > > > > El jueves, 10 de julio de 2014 19:47:01 UTC+2, vineeth mohan escribió: > > > > > Hello Joaquin , > > > > > > Your question is not very clear. > > > Can you brief it once more. > > > > > > Thanks > > > Vineeth > > > > > > On Thu, Jul 10, 2014 at 9:58 PM, JB Mere [jbm...@gmail.com](mailto:jbm...@gmail.com) wrote: > > > > > > > Hello to everybody and sorry for this, maybe naive question. > > > > > > > > I'm defining a mapping for an ES 1.X index database > > > > > > > > My interest should be to do like: > > > > ... > > > > "unmatch" : ["Hash","video\_hash"], > > > > "match" : "\*", > > > > ... > > > > > > > > but unfortunately it doesn't work? > > > > > > > > Can you figure out how to get it done ? > > > > > > > > Thanks in advance > > > > > > > > Joaquin > > > > > > > > -- > > > > You received this message because you are subscribed to the Google > > > > Groups "elasticsearch" group. > > > > To unsubscribe from this group and stop receiving emails from it, send > > > > an email to [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > > > > > > > To view this discussion on the web visit [https://groups.google.com/d/](https://groups.google.com/d/) > > > > msgid/elasticsearch/6c6fbcf6-40b4-447f-b09d-5d74ad67a1a9% > > > > [40googlegroups.com](http://40googlegroups.com) > > > > [https://groups.google.com/d/msgid/elasticsearch/6c6fbcf6-40b4-447f-b09d-5d74ad67a1a9%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/6c6fbcf6-40b4-447f-b09d-5d74ad67a1a9%40googlegroups.com?utm_medium=email&utm_source=footer) > > > > . > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > > > -- > > > You received this message because you are subscribed to the Google Groups > > > "elasticsearch" group. > > > To unsubscribe from this group and stop receiving emails from it, send an > > > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > > > To view this discussion on the web visit > > > [https://groups.google.com/d/msgid/elasticsearch/497dff13-514d-4944-8d2f-0c1146d05487%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/497dff13-514d-4944-8d2f-0c1146d05487%40googlegroups.com) > > > [https://groups.google.com/d/msgid/elasticsearch/497dff13-514d-4944-8d2f-0c1146d05487%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/497dff13-514d-4944-8d2f-0c1146d05487%40googlegroups.com?utm_medium=email&utm_source=footer) > > > . > > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit > [https://groups.google.com/d/msgid/elasticsearch/CAGdPd5nd%3DnJpoGZdAprKsoFH0b8jJjB4D2LbDQiU5SmkzAnJMA%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAGdPd5nd%3DnJpoGZdAprKsoFH0b8jJjB4D2LbDQiU5SmkzAnJMA%40mail.gmail.com) > [https://groups.google.com/d/msgid/elasticsearch/CAGdPd5nd%3DnJpoGZdAprKsoFH0b8jJjB4D2LbDQiU5SmkzAnJMA%40mail.gmail.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/CAGdPd5nd%3DnJpoGZdAprKsoFH0b8jJjB4D2LbDQiU5SmkzAnJMA%40mail.gmail.com?utm_medium=email&utm_source=footer) > . > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CALY%3DcQDkW4J6ZxyeCdQLgq%3DKub80V0F8HiTe8oxDa5SywkNiWA%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CALY%3DcQDkW4J6ZxyeCdQLgq%3DKub80V0F8HiTe8oxDa5SywkNiWA%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**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, 1:16am UTC](https://discuss.elastic.co/t/how-to-add-several-name-fields-to-an-unmach-definition-in-a-mapping-definition/18581/6 "2017-07-06T01:16:27Z")