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

Sean Chen

01/21/2021, 11:35 AM
Hi, while using
upsert
in the real-time table, which requires partitioned replica group assignment, can I use a different segment assignment in the offline table?
j

Jackie

01/21/2021, 7:08 PM
Yes, but the offline side won't have
upsert
enabled.
upsert
for hybrid table is still a WIP
s

Sean Chen

01/22/2021, 1:58 AM
Got it. Thanks
how does upsert mode clean old versions?
@Jackie For upsert, we can setup a hybrid table with upsert only in the real-time part, right? Or if we want to use upsert, we can’t use hybrid table?
j

Jackie

01/22/2021, 3:53 AM
It won't work properly on hybrid table. New record received on real-time side won't replace the one from offline side if exists
s

Sean Chen

01/22/2021, 4:08 AM
The time column for upsert to dertermine the latest version is the same column used for online/offline time range cut?
j

Jackie

01/22/2021, 6:04 AM
Yes, which should be the stream event time