Can I have more than one query granularity for an interval?

A community member asked this question with the following example:

for an index task for interval I1/I2 where it has data d1 , indexing it with HOUR Granularity and for same interval for data d2 indexing it with 15m granularity, is that possible?

While it is not possible to do this in the same datasource, a solution is to have two datasources of different granularity for the same underlying data. Read a more detailed discussion here.

2 Likes

Curious… do you know what they wanted to have different granularities? And also OOI was this with respect to queryGranularity (ie. time trunc with GROUP BY with INSERT / rollup) or segmentGranularity?