I have a bit of a funny use case that I’m struggling to find a solution to. Let me explain. My schema includes a secondary time dimension, with values that are millis since epoch.
I am trying to build a timeseries query that does the following:
Aggregate data with a granularity of daily buckets
Filter out any events that their secondary timestamp is not within the current bucket time range
In the doc, I saw the option to use the special __time dimension (http://druid.io/docs/latest/querying/dimensionspecs.html) to get the current bucket’s time according to the query granularity.
Am I missing something? Is there a solution to this use case or is it not supported at the moment?
Thanks in advance,