Hey Guys, I am seeking advice on design a system that maintains a historical view of a user's activities in past one year. Each user can have different activities: email_open, email_click, item_view, add_to_cart, purchase etc. The query I would like to do is, for example,
Find all customers who browse item A in the past 6 month, and also clicked an email. and I would like the query to be done in reasonable time frame. (for example, within 30 minutes to retrieve 10million such users) Is ES a good candidate for such problem? I am thinking creating an index for each user, but that would have too many indexes(millions). I also tried to index each activity(userid, activity_type, item_id, timestamp etc) as a individual document to ES, but it involves join operations which turns out not so efficient(I am using parent-child). Has any of you have experience in designing similar system? As I think this is a rather common problem that need to be solved..(Of cause we can do it in map reduce) Any suggestion is appreciated. Thanks in advance. Chen -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/ebcb521f-4115-489c-a759-e1459c250eda%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
