Apache Pinot

I have a question about realtime to offline job for upsert table. In <https://dev.startree.ai/docs/pinot/recipes/upserts-real-time-offline-job|this recipe>, it says
&gt; Now let’s run the job to replace the offline segment, which has the name `orders_1632463351000_1632467070000_0`
In production, how do we know which segment we need to replace?

ah nvm I think I found the answer… the timestamps of the segment name are the time boundaries of the segment… :thinking_face:

You can get a list of the segment names from the REST API. If you want to know which segment a record lives in, you can use the $segmentName variable in a query.

<https://dev.startree.ai/docs/pinot/recipes/query-by-segment>