Hi, We are currently looking for a data store that can be used to store real-time event data and query out customer segments. For example, customers who bought a specific brand in the last month.
Druid sounds like a good option, but complex queries like customers who viewed a specific brand but did not purchase sounds a bit complex in druid.
Is druid a good candidate for this use case ? Or any other recommmedations
It all depends on how you are building your schema but it is doable. IMO depending on the cardinality of your customer base and/or the number of products. Also you might be able to use Sketches if approximation is okay for your use cases.