Hi, if I want to have a time column that's essentially another column (say epoch_minutes) but bucketed (say every 5 minutes), my understanding was that I can create a column with format

1:MINUTES:EPOCH

and granularity

5:MINUTES

, and that Pinot would handle it for me. I don't think that's the case though, i.e. I have to write an ingestion transform right?

you have to write transform function

ok thanks, but out of curiosity if that's the case couldn't I just make my format

5:MINUTES:EPOCH

? How does granularity differ?

5:MINUTES:EPOCH

would mean,

epoch_millis/(1000*60*5)

whereas,

1:MINUTES:EPOCH

with granularity

5:MINUTES

would mean,

epoch_millis/(1000*60)

, with value rounded to the nearest 5 minutes

okay