I am planning to use druid, not sure whether these use cases fit.
I have 3 primary use cases:
- Give me emails of all the users who satisfy a predicate such as sum of visits > 100.
- Give me details of a specific user who has email=“some email”. (will return 1 row for that user)
- How many visitors were there this month? (sum of visitors)
My data is both historical & real-time with new clickstream events coming in through streaming constantly.
Although use case #1 and #3 look like something druid can handle easily, I am skeptical about #2 since it is a row level get. If druid is indeed a good fit for #2 as well, which query should I use (search query) ?