Re: Alter table

Alter table would change columns (the structure) of a table. Adding or deleting a column, for instance. Upserts would add (or edit) rows of an existing table. ALTER TABLE vs. UPDATE

Alter table

Why would I want to use alter table vs upserts with the new document format? Mark Furlong Sr. Database Administrator mfurl...@ancestry.com M: 801-859-7427 O: 801-705-7115 1300 W Traverse Pkwy Lehi, UT 84043 ​[http://c.mfcreative.com/mars/email/shared-icon/sig-l

Re: TWCS sstables gets merged following node removal

The min timestamps vary (likely due to read repairing old values into the memtable and flushing into these sstables), but the max timestamps for both are in the same second (same microsecond, even, so probably the same write): Maximum timestamp: 1544903882074190 Maximum timestamp: 1544903882074190

CommitLog Recovery replay stop on first timestamp after restore-point-in-time

Hi, I have found a statement in the Datastax documentation regarding CommitLog recovery that concerns me, namely: "*Restore stops when the first client-supplied timestamp is greater than the restore point timestamp. Because the order in which the database receives mutations does not strictly foll

Re: Re: How to gracefully decommission a highly loaded node?

On Mon, Dec 17, 2018 at 11:44 AM Riccardo Ferrari wrote: > I am having "the same" issue. > One of my nodes seems to have some hardware struggle, out of 6 nodes (same > instance size) this one is likely to be makred down, it consntantly > compacting, high system load, it's just a big pain. > > My

Re: Re: How to gracefully decommission a highly loaded node?

I am having "the same" issue. One of my nodes seems to have some hardware struggle, out of 6 nodes (same instance size) this one is likely to be makred down, it consntantly compacting, high system load, it's just a big pain. My idea was to add nodes and decommission all the one running on old hard