# Full Text Search not working in elasticsearch with couchdb - river plugin **URL:** \ **Category:** Elasticsearch\ **Created:** [January 24, 2014, 10:27am UTC](https://discuss.elastic.co/t/full-text-search-not-working-in-elasticsearch-with-couchdb-river-plugin/15399 "2014-01-24T10:27:40Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Akbar\_Ali](https://avatars.discourse-cdn.com/v4/letter/a/41988e/32.png) [@Akbar\_Ali](https://discuss.elastic.co/u/Akbar_Ali)\ **Post date:** [January 24, 2014, 10:27am UTC](https://discuss.elastic.co/t/full-text-search-not-working-in-elasticsearch-with-couchdb-river-plugin/15399/1 "2014-01-24T10:27:40Z")
Hi, I am trying to achieve full text search with elastic search. I created index using the following request _curl -XPUT "[http://192.168.1.90:9200/\_river/elastictest/\_meta](http://192.168.1.90:9200/_river/elastictest/_meta)" -d'_ _{_ - "type" : "couchdb",\* - "couchdb" : {\* - ``` "host" : "localhost",* ``` - ``` "ignore_attachments":true,* ``` - ``` "port" : 5984,* ``` - ``` "db" : "elastictest",* ``` - ``` "filter" : null* ``` - },\* - "index" : {\* - ``` "index" : "elastictest",* ``` - ``` "type" : "elastictest",* ``` - ``` "bulk_size" : "100",* ``` - ``` "bulk_timeout" : "10ms"* ``` - }\* \*}' \* ``` following is my document in couchdb in the database elastictest ``` _{_ - "\_id": "c0a14920f39ee4127446be81db000172",\* - "\_rev": "2-58e0fefa2cbfa6e3fdbb2a6ff3933740",\* - "name": "akbarali",\* - "company": {\* - ``` "name": "Mobinius",* ``` - ``` "location": "Bangalore"* ``` - }\* _}_ following is my query _curl -XPOST "[http://192.168.1.90:9200/elastictest/elastictest/\_search?size=10&from=0](http://192.168.1.90:9200/elastictest/elastictest/_search?size=10&from=0)" -d'_ _{_ _"query" : {_ - ``` "multi_match" : {* ``` - ``` "query" : "a",* ``` - ``` "fields" : ["name", "company.location"]* ``` - }\* _}_ _}'_ And it returns _{_ - "took": 1,\* - "timed\_out": false,\* - "\_shards": {\* - ``` "total": 5,* ``` - ``` "successful": 5,* ``` - ``` "failed": 0* ``` - },\* - "hits": {\* - ``` "total": 0,* ``` - ``` "max_score": null,* ``` - ``` "hits": []* ``` - }\* \*} \* Also in the query, if i replace a with full name akbarali, it returns one row, i also trued a.\* that also doesn't work And i would like to know how to change the default index since there are lot of unwanted filed included in the default indexing Regards Akbar -- 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/037f2217-2e64-4733-a1e8-72475633c821%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/037f2217-2e64-4733-a1e8-72475633c821%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Ivan](https://avatars.discourse-cdn.com/v4/letter/i/df788c/32.png) [@Ivan](https://discuss.elastic.co/u/Ivan)\ **Post date:** [January 25, 2014, 5:58pm UTC](https://discuss.elastic.co/t/full-text-search-not-working-in-elasticsearch-with-couchdb-river-plugin/15399/2 "2014-01-25T17:58:56Z")
If you are using the standard default analyzer, then "a" is considered a stopword and will be removed from your query. Try with a different query. -- Ivan On Fri, Jan 24, 2014 at 2:27 AM, Akbar Ali [akbarali1klr@gmail.com](mailto:akbarali1klr@gmail.com) wrote: > Hi, > I am trying to achieve full text search with Elasticsearch. I created > index using the following request > > _curl -XPUT "[http://192.168.1.90:9200/\_river/elastictest/\_meta](http://192.168.1.90:9200/_river/elastictest/_meta) > [http://192.168.1.90:9200/\_river/elastictest/\_meta](http://192.168.1.90:9200/_river/elastictest/_meta)" -d'_ > > _{_ > > - "type" : "couchdb",\* > > - "couchdb" : {\* > > - > > ``` > "host" : "localhost",* > > ``` > > - > > ``` > "ignore_attachments":true,* > > ``` > > - > > ``` > "port" : 5984,* > > ``` > > - > > ``` > "db" : "elastictest",* > > ``` > > - > > ``` > "filter" : null* > > ``` > > - },\* > > - "index" : {\* > > - > > ``` > "index" : "elastictest",* > > ``` > > - > > ``` > "type" : "elastictest",* > > ``` > > - > > ``` > "bulk_size" : "100",* > > ``` > > - > > ``` > "bulk_timeout" : "10ms"* > > ``` > > - }\* > > \*}' \* > > ``` > following is my document in couchdb in the database elastictest > > ``` > > _{_ > > - "\_id": "c0a14920f39ee4127446be81db000172",\* > > - "\_rev": "2-58e0fefa2cbfa6e3fdbb2a6ff3933740",\* > > - "name": "akbarali",\* > > - "company": {\* > > - > > ``` > "name": "Mobinius",* > > ``` > > - > > ``` > "location": "Bangalore"* > > ``` > > - }\* > > _}_ > > following is my query > > _curl -XPOST > "[http://192.168.1.90:9200/elastictest/elastictest/\_search?size=10&from=0](http://192.168.1.90:9200/elastictest/elastictest/_search?size=10&from=0) > [http://192.168.1.90:9200/elastictest/elastictest/\_search?size=10&from=0](http://192.168.1.90:9200/elastictest/elastictest/_search?size=10&from=0)" > -d'_ > > _{_ > > _"query" : {_ > > - > > ``` > "multi_match" : {* > > ``` > > - > > ``` > "query" : "a",* > > ``` > > - > > ``` > "fields" : ["name", "company.location"]* > > ``` > > - }\* > > _}_ > > _}'_ > > And it returns > > _{_ > > - "took": 1,\* > > - "timed\_out": false,\* > > - "\_shards": {\* > > - > > ``` > "total": 5,* > > ``` > > - > > ``` > "successful": 5,* > > ``` > > - > > ``` > "failed": 0* > > ``` > > - },\* > > - "hits": {\* > > - > > ``` > "total": 0,* > > ``` > > - > > ``` > "max_score": null,* > > ``` > > - > > ``` > "hits": []* > > ``` > > - }\* > > \*} \* > > Also in the query, if i replace a with full name akbarali, it returns one > row, i also trued a.\* that also doesn't work > And i would like to know how to change the default index since there are > lot of unwanted filed included in the default indexing > > Regards > Akbar > > -- > 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/037f2217-2e64-4733-a1e8-72475633c821%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/037f2217-2e64-4733-a1e8-72475633c821%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/CALY%3DcQBqqitBPVop0L45%2BQwDsk-weQhffw2DP7OivSyf5o4uyQ%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CALY%3DcQBqqitBPVop0L45%2BQwDsk-weQhffw2DP7OivSyf5o4uyQ%40mail.gmail.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Akbar\_Ali](https://avatars.discourse-cdn.com/v4/letter/a/41988e/32.png) [@Akbar\_Ali](https://discuss.elastic.co/u/Akbar_Ali)\ **Post date:** [January 27, 2014, 6:32am UTC](https://discuss.elastic.co/t/full-text-search-not-working-in-elasticsearch-with-couchdb-river-plugin/15399/3 "2014-01-27T06:32:21Z")
Hi Ivan, Thanks for the reply. I changed the query to "_akb_" , but still i am not able to get the result. I tried to play around with values and queries a little, Suppose I have a field "_name_" with value "_This is going well_", and "_Sushil_" in two documents, it gives me fail result mentioned below for the below queries _POST /elastictest/elastictest/\_search?size=10&from=0_ _{_ - "query": {\* - "match": {\* - ``` "_all": {* ``` - ``` "query": "This is going well", // "Th" , This => Failure* ``` - ``` "operator": "or"* ``` - ``` }* ``` - }\* - } \* _}_ _POST /elastictest/elastictest/\_search?size=10&from=0_ _{_ - "query": {\* - "match": {\* - ``` "_all": {* ``` - ``` "query": "Sushil", // Success* ``` - ``` "operator": "or"* ``` - ``` }* ``` - }\* - } \* _}_ I expect sentences with some words or only words as expected values of my fields and i would like to search then with letters. Can you guide me a way do achieve this? and it is success only for On Saturday, 25 January 2014 23:28:56 UTC+5:30, Ivan Brusic wrote: > If you are using the standard default analyzer, then "a" is considered a > stopword and will be removed from your query. Try with a different query. > > -- > Ivan > > On Fri, Jan 24, 2014 at 2:27 AM, Akbar Ali \<[akbara...@gmail.com](mailto:akbara...@gmail.com)\ > > > wrote: > > > Hi, > > I am trying to achieve full text search with Elasticsearch. I created > > index using the following request > > > > _curl -XPUT "[http://192.168.1.90:9200/\_river/elastictest/\_meta](http://192.168.1.90:9200/_river/elastictest/_meta) > > [http://192.168.1.90:9200/\_river/elastictest/\_meta](http://192.168.1.90:9200/_river/elastictest/_meta)" -d'_ > > > > _{_ > > > > - "type" : "couchdb",\* > > > > - "couchdb" : {\* > > > > - > > > > ``` > > "host" : "localhost",* > > > > ``` > > > > - > > > > ``` > > "ignore_attachments":true,* > > > > ``` > > > > - > > > > ``` > > "port" : 5984,* > > > > ``` > > > > - > > > > ``` > > "db" : "elastictest",* > > > > ``` > > > > - > > > > ``` > > "filter" : null* > > > > ``` > > > > - },\* > > > > - "index" : {\* > > > > - > > > > ``` > > "index" : "elastictest",* > > > > ``` > > > > - > > > > ``` > > "type" : "elastictest",* > > > > ``` > > > > - > > > > ``` > > "bulk_size" : "100",* > > > > ``` > > > > - > > > > ``` > > "bulk_timeout" : "10ms"* > > > > ``` > > > > - }\* > > > > \*}' \* > > > > ``` > > following is my document in couchdb in the database elastictest > > > > ``` > > > > _{_ > > > > - "\_id": "c0a14920f39ee4127446be81db000172",\* > > > > - "\_rev": "2-58e0fefa2cbfa6e3fdbb2a6ff3933740",\* > > > > - "name": "akbarali",\* > > > > - "company": {\* > > > > - > > > > ``` > > "name": "Mobinius",* > > > > ``` > > > > - > > > > ``` > > "location": "Bangalore"* > > > > ``` > > > > - }\* > > > > _}_ > > > > following is my query > > > > _curl -XPOST > > "[http://192.168.1.90:9200/elastictest/elastictest/\_search?size=10&from=0](http://192.168.1.90:9200/elastictest/elastictest/_search?size=10&from=0) > > [http://192.168.1.90:9200/elastictest/elastictest/\_search?size=10&from=0](http://192.168.1.90:9200/elastictest/elastictest/_search?size=10&from=0)" > > -d'_ > > > > _{_ > > > > _"query" : {_ > > > > - > > > > ``` > > "multi_match" : {* > > > > ``` > > > > - > > > > ``` > > "query" : "a",* > > > > ``` > > > > - > > > > ``` > > "fields" : ["name", "company.location"]* > > > > ``` > > > > - }\* > > > > _}_ > > > > _}'_ > > > > And it returns > > > > _{_ > > > > - "took": 1,\* > > > > - "timed\_out": false,\* > > > > - "\_shards": {\* > > > > - > > > > ``` > > "total": 5,* > > > > ``` > > > > - > > > > ``` > > "successful": 5,* > > > > ``` > > > > - > > > > ``` > > "failed": 0* > > > > ``` > > > > - },\* > > > > - "hits": {\* > > > > - > > > > ``` > > "total": 0,* > > > > ``` > > > > - > > > > ``` > > "max_score": null,* > > > > ``` > > > > - > > > > ``` > > "hits": []* > > > > ``` > > > > - }\* > > > > \*} \* > > > > Also in the query, if i replace a with full name akbarali, it returns > > one row, i also trued a.\* that also doesn't work > > And i would like to know how to change the default index since there are > > lot of unwanted filed included in the default indexing > > > > Regards > > Akbar > > > > -- > > 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/037f2217-2e64-4733-a1e8-72475633c821%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/037f2217-2e64-4733-a1e8-72475633c821%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/2366ecbb-61c9-4d06-80e8-584fc95485c1%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/2366ecbb-61c9-4d06-80e8-584fc95485c1%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:54am UTC](https://discuss.elastic.co/t/full-text-search-not-working-in-elasticsearch-with-couchdb-river-plugin/15399/4 "2017-07-06T01:54:43Z")