Re: Simple Array Example
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=emailutm_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.
Re: Simple Array Example
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=emailutm_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.
Re: Simple Array Example
Hello , In that case you should make product_id as _type rather than _id. Thanks Vineeth On Tue, Sep 9, 2014 at 6:38 PM, EzCocos jmdepi...@gmail.com wrote: 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 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. 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=emailutm_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 https://groups.google.com/d/msgid/elasticsearch/ddef0646-cd57-4027-9086-43f83ab40a0f%40googlegroups.com?utm_medium=emailutm_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/CAGdPd5neQNWKgbV%3DGFndEOwc5CoWs6CWf_kUJA2zZx580p3iGQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
Re: Simple Array Example
Sorry! but I don't understand. I tried to replace _id by _type and I get 4 documents. Would you be able to give me the related short mapping that would work? For instance for the data: product_id product_info_id '1' 1 '1' 2 '2' 3 '2' 4 I would like to create via a river (select * from product_table) and get 2 Elasticsearch documents. The one with id=1 containing an array of product_info_id containing (1,2) and the one with id=2 the product_info_id=(3,4). Many thanks in advance. Ez On Tuesday, 9 September 2014 14:44:32 UTC+1, vineeth mohan wrote: Hello , In that case you should make product_id as _type rather than _id. Thanks Vineeth On Tue, Sep 9, 2014 at 6:38 PM, EzCocos jmde...@gmail.com javascript: wrote: 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 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. 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=emailutm_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 elasticsearc...@googlegroups.com javascript:. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/ddef0646-cd57-4027-9086-43f83ab40a0f%40googlegroups.com https://groups.google.com/d/msgid/elasticsearch/ddef0646-cd57-4027-9086-43f83ab40a0f%40googlegroups.com?utm_medium=emailutm_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/669a41da-8719-477e-96c4-27e1492601a8%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.