# No hit in the output **URL:** \ **Category:** Elasticsearch\ **Created:** [August 10, 2012, 8:19am UTC](https://discuss.elastic.co/t/no-hit-in-the-output/8701 "2012-08-10T08:19:40Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![rami\_sellami](https://avatars.discourse-cdn.com/v4/letter/r/e495f1/32.png) [@rami\_sellami](https://discuss.elastic.co/u/rami_sellami)\ **Post date:** [August 10, 2012, 8:19am UTC](https://discuss.elastic.co/t/no-hit-in-the-output/8701/1 "2012-08-10T08:19:40Z")
Dear all, My problem is that I do not get any hits as a result of a query. My input is the imported json file (SampleOfBruno.json). I have only this document in the couchdb database. My query is : curl -XGET [http://localhost:9200/rs/rs/\_search?pretty=true](http://localhost:9200/rs/rs/_search?pretty=true) -d '{ "query" : { "query\_string" :{"query" : "\*"} } }' My output is : { "took" : 94, "timed\_out" : false, "\_shards" : { "total" : 5, "successful" : 5, "failed" : 0 }, "hits" : { "total" : 0, "max\_score" : null, "hits" : [] } }. Could you help me please!! Best regards Rami Sellami. ---
**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:** [August 10, 2012, 9:10am UTC](https://discuss.elastic.co/t/no-hit-in-the-output/8701/2 "2012-08-10T09:10:04Z")
Are you sure you have indexed something ? What about if you query on all: curl -XGET [http://localhost:9200/\_search?query=\*&pretty=true](http://localhost:9200/_search?query=*&pretty=true) Did you create a CouchDB river? David Le 10 août 2012 à 10:19, rami sellami [sel.rami@gmail.com](mailto:sel.rami@gmail.com) a écrit : > Dear all, > > My problem is that I do not get any hits as a result of a query. > My input is the imported json file (SampleOfBruno.json). I have only this > document in the couchdb database. > My query is : > > curl -XGET [http://localhost:9200/rs/rs/\_search?pretty=true](http://localhost:9200/rs/rs/_search?pretty=true) -d '{ > "query" : { > "query\_string" :{"query" : "\*"} > } > }' > > My output is : > > { > "took" : 94, > "timed\_out" : false, > "\_shards" : { > "total" : 5, > "successful" : 5, > "failed" : 0 > }, > "hits" : { > "total" : 0, > "max\_score" : null, > "hits" : > } > }. > > Could you help me please!! > > Best regards > Rami Sellami. -- David Pilato [http://www.scrutmydocs.org/](http://www.scrutmydocs.org/) [http://dev.david.pilato.fr/](http://dev.david.pilato.fr/) Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs ---
**Author:** ![rami\_sellami](https://avatars.discourse-cdn.com/v4/letter/r/e495f1/32.png) [@rami\_sellami](https://discuss.elastic.co/u/rami_sellami)\ **Post date:** [August 10, 2012, 9:24am UTC](https://discuss.elastic.co/t/no-hit-in-the-output/8701/3 "2012-08-10T09:24:32Z")
Yes I created a couchDB river index with: curl -XPUT 'localhost:9200/\_river/rs/\_meta' -d '{ "type" : "couchdb", "couchdb" : { "host" : "localhost", "port" : 5984, "db" : "rs", "filter" : null }, "index" : { "index" : "rs", "type" : "rs", "bulk\_size" : "100", "bulk\_timeout" : "10ms" } }' In addition, the index works, because I add the json file below and I get it when I query on it: { "forename": "Gavin", "surname": "Cooper", "type": "person" }. This is the result if I query on all: {"took":10,"timed\_out":false,"\_shards":{"total":57,"successful":10,"failed":47,"failures":[{"index":"db","shard":0,"status":500,"reason":"No active shards"},{"index":"db","shard":1,"status":500,"reason":"No active shards"},{"index":"db","shard":2,"status":500,"reason":"No active shards"},{"index":"db","shard":3,"status":500,"reason":"No active shards"},{"index":"db","shard":4,"status":500,"reason":"No active shards"},{"index":"ckan-147.102.12.234","shard":0,"status":500,"reason":"No active shards"},{"index":"ckan-147.102.12.234","shard":1,"status":500,"reason":"No active shards"},{"index":"ckan-147.102.12.234","shard":2,"status":500,"reason":"No active shards"},{"index":"ckan-147.102.12.234","shard":3,"status":500,"reason":"No active shards"},{"index":"ckan-147.102.12.234","shard":4,"status":500,"reason":"No active shards"},{"index":"twitter","shard":0,"status":500,"reason":"No active shards"},{"index":"twitter","shard":1,"status":500,"reason":"No active shards"},{"index":"twitter","shard":2,"status":500,"reason":"No active shards"},{"index":"twitter","shard":3,"status":500,"reason":"No active shards"},{"index":"twitter","shard":4,"status":500,"reason":"No active shards"},{"index":"my\_db","shard":0,"status":500,"reason":"No active shards"},{"index":"my\_db","shard":1,"status":500,"reason":"No active shards"},{"index":"my\_db","shard":2,"status":500,"reason":"No active shards"},{"index":"my\_db","shard":3,"status":500,"reason":"No active shards"},{"index":"my\_db","shard":4,"status":500,"reason":"No active shards"},{"index":"test","shard":0,"status":500,"reason":"No active shards"},{"index":"test","shard":1,"status":500,"reason":"No active shards"},{"index":"test","shard":2,"status":500,"reason":"No active shards"},{"index":"test","shard":3,"status":500,"reason":"No active shards"},{"index":"test","shard":4,"status":500,"reason":"No active shards"},{"index":"test","shard":5,"status":500,"reason":"No active shards"},{"index":"test","shard":6,"status":500,"reason":"No active shards"},{"index":"test","shard":7,"status":500,"reason":"No active shards"},{"index":"test","shard":8,"status":500,"reason":"No active shards"},{"index":"test","shard":9,"status":500,"reason":"No active shards"},{"index":"kimchy","shard":2,"status":500,"reason":"No active shards"},{"index":"blog","shard":0,"status":500,"reason":"No active shards"},{"index":"blog","shard":1,"status":500,"reason":"No active shards"},{"index":"blog","shard":2,"status":500,"reason":"No active shards"},{"index":"blog","shard":3,"status":500,"reason":"No active shards"},{"index":"blog","shard":4,"status":500,"reason":"No active shards"},{"index":"mycouchshop","shard":0,"status":500,"reason":"No active shards"},{"index":"mycouchshop","shard":1,"status":500,"reason":"No active shards"},{"index":"mycouchshop","shard":2,"status":500,"reason":"No active shards"},{"index":"mycouchshop","shard":3,"status":500,"reason":"No active shards"},{"index":"mycouchshop","shard":4,"status":500,"reason":"No active shards"},{"index":"another\_user","shard":0,"status":500,"reason":"No active shards"},{"index":"toto1","shard":0,"status":500,"reason":"No active shards"},{"index":"toto1","shard":1,"status":500,"reason":"No active shards"},{"index":"toto1","shard":2,"status":500,"reason":"No active shards"},{"index":"toto1","shard":3,"status":500,"reason":"No active shards"},{"index":"toto1","shard":4,"status":500,"reason":"No active shards"}]},"hits":{"total":8,"max\_score":1.0,"hits":[{"\_index":"\_river","\_type":"rs","\_id":"\_meta","\_score":1.0, "\_source" : { "type" : "couchdb", "couchdb" : { "host" : "localhost", "port" : 5984, "db" : "rs", "filter" : null }, "index" : { "index" : "rs", "type" : "rs", "bulk\_size" : "100", "bulk\_timeout" : "10ms" } }},{"\_index":"\_river","\_type":"test","\_id":"\_meta","\_score":1.0, "\_source" : { "type" : "couchdb", "couchdb" : { "host" : "localhost", "port" : 5984, "db" : "test", "filter" : null }, "index" : { "index" : "test", "type" : "test", "bulk\_size" : "100", "bulk\_timeout" : "10ms" } }},{"\_index":"\_river","\_type":"test","\_id":"\_seq","\_score":1.0, "\_source" : {"couchdb":{"last\_seq":"3"}}},{"\_index":"\_river","\_type":"rs","\_id":"\_seq","\_score":1.0, "\_source" : {"couchdb":{"last\_seq":"2"}}},{"\_index":"\_river","\_type":"rs","\_id":"\_status","\_score":1.0, "\_source" : {"ok":true,"node":{"id":"LtttB4KXSHGdj\_Y9ZkTxhg","name":"Archer","transport\_address":"inet[/ 157.159.110.99:9300]"}}},{"\_index":"\_river","\_type":"test","\_id":"\_status","\_score":1.0, "\_source" : {"ok":true,"node":{"id":"LtttB4KXSHGdj\_Y9ZkTxhg","name":"Archer","transport\_address":"inet[/ 157.159.110.99:9300]"}}},{"\_index":"kimchy","\_type":"tweet","\_id":"2","\_score":1.0, "\_source" : { "user": "kimchy", "postDate": "2009-11-15T14:12:12", "message": "Another tweet, will it be indexed?" }},{"\_index":"rs","\_type":"rs","\_id":"bcd20f6c77198921be8af0ea69000d91","\_score":1.0, "\_source" : {"\_rev":"1-f62208cb5761dd5c7d1c5954dfba0e7a","forename":"Gavin","\_id":"bcd20f6c77198921be8af0ea69000d91","surname":"Cooper","type":"person"}}]}} 2012/8/10 David Pilato [david@pilato.fr](mailto:david@pilato.fr) > \*\* > > Are you sure you have indexed something ? > > What about if you query on all: > > curl -XGET [http://localhost:9200/\_search?query=\*&pretty=true](http://localhost:9200/_search?query=*&pretty=true) > > Did you create a CouchDB river? > > David > > Le 10 août 2012 à 10:19, rami sellami [sel.rami@gmail.com](mailto:sel.rami@gmail.com) a écrit : > > Dear all, > > My problem is that I do not get any hits as a result of a query. > My input is the imported json file (SampleOfBruno.json). I have only this > document in the couchdb database. > My query is : > > curl -XGET [http://localhost:9200/rs/rs/\_search?pretty=true](http://localhost:9200/rs/rs/_search?pretty=true) -d '{ > "query" : { > "query\_string" :{"query" : "\*"} > } > }' > > My output is : > > { > "took" : 94, > "timed\_out" : false, > "\_shards" : { > "total" : 5, > "successful" : 5, > "failed" : 0 > }, > "hits" : { > "total" : 0, > "max\_score" : null, > "hits" : > } > }. > > Could you help me please!! > > Best regards > Rami Sellami. > > -- > David Pilato > [http://www.scrutmydocs.org/](http://www.scrutmydocs.org/) > [http://dev.david.pilato.fr/](http://dev.david.pilato.fr/) > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs -- Cordialement, Rami Sellami ---
**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:** [August 10, 2012, 9:30am UTC](https://discuss.elastic.co/t/no-hit-in-the-output/8701/4 "2012-08-10T09:30:50Z")
So CouchDB river is working fine as we can see for rs/rs lastseq=2. Then, we can see your document in result: { "\_index":"rs", "\_type":"rs", "\_id":"bcd20f6c77198921be8af0ea69000d91", "\_score":1.0, "\_source":{ "\_rev":"1-f62208cb5761dd5c7d1c5954dfba0e7a", "forename":"Gavin", "\_id":"bcd20f6c77198921be8af0ea69000d91", "surname":"Cooper", "type":"person" } } Stupid I am ! You have to POST your query... Don't use GET. curl -XPOST [http://localhost:9200/rs/rs/\_search?pretty=true](http://localhost:9200/rs/rs/_search?pretty=true) [http://localhost:9200/rs/rs/\_search?pretty=true](http://localhost:9200/rs/rs/_search?pretty=true) -d '{ "query" : { "query\_string" :{"query" : "\*"} } }' Le 10 août 2012 à 11:24, rami sellami [sel.rami@gmail.com](mailto:sel.rami@gmail.com) a écrit : > Yes I created a couchDB river index with: > > curl -XPUT 'localhost:9200/\_river/rs/\_meta' -d '{ > "type" : "couchdb", > "couchdb" : { > "host" : "localhost", > "port" : 5984, > "db" : "rs", > "filter" : null > }, > "index" : { > "index" : "rs", > "type" : "rs", > "bulk\_size" : "100", > "bulk\_timeout" : "10ms" > } > }' > > In addition, the index works, because I add the json file below and I get it > when I query on it: > { > "forename": "Gavin", > "surname": "Cooper", > "type": "person" > }. > > This is the result if I query on all: > > {"took":10,"timed\_out":false,"\_shards":{"total":57,"successful":10,"failed":47,"failures":[{"index":"db","shard":0,"status":500,"reason":"No > active shards"},{"index":"db","shard":1,"status":500,"reason":"No active > shards"},{"index":"db","shard":2,"status":500,"reason":"No active > shards"},{"index":"db","shard":3,"status":500,"reason":"No active > shards"},{"index":"db","shard":4,"status":500,"reason":"No active > shards"},{"index":"ckan-147.102.12.234","shard":0,"status":500,"reason":"No > active > shards"},{"index":"ckan-147.102.12.234","shard":1,"status":500,"reason":"No > active > shards"},{"index":"ckan-147.102.12.234","shard":2,"status":500,"reason":"No > active > shards"},{"index":"ckan-147.102.12.234","shard":3,"status":500,"reason":"No > active > shards"},{"index":"ckan-147.102.12.234","shard":4,"status":500,"reason":"No > active shards"},{"index":"twitter","shard":0,"status":500,"reason":"No active > shards"},{"index":"twitter","shard":1,"status":500,"reason":"No active > shards"},{"index":"twitter","shard":2,"status":500,"reason":"No active > shards"},{"index":"twitter","shard":3,"status":500,"reason":"No active > shards"},{"index":"twitter","shard":4,"status":500,"reason":"No active > shards"},{"index":"my\_db","shard":0,"status":500,"reason":"No active > shards"},{"index":"my\_db","shard":1,"status":500,"reason":"No active > shards"},{"index":"my\_db","shard":2,"status":500,"reason":"No active > shards"},{"index":"my\_db","shard":3,"status":500,"reason":"No active > shards"},{"index":"my\_db","shard":4,"status":500,"reason":"No active > shards"},{"index":"test","shard":0,"status":500,"reason":"No active > shards"},{"index":"test","shard":1,"status":500,"reason":"No active > shards"},{"index":"test","shard":2,"status":500,"reason":"No active > shards"},{"index":"test","shard":3,"status":500,"reason":"No active > shards"},{"index":"test","shard":4,"status":500,"reason":"No active > shards"},{"index":"test","shard":5,"status":500,"reason":"No active > shards"},{"index":"test","shard":6,"status":500,"reason":"No active > shards"},{"index":"test","shard":7,"status":500,"reason":"No active > shards"},{"index":"test","shard":8,"status":500,"reason":"No active > shards"},{"index":"test","shard":9,"status":500,"reason":"No active > shards"},{"index":"kimchy","shard":2,"status":500,"reason":"No active > shards"},{"index":"blog","shard":0,"status":500,"reason":"No active > shards"},{"index":"blog","shard":1,"status":500,"reason":"No active > shards"},{"index":"blog","shard":2,"status":500,"reason":"No active > shards"},{"index":"blog","shard":3,"status":500,"reason":"No active > shards"},{"index":"blog","shard":4,"status":500,"reason":"No active > shards"},{"index":"mycouchshop","shard":0,"status":500,"reason":"No active > shards"},{"index":"mycouchshop","shard":1,"status":500,"reason":"No active > shards"},{"index":"mycouchshop","shard":2,"status":500,"reason":"No active > shards"},{"index":"mycouchshop","shard":3,"status":500,"reason":"No active > shards"},{"index":"mycouchshop","shard":4,"status":500,"reason":"No active > shards"},{"index":"another\_user","shard":0,"status":500,"reason":"No active > shards"},{"index":"toto1","shard":0,"status":500,"reason":"No active > shards"},{"index":"toto1","shard":1,"status":500,"reason":"No active > shards"},{"index":"toto1","shard":2,"status":500,"reason":"No active > shards"},{"index":"toto1","shard":3,"status":500,"reason":"No active > shards"},{"index":"toto1","shard":4,"status":500,"reason":"No active > shards"}]},"hits":{"total":8,"max\_score":1.0,"hits":[{"\_index":"\_river","\_type":"rs","\_id":"\_meta","\_score":1.0, > "\_source" : { > "type" : "couchdb", > "couchdb" : { > "host" : "localhost", > "port" : 5984, > "db" : "rs", > "filter" : null > }, > "index" : { > "index" : "rs", > "type" : "rs", > "bulk\_size" : "100", > "bulk\_timeout" : "10ms" > } > }},{"\_index":"\_river","\_type":"test","\_id":"\_meta","\_score":1.0, "\_source" : > { > "type" : "couchdb", > "couchdb" : { > "host" : "localhost", > "port" : 5984, > "db" : "test", > "filter" : null > }, > "index" : { > "index" : "test", > "type" : "test", > "bulk\_size" : "100", > "bulk\_timeout" : "10ms" > } > }},{"\_index":"\_river","\_type":"test","\_id":"\_seq","\_score":1.0, "\_source" : > {"couchdb":{"last\_seq":"3"}}},{"\_index":"\_river","\_type":"rs","\_id":"\_seq","\_score":1.0, > "\_source" : > {"couchdb":{"last\_seq":"2"}}},{"\_index":"\_river","\_type":"rs","\_id":"\_status","\_score":1.0, > "\_source" : > {"ok":true,"node":{"id":"LtttB4KXSHGdj\_Y9ZkTxhg","name":"Archer","transport\_address":"inet[/ > 157.159.110.99:9300 [http://157.159.110.99:9300](http://157.159.110.99:9300) > ]"}}},{"\_index":"\_river","\_type":"test","\_id":"\_status","\_score":1.0, > "\_source" : > {"ok":true,"node":{"id":"LtttB4KXSHGdj\_Y9ZkTxhg","name":"Archer","transport\_address":"inet[/ > 157.159.110.99:9300 [http://157.159.110.99:9300](http://157.159.110.99:9300) > ]"}}},{"\_index":"kimchy","\_type":"tweet","\_id":"2","\_score":1.0, "\_source" : > { > "user": "kimchy", > "postDate": "2009-11-15T14:12:12", > "message": "Another tweet, will it be indexed?" > > }},{"\_index":"rs","\_type":"rs","\_id":"bcd20f6c77198921be8af0ea69000d91","\_score":1.0, > "\_source" : > {"\_rev":"1-f62208cb5761dd5c7d1c5954dfba0e7a","forename":"Gavin","\_id":"bcd20f6c77198921be8af0ea69000d91","surname":"Cooper","type":"person"}}]}} > > 2012/8/10 David Pilato \<[david@pilato.fr](mailto:david@pilato.fr) [mailto:david@pilato.fr](mailto:david@pilato.fr) \> > > > > Are you sure you have indexed something ? > > > What about if you query on all: > > > curl -XGET [http://localhost:9200/\_search?query=\*&pretty=true](http://localhost:9200/_search?query=*&pretty=true) > > > [http://localhost:9200/\_search?query=\*&pretty=true](http://localhost:9200/_search?query=*&pretty=true) > > > > Did you create a CouchDB river? > > > > David > > > > Le 10 août 2012 à 10:19, rami sellami \< [sel.rami@gmail.com](mailto:sel.rami@gmail.com) > > [mailto:sel.rami@gmail.com](mailto:sel.rami@gmail.com) \> a écrit : > > > > ``` > > > > > Dear all, > > > > ``` > > > > > ``` > > > My problem is that I do not get any hits as a result of a query. > > > My input is the imported json file (SampleOfBruno.json). I have only > > > > > > ``` > > > > > > this document in the couchdb database. > > > My query is : > > > > > > ``` > > > curl -XGET http://localhost:9200/rs/rs/_search?pretty=true > > > > > > ``` > > > > > > [http://localhost:9200/rs/rs/\_search?pretty=true](http://localhost:9200/rs/rs/_search?pretty=true) -d '{ > > > "query" : { > > > "query\_string" :{"query" : "\*"} > > > } > > > }' > > > > > > ``` > > > My output is : > > > > > > { > > > "took" : 94, > > > "timed_out" : false, > > > "_shards" : { > > > "total" : 5, > > > "successful" : 5, > > > "failed" : 0 > > > }, > > > "hits" : { > > > "total" : 0, > > > "max_score" : null, > > > "hits" : [] > > > } > > > }. > > > > > > Could you help me please!! > > > > > > Best regards > > > Rami Sellami. > > > > > > ``` > > > > > > > > > > > > -- > > David Pilato > > [http://www.scrutmydocs.org/](http://www.scrutmydocs.org/) [http://www.scrutmydocs.org/](http://www.scrutmydocs.org/) > > [http://dev.david.pilato.fr/](http://dev.david.pilato.fr/) [http://dev.david.pilato.fr/](http://dev.david.pilato.fr/) > > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs > > > > > > > -- > Cordialement, > Rami Sellami -- David Pilato [http://www.scrutmydocs.org/](http://www.scrutmydocs.org/) [http://dev.david.pilato.fr/](http://dev.david.pilato.fr/) Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs ---
**Author:** ![rami\_sellami](https://avatars.discourse-cdn.com/v4/letter/r/e495f1/32.png) [@rami\_sellami](https://discuss.elastic.co/u/rami_sellami)\ **Post date:** [August 10, 2012, 9:38am UTC](https://discuss.elastic.co/t/no-hit-in-the-output/8701/5 "2012-08-10T09:38:25Z")
This is the result of the POST query, I do not see the other file!! { "took" : 8, "timed\_out" : false, "\_shards" : { "total" : 5, "successful" : 5, "failed" : 0 }, "hits" : { "total" : 1, "max\_score" : 1.0, "hits" : [ { "\_index" : "rs", "\_type" : "rs", "\_id" : "bcd20f6c77198921be8af0ea69000d91", "\_score" : 1.0, "\_source" : {"\_rev":"1-f62208cb5761dd5c7d1c5954dfba0e7a","forename":"Gavin","\_id":"bcd20f6c77198921be8af0ea69000d91","surname":"Cooper","type":"person"} } ] } } 2012/8/10 David Pilato [david@pilato.fr](mailto:david@pilato.fr) > \*\* > > So CouchDB river is working fine as we can see for rs/rs lastseq=2. > > Then, we can see your document in result: > { > "\_index":"rs", > "\_type":"rs", > "\_id":"bcd20f6c77198921be8af0ea69000d91", > "\_score":1.0, > "\_source":{ > "\_rev":"1-f62208cb5761dd5c7d1c5954dfba0e7a", > "forename":"Gavin", > "\_id":"bcd20f6c77198921be8af0ea69000d91", > "surname":"Cooper", > "type":"person" > } > } > > Stupid I am ! You have to POST your query... Don't use GET. > > curl -XPOST [http://localhost:9200/rs/rs/\_search?pretty=true](http://localhost:9200/rs/rs/_search?pretty=true) -d '{ > "query" : { > "query\_string" :{"query" : "\*"} > } > }' > > Le 10 août 2012 à 11:24, rami sellami [sel.rami@gmail.com](mailto:sel.rami@gmail.com) a écrit : > > Yes I created a couchDB river index with: > > curl -XPUT 'localhost:9200/\_river/rs/\_meta' -d '{ > "type" : "couchdb", > "couchdb" : { > "host" : "localhost", > "port" : 5984, > "db" : "rs", > "filter" : null > }, > "index" : { > "index" : "rs", > "type" : "rs", > "bulk\_size" : "100", > "bulk\_timeout" : "10ms" > } > }' > > In addition, the index works, because I add the json file below and I get > it when I query on it: > { > "forename": "Gavin", > "surname": "Cooper", > "type": "person" > }. > > This is the result if I query on all: > {"took":10,"timed\_out":false,"\_shards":{"total":57,"successful":10,"failed":47,"failures":[{"index":"db","shard":0,"status":500,"reason":"No > active shards"},{"index":"db","shard":1,"status":500,"reason":"No active > shards"},{"index":"db","shard":2,"status":500,"reason":"No active > shards"},{"index":"db","shard":3,"status":500,"reason":"No active > shards"},{"index":"db","shard":4,"status":500,"reason":"No active > shards"},{"index":"ckan-147.102.12.234","shard":0,"status":500,"reason":"No > active > shards"},{"index":"ckan-147.102.12.234","shard":1,"status":500,"reason":"No > active > shards"},{"index":"ckan-147.102.12.234","shard":2,"status":500,"reason":"No > active > shards"},{"index":"ckan-147.102.12.234","shard":3,"status":500,"reason":"No > active > shards"},{"index":"ckan-147.102.12.234","shard":4,"status":500,"reason":"No > active shards"},{"index":"twitter","shard":0,"status":500,"reason":"No > active shards"},{"index":"twitter","shard":1,"status":500,"reason":"No > active shards"},{"index":"twitter","shard":2,"status":500,"reason":"No > active shards"},{"index":"twitter","shard":3,"status":500,"reason":"No > active shards"},{"index":"twitter","shard":4,"status":500,"reason":"No > active shards"},{"index":"my\_db","shard":0,"status":500,"reason":"No active > shards"},{"index":"my\_db","shard":1,"status":500,"reason":"No active > shards"},{"index":"my\_db","shard":2,"status":500,"reason":"No active > shards"},{"index":"my\_db","shard":3,"status":500,"reason":"No active > shards"},{"index":"my\_db","shard":4,"status":500,"reason":"No active > shards"},{"index":"test","shard":0,"status":500,"reason":"No active > shards"},{"index":"test","shard":1,"status":500,"reason":"No active > shards"},{"index":"test","shard":2,"status":500,"reason":"No active > shards"},{"index":"test","shard":3,"status":500,"reason":"No active > shards"},{"index":"test","shard":4,"status":500,"reason":"No active > shards"},{"index":"test","shard":5,"status":500,"reason":"No active > shards"},{"index":"test","shard":6,"status":500,"reason":"No active > shards"},{"index":"test","shard":7,"status":500,"reason":"No active > shards"},{"index":"test","shard":8,"status":500,"reason":"No active > shards"},{"index":"test","shard":9,"status":500,"reason":"No active > shards"},{"index":"kimchy","shard":2,"status":500,"reason":"No active > shards"},{"index":"blog","shard":0,"status":500,"reason":"No active > shards"},{"index":"blog","shard":1,"status":500,"reason":"No active > shards"},{"index":"blog","shard":2,"status":500,"reason":"No active > shards"},{"index":"blog","shard":3,"status":500,"reason":"No active > shards"},{"index":"blog","shard":4,"status":500,"reason":"No active > shards"},{"index":"mycouchshop","shard":0,"status":500,"reason":"No active > shards"},{"index":"mycouchshop","shard":1,"status":500,"reason":"No active > shards"},{"index":"mycouchshop","shard":2,"status":500,"reason":"No active > shards"},{"index":"mycouchshop","shard":3,"status":500,"reason":"No active > shards"},{"index":"mycouchshop","shard":4,"status":500,"reason":"No active > shards"},{"index":"another\_user","shard":0,"status":500,"reason":"No active > shards"},{"index":"toto1","shard":0,"status":500,"reason":"No active > shards"},{"index":"toto1","shard":1,"status":500,"reason":"No active > shards"},{"index":"toto1","shard":2,"status":500,"reason":"No active > shards"},{"index":"toto1","shard":3,"status":500,"reason":"No active > shards"},{"index":"toto1","shard":4,"status":500,"reason":"No active > shards"}]},"hits":{"total":8,"max\_score":1.0,"hits":[{"\_index":"\_river","\_type":"rs","\_id":"\_meta","\_score":1.0, > "\_source" : { > "type" : "couchdb", > "couchdb" : { > "host" : "localhost", > "port" : 5984, > "db" : "rs", > "filter" : null > }, > "index" : { > "index" : "rs", > "type" : "rs", > "bulk\_size" : "100", > "bulk\_timeout" : "10ms" > } > }},{"\_index":"\_river","\_type":"test","\_id":"\_meta","\_score":1.0, "\_source" > : { > "type" : "couchdb", > "couchdb" : { > "host" : "localhost", > "port" : 5984, > "db" : "test", > "filter" : null > }, > "index" : { > "index" : "test", > "type" : "test", > "bulk\_size" : "100", > "bulk\_timeout" : "10ms" > } > }},{"\_index":"\_river","\_type":"test","\_id":"\_seq","\_score":1.0, "\_source" > : > {"couchdb":{"last\_seq":"3"}}},{"\_index":"\_river","\_type":"rs","\_id":"\_seq","\_score":1.0, > "\_source" : > {"couchdb":{"last\_seq":"2"}}},{"\_index":"\_river","\_type":"rs","\_id":"\_status","\_score":1.0, > "\_source" : > {"ok":true,"node":{"id":"LtttB4KXSHGdj\_Y9ZkTxhg","name":"Archer","transport\_address":"inet[/ > 157.159.110.99:9300]"}}},{"\_index":"\_river","\_type":"test","\_id":"\_status","\_score":1.0, > "\_source" : > {"ok":true,"node":{"id":"LtttB4KXSHGdj\_Y9ZkTxhg","name":"Archer","transport\_address":"inet[/ > 157.159.110.99:9300]"}}},{"\_index":"kimchy","\_type":"tweet","\_id":"2","\_score":1.0, > "\_source" : > { > "user": "kimchy", > "postDate": "2009-11-15T14:12:12", > "message": "Another tweet, will it be indexed?" > }},{"\_index":"rs","\_type":"rs","\_id":"bcd20f6c77198921be8af0ea69000d91","\_score":1.0, > "\_source" : > {"\_rev":"1-f62208cb5761dd5c7d1c5954dfba0e7a","forename":"Gavin","\_id":"bcd20f6c77198921be8af0ea69000d91","surname":"Cooper","type":"person"}}]}} > > 2012/8/10 David Pilato [david@pilato.fr](mailto:david@pilato.fr) > > Are you sure you have indexed something ? > > What about if you query on all: > > curl -XGET [http://localhost:9200/\_search?query=\*&pretty=true](http://localhost:9200/_search?query=*&pretty=true) > > Did you create a CouchDB river? > > David > > Le 10 août 2012 à 10:19, rami sellami \< [sel.rami@gmail.com](mailto:sel.rami@gmail.com)\> a écrit : > > Dear all, > > My problem is that I do not get any hits as a result of a query. > My input is the imported json file (SampleOfBruno.json). I have only this > document in the couchdb database. > My query is : > > curl -XGET [http://localhost:9200/rs/rs/\_search?pretty=true](http://localhost:9200/rs/rs/_search?pretty=true) -d '{ > "query" : { > "query\_string" :{"query" : "\*"} > } > }' > > My output is : > > { > "took" : 94, > "timed\_out" : false, > "\_shards" : { > "total" : 5, > "successful" : 5, > "failed" : 0 > }, > "hits" : { > "total" : 0, > "max\_score" : null, > "hits" : > } > }. > > Could you help me please!! > > Best regards > Rami Sellami. > > -- > David Pilato > [http://www.scrutmydocs.org/](http://www.scrutmydocs.org/) > [http://dev.david.pilato.fr/](http://dev.david.pilato.fr/) > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs > > -- > Cordialement, > Rami Sellami > > -- > David Pilato > [http://www.scrutmydocs.org/](http://www.scrutmydocs.org/) > [http://dev.david.pilato.fr/](http://dev.david.pilato.fr/) > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs -- Cordialement, Rami Sellami ---
**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:** [August 10, 2012, 10:20am UTC](https://discuss.elastic.co/t/no-hit-in-the-output/8701/6 "2012-08-10T10:20:13Z")
What is the other file you are talking about? You have 2 docs in couchDB? What are theses docs? David Le 10 août 2012 à 11:38, rami sellami [sel.rami@gmail.com](mailto:sel.rami@gmail.com) a écrit : > This is the result of the POST query, I do not see the other file!! > { > "took" : 8, > "timed\_out" : false, > "\_shards" : { > "total" : 5, > "successful" : 5, > "failed" : 0 > }, > "hits" : { > "total" : 1, > "max\_score" : 1.0, > "hits" : [ { > "\_index" : "rs", > "\_type" : "rs", > "\_id" : "bcd20f6c77198921be8af0ea69000d91", > "\_score" : 1.0, "\_source" : > {"\_rev":"1-f62208cb5761dd5c7d1c5954dfba0e7a","forename":"Gavin","\_id":"bcd20f6c77198921be8af0ea69000d91","surname":"Cooper","type":"person"} > } ] > } > } > > 2012/8/10 David Pilato \<[david@pilato.fr](mailto:david@pilato.fr) [mailto:david@pilato.fr](mailto:david@pilato.fr) \> > > > > So CouchDB river is working fine as we can see for rs/rs lastseq=2. > > > Then, we can see your document in result: > > > { > > > "\_index":"rs", > > > "\_type":"rs", > > > "\_id":"bcd20f6c77198921be8af0ea69000d91", > > > "\_score":1.0, > > > "\_source":{ > > > "\_rev":"1-f62208cb5761dd5c7d1c5954dfba0e7a", > > > "forename":"Gavin", > > > "\_id":"bcd20f6c77198921be8af0ea69000d91", > > > "surname":"Cooper", > > > "type":"person" > > > } > > > } > > > > Stupid I am ! You have to POST your query... Don't use GET. > > > > curl -XPOST [http://localhost:9200/rs/rs/\_search?pretty=true](http://localhost:9200/rs/rs/_search?pretty=true) > > [http://localhost:9200/rs/rs/\_search?pretty=true](http://localhost:9200/rs/rs/_search?pretty=true) -d '{ > > "query" : { > > "query\_string" :{"query" : "\*"} > > } > > }' > > > > Le 10 août 2012 à 11:24, rami sellami \< [sel.rami@gmail.com](mailto:sel.rami@gmail.com) > > [mailto:sel.rami@gmail.com](mailto:sel.rami@gmail.com) \> a écrit : > > > > ``` > > > > > Yes I created a couchDB river index with: > > > > ``` > > > > > ``` > > > curl -XPUT 'localhost:9200/_river/rs/_meta' -d '{ > > > "type" : "couchdb", > > > "couchdb" : { > > > "host" : "localhost", > > > "port" : 5984, > > > "db" : "rs", > > > "filter" : null > > > }, > > > "index" : { > > > "index" : "rs", > > > "type" : "rs", > > > "bulk_size" : "100", > > > "bulk_timeout" : "10ms" > > > } > > > }' > > > > > > In addition, the index works, because I add the json file below and I > > > > > > ``` > > > > > > get it when I query on it: > > > { > > > "forename": "Gavin", > > > "surname": "Cooper", > > > "type": "person" > > > }. > > > > > > ``` > > > This is the result if I query on all: > > > > > > {"took":10,"timed_out":false,"_shards":{"total":57,"successful":10,"failed":47,"failures":[{"index":"db","shard":0,"status":500,"reason":"No > > > > > > ``` > > > > > > active shards"},{"index":"db","shard":1,"status":500,"reason":"No active > > > shards"},{"index":"db","shard":2,"status":500,"reason":"No active > > > shards"},{"index":"db","shard":3,"status":500,"reason":"No active > > > shards"},{"index":"db","shard":4,"status":500,"reason":"No active > > > shards"},{"index":"ckan-147.102.12.234","shard":0,"status":500,"reason":"No > > > active > > > shards"},{"index":"ckan-147.102.12.234","shard":1,"status":500,"reason":"No > > > active > > > shards"},{"index":"ckan-147.102.12.234","shard":2,"status":500,"reason":"No > > > active > > > shards"},{"index":"ckan-147.102.12.234","shard":3,"status":500,"reason":"No > > > active > > > shards"},{"index":"ckan-147.102.12.234","shard":4,"status":500,"reason":"No > > > active shards"},{"index":"twitter","shard":0,"status":500,"reason":"No > > > active shards"},{"index":"twitter","shard":1,"status":500,"reason":"No > > > active shards"},{"index":"twitter","shard":2,"status":500,"reason":"No > > > active shards"},{"index":"twitter","shard":3,"status":500,"reason":"No > > > active shards"},{"index":"twitter","shard":4,"status":500,"reason":"No > > > active shards"},{"index":"my\_db","shard":0,"status":500,"reason":"No > > > active shards"},{"index":"my\_db","shard":1,"status":500,"reason":"No > > > active shards"},{"index":"my\_db","shard":2,"status":500,"reason":"No > > > active shards"},{"index":"my\_db","shard":3,"status":500,"reason":"No > > > active shards"},{"index":"my\_db","shard":4,"status":500,"reason":"No > > > active shards"},{"index":"test","shard":0,"status":500,"reason":"No active > > > shards"},{"index":"test","shard":1,"status":500,"reason":"No active > > > shards"},{"index":"test","shard":2,"status":500,"reason":"No active > > > shards"},{"index":"test","shard":3,"status":500,"reason":"No active > > > shards"},{"index":"test","shard":4,"status":500,"reason":"No active > > > shards"},{"index":"test","shard":5,"status":500,"reason":"No active > > > shards"},{"index":"test","shard":6,"status":500,"reason":"No active > > > shards"},{"index":"test","shard":7,"status":500,"reason":"No active > > > shards"},{"index":"test","shard":8,"status":500,"reason":"No active > > > shards"},{"index":"test","shard":9,"status":500,"reason":"No active > > > shards"},{"index":"kimchy","shard":2,"status":500,"reason":"No active > > > shards"},{"index":"blog","shard":0,"status":500,"reason":"No active > > > shards"},{"index":"blog","shard":1,"status":500,"reason":"No active > > > shards"},{"index":"blog","shard":2,"status":500,"reason":"No active > > > shards"},{"index":"blog","shard":3,"status":500,"reason":"No active > > > shards"},{"index":"blog","shard":4,"status":500,"reason":"No active > > > shards"},{"index":"mycouchshop","shard":0,"status":500,"reason":"No active > > > shards"},{"index":"mycouchshop","shard":1,"status":500,"reason":"No active > > > shards"},{"index":"mycouchshop","shard":2,"status":500,"reason":"No active > > > shards"},{"index":"mycouchshop","shard":3,"status":500,"reason":"No active > > > shards"},{"index":"mycouchshop","shard":4,"status":500,"reason":"No active > > > shards"},{"index":"another\_user","shard":0,"status":500,"reason":"No > > > active shards"},{"index":"toto1","shard":0,"status":500,"reason":"No > > > active shards"},{"index":"toto1","shard":1,"status":500,"reason":"No > > > active shards"},{"index":"toto1","shard":2,"status":500,"reason":"No > > > active shards"},{"index":"toto1","shard":3,"status":500,"reason":"No > > > active shards"},{"index":"toto1","shard":4,"status":500,"reason":"No > > > active > > > shards"}]},"hits":{"total":8,"max\_score":1.0,"hits":[{"\_index":"\_river","\_type":"rs","\_id":"\_meta","\_score":1.0, > > > "\_source" : { > > > "type" : "couchdb", > > > "couchdb" : { > > > "host" : "localhost", > > > "port" : 5984, > > > "db" : "rs", > > > "filter" : null > > > }, > > > "index" : { > > > "index" : "rs", > > > "type" : "rs", > > > "bulk\_size" : "100", > > > "bulk\_timeout" : "10ms" > > > } > > > }},{"\_index":"\_river","\_type":"test","\_id":"\_meta","\_score":1.0, > > > "\_source" : { > > > "type" : "couchdb", > > > "couchdb" : { > > > "host" : "localhost", > > > "port" : 5984, > > > "db" : "test", > > > "filter" : null > > > }, > > > "index" : { > > > "index" : "test", > > > "type" : "test", > > > "bulk\_size" : "100", > > > "bulk\_timeout" : "10ms" > > > } > > > }},{"\_index":"\_river","\_type":"test","\_id":"\_seq","\_score":1.0, > > > "\_source" : > > > {"couchdb":{"last\_seq":"3"}}},{"\_index":"\_river","\_type":"rs","\_id":"\_seq","\_score":1.0, > > > "\_source" : > > > {"couchdb":{"last\_seq":"2"}}},{"\_index":"\_river","\_type":"rs","\_id":"\_status","\_score":1.0, > > > "\_source" : > > > {"ok":true,"node":{"id":"LtttB4KXSHGdj\_Y9ZkTxhg","name":"Archer","transport\_address":"inet[/ > > > 157.159.110.99:9300 [http://157.159.110.99:9300](http://157.159.110.99:9300) > > > ]"}}},{"\_index":"\_river","\_type":"test","\_id":"\_status","\_score":1.0, > > > "\_source" : > > > {"ok":true,"node":{"id":"LtttB4KXSHGdj\_Y9ZkTxhg","name":"Archer","transport\_address":"inet[/ > > > 157.159.110.99:9300 [http://157.159.110.99:9300](http://157.159.110.99:9300) > > > ]"}}},{"\_index":"kimchy","\_type":"tweet","\_id":"2","\_score":1.0, "\_source" > > > : > > > { > > > "user": "kimchy", > > > "postDate": "2009-11-15T14:12:12", > > > "message": "Another tweet, will it be indexed?" > > > > > > }},{"\_index":"rs","\_type":"rs","\_id":"bcd20f6c77198921be8af0ea69000d91","\_score":1.0, > > > "\_source" : > > > {"\_rev":"1-f62208cb5761dd5c7d1c5954dfba0e7a","forename":"Gavin","\_id":"bcd20f6c77198921be8af0ea69000d91","surname":"Cooper","type":"person"}}]}} > > > > > > ``` > > > 2012/8/10 David Pilato > > > > > > > > Are you sure you have indexed something ? > > > > > > ``` > > > > > > > ``` > > > > What about if you query on all: > > > > curl -XGET http://localhost:9200/_search?query=*&pretty=true > > > > > > > > ``` > > > > > > > > [http://localhost:9200/\_search?query=\*&pretty=true](http://localhost:9200/_search?query=*&pretty=true) > > > > > > > > ``` > > > > Did you create a CouchDB river? > > > > > > > > David > > > > > > > > Le 10 août 2012 à 10:19, rami sellami < sel.rami@gmail.com > > > > > > > > ``` > > > > > > > > [mailto:sel.rami@gmail.com](mailto:sel.rami@gmail.com) \> a écrit : > > > > > > > > ``` > > > > > > > > > Dear all, > > > > > > > > ``` > > > > > > > > > ``` > > > > > My problem is that I do not get any hits as a result of a > > > > > > > > > > ``` > > > > > > > > > > query. > > > > > My input is the imported json file (SampleOfBruno.json). I have > > > > > only this document in the couchdb database. > > > > > My query is : > > > > > > > > > > ``` > > > > > curl -XGET http://localhost:9200/rs/rs/_search?pretty=true > > > > > > > > > > ``` > > > > > > > > > > [http://localhost:9200/rs/rs/\_search?pretty=true](http://localhost:9200/rs/rs/_search?pretty=true) -d '{ > > > > > "query" : { > > > > > "query\_string" :{"query" : "\*"} > > > > > } > > > > > }' > > > > > > > > > > ``` > > > > > My output is : > > > > > > > > > > { > > > > > "took" : 94, > > > > > "timed_out" : false, > > > > > "_shards" : { > > > > > "total" : 5, > > > > > "successful" : 5, > > > > > "failed" : 0 > > > > > }, > > > > > "hits" : { > > > > > "total" : 0, > > > > > "max_score" : null, > > > > > "hits" : [] > > > > > } > > > > > }. > > > > > > > > > > Could you help me please!! > > > > > > > > > > Best regards > > > > > Rami Sellami. > > > > > > > > > > > > > > > > > > > > > > > > ``` > > > > > > > > ``` > > > > -- > > > > David Pilato > > > > http://www.scrutmydocs.org/ > > > > http://dev.david.pilato.fr/ > > > > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs > > > > > > > > > > > > > > > > > > > ``` > > > > > > ``` > > > -- > > > Cordialement, > > > Rami Sellami > > > > > > ``` > > > > > > > > > > > > -- > > David Pilato > > [http://www.scrutmydocs.org/](http://www.scrutmydocs.org/) [http://www.scrutmydocs.org/](http://www.scrutmydocs.org/) > > [http://dev.david.pilato.fr/](http://dev.david.pilato.fr/) [http://dev.david.pilato.fr/](http://dev.david.pilato.fr/) > > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs > > > > > > > -- > Cordialement, > Rami Sellami -- David Pilato [http://www.scrutmydocs.org/](http://www.scrutmydocs.org/) [http://dev.david.pilato.fr/](http://dev.david.pilato.fr/) Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs ---
**Author:** ![rami\_sellami](https://avatars.discourse-cdn.com/v4/letter/r/e495f1/32.png) [@rami\_sellami](https://discuss.elastic.co/u/rami_sellami)\ **Post date:** [August 10, 2012, 10:24am UTC](https://discuss.elastic.co/t/no-hit-in-the-output/8701/7 "2012-08-10T10:24:13Z")
Yes I have two files the first one is called "SampleOfBruno.json" and the second one is : { "forename": "Gavin", "surname": "Cooper", "type": "person" }. 2012/8/10 David Pilato [david@pilato.fr](mailto:david@pilato.fr) > \*\* > > What is the other file you are talking about? > > You have 2 docs in couchDB? > > What are theses docs? > > David > > Le 10 août 2012 à 11:38, rami sellami [sel.rami@gmail.com](mailto:sel.rami@gmail.com) a écrit : > > This is the result of the POST query, I do not see the other file!! > { > "took" : 8, > "timed\_out" : false, > "\_shards" : { > "total" : 5, > "successful" : 5, > "failed" : 0 > }, > "hits" : { > "total" : 1, > "max\_score" : 1.0, > "hits" : [ { > "\_index" : "rs", > "\_type" : "rs", > "\_id" : "bcd20f6c77198921be8af0ea69000d91", > "\_score" : 1.0, "\_source" : > {"\_rev":"1-f62208cb5761dd5c7d1c5954dfba0e7a","forename":"Gavin","\_id":"bcd20f6c77198921be8af0ea69000d91","surname":"Cooper","type":"person"} > > ``` > } ] > > ``` > > } > } > > 2012/8/10 David Pilato [david@pilato.fr](mailto:david@pilato.fr) > > So CouchDB river is working fine as we can see for rs/rs lastseq=2. > > Then, we can see your document in result: > { > "\_index":"rs", > "\_type":"rs", > "\_id":"bcd20f6c77198921be8af0ea69000d91", > "\_score":1.0, > "\_source":{ > "\_rev":"1-f62208cb5761dd5c7d1c5954dfba0e7a", > "forename":"Gavin", > "\_id":"bcd20f6c77198921be8af0ea69000d91", > "surname":"Cooper", > "type":"person" > } > } > > Stupid I am ! You have to POST your query... Don't use GET. > > curl -XPOST [http://localhost:9200/rs/rs/\_search?pretty=true](http://localhost:9200/rs/rs/_search?pretty=true) -d '{ > "query" : { > "query\_string" :{"query" : "\*"} > } > }' > > Le 10 août 2012 à 11:24, rami sellami \< [sel.rami@gmail.com](mailto:sel.rami@gmail.com)\> a écrit : > > Yes I created a couchDB river index with: > > curl -XPUT 'localhost:9200/\_river/rs/\_meta' -d '{ > "type" : "couchdb", > "couchdb" : { > "host" : "localhost", > "port" : 5984, > "db" : "rs", > "filter" : null > }, > "index" : { > "index" : "rs", > "type" : "rs", > "bulk\_size" : "100", > "bulk\_timeout" : "10ms" > } > }' > > In addition, the index works, because I add the json file below and I get > it when I query on it: > { > "forename": "Gavin", > "surname": "Cooper", > "type": "person" > }. > > This is the result if I query on all: > {"took":10,"timed\_out":false,"\_shards":{"total":57,"successful":10,"failed":47,"failures":[{"index":"db","shard":0,"status":500,"reason":"No > active shards"},{"index":"db","shard":1,"status":500,"reason":"No active > shards"},{"index":"db","shard":2,"status":500,"reason":"No active > shards"},{"index":"db","shard":3,"status":500,"reason":"No active > shards"},{"index":"db","shard":4,"status":500,"reason":"No active > shards"},{"index":"ckan-147.102.12.234","shard":0,"status":500,"reason":"No > active > shards"},{"index":"ckan-147.102.12.234","shard":1,"status":500,"reason":"No > active > shards"},{"index":"ckan-147.102.12.234","shard":2,"status":500,"reason":"No > active > shards"},{"index":"ckan-147.102.12.234","shard":3,"status":500,"reason":"No > active > shards"},{"index":"ckan-147.102.12.234","shard":4,"status":500,"reason":"No > active shards"},{"index":"twitter","shard":0,"status":500,"reason":"No > active shards"},{"index":"twitter","shard":1,"status":500,"reason":"No > active shards"},{"index":"twitter","shard":2,"status":500,"reason":"No > active shards"},{"index":"twitter","shard":3,"status":500,"reason":"No > active shards"},{"index":"twitter","shard":4,"status":500,"reason":"No > active shards"},{"index":"my\_db","shard":0,"status":500,"reason":"No active > shards"},{"index":"my\_db","shard":1,"status":500,"reason":"No active > shards"},{"index":"my\_db","shard":2,"status":500,"reason":"No active > shards"},{"index":"my\_db","shard":3,"status":500,"reason":"No active > shards"},{"index":"my\_db","shard":4,"status":500,"reason":"No active > shards"},{"index":"test","shard":0,"status":500,"reason":"No active > shards"},{"index":"test","shard":1,"status":500,"reason":"No active > shards"},{"index":"test","shard":2,"status":500,"reason":"No active > shards"},{"index":"test","shard":3,"status":500,"reason":"No active > shards"},{"index":"test","shard":4,"status":500,"reason":"No active > shards"},{"index":"test","shard":5,"status":500,"reason":"No active > shards"},{"index":"test","shard":6,"status":500,"reason":"No active > shards"},{"index":"test","shard":7,"status":500,"reason":"No active > shards"},{"index":"test","shard":8,"status":500,"reason":"No active > shards"},{"index":"test","shard":9,"status":500,"reason":"No active > shards"},{"index":"kimchy","shard":2,"status":500,"reason":"No active > shards"},{"index":"blog","shard":0,"status":500,"reason":"No active > shards"},{"index":"blog","shard":1,"status":500,"reason":"No active > shards"},{"index":"blog","shard":2,"status":500,"reason":"No active > shards"},{"index":"blog","shard":3,"status":500,"reason":"No active > shards"},{"index":"blog","shard":4,"status":500,"reason":"No active > shards"},{"index":"mycouchshop","shard":0,"status":500,"reason":"No active > shards"},{"index":"mycouchshop","shard":1,"status":500,"reason":"No active > shards"},{"index":"mycouchshop","shard":2,"status":500,"reason":"No active > shards"},{"index":"mycouchshop","shard":3,"status":500,"reason":"No active > shards"},{"index":"mycouchshop","shard":4,"status":500,"reason":"No active > shards"},{"index":"another\_user","shard":0,"status":500,"reason":"No active > shards"},{"index":"toto1","shard":0,"status":500,"reason":"No active > shards"},{"index":"toto1","shard":1,"status":500,"reason":"No active > shards"},{"index":"toto1","shard":2,"status":500,"reason":"No active > shards"},{"index":"toto1","shard":3,"status":500,"reason":"No active > shards"},{"index":"toto1","shard":4,"status":500,"reason":"No active > shards"}]},"hits":{"total":8,"max\_score":1.0,"hits":[{"\_index":"\_river","\_type":"rs","\_id":"\_meta","\_score":1.0, > "\_source" : { > "type" : "couchdb", > "couchdb" : { > "host" : "localhost", > "port" : 5984, > "db" : "rs", > "filter" : null > }, > "index" : { > "index" : "rs", > "type" : "rs", > "bulk\_size" : "100", > "bulk\_timeout" : "10ms" > } > }},{"\_index":"\_river","\_type":"test","\_id":"\_meta","\_score":1.0, "\_source" > : { > "type" : "couchdb", > "couchdb" : { > "host" : "localhost", > "port" : 5984, > "db" : "test", > "filter" : null > }, > "index" : { > "index" : "test", > "type" : "test", > "bulk\_size" : "100", > "bulk\_timeout" : "10ms" > } > }},{"\_index":"\_river","\_type":"test","\_id":"\_seq","\_score":1.0, "\_source" > : > {"couchdb":{"last\_seq":"3"}}},{"\_index":"\_river","\_type":"rs","\_id":"\_seq","\_score":1.0, > "\_source" : > {"couchdb":{"last\_seq":"2"}}},{"\_index":"\_river","\_type":"rs","\_id":"\_status","\_score":1.0, > "\_source" : > {"ok":true,"node":{"id":"LtttB4KXSHGdj\_Y9ZkTxhg","name":"Archer","transport\_address":"inet[/ > 157.159.110.99:9300]"}}},{"\_index":"\_river","\_type":"test","\_id":"\_status","\_score":1.0, > "\_source" : > {"ok":true,"node":{"id":"LtttB4KXSHGdj\_Y9ZkTxhg","name":"Archer","transport\_address":"inet[/ > 157.159.110.99:9300]"}}},{"\_index":"kimchy","\_type":"tweet","\_id":"2","\_score":1.0, > "\_source" : > { > "user": "kimchy", > "postDate": "2009-11-15T14:12:12", > "message": "Another tweet, will it be indexed?" > }},{"\_index":"rs","\_type":"rs","\_id":"bcd20f6c77198921be8af0ea69000d91","\_score":1.0, > "\_source" : > {"\_rev":"1-f62208cb5761dd5c7d1c5954dfba0e7a","forename":"Gavin","\_id":"bcd20f6c77198921be8af0ea69000d91","surname":"Cooper","type":"person"}}]}} > > 2012/8/10 David Pilato [david@pilato.fr](mailto:david@pilato.fr) > > Are you sure you have indexed something ? > > What about if you query on all: > > curl -XGET [http://localhost:9200/\_search?query=\*&pretty=true](http://localhost:9200/_search?query=*&pretty=true) > > Did you create a CouchDB river? > > David > > Le 10 août 2012 à 10:19, rami sellami \< [sel.rami@gmail.com](mailto:sel.rami@gmail.com)\> a écrit : > > Dear all, > > My problem is that I do not get any hits as a result of a query. > My input is the imported json file (SampleOfBruno.json). I have only this > document in the couchdb database. > My query is : > > curl -XGET [http://localhost:9200/rs/rs/\_search?pretty=true](http://localhost:9200/rs/rs/_search?pretty=true) -d '{ > "query" : { > "query\_string" :{"query" : "\*"} > } > }' > > My output is : > > { > "took" : 94, > "timed\_out" : false, > "\_shards" : { > "total" : 5, > "successful" : 5, > "failed" : 0 > }, > "hits" : { > "total" : 0, > "max\_score" : null, > "hits" : > } > }. > > Could you help me please!! > > Best regards > Rami Sellami. > > -- > David Pilato > [http://www.scrutmydocs.org/](http://www.scrutmydocs.org/) > [http://dev.david.pilato.fr/](http://dev.david.pilato.fr/) > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs > > -- > Cordialement, > Rami Sellami > > -- > David Pilato > [http://www.scrutmydocs.org/](http://www.scrutmydocs.org/) > [http://dev.david.pilato.fr/](http://dev.david.pilato.fr/) > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs > > -- > Cordialement, > Rami Sellami > > -- > David Pilato > [http://www.scrutmydocs.org/](http://www.scrutmydocs.org/) > [http://dev.david.pilato.fr/](http://dev.david.pilato.fr/) > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs -- Cordialement, Rami Sellami ---
**Author:** ![rami\_sellami](https://avatars.discourse-cdn.com/v4/letter/r/e495f1/32.png) [@rami\_sellami](https://discuss.elastic.co/u/rami_sellami)\ **Post date:** [August 10, 2012, 10:49am UTC](https://discuss.elastic.co/t/no-hit-in-the-output/8701/8 "2012-08-10T10:49:46Z")
It's fine now :), I deleted the file and I re-imported to the couchdb database. perhaps there was a problem in the first import. Thanks David for your cooperation 🙂 R.S. 2012/8/10 rami sellami [sel.rami@gmail.com](mailto:sel.rami@gmail.com) > Yes I have two files the first one is called "SampleOfBruno.json" and the > second one is : > > { > "forename": "Gavin", > "surname": "Cooper", > "type": "person" > }. > > 2012/8/10 David Pilato [david@pilato.fr](mailto:david@pilato.fr) > > > \*\* > > > > What is the other file you are talking about? > > > > You have 2 docs in couchDB? > > > > What are theses docs? > > > > David > > > > Le 10 août 2012 à 11:38, rami sellami [sel.rami@gmail.com](mailto:sel.rami@gmail.com) a écrit : > > > > This is the result of the POST query, I do not see the other file!! > > { > > "took" : 8, > > "timed\_out" : false, > > "\_shards" : { > > "total" : 5, > > "successful" : 5, > > "failed" : 0 > > }, > > "hits" : { > > "total" : 1, > > "max\_score" : 1.0, > > "hits" : [ { > > "\_index" : "rs", > > "\_type" : "rs", > > "\_id" : "bcd20f6c77198921be8af0ea69000d91", > > "\_score" : 1.0, "\_source" : > > {"\_rev":"1-f62208cb5761dd5c7d1c5954dfba0e7a","forename":"Gavin","\_id":"bcd20f6c77198921be8af0ea69000d91","surname":"Cooper","type":"person"} > > > > ``` > > } ] > > > > ``` > > > > } > > } > > > > 2012/8/10 David Pilato [david@pilato.fr](mailto:david@pilato.fr) > > > > So CouchDB river is working fine as we can see for rs/rs lastseq=2. > > > > Then, we can see your document in result: > > { > > "\_index":"rs", > > "\_type":"rs", > > "\_id":"bcd20f6c77198921be8af0ea69000d91", > > "\_score":1.0, > > "\_source":{ > > "\_rev":"1-f62208cb5761dd5c7d1c5954dfba0e7a", > > "forename":"Gavin", > > "\_id":"bcd20f6c77198921be8af0ea69000d91", > > "surname":"Cooper", > > "type":"person" > > } > > } > > > > Stupid I am ! You have to POST your query... Don't use GET. > > > > curl -XPOST [http://localhost:9200/rs/rs/\_search?pretty=true](http://localhost:9200/rs/rs/_search?pretty=true) -d '{ > > "query" : { > > "query\_string" :{"query" : "\*"} > > } > > }' > > > > Le 10 août 2012 à 11:24, rami sellami \< [sel.rami@gmail.com](mailto:sel.rami@gmail.com)\> a écrit : > > > > Yes I created a couchDB river index with: > > > > curl -XPUT 'localhost:9200/\_river/rs/\_meta' -d '{ > > "type" : "couchdb", > > "couchdb" : { > > "host" : "localhost", > > "port" : 5984, > > "db" : "rs", > > "filter" : null > > }, > > "index" : { > > "index" : "rs", > > "type" : "rs", > > "bulk\_size" : "100", > > "bulk\_timeout" : "10ms" > > } > > }' > > > > In addition, the index works, because I add the json file below and I get > > it when I query on it: > > { > > "forename": "Gavin", > > "surname": "Cooper", > > "type": "person" > > }. > > > > This is the result if I query on all: > > {"took":10,"timed\_out":false,"\_shards":{"total":57,"successful":10,"failed":47,"failures":[{"index":"db","shard":0,"status":500,"reason":"No > > active shards"},{"index":"db","shard":1,"status":500,"reason":"No active > > shards"},{"index":"db","shard":2,"status":500,"reason":"No active > > shards"},{"index":"db","shard":3,"status":500,"reason":"No active > > shards"},{"index":"db","shard":4,"status":500,"reason":"No active > > shards"},{"index":"ckan-147.102.12.234","shard":0,"status":500,"reason":"No > > active > > shards"},{"index":"ckan-147.102.12.234","shard":1,"status":500,"reason":"No > > active > > shards"},{"index":"ckan-147.102.12.234","shard":2,"status":500,"reason":"No > > active > > shards"},{"index":"ckan-147.102.12.234","shard":3,"status":500,"reason":"No > > active > > shards"},{"index":"ckan-147.102.12.234","shard":4,"status":500,"reason":"No > > active shards"},{"index":"twitter","shard":0,"status":500,"reason":"No > > active shards"},{"index":"twitter","shard":1,"status":500,"reason":"No > > active shards"},{"index":"twitter","shard":2,"status":500,"reason":"No > > active shards"},{"index":"twitter","shard":3,"status":500,"reason":"No > > active shards"},{"index":"twitter","shard":4,"status":500,"reason":"No > > active shards"},{"index":"my\_db","shard":0,"status":500,"reason":"No active > > shards"},{"index":"my\_db","shard":1,"status":500,"reason":"No active > > shards"},{"index":"my\_db","shard":2,"status":500,"reason":"No active > > shards"},{"index":"my\_db","shard":3,"status":500,"reason":"No active > > shards"},{"index":"my\_db","shard":4,"status":500,"reason":"No active > > shards"},{"index":"test","shard":0,"status":500,"reason":"No active > > shards"},{"index":"test","shard":1,"status":500,"reason":"No active > > shards"},{"index":"test","shard":2,"status":500,"reason":"No active > > shards"},{"index":"test","shard":3,"status":500,"reason":"No active > > shards"},{"index":"test","shard":4,"status":500,"reason":"No active > > shards"},{"index":"test","shard":5,"status":500,"reason":"No active > > shards"},{"index":"test","shard":6,"status":500,"reason":"No active > > shards"},{"index":"test","shard":7,"status":500,"reason":"No active > > shards"},{"index":"test","shard":8,"status":500,"reason":"No active > > shards"},{"index":"test","shard":9,"status":500,"reason":"No active > > shards"},{"index":"kimchy","shard":2,"status":500,"reason":"No active > > shards"},{"index":"blog","shard":0,"status":500,"reason":"No active > > shards"},{"index":"blog","shard":1,"status":500,"reason":"No active > > shards"},{"index":"blog","shard":2,"status":500,"reason":"No active > > shards"},{"index":"blog","shard":3,"status":500,"reason":"No active > > shards"},{"index":"blog","shard":4,"status":500,"reason":"No active > > shards"},{"index":"mycouchshop","shard":0,"status":500,"reason":"No active > > shards"},{"index":"mycouchshop","shard":1,"status":500,"reason":"No active > > shards"},{"index":"mycouchshop","shard":2,"status":500,"reason":"No active > > shards"},{"index":"mycouchshop","shard":3,"status":500,"reason":"No active > > shards"},{"index":"mycouchshop","shard":4,"status":500,"reason":"No active > > shards"},{"index":"another\_user","shard":0,"status":500,"reason":"No active > > shards"},{"index":"toto1","shard":0,"status":500,"reason":"No active > > shards"},{"index":"toto1","shard":1,"status":500,"reason":"No active > > shards"},{"index":"toto1","shard":2,"status":500,"reason":"No active > > shards"},{"index":"toto1","shard":3,"status":500,"reason":"No active > > shards"},{"index":"toto1","shard":4,"status":500,"reason":"No active > > shards"}]},"hits":{"total":8,"max\_score":1.0,"hits":[{"\_index":"\_river","\_type":"rs","\_id":"\_meta","\_score":1.0, > > "\_source" : { > > "type" : "couchdb", > > "couchdb" : { > > "host" : "localhost", > > "port" : 5984, > > "db" : "rs", > > "filter" : null > > }, > > "index" : { > > "index" : "rs", > > "type" : "rs", > > "bulk\_size" : "100", > > "bulk\_timeout" : "10ms" > > } > > }},{"\_index":"\_river","\_type":"test","\_id":"\_meta","\_score":1.0, > > "\_source" : { > > "type" : "couchdb", > > "couchdb" : { > > "host" : "localhost", > > "port" : 5984, > > "db" : "test", > > "filter" : null > > }, > > "index" : { > > "index" : "test", > > "type" : "test", > > "bulk\_size" : "100", > > "bulk\_timeout" : "10ms" > > } > > }},{"\_index":"\_river","\_type":"test","\_id":"\_seq","\_score":1.0, > > "\_source" : > > {"couchdb":{"last\_seq":"3"}}},{"\_index":"\_river","\_type":"rs","\_id":"\_seq","\_score":1.0, > > "\_source" : > > {"couchdb":{"last\_seq":"2"}}},{"\_index":"\_river","\_type":"rs","\_id":"\_status","\_score":1.0, > > "\_source" : > > {"ok":true,"node":{"id":"LtttB4KXSHGdj\_Y9ZkTxhg","name":"Archer","transport\_address":"inet[/ > > 157.159.110.99:9300]"}}},{"\_index":"\_river","\_type":"test","\_id":"\_status","\_score":1.0, > > "\_source" : > > {"ok":true,"node":{"id":"LtttB4KXSHGdj\_Y9ZkTxhg","name":"Archer","transport\_address":"inet[/ > > 157.159.110.99:9300]"}}},{"\_index":"kimchy","\_type":"tweet","\_id":"2","\_score":1.0, > > "\_source" : > > { > > "user": "kimchy", > > "postDate": "2009-11-15T14:12:12", > > "message": "Another tweet, will it be indexed?" > > }},{"\_index":"rs","\_type":"rs","\_id":"bcd20f6c77198921be8af0ea69000d91","\_score":1.0, > > "\_source" : > > {"\_rev":"1-f62208cb5761dd5c7d1c5954dfba0e7a","forename":"Gavin","\_id":"bcd20f6c77198921be8af0ea69000d91","surname":"Cooper","type":"person"}}]}} > > > > 2012/8/10 David Pilato [david@pilato.fr](mailto:david@pilato.fr) > > > > Are you sure you have indexed something ? > > > > What about if you query on all: > > > > curl -XGET [http://localhost:9200/\_search?query=\*&pretty=true](http://localhost:9200/_search?query=*&pretty=true) > > > > Did you create a CouchDB river? > > > > David > > > > Le 10 août 2012 à 10:19, rami sellami \< [sel.rami@gmail.com](mailto:sel.rami@gmail.com)\> a écrit : > > > > Dear all, > > > > My problem is that I do not get any hits as a result of a query. > > My input is the imported json file (SampleOfBruno.json). I have only this > > document in the couchdb database. > > My query is : > > > > curl -XGET [http://localhost:9200/rs/rs/\_search?pretty=true](http://localhost:9200/rs/rs/_search?pretty=true) -d '{ > > "query" : { > > "query\_string" :{"query" : "\*"} > > } > > }' > > > > My output is : > > > > { > > "took" : 94, > > "timed\_out" : false, > > "\_shards" : { > > "total" : 5, > > "successful" : 5, > > "failed" : 0 > > }, > > "hits" : { > > "total" : 0, > > "max\_score" : null, > > "hits" : > > } > > }. > > > > Could you help me please!! > > > > Best regards > > Rami Sellami. > > > > -- > > David Pilato > > [http://www.scrutmydocs.org/](http://www.scrutmydocs.org/) > > [http://dev.david.pilato.fr/](http://dev.david.pilato.fr/) > > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs > > > > -- > > Cordialement, > > Rami Sellami > > > > -- > > David Pilato > > [http://www.scrutmydocs.org/](http://www.scrutmydocs.org/) > > [http://dev.david.pilato.fr/](http://dev.david.pilato.fr/) > > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs > > > > -- > > Cordialement, > > Rami Sellami > > > > -- > > David Pilato > > [http://www.scrutmydocs.org/](http://www.scrutmydocs.org/) > > [http://dev.david.pilato.fr/](http://dev.david.pilato.fr/) > > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs > > -- > Cordialement, > Rami Sellami -- Cordialement, Rami Sellami ---
**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:16am UTC](https://discuss.elastic.co/t/no-hit-in-the-output/8701/9 "2017-07-06T03:16:50Z")