Many thanks Vineeth for your help. product_id is indeed unique. If I remove _id I get 4 documents rather than 2 documents containing each an array of related product_info_id.
I guess I want _id to be the key under which same product_id got aggregated. In other word if I remove _id, how Elasticsearch will know under which Key aggregate the array items (product_info_id). I suppose this is a basic issue but I just can't make it work... Many thanks in advance for your help. Ez On Tuesday, 9 September 2014 13:01:46 UTC+1, vineeth mohan wrote: > > Hello , > > Is product_id unique , seems to me its not. > In that case why have you made it as _id. > _id should be unique and in face of dedupe , it would be over written. > So remove defenition of _id should solve the issue. > > Thanks > Vineeth > > On Tue, Sep 9, 2014 at 4:09 PM, EzCocos <jmde...@gmail.com <javascript:>> > wrote: > >> Dear All, >> I am trying to upload via a river to Elasticsearch some MySQL data which >> look like this: >> product_id product_info_id >> '1' 1 >> '1' 2 >> '2' 3 >> '2' 4 >> >> I am looking to have in Elasticsearch for this example 2 documents with >> _id '1' and '2' containing each an array of product_info_id. >> >> I have been struggling with this for days, I get either 4 documents or 2 >> documents stored and 2 deleted. The mapping I used so far is this: >> { >> "product_merchant" : { >> "_source" : { "enabled" : false }, >> "_id" : { "path" : "product_id" }, >> "properties" : { >> "product_infos" : { >> "properties" : { >> "product_info_id" : { "type" : "integer", "store" : "yes" } >> } >> } >> } >> } >> } >> >> Could anyone help me to correct my mapping and/or provide some array >> examples? >> >> Many thanks in advance, >> jm >> >> -- >> You received this message because you are subscribed to the Google Groups >> "elasticsearch" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to elasticsearc...@googlegroups.com <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/elasticsearch/05aa08d0-8a3e-440e-8131-cb37c70d10df%40googlegroups.com >> >> <https://groups.google.com/d/msgid/elasticsearch/05aa08d0-8a3e-440e-8131-cb37c70d10df%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/ddef0646-cd57-4027-9086-43f83ab40a0f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.