Hi Team, Does pinot support upserting instead of ...
# troubleshooting
m
Hi Team, Does pinot support upserting instead of appending. My Pinot will get updated on every 24 hrs. So there can be duplicate tickets in pinot right. Is there an effective way to counter this? Can i set a ticket_id as a primary key, and if that same ticket comes again to pinot, can i just update teh details instead of appending it? Pls help.. We are stuck here!!!🙂
r
m
Thanks @Rajat Venkatesh
@Rajat Venkatesh can we do this in OFFLINE tables also, or only supported in REALTIME table?
r
It’s only supported for REALTIME.
m
ohh
Can i use deduplication as a workaround, for OFFLINE tables
r
No. Dedup is also for realtime tables. These features maintain data structures to find primary keys. These are created for realtime tables only
m
oh okay
m
Are you able to use real-time table?
m
I will need to use kafka for that rt @Mayank
m
Yes