You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cassandra.apache.org by "Li, Guangxing" <gu...@pearson.com> on 2017/10/19 15:53:12 UTC

Options to add a column to column family with compact storage

Hi,

I have a column family with compact storage setting:

CREATE TABLE course_book_catalogue (
  key text,
  "actVersion" int,
  "addonResources" text,
  "assessmentOpnrEnabled" boolean,
  "attachmentId" text,
  version int,
  PRIMARY KEY ((key))
) WITH COMPACT STORAGE AND...

I have a need to add a new column. We know that cf with 'COMPACT STORAGE'
does not allow adding new column. What options do I have? Can I change the
cf's setting to not have 'COMPACT STORAGE' and then add the new column, or
do I have to do a data migration?

Thanks.

George.