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 <[email protected]> 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 <[email protected]>: > >> 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 >> > >
