Apache Pinot Docs
Search…
latest
Configuration Reference
round
This section contains reference documentation for the round function.
Round the given time value to nearest bucket start value.

Signature

round(timeValue, bucketSize)

Usage Examples

Round seconds epoch value to the start value of the 30 seconds bucket to which it belongs.
1
select round(1639144274, 30) AS rounded
2
FROM ignoreMe
Copied!
rounded
1639144260
Round milliseconds epoch value to the start value of the 5,000 milliseconds bucket to which it belongs.
1
select round(1639144274000, 5000) AS rounded
2
FROM ignoreMe
Copied!
rounded
1639144270000
Last modified 6mo ago
Copy link