Hi, while using `upsert` in the real-time table, w...
# general
s
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
Yes, but the offline side won't have
upsert
enabled.
upsert
for hybrid table is still a WIP
s
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
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
The time column for upsert to dertermine the latest version is the same column used for online/offline time range cut?
j
Yes, which should be the stream event time