Groupby dayOfWeek

Hi,

Is there a dayOfWeek primitive groupby key in druid? If not, how can I achieve the same? By dayOfWeek I mean that if there are 7 records where each record has a timestamp belonging to one day of the week, I should be able to get the groupby response with 7 records where each one is for one day of the week. Please let me know if this is not clear. I want to achieve in druid what is available here in mongodb: https://docs.mongodb.com/v3.2/reference/operator/aggregation/dayOfWeek/

Thanks,

Arjun

Hey Arjun,

You can do this with a timeFormat extraction function: http://druid.io/docs/latest/querying/dimensionspecs.html

Gian

Thank you!