It seems like product-offer relation is what usually represents like
product-SKU or product-UPC, model-item, eg
http://blog.mikemccandless.com/2012/01/searching-relational-content-with.html
for me that denormalized children can be indexed by the following block:
{"product_id":1,
"brand":"Converse",
"children":[
{offer_id:1, size:8, color: red},
{offer_id:2, size:9, color: blue},
{offer_id:3, size:3, color: red},
...
]
}
two notes: it's not an exact syntax, just a model; there is no open source
facet component for block indexing. AFAIK even ElasticSearch count them
wrong.
On Tue, Feb 5, 2013 at 12:17 PM, Mickael Magniez
<mickaelmagn...@gmail.com>wrote:
> I don't see how join would help me
>
> I don't really have parent/child relationship, the only common field is
> product_id
>
> For example, for different sheos of same model, img and title is different
> for each model :
> [
> {"product_id":1, "offer_id":1,"title":"Converse all star - red - 8",
> "attribute_size":"8", "attribute_color":"red", "price":49},
> {"product_id":1, "offer_id":2,"title":"Converse all star - red - 9",
> "attribute_size":"9", "attribute_color":"red", "price":49},
> {"product_id":1, "offer_id":3,"title":"Converse all star - blue - 8",
> "attribute_size":"8", "attribute_color":"blue", "price":49},
> {"product_id":1, "offer_id":4,"title":"Converse all star - blue - 9",
> "attribute_size":"9", "attribute_color":"blue", "price":49}
> ]
>
> How can i index/query for using join in order to have only one shoe per
> model (the best price for example)?
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Field-collapsing-bad-performances-schema-redesign-tp4038359p4038500.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
--
Sincerely yours
Mikhail Khludnev
Principal Engineer,
Grid Dynamics
<http://www.griddynamics.com>
<mkhlud...@griddynamics.com>
