I’m very new to Druid, but I’ve been reading a lot about it and after some tests I find it more than interesting.
Currently I’m trying to query a data set to see if I can accomplish what I need, but I can’t find how to do it.
I’m using the wikiticker database that is present on Druid’s Quickstart tutorial on their webpage (http://druid.io/docs/latest/tutorials/quickstart.html). For the example purpose, let’s use just two dimensions from that database: user and page.
What I need to do is to group users and generate a field like ‘edited_pages’ which should be a multiple values field (with all the edited URLs), and then filter by that new field.
For example: users that edited (page A and page B and not page C) or page D .
I could use the HAVING clause but since this query is generated dynamically in a user front-end, I think it’s more difficult to generate it programmatically.
Is this possible using Druid queries?
Thanks a lot !