Support segment granularity and query granularity in Druid

[Jagadeesh M]

What are the supported segmentGranularity and queryGranularity options?

As per doc here - http://druid.io/docs/latest/querying/granularities.html only the following are supported - 

all, none, minute, fifteen_minute, thirty_minute, hour and day

Are these the only ones supported? Can we say 10 minutes? And whatz the reason behind not having more flexibility here ?

Thanks!

[Xavier Léauté]

If you scroll down the page a bit, you can define arbitrary granularities using any ISO 8601 Period

http://druid.io/docs/latest/querying/granularities.html#period-granularities

--
You received this message because you are subscribed to the Google Groups "Druid User" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-user+...@googlegroups.com.
To post to this group, send email to druid...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-user/c5b62344-ad59-45cb-8e51-8e71d23373bb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Jagadeesh M]

It is slightly confusing, but using the periods, can I do the following - 

I currently have -  

"granularitySpec" : {
            "type" : "uniform",
            "segmentGranularity" : "FIFTEEN_MINUTE",
            "queryGranularity" : "NONE"
},

And can I do this instead ? - 

 "granularitySpec" : {
            "type": "period",
            "segmentGranularity" : "P30M"
            "queryGranularity" : "P10M"
},

I think it doesn't work, these periods look like they only work for queries. Can FJ or Giam confirm?

Thank!

[Gian Merlino]

segmentGranularity is an enum and is restricted to the values defined here: https://github.com/metamx/java-util/blob/master/src/main/java/com/metamx/common/Granularity.java

queryGranularity can be anything, the link Xavier posted applies to those.

Gian

To view this discussion on the web visit https://groups.google.com/d/msgid/druid-user/762bb2bd-7887-4bd9-af68-6486c9b7d335%40googlegroups.com.

[Jagadeesh M]

Thanks Gian!

So for I can say -  "queryGranularity" : "P10M" ?? And should I specify the type as period or uniform ?

Thanks!

[Gian Merlino]

I guess you want queryGranularity PT10M (10 minutes) not P10M (10 months). But yes that would work. The type should still be "uniform". So something like this should work,

   "granularitySpec" : {

            "type" : "uniform",

            "segmentGranularity" : "HOUR",

            "queryGranularity" : "PT10M"

   },

Gian

To view this discussion on the web visit https://groups.google.com/d/msgid/druid-user/d9ad1ebf-2a59-4988-932d-de6c3f618362%40googlegroups.com.

[Jagadeesh M]

Thanks Gian!