I would like to get the value of a particular dimension for the first (and last) event in a given granularity.
If I have dimensions = ['timestamp', 'dim1']
I would like to do a TimeSeries (or GroupBy) query to get the value of dim1 for the first and last rows (the rows with the min and max timestamp) in the grouping.
"intervals": [ "2012-01-01T00:00:00.000/2012-01-03T00:00:00.000" ]
I'm pretty new to Druid, so any help would be greatly appreciated!