Hi Joel, Sadly it's not possible to alter the primary key of a table in Cassandra. That would require to rewrite all data on disk to match the new partitioning and/or clustering.
You need to create a new table and transfer all data from the old one programmatically. Cheers, Le jeu. 18 janv. 2018 à 11:14, Joel Samuelsson <samuelsson.j...@gmail.com> a écrit : > 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 >> > > -- ----------------- Alexander Dejanovski France @alexanderdeja Consultant Apache Cassandra Consulting http://www.thelastpickle.com
