A quick question about upsert table: if the data old than the retention is ingested, will Pinot ignore it?

Upsert is typically expected to be a refresh table (no retention). For regular tables, the answer is yes.

There is retention configuration inside segment config: https://docs.pinot.apache.org/configuration-reference/table#segments-config. @User