https://pinot.apache.org/ logo
#general
Title
# general
c

Carl

11/04/2021, 1:53 AM
Hi team, is there a Pinot query to find out when is the last ingest time of a offline table?
m

Mayank

11/04/2021, 1:54 AM
You mean the time when the segment was pushed or the max value of time column
If latter you can just do sql select max(timeCol)
c

Carl

11/04/2021, 1:57 AM
I mean when the segment are pushed.
j

jagadesh

11/04/2021, 11:44 AM
@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.
m

Mayank

11/04/2021, 2:43 PM
That works for real-time segment. There’s a metric for delay since last push that you can also check
j

jagadesh

11/04/2021, 5:57 PM
Thank you @User for correcting. Is this metric
lastPushTimeDelayHours
would give last push info?
m

Mayank

11/04/2021, 6:51 PM
Yes that’s the one
c

Carl

12/06/2021, 9:56 PM
How do I query to get this lastPushTimeDelayHours metric?