Hi <@UDQU92KBK> We change the topic with less part...
# troubleshooting
m
Hi @Mayank We change the topic with less partition for a partial upset table which resulted in duplicate entry in tables even if primary key was defined
m
You cannot change number of portions for upsert tables, you need to re-bootstrap
m
@Mayank Is this mentioned in documentation. Please share
Topic change is possible right? Then what is the issue
image.png
We can change stream ingestion topic as per this document and apart from change in topic previously topic had 16 partition and later on we made it to 6
m
Upsert requires that all data for 1 PK is always on one server. If you change topic or partition and break this guarantee, then it breaks upsert.
m
@Mayank Can you share this link?
m
There is only one page for upsert
m
is there a way to achieve this by adding dedup configurations?
But we define primary key in table for partial upsert or full upsert tables. Is this not achievable?
@Mayank I did not change the server. Topic was changed.
m
Will it guarantee that PK to parittion mapping is same before and after? If not, then same PK can now go to another server, and break upsert.