Groupby dayOfWeek


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:



Hey Arjun,

You can do this with a timeFormat extraction function:


Thank you!