Hive-Druid Segment granularity MONTH of 31 days issue

hamid_zorgani — Fri, 16 Sep 2022 12:57:44 GMT

Hi,

When loading data into Hive using druid storage handler my table properties have "druid.segment.granularity" = "MONTH", It cause a exception error while loading data, seems like the segment of length one month process only 30 days and some month have 31 days.

Caused by: java.util.concurrent.ExecutionException: org.apache.hive.druid.io.druid.java.util.common.IAE: interval[1992-10-01T00:00:00.000+01:00/1992-10-30T23:00:00.000Z] does not encapsulate the full range of timestamps[1992-10-01T00:00:00.000+01:00, 1992-10-31T00:00:00.000Z] at org.apache.hive.druid.com.google.common.util.concurrent.AbstractFuture$Sync.getValue(AbstractFuture.java:299) at org.apache.hive.druid.com.google.common.util.concurrent.AbstractFuture$Sync.get(AbstractFuture.java:286) at org.apache.hive.druid.com.google.common.util.concurrent.AbstractFuture.get(AbstractFuture.java:116) at org.apache.hadoop.hive.druid.io.DruidRecordWriter.pushSegments(DruidRecordWriter.java:165)

Re: Hive-Druid Segment granularity MONTH of 31 days issue

hamid_zorgani — Mon, 12 Mar 2018 19:45:16 GMT

I changed the segment granularity to YEAR and worked fine

"druid.segment.granularity" = "YEAR",druid-benchmarking-results.png

question Re: Hive-Druid Segment granularity MONTH of 31 days issue in Archives of Support Questions (Read Only)

Hive-Druid Segment granularity MONTH of 31 days issue

Re: Hive-Druid Segment granularity MONTH of 31 days issue