How to add multiple columns in cassandra table?

Question

I need to add some new columns to my existing column_family/table in cassandra. I can add single column like this :

ALTER TABLE keyspace_name.table_name ADD column_name cql_type;

Can I add all new columns using a single query? If yes, how to do it using cql and datastax cassandra driver?

I think it is not possible. See: http://www.tutorialspoint.com/cassandra/cassandra_alter_table.htm and https://docs.datastax.com/en/cql/3.0/cql/cql_reference/alter_table_r.html. — Soumya Kanti, Jan 05 '16 at 11:38
Remember to be careful with schema agreement when modifying schema programmatically — phact, Jan 05 '16 at 14:39

score 23 · Accepted Answer · answered Aug 02 '16 at 20:57

23

ALTER TABLE foo ADD (colname1 int, colname2 int)

answered Aug 02 '16 at 20:57

Lucas B

1 Answers1