It was indeed created with C* 1.X Do you have any links or otherwise on how I would add the column4? I don't want to risk destroying my data.
Best regards, Joel 2018-01-18 11:18 GMT+01:00 Nicolas Guyomar <nicolas.guyo...@gmail.com>: > Hi Joel, > > You cannot alter a table primary key. > > You can however alter your existing table to only add column4 using cqlsh > and cql, even if this table as created back with C* 1.X for instance > > On 18 January 2018 at 11:14, Joel Samuelsson <samuelsson.j...@gmail.com> > wrote: > >> So to rephrase that in CQL terms I have a table like this: >> >> CREATE TABLE events ( >> key text, >> column1 int, >> column2 int, >> column3 text, >> value text, >> PRIMARY KEY(key, column1, column2, column3) >> ) WITH COMPACT STORAGE >> >> and I'd like to change it to: >> CREATE TABLE events ( >> key text, >> column1 int, >> column2 int, >> column3 text, >> column4 text, >> value text, >> PRIMARY KEY(key, column1, column2, column3, column4) >> ) WITH COMPACT STORAGE >> >> Is this possible? >> Best regards, >> Joel >> >> 2018-01-12 16:53 GMT+01:00 Joel Samuelsson <samuelsson.j...@gmail.com>: >> >>> Hi, >>> >>> I have an older system (C* 2.1) using Thrift tables on which I want to >>> alter a column composite. Right now it looks like (int, int, string) but I >>> want it to be (int, int, string, string). Is it possible to do this on a >>> live cluster without deleting the old data? Can you point me to some >>> documentation about this? I can't seem to find it any more. >>> >>> Best regards, >>> Joel >>> >> >> >
