Powered by GitBook

1 of 1

Loading...

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

bucket

bucket

bucket

bucket

1613472

2689120

89637

1867

select ToEpochSecondsBucket(1613472303000, 1000) AS bucket
FROM ignoreMe

select ToEpochMinutesBucket(1613472303000, 10) AS bucket
FROM ignoreMe

select ToEpochHoursBucket(1613472303000, 5) AS bucket
FROM ignoreMe

select ToEpochDaysBucket(1613472303000, 10) AS bucket
FROM ignoreMe