# 0.90.9 in elasticsearch - indexing with ngrams, search returns 0 results **URL:** \ **Category:** Elasticsearch\ **Created:** [January 16, 2014, 1:24pm UTC](https://discuss.elastic.co/t/0-90-9-in-elasticsearch-indexing-with-ngrams-search-returns-0-results/15270 "2014-01-16T13:24:58Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![thale\_jacobs](https://avatars.discourse-cdn.com/v4/letter/t/b19c9b/32.png) [@thale\_jacobs](https://discuss.elastic.co/u/thale_jacobs)\ **Post date:** [January 16, 2014, 1:24pm UTC](https://discuss.elastic.co/t/0-90-9-in-elasticsearch-indexing-with-ngrams-search-returns-0-results/15270/1 "2014-01-16T13:24:58Z")
Hello - I am attempting to run a ngram test using elastics 0.90.9. I was able to replicate the problem I am having in our production system by following the example from here: [http://blog.rnf.me/2013/exact-substring-search-in-elasticsearch.html](http://blog.rnf.me/2013/exact-substring-search-in-elasticsearch.html) The Mappings looks like this: { "mappings": { "homes": { "properties": { "desc": { "type": "string", "index\_analyzer": "index\_ngram", "search\_analyzer": "search\_ngram" } } } }, "settings": { "analysis": { "filter": { "desc\_ngram": { "type": "ngram", "min\_gram": 3, "max\_gram": 8 } }, "analyzer": { "index\_ngram": { "type": "custom", "tokenizer": "keyword", "filter": ["desc\_ngram", "lowercase"] }, "search\_ngram": { "type": "custom", "tokenizer": "keyword", "filter": "lowercase" } } } } } The mapping is set up as follows: curl -s -XPUT 'localhost:9200/listings' -d @settings.json Three records are inserted into the index as follows: curl -s -XPUT 'localhost:9200/listings/homes/1' -d '{ "desc": "This is a lovely home with a large yard." }' curl -s -XPUT 'localhost:9200/listings/homes/2' -d '{ "desc": "This large fixer-upper has a gravelly yard." }' curl -s -XPUT 'localhost:9200/listings/homes/3' -d '{ "desc": "A colonial mansion with a large yard and a pool." }' The Search looks like this: curl -s -XGET 'localhost:9200/listings/homes/\_search?pretty=true' -d '{ "query" : { "bool" : { "must" : [ { "match" : { "desc" : { "query" : "large ya", "type" : "phrase" } } }, { "match" : { "desc" : { "query" : "arge yar", "type" : "phrase" } } }, { "match" : { "desc" : { "query" : "rge yard", "type" : "phrase" } } } ] } } }'; The problem is no results are returned. Any input that can be given for a solution would be appreciated. Thank you! -- 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/4bee1be0-7ee4-4667-b4f7-b51371963928%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/4bee1be0-7ee4-4667-b4f7-b51371963928%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [January 16, 2014, 3:14pm UTC](https://discuss.elastic.co/t/0-90-9-in-elasticsearch-indexing-with-ngrams-search-returns-0-results/15270/2 "2014-01-16T15:14:20Z")
Hey! Just tested it with es 1.0.0.RC1 and it's working fine. See [https://gist.github.com/dadoonet/8456535](https://gist.github.com/dadoonet/8456535) -- David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) @dadoonet | @elasticsearchfr Le 16 janvier 2014 at 14:25:02, thale jacobs ([thalejacobs@gmail.com](mailto:thalejacobs@gmail.com)) a écrit: Hello - I am attempting to run a ngram test using elastics 0.90.9. I was able to replicate the problem I am having in our production system by following the example from here: [http://blog.rnf.me/2013/exact-substring-search-in-elasticsearch.html](http://blog.rnf.me/2013/exact-substring-search-in-elasticsearch.html) The Mappings looks like this: { "mappings": { "homes": { "properties": { "desc": { "type": "string", "index\_analyzer": "index\_ngram", "search\_analyzer": "search\_ngram" } } } }, "settings": { "analysis": { "filter": { "desc\_ngram": { "type": "ngram", "min\_gram": 3, "max\_gram": 8 } }, "analyzer": { "index\_ngram": { "type": "custom", "tokenizer": "keyword", "filter": ["desc\_ngram", "lowercase"] }, "search\_ngram": { "type": "custom", "tokenizer": "keyword", "filter": "lowercase" } } } } } The mapping is set up as follows: curl -s -XPUT 'localhost:9200/listings' -d @settings.json Three records are inserted into the index as follows: curl -s -XPUT 'localhost:9200/listings/homes/1' -d '{ "desc": "This is a lovely home with a large yard." }' curl -s -XPUT 'localhost:9200/listings/homes/2' -d '{ "desc": "This large fixer-upper has a gravelly yard." }' curl -s -XPUT 'localhost:9200/listings/homes/3' -d '{ "desc": "A colonial mansion with a large yard and a pool." }' The Search looks like this: curl -s -XGET 'localhost:9200/listings/homes/\_search?pretty=true' -d '{ "query" : { "bool" : { "must" : [{ "match" : { "desc" : { "query" : "large ya", "type" : "phrase" } } }, { "match" : { "desc" : { "query" : "arge yar", "type" : "phrase" } } }, { "match" : { "desc" : { "query" : "rge yard", "type" : "phrase" } } }] } } }'; The problem is no results are returned. Any input that can be given for a solution would be appreciated. Thank you! -- 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/4bee1be0-7ee4-4667-b4f7-b51371963928%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/4bee1be0-7ee4-4667-b4f7-b51371963928%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- 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/etPan.52d7f74c.2ae8944a.dc5%40MacBook-Air-de-David.local](https://groups.google.com/d/msgid/elasticsearch/etPan.52d7f74c.2ae8944a.dc5%40MacBook-Air-de-David.local). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![thale\_jacobs](https://avatars.discourse-cdn.com/v4/letter/t/b19c9b/32.png) [@thale\_jacobs](https://discuss.elastic.co/u/thale_jacobs)\ **Post date:** [January 16, 2014, 5:06pm UTC](https://discuss.elastic.co/t/0-90-9-in-elasticsearch-indexing-with-ngrams-search-returns-0-results/15270/3 "2014-01-16T17:06:54Z")
Hi David - Thanks for the reply. I just tried it on 90.5, 90.9, 90.10, and 1.0.0.RC1. No results were returned in my searches. I forgot to include that I have ES running on ubuntu if that makes a difference. Thale On Thursday, January 16, 2014 10:14:20 AM UTC-5, David Pilato wrote: > Hey! > > Just tested it with es 1.0.0.RC1 and it's working fine. > See [Testing ngrams for https://groups.google.com/d/msgid/elasticsearch/4bee1be0-7ee4-4667-b4f7-b51371963928%40googlegroups.com · GitHub](https://gist.github.com/dadoonet/8456535) > > -- > _David Pilato_ | _Technical Advocate_ | _[Elasticsearch.com](http://Elasticsearch.com)_ > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr) > > Le 16 janvier 2014 at 14:25:02, thale jacobs ([thale...@gmail.com](mailto:thale...@gmail.com)\) > a écrit: > > Hello - I am attempting to run a ngram test using elastics 0.90.9. I was > able to replicate the problem I am having in our production system by > following the example from here: > > [http://blog.rnf.me/2013/exact-substring-search-in-elasticsearch.html](http://blog.rnf.me/2013/exact-substring-search-in-elasticsearch.html) > > The Mappings looks like this: > > { > "mappings": { > "homes": { > "properties": { > "desc": { > "type": "string", > "index\_analyzer": "index\_ngram", > "search\_analyzer": "search\_ngram" > } > } > } > }, > "settings": { > "analysis": { > "filter": { > "desc\_ngram": { > "type": "ngram", > "min\_gram": 3, > "max\_gram": 8 > } > }, > "analyzer": { > "index\_ngram": { > "type": "custom", > "tokenizer": "keyword", > "filter": ["desc\_ngram", "lowercase"] > }, > "search\_ngram": { > "type": "custom", > "tokenizer": "keyword", > "filter": "lowercase" > } > } > } > } > } > > The mapping is set up as follows: > > curl -s -XPUT 'localhost:9200/listings' -d @settings.json > > Three records are inserted into the index as follows: > > curl -s -XPUT 'localhost:9200/listings/homes/1' -d '{ "desc": "This is a > lovely home with a large yard." }' > curl -s -XPUT 'localhost:9200/listings/homes/2' -d '{ "desc": "This large > fixer-upper has a gravelly yard." }' > curl -s -XPUT 'localhost:9200/listings/homes/3' -d '{ "desc": "A colonial > mansion with a large yard and a pool." }' > > The Search looks like this: > curl -s -XGET 'localhost:9200/listings/homes/\_search?pretty=true' -d '{ > "query" : { "bool" : { "must" : [ { "match" : { "desc" : { "query" : "large > ya", "type" : "phrase" } } }, { "match" : { "desc" : { "query" : "arge > yar", "type" : "phrase" } } }, { "match" : { "desc" : { "query" : "rge > yard", "type" : "phrase" } } } ] } } }'; > > The problem is no results are returned. Any input that can be given for a > solution would be appreciated. > > Thank you! > > -- > 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/4bee1be0-7ee4-4667-b4f7-b51371963928%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/4bee1be0-7ee4-4667-b4f7-b51371963928%40googlegroups.com) > . > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- 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/7bccf38a-eaa7-4e7b-9f82-a364a1d410df%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/7bccf38a-eaa7-4e7b-9f82-a364a1d410df%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [January 16, 2014, 5:08pm UTC](https://discuss.elastic.co/t/0-90-9-in-elasticsearch-indexing-with-ngrams-search-returns-0-results/15270/4 "2014-01-16T17:08:07Z")
So you have specific settings in elasticsearch.yml file? What result do you actually get? -- David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) @dadoonet | @elasticsearchfr Le 16 janvier 2014 at 18:06:58, thale jacobs ([thalejacobs@gmail.com](mailto:thalejacobs@gmail.com)) a écrit: Hi David - Thanks for the reply. I just tried it on 90.5, 90.9, 90.10, and 1.0.0.RC1. No results were returned in my searches. I forgot to include that I have ES running on ubuntu if that makes a difference. Thale On Thursday, January 16, 2014 10:14:20 AM UTC-5, David Pilato wrote: Hey! Just tested it with es 1.0.0.RC1 and it's working fine. See [https://gist.github.com/dadoonet/8456535](https://gist.github.com/dadoonet/8456535) -- David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) @dadoonet | @elasticsearchfr Le 16 janvier 2014 at 14:25:02, thale jacobs ([thale...@gmail.com](mailto:thale...@gmail.com)) a écrit: Hello - I am attempting to run a ngram test using elastics 0.90.9. I was able to replicate the problem I am having in our production system by following the example from here: [http://blog.rnf.me/2013/exact-substring-search-in-elasticsearch.html](http://blog.rnf.me/2013/exact-substring-search-in-elasticsearch.html) The Mappings looks like this: { "mappings": { "homes": { "properties": { "desc": { "type": "string", "index\_analyzer": "index\_ngram", "search\_analyzer": "search\_ngram" } } } }, "settings": { "analysis": { "filter": { "desc\_ngram": { "type": "ngram", "min\_gram": 3, "max\_gram": 8 } }, "analyzer": { "index\_ngram": { "type": "custom", "tokenizer": "keyword", "filter": ["desc\_ngram", "lowercase"] }, "search\_ngram": { "type": "custom", "tokenizer": "keyword", "filter": "lowercase" } } } } } The mapping is set up as follows: curl -s -XPUT 'localhost:9200/listings' -d @settings.json Three records are inserted into the index as follows: curl -s -XPUT 'localhost:9200/listings/homes/1' -d '{ "desc": "This is a lovely home with a large yard." }' curl -s -XPUT 'localhost:9200/listings/homes/2' -d '{ "desc": "This large fixer-upper has a gravelly yard." }' curl -s -XPUT 'localhost:9200/listings/homes/3' -d '{ "desc": "A colonial mansion with a large yard and a pool." }' The Search looks like this: curl -s -XGET 'localhost:9200/listings/homes/\_search?pretty=true' -d '{ "query" : { "bool" : { "must" : [{ "match" : { "desc" : { "query" : "large ya", "type" : "phrase" } } }, { "match" : { "desc" : { "query" : "arge yar", "type" : "phrase" } } }, { "match" : { "desc" : { "query" : "rge yard", "type" : "phrase" } } }] } } }'; The problem is no results are returned. Any input that can be given for a solution would be appreciated. Thank you! ## -- 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/4bee1be0-7ee4-4667-b4f7-b51371963928%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/4bee1be0-7ee4-4667-b4f7-b51371963928%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). 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/7bccf38a-eaa7-4e7b-9f82-a364a1d410df%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/7bccf38a-eaa7-4e7b-9f82-a364a1d410df%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- 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/etPan.52d811f7.216231b.dc5%40MacBook-Air-de-David.local](https://groups.google.com/d/msgid/elasticsearch/etPan.52d811f7.216231b.dc5%40MacBook-Air-de-David.local). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![thale\_jacobs](https://avatars.discourse-cdn.com/v4/letter/t/b19c9b/32.png) [@thale\_jacobs](https://discuss.elastic.co/u/thale_jacobs)\ **Post date:** [January 16, 2014, 5:28pm UTC](https://discuss.elastic.co/t/0-90-9-in-elasticsearch-indexing-with-ngrams-search-returns-0-results/15270/5 "2014-01-16T17:28:19Z")
Actually, I take back what I said about it not working. The example you posted up on gist is working. Thanks!...I just need to figure out the difference between the original example I posted up which is not working and your working post. Thanks again. On Thursday, January 16, 2014 12:06:54 PM UTC-5, thale jacobs wrote: > Hi David - Thanks for the reply. I just tried it on 90.5, 90.9, 90.10, > and 1.0.0.RC1. No results were returned in my searches. I forgot to > include that I have ES running on ubuntu if that makes a difference. > > Thale > > On Thursday, January 16, 2014 10:14:20 AM UTC-5, David Pilato wrote: > > > Hey! > > > > Just tested it with es 1.0.0.RC1 and it's working fine. > > See [Testing ngrams for https://groups.google.com/d/msgid/elasticsearch/4bee1be0-7ee4-4667-b4f7-b51371963928%40googlegroups.com · GitHub](https://gist.github.com/dadoonet/8456535) > > > > -- > > _David Pilato_ | _Technical Advocate_ | _[Elasticsearch.com](http://Elasticsearch.com)_ > > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr) > > > > Le 16 janvier 2014 at 14:25:02, thale jacobs ([thale...@gmail.com](mailto:thale...@gmail.com)) a > > écrit: > > > > Hello - I am attempting to run a ngram test using elastics 0.90.9. I > > was able to replicate the problem I am having in our production system by > > following the example from here: > > > > [http://blog.rnf.me/2013/exact-substring-search-in-elasticsearch.html](http://blog.rnf.me/2013/exact-substring-search-in-elasticsearch.html) > > > > The Mappings looks like this: > > > > { > > "mappings": { > > "homes": { > > "properties": { > > "desc": { > > "type": "string", > > "index\_analyzer": "index\_ngram", > > "search\_analyzer": "search\_ngram" > > } > > } > > } > > }, > > "settings": { > > "analysis": { > > "filter": { > > "desc\_ngram": { > > "type": "ngram", > > "min\_gram": 3, > > "max\_gram": 8 > > } > > }, > > "analyzer": { > > "index\_ngram": { > > "type": "custom", > > "tokenizer": "keyword", > > "filter": ["desc\_ngram", "lowercase"] > > }, > > "search\_ngram": { > > "type": "custom", > > "tokenizer": "keyword", > > "filter": "lowercase" > > } > > } > > } > > } > > } > > > > The mapping is set up as follows: > > > > curl -s -XPUT 'localhost:9200/listings' -d @settings.json > > > > Three records are inserted into the index as follows: > > > > curl -s -XPUT 'localhost:9200/listings/homes/1' -d '{ "desc": "This is > > a lovely home with a large yard." }' > > curl -s -XPUT 'localhost:9200/listings/homes/2' -d '{ "desc": "This > > large fixer-upper has a gravelly yard." }' > > curl -s -XPUT 'localhost:9200/listings/homes/3' -d '{ "desc": "A > > colonial mansion with a large yard and a pool." }' > > > > The Search looks like this: > > curl -s -XGET 'localhost:9200/listings/homes/\_search?pretty=true' -d '{ > > "query" : { "bool" : { "must" : [ { "match" : { "desc" : { "query" : "large > > ya", "type" : "phrase" } } }, { "match" : { "desc" : { "query" : "arge > > yar", "type" : "phrase" } } }, { "match" : { "desc" : { "query" : "rge > > yard", "type" : "phrase" } } } ] } } }'; > > > > The problem is no results are returned. Any input that can be given for > > a solution would be appreciated. > > > > Thank you! > > > > -- > > 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/4bee1be0-7ee4-4667-b4f7-b51371963928%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/4bee1be0-7ee4-4667-b4f7-b51371963928%40googlegroups.com) > > . > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- 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/d67e3572-f074-4879-9659-59bc2a561bc5%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/d67e3572-f074-4879-9659-59bc2a561bc5%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**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:56am UTC](https://discuss.elastic.co/t/0-90-9-in-elasticsearch-indexing-with-ngrams-search-returns-0-results/15270/6 "2017-07-06T01:56:21Z")