@User will upsert will be available for batch data as well?

This is Ting from Uber. Upsert is mainly designed for realtime data ingestion. Pinot already can support update in batch data by replacing existing segments. @James Shao ^^

also a bit more clarification. For batch-only table (aka pinot offline table), you don’t really need upsert as you can always override existing datas.