OrderBy query is not working

Hi Guys,

I am using Druid-0.7.0

OrderBy Query is not working but on previous version it was working.


“queryType”: “groupBy”,

“dataSource”: “test_analytics”,

“granularity”: “day”,

“dimension”: [



“aggregations”: [


“type”: “longSum”,

“name”: “total_numz_count”,

“fieldName”: “numz”



“orderBy”: {

“type”: “default”,

“columns”: [


“dimension”: “total_numz_count”,

“direction”: “DESCENDING”



“limit”: 10


“intervals”: [




Some time I want to query for multiple groupBy with Limit that’s why I am not using topN Query type.



Hi Jitesh,
I wonder if this is related to the discussion in PR


Hi Jitesh, is this reproducible via a unit test?