Hi team, is there a Pinot query to find out when is the last ingest time of a offline table?

You mean the time when the segment was pushed or the max value of time column

I mean when the segment are pushed.

@User, Segment name is defined using

tableName__partitionGroupId__sequenceNumber__creationTime

you could look into latest pushed segment name and get the last value after

__

for the ingest time.

That works for real-time segment. There’s a metric for delay since last push that you can also check

Thank you @User for correcting. Is this metric

lastPushTimeDelayHours

would give last push info?

Yes that’s the one

How do I query to get this lastPushTimeDelayHours metric?