Sorting in Select Query

Hi everyone,
Druid’s select query( doesn’t support sorting by any column. I can use groupBy query for applying sorting but in this case I’ll get only distinct results(since I’m grouping by the dimensions which I want to see in response).

Is there any way of getting all(not distinct) records sorted by any column?

Not currently, although you could do a groupBy and include a “count” aggregator, and then on the client side, if you see a count of 3 then treat that as 3 separate rows. It’s a little goofy but it should get you the same effect.