Is there a way of doing MAX() on a long timestamp column returning a long not double?

You can cast it using sql syntax. Something like

cast(max(colum) as long)

Thanks, is there any way to maintain

long

precision for

max()

aggregation? Because doing the cast will always be approximate, because

double

can not handle nano epoc timestamps.

Currently that is not supported. Here is the issue tracking this feature request: https://github.com/apache/pinot/issues/7888