Well it should be as easy as following this : https://docs.datastax.com/en/cql/3.1/cql/cql_using/use_alter_add.html
But I'm worried that your initial requirement was to change the clustering key, as Alexander stated, you need to create a new table and transfer your data in it On 18 January 2018 at 12:03, Joel Samuelsson <samuelsson.j...@gmail.com> wrote: > 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 >>>> >>> >>> >> >
