Merge 2 types based on common field

Hi,

I have an index named 'product' it has two types named 'type1' and 'type2'

For example:
/{
product_id: "1111",
price: "23.56",
stock: "100"
}/

/{
product_id: "1111",
category: "iPhone case",
manufacturer: "Belkin"
}/

I want them to join based on 'product_id' and index them in either new index
or new type in same 'product' index, so eventually it should look like this.

/{
product_id: "1111",
price: "23.56",
stock: "100"
category: "iPhone case",
manufacturer: "Belkin"
}/

FYI,

  • I have millions of records similar to above, so finally I will be doing
    the similar thing for all.
  • I am using ELK stack.
  • My end goal is to display the combined result of above 2 types in Kibana.

My question is similar to this
http://elasticsearch-users.115913.n3.nabble.com/Combining-fields-from-various-indexes-td4031116.html
but the person reported this question have 2 separate indexes while I have
one index but 2 separate types.

Thanks!

--
View this message in context: http://elasticsearch-users.115913.n3.nabble.com/Merge-2-types-based-on-common-field-tp4052873.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.

--
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/1395904150360-4052873.post%40n3.nabble.com.
For more options, visit https://groups.google.com/d/optout.