What is a “soft delete”? My 2 cents, if you want to update some information just update it. There’s no need to overthink it.
Batches are good if they’re constrained to a single partition, not so hot otherwise. On Sun, May 27, 2018 at 8:19 AM Rahul Singh <rahul.xavier.si...@gmail.com> wrote: > Deletes create tombstones — not really something to consider. Better to > add / update or insert data and do a soft delete on old data and apply a > TTL to remove it at a future time. > > -- > Rahul Singh > rahul.si...@anant.us > > Anant Corporation > > On May 27, 2018, 5:36 AM -0400, onmstester onmstester <onmstes...@zoho.com>, > wrote: > > Hi > I want to load all rows from many partitions and change a column value in > each row, which of following ways is better concerning disk space and > performance? > 1. create a update statement for every row and batch update for each > partitions > 2. create an insert statement for every row and batch insert for each > partition, then run a single statement to delete the whole old partition > > Thanks in advance > > Sent using Zoho Mail <https://www.zoho.com/mail/> > > > -- Jon Haddad http://www.rustyrazorblade.com twitter: rustyrazorblade