cassandra add column if not exists

cassandra database-schema cql3
beterthanlife picture beterthanlife · Sep 8, 2014 · Viewed 9.5k times · Source

I need to insert a new column into an existing column family via a CQL script.

I want to do something like:

alter COLUMNFAMILY rules ADD rule_template text IF NOT EXISTS;

How can I achieve this purely in CQL script?

Answer

BrianC picture BrianC · Sep 8, 2014

There is no optional "if not exists" for altering column families (tables). As a workaround you could just execute the alter command and ignore the error if the column already exists. There shouldn't be any harm in it, other than the error message.

Related questions

Import and export schema in cassandra

How to import and export schema from Cassandra or Cassandra cqlsh prompt?

Read More
MongoDB vs. Cassandra

I am evaluating what might be the best migration option. Currently, I am on a sharded MySQL (horizontal partition), with most of my data stored in JSON blobs. I do not have any complex SQL queries (already migrated away after …

Read More
How to list all the available keyspaces in Cassandra?

I am newbie in Cassandra and trying to implement one toy application using Cassandra. I had created one keyspace and few column families in my Cassandra DB but I forgot the name of my cluster. I am trying to find …

Read More