Re: [druid-user] druid query about event duration

Do you mean you want to save the data in druid at a 5-second granularity? That could be done in the ingestionSpec. It’s unusual to store every event, and even every 5 seconds is a pretty small interval for rollup. But, if you’ve stored every event in druid, and are asking about queries, in native queries, you’d use “query granularity”, in druid SQL, some combination of time format functions (don’t have it off-hand - something with TIME_FORMAT and a GROUP BY, I’d think.)