No hit in the output


(rami sellami) #1

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 -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) #2

Are you sure you have indexed something ?
What about if you query on all:
curl -XGET 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 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 -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


(rami sellami) #3

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

**

Are you sure you have indexed something ?

What about if you query on all:

curl -XGET 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 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 -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) #4

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 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
]"}}},{"_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
]"}}},{"_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://dev.david.pilato.fr/
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs


(rami sellami) #5

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

**

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 -d '{
"query" : {
"query_string" :{"query" : "*"}
}
}'

Le 10 août 2012 à 11:24, rami sellami 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

Are you sure you have indexed something ?

What about if you query on all:

curl -XGET 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> 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 -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://dev.david.pilato.fr/
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

--
Cordialement,
Rami Sellami


(David Pilato) #6

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 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 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
]"}}},{"_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://dev.david.pilato.fr/
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs


(rami sellami) #7

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

**

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 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

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 -d '{
"query" : {
"query_string" :{"query" : "*"}
}
}'

Le 10 août 2012 à 11:24, rami sellami < 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

Are you sure you have indexed something ?

What about if you query on all:

curl -XGET 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> 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 -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://dev.david.pilato.fr/
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

--
Cordialement,
Rami Sellami

--
David Pilato
http://www.scrutmydocs.org/
http://dev.david.pilato.fr/
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

--
Cordialement,
Rami Sellami


(rami sellami) #8

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 :slight_smile:

R.S.

2012/8/10 rami sellami 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

**

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 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

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 -d '{
"query" : {
"query_string" :{"query" : "*"}
}
}'

Le 10 août 2012 à 11:24, rami sellami < 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

Are you sure you have indexed something ?

What about if you query on all:

curl -XGET 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> 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 -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://dev.david.pilato.fr/
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

--
Cordialement,
Rami Sellami

--
David Pilato
http://www.scrutmydocs.org/
http://dev.david.pilato.fr/
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

--
Cordialement,
Rami Sellami

--
Cordialement,
Rami Sellami


(system) #9