Re: How to join 2 indexes at query time

2014-02-26 Thread Binh Ly
Unfortunately, ES is not like SQL in this respect. You'll need to denormalize somewhat because ES is more document-oriented. You'd probably need to either denormalize offer_id into categorytype, or category into offertype to get all the data you want returned in 1 query. -- You received this

Re: How to join 2 indexes at query time

2014-02-26 Thread Jayesh Bhoyar
Hi Binh, Thanks for the answer. Is there any case if I index this data into same index with different category GIST@ https://gist.github.com/jsbonline2006/9243973 I have 1 index: productindex/ Type: offertype productindex/ Type: categorytype Now as per my index data: My input will be

Re: How to join 2 indexes at query time

2014-02-26 Thread Matt Weber
How about using parent/child functionality? https://gist.github.com/mattweber/96f3515fc4453a5cb0db Thanks, Matt Weber On Wed, Feb 26, 2014 at 7:45 PM, Jayesh Bhoyar jsbonline2...@gmail.comwrote: Hi Binh, Thanks for the answer. Is there any case if I index this data into same index with