How to add multiple columns in cassandra table?

cassandra cql datastax-java-driver
Pankaj Goyal picture Pankaj Goyal · Jan 5, 2016 · Viewed 8.3k times · Source

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?

Answer

Lucas B picture Lucas B · Aug 2, 2016

This is fixed in Cassandra 3.6 https://issues.apache.org/jira/browse/CASSANDRA-10411

ALTER TABLE foo ADD (colname1 int, colname2 int)

Related questions

How to get current timestamp with CQL while using Command Line?

I am trying to insert into my CQL table from the command line. I am able to insert everything. But I am wondering if I have a timestamp column, then how can I insert into timestamp column from the command …

Read More
How to get tombstone count for a cql query?

I am trying to evaluate number of tombstones getting created in one of tables in our application. For that I am trying to use nodetool cfstats. Here is how I am doing it: create table demo.test(a int, b …

Read More
Example about how to use map cql type with DataStax java driver

I am trying to use the datastax java driver to update and query a column family that has a map field. Does anyone an example about how to use cql collections with the Datastax Java Driver? Thanks

Read More