Using ES as an alternative for a data warehouse

Hiya

  • Group by + having + aggregates over large data sets: ES does have
    facets, can possibly can be used in case we want counts as aggregates,
    but probably not optimal.

If the aggregation capabilities are going to be very unnatural/heavy
for ES, we might as well need to go with some other alternative
(Mongo/Couch or maybe MySQL, don't know), and use ES only for search,
or just full-text search.

Facets are a natural part of ES and Lucene. Depending on your data and
your queries, they may use quite a lot of memory. Without concrete
examples, its difficult to say whether it is a good match or not, but
based upon what you've said so far, I would think that ES fits in very
well with your requirements

clint

Would appreciate any help on the above.

Regards,
--Parikshit N. Samant.