Apache Pinot Docs
latest
Search…
⌃K

ToEpochBucket

This section contains reference documentation for the toEpochBucket functions.
Convert epoch milliseconds to epoch , and divided by bucket size (Bucket size is defined in ). The following time units are supported:
  • SECONDS
  • MINUTES
  • HOURS
  • DAYS

Signature

ToEpoch<TIME_UNIT>Bucket(timeInMillis, bucketSize)

Usage Examples

select ToEpochSecondsBucket(1613472303000, 1000) AS bucket
FROM ignoreMe
bucket
1613472
select ToEpochMinutesBucket(1613472303000, 10) AS bucket
FROM ignoreMe
bucket
2689120
select ToEpochHoursBucket(1613472303000, 5) AS bucket
FROM ignoreMe
bucket
89637
select ToEpochDaysBucket(1613472303000, 10) AS bucket
FROM ignoreMe
bucket
1867