I’m new to Druid and I understand joins are not supported but is there a way to filter rows by matching a dimension value with a subquery result?
For example, I have historical user events containing different dimensions/metrics and I’d like to filter them according to current user profile values, it’s not possible to do denormalisation at ingestion time as the filter must relate to current users state.
In SQL it would have looked something like this:
SELECT username, SUM(deposit) AS deposits
WHERE username IN (SELECT username FROM user_profile WHERE frozen = 1)
GROUP BY username