Hi, is it possible to update the `primaryKeyColumn...
# troubleshooting
t
Hi, is it possible to update the
primaryKeyColumns
for an existing upsert table and have it take effect? Or would I need to recreate the table?
n
we maintain some metadata per primary key for every partition on the server. If you change pk, that map is invalid. but i dont think you would need to recreate the table entirely. i think just a restart server is enough. In upsert, all records are still present, and just the metadata controls what’s served, so I believe a restart should suffice after change in pk, as the metadata map would be rebuilt @Kartik Khare would you help confirm this?
k
Yes, the servers need to be restarted for the primary key changes to take effect. It can take significant time to rebuilt the state if you have high number of unique keys.
t
got it thanks! So when a restart occurs, the servers would basically just go over every single row in the table and rebuild the metadata for upsert?
n
that’s right
👍 1
t
is the metadata regenerated every time a restart occurs or is it saved on disk somewhere?
k
currently generated every time
👍 1