How to specify granularity in sql

I cant find any documentation for how to specify granularity of results returned.

it seems all queries are run over the entire interval.

how do i say, return results with say, granularity of ‘hour’?

It seems there is no way to do this.
I have opened a bug/feature request for this here

This is weird though, since getting time series data is one of the prime use cases of druid.

The fact that druid sql doesnt support specifying granularity makes it unusable for majority of use cases

Hi Prashant,

I just wrote a comment on the issue you linked. I think if you remove the “limit” then the query will behave as you expect.