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 <jmdepi...@gmail.com> 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 elasticsearch+unsubscr...@googlegroups.com. > 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/CAGdPd5nyKqodCq9HG4V3k47m6kiAYfQuNSsvteYKLF2n1CLhRA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.