Support Questions

Find answers, ask questions, and share your expertise

Hive-Druid Segment granularity MONTH of 31 days issue

avatar
Contributor

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)

1 ACCEPTED SOLUTION

avatar
Contributor

I changed the segment granularity to YEAR and worked fine

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

View solution in original post

1 REPLY 1

avatar
Contributor

I changed the segment granularity to YEAR and worked fine

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