Daylight savings time issue when querying data sliced by day

Hi everybody,

We have a problematic use-case which we try to figure out. Turns out Brazil moved its clock on October 15th from 00:00 to 1:00. In our system we query a date range of either a week or month, sliced by the day. So the query requests the data slices from 00:00 to 23:59. But since it’s an illegal hour in Brazil this week, our queries fail.

What would be the best way to mitigate this issue?

Here’s the error we get from our Druid HTTP request:

{“error”:“Unknown exception”,“errorMessage”:“Value 0 for hourOfDay is not supported: Illegal instant due to time zone offset transition (daylight savings time ‘gap’): 2017-10-15T00:00:00.000 (America/Sao_Paulo)”,“errorClass”:“org.joda.time.IllegalFieldValueException”,“host”:“”}