[druid-user] Default dimension used to do order by in Group by query

Apache Druid Q&A Google Groups
#1

Hi,

I have noticed that in the group by queries, the result is by default ordered by the “timestamp” in an ascending order, if the limitSpec is not given in the query.
does anyone know if this is the standard behaviour in case of group by query or the order can vary randomly?

Thanks,
Prachi

#2

This is standard behaviour. It will sort by _time first, then by the order of the dimensions in the dimensionspec.