Need explaination about intervals in granularitySpec in indexing task

Hi all,
I have a batch indexing task in which I declared:

“parseSpec”: {
“format”: “tsv”,
“delimiter”: “|”,
“timestampSpec”: {
“column”: “ts”,
“format”: “YYYY-MM-dd.HHmm.ZZZ”
},
etc. etc.

and this is an example of records:

257|2016-01-13.0000.CET|105||0|1369|0|0|0|0|0|0|0
257|2016-01-13.0005.CET|101||-2002|164|1|1|0|0|0|0|0
257|2016-01-13.1740.CET|102||0|12|104|932|0|0|0|0|0

in the intervals specification for granularitySpec I wrote:

“granularitySpec”: {
“type”: “uniform”,
“segmentGranularity”: “DAY”,
“granularity”: {“type”: “period”, “period”: “PT5M”, “timeZone”: “Europe/Rome”},
“intervals”: [“2016-01-13T00:00:00/2016-01-13T23:59:59”]
}

In this way, the indexing task ends successfully, but records related to the first hour of day (CET) are not loaded. I presume because the intervals are assumed to be in UTC timezone.
Which is the right way to specify intervals in CET timezone?
Adding CET caused an Invalid format error message to be returned when submitting the indexing task.
Thanks,
Marco

Hello,

You should use ISO 8601 standard for specifying interval start and end times. So for a timezone which is +1 from UTC, interval can be specified as [“2016-01-13T00:00:00+01:00/2016-01-13T23:59:59+01:00”]

Date and Time Formats

image

Date and Time Formats
NOTE-datetime Date and Time Formats Submitted to W3C 15 September
1997 This version: http://www.w3.org/TR/NOTE-datetime-970915 Newest version: http:…

View on www.w3.org

Preview by Yahoo

Thank you Parag.
WIth your help I was able to go on …
I found another puzzling issue: https://groups.google.com/forum/#!topic/druid-user/2MoQqxMi180
Best,
Marco