Hi all,
I have a scenario like this:
- I have a e-commerce site, and I get thousands users on it. Each user sells thousands items. I decided to create a route for each user, and all the items that belong to this user will use the same route with the user.
So, I created something like this:
================================================================================
{ "index" : { "_index" : "ecommerce", "_type" : "users", "_routing":"sammy" } }
{ "user" : "sammy", "email":"sammy@abc.com", "type":"seller" }
{ "index" : { "_index" : "ecommerce", "_type" : "items", "_routing":"sammy" } }
{ "name" : "Pencil", "post_time":"06-12-2012", "message":"Selling pencils", "price":"$0.2" }
{ "index" : { "_index" : "ecommerce", "_type" : "items", "_routing":"sammy" } }
{ "name" : "Notebook", "post_time":"06-14-2012", "message":"Selling notebooks", "price":"$0.5" }
{ "index" : { "_index" : "ecommerce", "_type" : "items", "_routing":"sammy" } }
{ "name" : "Ruler", "post_time":"06-16-2012", "message":"Selling rulers", "price":"$0.2" }
{ "index" : { "_index" : "ecommerce", "_type" : "items", "_routing":"sammy" } }
{ "name" : "Eraser", "post_time":"06-20-2012", "message":"Selling erasers", "price":"$0.1" }
{ "index" : { "_index" : "ecommerce", "_type" : "items", "_routing":"sammy" } }
{ "name" : "Pen", "post_time":"05-14-2012", "message":"Selling pens", "price":"$0.3" }
{ "index" : { "_index" : "ecommerce", "_type" : "users", "_routing":"nigel" } }
{ "user" : "nigel", "email":"nigel@abc.com", "type":"seller" }
{ "index" : { "_index" : "ecommerce", "_type" : "items", "_routing":"nigel" } }
{ "name" : "Pencil", "post_time":"06-12-2012", "message":"Selling pencils", "price":"$0.2" }
{ "index" : { "_index" : "ecommerce", "_type" : "items", "_routing":"nigel" } }
{ "name" : "Notebook", "post_time":"06-14-2012", "message":"Selling notebooks", "price":"$0.5" }
{ "index" : { "_index" : "ecommerce", "_type" : "items", "_routing":"nigel" } }
{ "name" : "Ruler", "post_time":"06-16-2012", "message":"Selling rulers", "price":"$0.2" }
{ "index" : { "_index" : "ecommerce", "_type" : "items", "_routing":"nigel" } }
{ "name" : "Eraser", "post_time":"06-20-2012", "message":"Selling erasers", "price":"$0.1" }
{ "index" : { "_index" : "ecommerce", "_type" : "items", "_routing":"nigel" } }
{ "name" : "Pen", "post_time":"05-14-2012", "message":"Selling pens", "price":"$0.3" }
Now, I want to search all the items that belong to some user, let say "sammy". What should I do?
I've read this guide "http://www.elasticsearch.org/guide/reference/api/search/" and some other posts but still not find the solution. Could you guys please help me to query in this case? I appreciate all your helps.
Regards,
Sam Vo
