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 <https://docs.scylladb.com/getting-started/ddl/#id10> vs. UPDATE
<https://docs.scylladb.com/getting-started/dml/#update-statement>

(These docs are for Scylla, but Cassandra should be the same or similar for
Datastax.)

On Mon, Dec 17, 2018 at 1:45 PM Mark Furlong <mfurl...@ancestry.com> wrote:

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


-- 
Peter Corless
Technical Marketing Manager
pe...@scylladb.com
650-906-3134

Reply via email to