hello team when we are running below query in the production,it returns hourly_event_time is 0. SELECT toEpochSeconds(DATETRUNC('HOUR', original_event_time)) AS hourly_event_time from events limit 1; 1752617893996 is the value of original_event_time we are not identifying the issue.

DATETRUNC

returns you the hours epoch value, but

toEpochSeconds

takes the input

millis (LONG): Epoch timestamp in milliseconds.

https://docs.pinot.apache.org/functions-1/datetrunc#signature https://docs.pinot.apache.org/functions/datetime-functions#toepochseconds