Comment on page
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
ToEpoch<TIME_UNIT>Bucket(timeInMillis, bucketSize)
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 |
Last modified 1yr ago