groupby query: unespected result

Hi Guys!

we are getting unespected results using groupBy querys.

Hey Alberto,

The way granularity and limitSpecs work together is that results are first grouped in their granular buckets (so, one set of groupings for each day if you have granularity “day”), then they are sorted within their granular buckets, then the limit is applied to the global list of results starting from the first granular bucket.

There is an issue open about possibly offering different behaviors here: https://github.com/druid-io/druid/issues/1780

Hi Gian Merlino!!,

no fix to problem?

I read issue 1780 but i dont find one solutions for problem. our use of case is 1 and 2.

whats flag set in query?

very thanks!!

Nope, there’s no option yet, that issue is still open.