I am interested in using the new aggregations support to implement something similar to an OLAP cube.
Let's say I have a big bunch of documents that represent orders. On those documents I want to calculate a bunch of metrics (using the "metric" aggregation) based on various fields. Stuff like "# of items". Then, I want to group this (using the "bucket" aggregation) based on brand, for instance. All of this is multi-tenant as well, so I need to filter out a whole lot of irrelevant data for every query. The amount of documents is quite high (hundreds of millions) so I was wondering if aggregations have any form of caching or precalculation, or if they have to traverse the entire index every time I do a query. This could also be quite prohibitive memory-wise. Has anyone been using aggregations in this manner? Roy -- 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/08487eb4-5a1e-4e30-a873-8d0623d4f355%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
