CODEWITHSUNDEEP
cassandradatastax-enterprisedatastax
user3774905
user3774905

Reputation: 178

Altering cassandra table by adding new column while inserting data

I have high frequency of data for insertion in cassandra table.And column are dynamic .As per my scenario i want to alter my static table and add new column while insertion process. Does it impact on insertion or create any lock Or performance issue?

Note :I dont want to use dynamic column family. Please suggest ..

Thanks

Upvotes: 0

Views: 1159

Answers (1)

Maxim Zakharenkov
Maxim Zakharenkov

Reputation: 311

It should not impact your performance very dramatically. Cassandra is good for such types of operations. (E.g. in relational databases like MySQL it might be quite heavy operation). In case you use Cassandra 2.0, you can use batch to execute both operations: 1. alter table and 2. update column. In this case you will have only one network round-trip.

Upvotes: 1

Related Questions